Visual Integrator Commands from external application

[nickerp]

Hi all, I am trying to run MAS200 export job from .net. I am currently using the following commands
C:\Program Files\Best\MAS 200\Version4\MAS90\Home\pvxwin32.exe ..\launcher\sota.ini ..\SOA\Startup.M4P -ARG DIRECT UIOFF username password VIWX04 AUTO

I would like to export INVHISH table data based on a invoice date. My requirement is to change the invoice date in the selection criteria before running it. Is there a command that I can use?

 

[BigLouie]

Try using a Temp field and making it a calculation adding or subtracting days from the invoice date as needed.

 

[nickerp]

Thanks for the reply. I am new to MSA200, so can you please be more specific. Lets say I need to pull data with invoice date being '10/20/2008' or for any other date.

 

[BigLouie]

Straight from the Help files (imagine that) which you should be reading:

On the Export Job Maintenance Data tab, click the Temp button to create a temporary field that can be used to assign values or to calculate values to be exported. This feature is accessed by clicking the Temp button on the Export Job Maintenance Data tab. Calculated values can be used for another calculation to accumulate totals. The available fields are dependent on the data type and the operation selected for the temporary field.
NOTE Temporary fields can contain numeric, string, or date values.

Click Condition to specify a conditional expression. Click Perform to enter multiple perform logic to be executed before and after assigning the field.

 

[nickerp]

I tried this but does not help me solve my issue. I want o restrict the data based on a date.

 

[nickerp]

Hello BigLouie,

I contacted our MAS200 vendor today and they replied that it is not possible to pass data selection criteria as part of an automated VI command. I created a temporary field. Is there a way to assign a system date to the temporary field. My idea is to assign invoice_date = system date in the temporary field. Can you please advice.

 

[dfeller]

If you are using .NET why not just extract the data using a select statement?

Dawn

 

[BigLouie]

If you are using .NET why not just extract the data using a select statement?" - What and give up on VI? har har har...