line format in generated CSV ouput file using Outsystem

I have generated output file for invoice in CSV format. required line sequence in csv for loading the same in QAD environment. please guide me if any info related to this. attached current and expectedFormat in atttachments 



Hi Bindu,

Can you be a bit more specific what the problem is you are facing?

Easiest way to generate csv in OutSystems is by using the csvutil forge component. You create a record list or aggregate and using the component you can then generate the csv.

Regards,

Daniel

Hi Daniel,


using csvutil forge component i have generated data in CSV file. but lines generated in csv should be like line followed by cross comp.line. 

example: 


IS expected below format in output CSV:

LINE*1*37026130**2406*102518
CROSS*1*AB21*37026130**2406*102518*JE
LINE*2*37026130**2406*102518
CROSS*2*AB21*37026130**2406*102518*JE


  

My Output CSV:

LINE*1*37026130**2406*102518
LINE*2*37026130**2406*102518
CROSS*1*AB21*37026130**2406*102518*JE
CROSS*2*AB21*37026130**2406*102518*JE





Hi bindu chandralekha,

The order of the lines in your Output CSV will be the same order they have in the List you pass to the component... If they are not in the order you want, you probably need to change your source of data (sort the Aggregate for instance) or manipulate the list before you convert it to CSV, so you programmatically move around elements according to your requirements (using ListAdd, ListRemove, ListAppend, etc).

Hope this helps!