Will export order information to a text file. Each row in the generated text file contains information about a single operation in ROB-EX Scheduler, including the project and production order it belongs to. Operations are grouped by production order and the sequence of the operations are current operation sequence order in ROB-EX Scheduler.

The parameter “exportOption” decides if currently selected order, all orders or changed orders are exported.

In case of errors a diagnostic message is logged to the standard ROB-EX log window.

Example parameter configuration

The exported file is semicolon ; separated and all values are contained with double quotes “. The file contains the following fields/columns

No. Field/Column Description
1 Project number
2 Project name
3 Project customer
4 Production order internal id Internal record id of the production order. Normally hidden inside ROB-EX client.
5 Production order name/no. The name or number that is visible inside the ROB-EX client
6 Item no. The ROB-EX combined field for item number and name
7 Item text Currently not used – will be left blank
8 Production order description
9 Production order quantity
10 Production order customer
11 Production order material date and time DD-MM-YYYY HH:MM
12 Production order delivery date and time DD-MM-YYYY HH:MM
13 Operation id Internal record id of the operation. Normally hidden inside ROB-EX client.
14 Operation name
15 Operation setup time
16 Operation workload time The processing time
17 Operation switchover time
18 Operation quantity Normally the same as “Production order quantity”, but can be different
19 Operation planned start time DD-MM-YYYY HH:MM
20 Operation planned end time DD-MM-YYYY HH:MM
21 Operation status An integer value with the following meaning

15 = Reserved
20 = Planned
30 = Start possible
40 = Started
50 = Paused
60 = Cancelled
70 = Completed
90 = Deleted
22 Resource id Internal record id of the resource. Normally hidden inside ROB-EX client.
23 Resource name

Parameter descriptions

(* = configuration required)

appendToFile
if true then exported data is appended to possible already existing file.

checkOperationsDirtyFlag
if true then only changed operations will be selected for export.

exportOption
selected = The selected orders in the plan will be exported
all = A dialog will be shown, where you can choose which orders to export.

changed = A dialog will be shown, where you can choose which orders to export.

current = The latest option selected by the user in the export GUI will be used. If show GUI is true, this option will make the export dialog remember its last settings.

fileName *
The path and file name of the export file.
A timestamp can be constructed by adding a date format enclosed in curly brackets. E.g. FileName-{ddMMyyyy-HHmm}.csv will result in: “FileName-30122013-0910.csv”

See Date Formatting for further details on the valid date formats.

showGUI
true = Export dialog will be shown, enabling user to select export file and options. in that case fileName doesn’t have to be filled.
false = Don’t show export dialog. fileName parameter must be filled.

skipExportWhenNoOrdersChanged
if true and no orders are changed export will be skipped.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment