Export data
This workflow shows you how to write work orders out of oneGRID into a file with the Export Data page. Use it when you need order data in a spreadsheet — for a report, a hand-over, or an analysis outside oneGRID.
Role: Administrator
Prerequisites
- Your account has the Export Data permission. The Administrator and Supervisor presets include it; for any other user it has to be granted on the Users page — see Manage users and Permissions and presets.
Steps
-
On the Main Menu, click Export Data in the Export group. The Export Data page opens with the Work orders section.
-
Select the Status of the orders you want to export:
Status Exports Completed Orders that were fully processed Pending Orders that are being processed or were paused New Orders that have not been started yet -
Set the creation date range with From and To. Both dates are required, and To cannot be earlier than From.
-
Open Columns and select the columns the file should contain. All selects every offered column at once.
Column Contains No. A running row number the name your adapter provides The value your connected system sends with the work order — the same value the work order pages show in that column. Offered only when your adapter provides a name for it Work order number The order number Work order description The order description Total assigned containers How many containers the order is assigned to Container codes The codes of those containers -
Click Export and choose the file format, CSV or EXCEL. The file downloads through your browser.
The column selection is remembered per status, so a Completed export and a New export can keep different column sets. It is saved whenever an export succeeds and stored per user in the browser you exported from, so it does not follow you to another machine.
Adapter columns
If your connected system offers additional columns through its adapter, they appear in Columns below the standard ones, under the headings your system provides. Their values are read from the adapter while the file is being built, so the file always reflects what your system reports at that moment and nothing has to be stored in oneGRID beforehand.
Your adapter also names the column that carries the value it sends with each work order. A name oneGRID already translates — for example Customer Name — appears in your own language; any other name appears exactly as your adapter sent it. The column is offered only when the adapter provides a name, so an installation without an adapter, or with an adapter that provides no name, does not see it at all. The same rule applies on the work order pages and in the work order details.
Nothing changes for an installation whose adapter offers no columns — the page and the exported file stay as described above.
Result
The file contains one row per work order that matches the selected status and date range. Abandoned, fully cancelled, and empty work orders are never exported, and the status matches what the History shows for the same order.
Column headings and the file name follow your own language, so a German account gets a German heading row and a file named Arbeitsaufträge_Abgeschlossen_… instead of WorkOrders_Completed_…. Adapter columns keep the heading your system provides.
Both formats contain exactly the same rows and columns. They differ in how a spreadsheet reads them:
| Format | What you get |
|---|---|
| CSV | A plain text file. Separators and number formatting follow your language. |
| EXCEL | A workbook on a sheet named after the work orders, with a bold heading row that stays visible while you scroll, a filter dropdown on every column, and every column wide enough to read its heading. No. and Total assigned containers are numbers you can sum; every other cell is text, so a container code or order number that starts with a zero keeps it. |
If something goes wrong
| Problem | See |
|---|---|
| The Export group or the Export Data card is not on the Main Menu | A feature is not visible — the Export Data permission is missing |
| Export stays disabled | A required field is missing: check that From and To are set, that To is not earlier than From, and that at least one column is selected |
| The export fails when adapter columns are selected | The adapter could not be reached. Retry, or export without the adapter columns |