вход по аккаунту


How to run Visual Integrator from the command line - Sage Software

код для вставки
Running Visual Integrator From the Command Line
Have you ever wondered about how to automate the process of entering Accounts Receivable
invoices into Sage MAS 90? How about uploading Sales Order data while you sleep at night,
ready to process by the time you arrive in the morning?
With Sage MAS 90 Visual Integrator (VI), users can automate the import of Accounts Receivable,
Sales Order, or other types of data, by running a VI job from the command line. A Visual
Integrator job or any other Sage MAS 90 program can run independent of Sage MAS 90, with a
Windows task, a batch file, or similar method. This allows a user to run the job after business
hours, or several times a day, without anyone having to log into Sage MAS 90.
Please review the details below for examples and notes regarding the command line structure:
Version 4.xx
The following information must be included in the command line:
..\MAS90\Home\Pvxwin32.exe ..\launcher\sota.Ini
..\SOA\Startup.M4P -ARG DIRECT (UI State) (User Logon)
(Password) (CompanyCode) (Program Name) (Program Argument)
..\MAS90\Home\Pvxwin32.exe .. \Launcher\Sota.Ini
..\SOA\Startup.M4P -ARG DIRECT UION myuser mypassword ABC
If an argument has no value (for example: if the User Logon has no
password), use quotation marks (“”) to hold the arguments in place.
The User Logon above refers to the Sage MAS 90 or Sage MAS 200
ERP user logon setup in User Maintenance (not the User Code field in
User Maintenance).
UIState - Set this argument to either UION or UIOFF. This setting
specifies if aUser Interface exists (for example: a user could receive
notification of errors in a message box.)
Set the Program Argument to Auto or Manual. The Manual option forces
the import job interface to launch, and requires the user to click Accept.
Use the Manual option to test your procedure, then use the Auto option
once you have verified that the job launches correctly in the Manual
For batch file command lines, use this example as a model:
CD F:\Version4\Mas90\Home
Pvxwin32.exe .. \Launcher\Sota.Ini ..\SOA\Startup.M4P
-ARG DIRECT UION myuser mypassword ABC VIWI00 MANUAL
REM Note we set the current directory to Home first
REM Note we set the program argument to MANUAL
Any program run with a command line on version 4.0 must exist as a
Task within the Sage MAS 90 or 200 Role-based security system. You
must add Visual Integrator "legacy" jobs (jobs not using a 4.0 Table as
the Primary Table) to the Jobs Menu before running the job with a
command line. Jobs using a 4.0 Table as the Primary Table are
automatically added to the Jobs Menu (for example General Ledger
After you add the task to the system tasks files, use Role Maintenance to
grant access to the new menu for the Visual Integrator Jobs menu. The
user logon specified on the command line above must belong to a role
that has access to this new task or menu item.
Version 3.x
Note: For more information, see the Visual Integrator Help screens within Sage
MAS 90.
Create a Shortcut Icon on the Windows Desktop with the following command line
in the Target field:
-ARG (Program Name) W 0 DIRECT (Run Mode) (Company Code)
Replace X: \ XXX with the actual path to the Sage MAS 90 directory. For
Sage MAS 200 this corresponds to the Sage MAS 90 directory of the
Sage MAS 200 Server Installation, not the Sage MAS 90 directory on the
Replace (Program Name) with the file name of the Sage MAS 90
Program or VI job that you are running. The program name of a VI job is
found in the upper right corner of the 'Import Job Maintenance' or 'Export
Job Maintenance' screen.
Replace (Run Mode) with MANUAL, AUTO or DISPLAY. See the VI Help
screens for details regarding each mode.
Replace (Company Code) with the Sage MAS 90 Company Code you
are importing to or exporting from.
Enter the command line in upper case as in the example above. Some
switches, such as Run Mode, fail to execute if entered in lower case.
Sage MAS 200:
For Sage MAS 200 the path to the Sage MAS 90 directory used in the shortcut
properties corresponds to the Sage MAS 90 directory of the Sage MAS 200
Server Installation, not the Sage MAS 90 directory on the workstation.
In the VI job, enter the path to the Import File/Export File as it appears from the
WORKSTATION, and uncheck the �On Host’ option.
MAS200 for SQL:
A MASSQL DSN on the client workstation should be setup to use NT
authentication, and the login must have sufficient rights to the MAS_SYSTEM
Note: Any user running this command must be set up as a SQL server login,
created with 'dbdatareader' and 'dbdatawriter' database role permissions in the
MAS_SYSTEM and MAS_XXX company databases. Also, 'dbo' database role
permissions would be required if the VI job creates or drops any SQL server
В© 2006 Sage Software, Inc. All rights reserved. The Sage Software logo and the Sage Sof tware product and service
names mentioned herein are registered trademarks or trademarks of Sage Software, Inc., or its affiliated entities. All other
trademarks are the property of their respective owner
Без категории
Размер файла
14 Кб
Пожаловаться на содержимое документа