Sage 100

Virtual Integrator questions SAGE 100 v2014. 1) When you run a VI import job from the Import Job Maintenance menu and you change the location and name of the .CSV file, does the VI job get automatically recompiled to keep the new .CSV file location and name? 2) If you run the VI job from the Job Select menu and change the .CSV file location and name does the system NOT recompile the job? 3) Is there a way to add a .CSV file location and name to a batch file that calls a VI job outside of SAGE 100?

Michael: You can supply the filename as an argument. Arguments include Company and Mas90 User-code and filename in format: TIcccuuu.12345 Examples here are ABC for company, FSI for usercode, LINK(user password) START /B PVXWIN32.EXE ../launcher/sota.ini ../soa/startup.m4p -ARG DIRECT UION FSI LINK ABC VLWITR TIABCFSI.12345

@LeeGraham In my case the .CSV file is located on the C drive in a folder call SO_Import, with a file name of ""SOTCC.txt"". So would the end of my batch file look like this?: ""../soa/startup.m4p -ARG DIRECT UION FSI LINK VLWITR ABC VIW101 C:\SO_Import\SOTCC.txt AUTO

When an existing VI job is modified, is there a log somewhere in the VI directory that can be read? The System Activity log shows when a VI job is executed, but I did not see if there is a System Activity entry for a recompile.

Not sure about your AUTO part. I have the filename after the VI job name. The job Info tab on VI Job Maint. screen shows the date last compiled.

@LeeGraham The AUTO means ""Set Program Argument to AUTO or MANUAL. The manual option displays the interface for the import job and requires the user to click Accept. Use the manual option for testing purposes before using AUTO."" Lee, I'm sorry I am not familiar with ""filename in format:TIcccuuu.12345"". Could you please explain? My file name=SOTCC.csv and it's location is on the C: drive in folder \SO_Import\ or C:\SO_Import\

Michael. The filename stuff was documentation for my project. Just put your filename in that position.

Not getting this to work after adding the path\filename as an argument in my batch file. Here is my batch file command line: Pvxwin32.exe ..\Launcher\Sota.Ini ..\SOA\Startup.M4P -ARG DIRECT UION mtm mtmgo TCC VIWI01 C:\TCC_IMPORT\tcc_so.csv MANUAL The import file box is not being populated with my file's path\filename

Michael it sounds like Lee's idea is to run in AUTO mode but replace the AUTO with the file name. In other words don't bother typing in MANUAL, AUTO, DISPLAY or anything. Just run it that way and see what happens. If it works it means you would always need to control the source file name in the .BAT file. If you use a script instead of .BAT file you could have an InputBox prompt the user for the name of the file then pass that in as the last argument to the command line.

@AlnoorCassim I changed the .BAT file and removed ""MANUAL"" from the end of the command line. The InputBox still came up looking for the path\filename. Controlling the path\filename (source file) in a .BAT file is EXACTLY what I'm trying to do.

Michael I tried it too just now using the TIcccUUU.12345 format after the compiled VI program name and nothing else after the filename. For me it looks like the filename is ignored and therefore it is treated as MANUAL. I'm just unlucky I guess.

Try putting the filename AFTER the AUTO and see if that works.

Lee Graham, Thank you for the suggestion, but placing the filename after ""AUTO"" did not work.