Step 9 – Order Status Feedback File¶
This will create a CSV file consisting of the incoming Order Id and the Sage300 assigned Order Number which will then be uploaded back to the order system.
- On the main design screen drag a CSV Writer from the Writers group onto the palette. Connect it to end of the Sage300 Order import and double click to open the setup.
- Expand the File Options.
- File Name
- For writer transforms you can enter a simple formula to generate a filename.
- For training, enter: "OrderStatus" & Format(Date, "yyyymmdd") & ".csv"
- File Path
- For training, enter: C:\IMan\OutputData
- Encoding Method
- For training, select: Unicode (UTF-8) (utf-8)
- Evaluate Filename
- To have the value in the File Name field evaluated or not.
- For training: checked.
- Overwrite Existing File
- Each time the process is run a new file (with an uniquifier) will be created.
- For training: checked.
- Collapse the File Options and select the remaining options.
- Field Delimiter
- Line delimiter
- Quote String Fields
- Write Header Rows
- Create file when no data
- Generate File Per Transaction
- Click the Field Mapping and press Edit to select/deselect the fields you wish to export.
- Deselect every field except REFERENCE and ORDNUMBER.
- Change to the OE0500 transaction and deselect ALL the fields.
- Refresh and then open your file.
- Press Apply to save the transform and close and then save the integration.