Export

The Export form is used to create Export Names that can be configured on the Export Definition form.

To open this form, click the button next to the Export Name field on the Export Definition form. Choose Add, Lookup, or Maintain.

The application comes with several pre-defined exports (OUT_EBS_WIP_COST, OUT_EBS_PA_TRANSACTION, SAP_CONF21, etc.). These exports cannot be deleted or modified. However, you can copy a System Required export and then modify it as necessary.

See Also:

Export Name Field Descriptions

Find an Export Name

Add an Export Name

Modify Export Name

Copy Export Name

Delete an Export Name

 

Export Name Field Descriptions

Export Context

The Context identifies the record's function and indicates what type of data extraction is being performed. Each Context is limited to a set of tables from which the data can be extracted.

Action: Action data extraction allows you to export/re-export data for specific actions (events). The event must be configured with Event Validation via the Events form. The data is converted according to the output requirements in the Export Definition.

Charge_Element: A Charge Element export allows you to export charge elements, such as order numbers, operation numbers, projects, and account numbers. On the Export Parameters tab, you can specify the Charge Types and Element Names you want to export. These options are defined on the Charge Type form.

Labor: Labor data extraction allows you to export/re-export employee labor data. You can specify which charge types and facilities you want to export, as well as the events you want to export. The data is converted according to the output requirements in the Export Definition.

The Labor Export Context can also be used to define a Labor Distribution Export . To do so, set the PROCESS_NAME in the Export Parameters to "Labor Distribution."

Message: Use this context to export messages and their responses to an external system.

Payroll: Payroll Data extraction allows you to export/re-export data for a specific payroll period. The data is converted according to the output requirements in the Export Definition.

Person (Employee): A Person export will extract data from the person table (such as badge numbers, employee profiles, assignments, and ad hoc codes). This information can be found on the Employee form.

Person_Balance: A Person Balance export will extract data about a person’s balances (leave type code, balance value, carry over value, etc.)

Person_Info: A Person_Info export will extract data from the person_info table, which is a table that stores person data received from an ERP system.

Person_Pin: This context will export person numbers and their corresponding PINS from the person table. You can use the DAYS_TO_EXPORT parameter to customize this list.

Person_Period: Sends employee timecard approval (signed timecard) data. A system-defined Export Definition called LDMTIME_APPROVAL has the Person_Period Export Context.

Transaction: Sends employee timecard data. There are three system-defined Export Definitions that have the Transaction Export Context:

 

Export Name

A unique identifier for the record.

 

Export Type

Determines the output format for the data.

CSV: The data will be exported using the CSV (comma separated values) format. If your Export Destination is FILE, the data columns will not have a header.

CSV With Header: The data will be exported using the CSV (comma separated values) format. If your Export Destination is FILE, each column will have a header that corresponds to a Field Name in the export (e.g., Person Number, First Name, Last Name).

Fixed Length: The data will be exported using the fixed length format. Each field in the export will have a fixed start and end position. If your Export Destination is FILE, the data columns will not have a header.

JSON: The data will be exported using the JSON (JavaScript Object Notation) format.

BCOREXML: The data will be exported to an XML file.

TABLE: The data will be exported to a table.

XML: The data will be exported to an XML file that will be used to send data to an ERP system. Use this option to produce an XML file that is specific to the ERP XML format.

 

Export Destination

Use this setting to configure where you want the export data to be sent.

QUEUE: Select QUEUE as your Export Destination if you want the export data to be placed in the Interface Out Queue (interface_out_queue table). The transaction_data column will contain the export data in the format of the Export Type you selected (CSV, Fixed Length, etc.). You can use the OUT_FILE_WRITER service to convert the data in the Interface Out Queue to an XML file.

You cannot select QUEUE as your Export Destination if the Export Type is TABLE.

If you want to export data to the queue, you also need to:

FILE: Select FILE as your Export Destination if you want the export data to be saved in a file. You must also enter a File Name (see below). You can also change the Destination Folder where the file will be saved.

You cannot select FILE as your Export Destination if the Export Type is TABLE.

TABLE: Select TABLE as your Export Destination if you are exporting the data to a table. This Export Destination is only available if your Export Type is TABLE. You will also need to configure the table on the Export Record tab.

 

Destination Folder

Identifies the output file's location. The default location is the \export folder in your AUTOTIME_HOME folder.

 

File Name

Identifies the output file name. If the Export Destination is FILE, you must enter a File Name.

You can use the following semantics in your File Name to include the timestamp and the Export Output ID number on the File Name. These semantics will cause a unique file to be generated each time you run the export.

[%TS%]

Include this semantic to add the current timestamp to the file name. The timestamp format will be yyyyMMddHHMMSS. For example, if the File Name is Action_Export_[%TS%] and the export file is generated on July 31, 2018 at 12:08:32 p.m., the export file name will be named Action_Export_20180731120832.

[%ID%]

Include this semantic to add the Export Output ID number (a system-assigned ID number for the export) to the file name. For example, if the File Name is Action_Export_[%ID%], the export file that is generated will be named Action_Export_1000. The next time you generate this export, the file will be named Action_Export_1001.

