i'm using PTC Integrity at my firm. We have there an Excelfile, which we can Transfer with a perl script to our SQL Database. In Integrity itself, there is a Number for a Member Revision. I can see this Revision Number, when i type
echo %MKSSI_REVISION1%in the commandline. Now i tried to write this in perl, but it's really hard for me. I must say perl, that the script should look for the Excelfile Database.xlsx in the path C:\Integrity_Sandbox\Database\Database.xlsx, then read the Member Revision Number of this, and write this Number to my SQL Database. Does anyone has some ideas, how i can manage this? Thanks for your help