Working with CSV Files
Creating CSV Templates
After you design the data integration worksheet, you can create a CSV template from the worksheet. You can then populate the CSV file with data from QAD or third-party applications either manually or programmatically. You can import the CSV file into the Excel worksheet for data synchronization with the target QAD application.
To create a CSV template:
1 Under the Developer tab in the Ribbon, click Create CSV Template.
2 Select one of the following:
• Single CSV Template: creates one CSV file for all the tables in the worksheet.
• Template Per Table: creates multiple CSV files, one for each table in the worksheet.
3 Specify a location to save the file.