The [%TS%] and [%ID%] semantics can be placed anywhere in the file name (e.g., [%TS%]_Action_Export or Action_Export_[%TS%]).

 

Override File

If a file with the same name already exists in the destination folder, the Override File setting determines if the existing file will be overwritten.

Append: New values will be added to the existing file.

Prevent: A new file will not be created. An error message will display in the Error Log in which  the existing file name will be identified.

Delete: The existing file will be deleted and replaced with the new file.

 

Ruleset Name

This field applies only if the Export Context Name is Payroll or Labor.

Identifies which Export Ruleset is used for this record. Export Rulesets determine when and how timecard data is grouped and extracted from the system tables.

 

Split Premium

Note: This field applies only if the Export Context Name is Payroll or Labor.

The split premium value determines if premium portions of a transaction will display in a separate record. Note that the time reporter's Export Premium Policy must be configured with at least a BASE record type in order for the Split Premium setting to take effect. See Export Premium Policy for more details.

No Split: There will be a single record combining base, hours premium, and shift premium. Note: This setting requires a configured BASE record type in the time reporter's Export Premium Policy.

Split Shift Premium: There will be one record for the base and hours premium portions and a separate record for the shift premium portion. Note: This setting requires configured BASE and SHIFT PREMIUM record types in the time reporter's Export Premium Policy.

Split Hours Premium and Shift Premium: There will separate records for base, hours premium, and shift premium. Note: This setting requires configured BASE, HOURS PREMIUM, and SHIFT PREMIUM record types in the time reporter's Export Premium Policy.

 

Emp Sign Required

This option is only available when the Export Context is Payroll.

When this box is checked, a person's records will only be exported if all the days in the range have employee signatures.

 

Sup Sign Required

This option is only available when the Export Context is Payroll.

When this box is checked, a person's records will only be exported if all the days in the range have supervisor signatures.

 

Payroll Lock Required

This option is only available when the Export Context is Labor, Payroll, or Transaction.

If Payroll Lock Required is checked and the export finds a day that is not payroll locked for a particular employee, the export will be affected as follows:

 

Enable Audit

This setting determines whether the export data will be placed in the export audit tables (export_output_data and export_output_data_map).

You can use the records in the export_output_data table to compare the export files Shop Floor Time sent with the data that your ERP or payroll system received. The columns in the export_output_data_map table are available to the user through the Export Audit context of an Ad Hoc Report. You need to map the export data to a column in the export_output_data_map table by configuring the Output Data Map field on the Export Field form.

Example 1: A Labor Export runs from an instance of the EXPORT service. If Enable Audit is checked, the entire export file is placed in the output_data column of the export_output_data table. The export file data is also mapped to columns such as person number and duration in the export_output_data_map table (based on the Output Data Map configuration of these Export Fields). When an Ad Hoc Report with the Export Audit context is run, it can select these person numbers and durations from the export_output_data_map table. If Enable Audit is not checked, then no records will be created in either the export_output_data or export_output_data_map table when the Labor Export is run by the EXPORT service.

Example 2: A Payroll Export runs from the Exports form. The entire export file is placed in the output_data column of the export_output_data table. The export file includes person numbers and durations. If Enable Audit is checked, these values are mapped to the person_num and duration columns in the export_output_data_map table (based on the Output Data Map configuration of these Export Fields). When an Ad Hoc Report with the Export Audit context is run, it can select these person numbers and durations from the export_output_data_map table.

 

System Required

If this box is checked, the export record cannot be deleted or modified. However, you can copy a system-defined record and then modify it as necessary.

 

Find an Export Name Record

  1. Click Main Menu > Configuration > Interfaces > Export Definition.

  2. Click the button next to the Export Name field and select Lookup from the pop-up menu.

  3. Select a record from the Export pop-up form and click OK.

 

Add an Export Name

  1. Click Main Menu > Configuration > Interfaces > Export Definition.

  2. Click the button next to the Export Name field and select Add from the pop-up menu.

  3. On the Export form, enter/select the values. See Field Descriptions for details.

  4. If you want to add more than one Export Name, click Save and Add to save your settings and keep the Export window open. Or click Save to save your Export Name and return to the Export Definition form.

  5. You are now ready to configure the output data. See Export Definition to do so.

 

Copy an Export Name

  1. Click Main Menu > Configuration > Interfaces > Export Definition.

  2. Click the button next to the Export Name field and select Maintain from the pop-up menu.

  3. On the Export form, select the Export Name you want to copy and click Copy.

  4. On the Copy Export form, change the settings as necessary and click Save.

 

Modify an Export Name

  1. Click Main Menu > Configuration > Interfaces > Export Definition.

  2. Click the button next to the Export Name field and select Maintain from the pop-up menu.

  3. On the Export form, select the Export Name you want to change and click Modify.

  4. Change the settings as necessary and click Save.

 

Delete an Export Name

  1. Click Main Menu > Configuration > Interfaces > Export Definition.

  2. Click the button next to the Export Name field and select Maintain from the pop-up menu.

  3. On the Export form, select the Export Name you want to remove and click Delete.

  4. Click OK to confirm the action.