Skip to main content

How to Download Bulk Order Data Using CSVB Export

***This functionality exports data only from the Work Orders module in AMFG. Clients who have the CNC functionalities enabled would not see the CSVB Export available on their console's Dashboard page***

Written by AMFG Consulting & Support

Overview

When managing production flow and orders in AMFG, you may need to export a large volume of historical order data for external reporting or analysis.

By default, clicking the Download button for the CSVB Export on your Dashboard downloads a report containing the most recent 1,000 orders. If you need to access older orders beyond this initial set, you can use a quick URL modification to fetch data in larger bulk batches.

Step-by-Step Instructions

Step 1: Trigger the CSVB Export Download

  1. Navigate to your Dashboard in the AMFG Management Console.

  2. Scroll down to the Custom reports section.

  3. Locate the CSVB Export report and click the Download button. (This initiates the generation and download of data from your 1,000 most recent Work Orders.)

Step 2: Copy the Generated Download URL

  1. While the report is generating or right as the download triggers, copy the full URL directly from your browser's address bar.

  2. The URL will look similar to this:

    https://console.amfg.ai/reporting-service/api/v1/report/10/download?token=YOUR_TOKEN_HERE

Step 3: Apply the Offset Parameter to Fetch Older Records

  1. Open a new tab in your web browser.

  2. Paste the copied URL into the address bar.

  3. Append the offset parameter (&offset=XXXX) to the end of the URL to offset the report by increments of 1,000 orders:

    • To download orders 1,001 to 2,000: Add &offset=1000 to the end of the URL.

    • To download orders 2,001 to 3,000: Add &offset=2000 to the end of the URL.

    • To download earlier orders: Continue increasing the offset by 1,000 (e.g., &offset=3000, &offset=4000).

  4. Press Enter. Your browser will instantly generate and download the CSV report corresponding to that offset range.

Example URL:

Plaintext

https://console.amfg.ai/reporting-service/api/v1/report/10/download?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJhcHBJZCI6IjIzMDEiLCJhcHBOYW1lIjoiWW9yZGFuIE1pdHJldiIsInVzZXJJZCI6IjExNzYxIiwiaXNBZG1pbiI6dHJ1ZSwiZXhwIjoxNzg1NDE4NjE4LCJpYXQiOjE3ODUzMzIyMTh9.1EubQqMwBhANr1aEjJHMF04qtNHHgdG748eYOUrKb7M&offset=1000

Helpful Notes & Troubleshooting

  • Token Expiration: The authentication token generated in the URL is temporary. Ensure you copy and run your modified URLs shortly after clicking the download button.

  • Combining Files: Once you have downloaded your batch CSV files (e.g., recent 1,000, 1,000 offset, 2,000 offset), you can easily merge or append them in Microsoft Excel or Google Sheets to get your complete historical dataset.

If you encounter any issues accessing your custom reports or setting up export parameters, please reach out to the AMFG Support Team or contact us via the in-app support chat.

Did this answer your question?