How can I Output Table Data from Progress into a CSV File?
- 01 Jun 2023
- Contributors
- Print
- DarkLight
- PDF
How can I Output Table Data from Progress into a CSV File?
- Updated on 01 Jun 2023
- Contributors
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
How can I Output Table Data from Progress into a CSV File?
Answer:
Use this Progress query where customer represents the table name. Note these steps are only for on-premise customers. You cannot do these steps on FIMS on Azure Cloud:
OUTPUT TO customer.csv. FOR EACH customer NO-LOCK : EXPORT DELIMITER "," customer. END. OUTPUT CLOSE.
1. In FIMS, go to Tools\System Utilities\Admin Utilities\Progress Editor or Persistent Progress Editor
2. Paste in the command. This example is using the Fund table. Again, you would change the table to whatever table you need to output:
OUTPUT TO fund.csv. FOR EACH fund NO-LOCK : EXPORT DELIMITER "," fund. END. OUTPUT CLOSE.
3. Highlight the command and then click compile button on the top of the window and then click Run.
OUTPUT TO customer.csv. FOR EACH customer NO-LOCK : EXPORT DELIMITER "," customer. END. OUTPUT CLOSE.
1. In FIMS, go to Tools\System Utilities\Admin Utilities\Progress Editor or Persistent Progress Editor
2. Paste in the command. This example is using the Fund table. Again, you would change the table to whatever table you need to output:
OUTPUT TO fund.csv. FOR EACH fund NO-LOCK : EXPORT DELIMITER "," fund. END. OUTPUT CLOSE.
3. Highlight the command and then click compile button on the top of the window and then click Run.
4. When you click Run, you will see the procedure window blink, no message will appear.
5. The csv file will write to the npo\found\fims folder. You can click on the Date Modified column to bring the most recent files to the top:
To see a list of tables and file names to use, see the following:
How can I see all the tables and fields in FIMS?
Was this article helpful?
