Running Visual Integrator Job From Within Access

Question

I am trying to run a Visual Integrator job when you click a button on an form in Microsoft Access. The job wont run, and I believe it has something to do with the fact that the Access application is open. I have tested the same command string that I am using in the VBA module in a desktop shortcut. The shortcut works, and the data from Access is imported into Sage, but only if the Access application is not open. I think this is much like Visual Integrator not being able to import a CSV file while it is open. There must be a way to handle this as it seems like a very basic thing to want to do. 
 I am running Sage 100 Premium (SQL) and Access 2013. 
 Does anyone have a suggestion? 
 
 Thanks!

gseales · Accepted Answer

I forgot about that one, it is the "App Name". Below is what I had received from Sage about how to do this and it list what each of the values are. The "IMPWEB" is the name of an application that is setup on the Application Server Configuration. 110-405391 - How to create a shortcut to run a V/I import job, export job, or other Sage MAS 90 and 200 task outside the program. Entry Type: Informational Product: Sage MAS 90 ERP Sage MAS 200 ERP Sage MAS 200 ERP - SQL Server Edition Sage MAS 90 Extended Enterprise Suite Application: Visual Integrator Version Reported: ALL Subject: How to create a shortcut to run a V/I import job, export job, or other Sage MAS 90 and 200 task outside the program. Possible Resolution: Sage MAS 200 only, 4.40.0.4 and higher The MAS 200 Application Server must be used to run the VI jobs (or other such tasks) externally from a workstation client using a batch (.bat) file so that the ODBC path to the MAS 200 server is not modified, thus causing MAS 200 to fail to launch certain tasks. All users must exit and the Application Server or Service must be stopped Add the Job to Menu by clicking the ‘Menu’ button in ‘Import Job Maintenance’ for the Job and follow the Wizard. Select Programs / Sage Software / Application Server Configuration. Click the Apps tab > click the New button. The screen New - App Props for Server: "SAGE" will open Enter a name for the application under App Name (for this example “Import”) Note: The 'App Name' will be referenced in the batch file to execute the VI Job or similar task. Enter the following values ProvideX EXE: leave Server INI: Enter ..\Launcher\Sota.ini Lead Program: Enter StartUp.M4P Leave the Extra CMD Options and Arguments fields blank Start-In Directory: Enter the path to the ..\MAS90\Home folder from the MAS 200 server's perspective. (Ex. C:\Sage Software\MAS 200\Version4\MAS90\Home) Init Window: Select Hidden In the Options section, ‘only Allow Client Arguments’ must be checked, the rest of the options must be unchecked. Click ‘Ok’ to close the New - App Props for Server: "SAGE" screen Press Apply button to save the new Application Name settings in Application Server Configuration. Warning: If there are users in the system they must exit, Applying the settings will disconnect all sessions. The following format must be used to run the VI Job or External task from the workstation, using the Application Server Application. C:\\Home\Pvxwin32.exe -hd ..\launcher\sota.ini *Client -ARG "Server" "Port" "App Name" -ARG= DIRECT UION User Password CompanyCode JobName DISPLAY Batch file example: Example: "C:\Sage Software\MAS 200 Client\Version4\MAS90\Home\Pvxwin32.exe" -hd ..\launcher\sota.ini *Client -ARG "ACCTSERVER" "10000" "IMPORT" -ARG= DIRECT UION JohnDoe MyPass ABC VIWI00 DISPLAY Note: When creating a Windows shortcut the "Start In" directory is the client "Home" directory Example: "C:\Sage Software\MAS 200 Client\Version4\MAS90\Home" Note: When creating a batch file or script the command line must be preceeded by a change directory to Home. Example: CD "C:\Sage Software\MAS 200 Client\Version4\MAS90\Home"

gseales · Answer

Look at my previous post above, it tells you how to do it.

Sage 100

Running Visual Integrator Job From Within Access

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING