I have a pascal script, which basically pushes information into a 3rd party system.
I have an excel macro written, which saves raw data into a CSV file, which I would like my script to read, and take the data (each row is 1 record) and put each portion in a specific field (setValue)
I cannot seem to find a way to do this (I am able to do this in a single field) but am unsure how to have 444,555,666 work so 444 goes here, 555 goes here, etc. into my 3rd party program.
The VBA (works great no issue) however the script to read it is where I keep getting stuck.
The set values below work fine with this 3rd party program, but I cannot seem to get it to read the CSV.
Program TEST; VAR //start the loop here begin //Constants per file setValue('invoice_Type','1'); SetValue('billed_Date',FormatDateTime('dd/mm/yy', Now()+10)); setValue('post_Date6','*'); setValue('time_Text6','*'); setValue('trace_Type1','MB') setValue('trace_Type2','MF') setValue('trace_Type3','PO') setValue('ship_Type','F'); setValue('man_Unit','PCS'); setValue('voy_Flt_Date','*'); setValue('trace_Date1','*'); setvalue('trace_No1','000-NA-A'); //end of constants //FIELDS I NEED TO ADD DATA FROM MY CSV setvalue('client_INFO',''); setvalue('client_No_LETTER',''); setValue('man_Qty',''); setValue('trace_Qty1',''); DoAction('PF6'); //Shipment History While FormName = 'askimportctxcontroller' do begin SetValue('DEFAULT_ANSWER','Y'); DoAction('Enter'); end; doAction('PF1'); //update doAction('PF8'); //exit doAction('PF7'); //other doAction('PF4'); //send //end log doAction('PF3'); //clear //end the loop here end.