Skip to main content

Export

Creating Export Templates Export templates define the source and destination for your data, and the mappings between the two. They are created through the Data Export wizard.

To create an export template:

  1. Open an existing DPL package or create a new one.

  2. In the Data pane, right-click Export Templates and select New Template from the shortcut menu.

  3. In the Data Export wizard, you must first create a Destination Connection for your exported data. From the list of Available Connectors, click to select the type of data connector you wish to use. Destination connections are set up in much the same way as source data connections. For more information on how to use a specific connector type, click its name in the list below.

  • Microsoft® Access Data Connector

  • Microsoft® Excel Data Connector

  • mySQL® Data Connector

  • OLE DB Data Connector

  • ODBC Data Connector

  • Oracle® Data Connector

  • SQL Server® Data Connector

  • Text Data Connector

  • XML Data Connector

  • SAP Business One-Business Objects Connector

  • SAP Data Connector

  • SAP SII Connector

  • SAP XML IDoc Connector

  • MongoDB Data Connector

  • Sap Business One - Sap Service Layer

  1. On the Define table mappings dialog, click Add new mapping to display a list of the existing queries in the package. Click to select the query containing the desired data.

  2. If the destination for export contains identifiable tables, DPL lists them and the option to Specify a new or existing table to contain the exported data. If the destination for export does not contain any identifiable tables, only the Specify option is displayed. Click to choose any of the listed tables or choose Specify to type in the name of a table. If you Specify a table that does not exist in the destination file, DPL attempts to create the new table in the destination file.

  3. If you select an existing table, DPL displays the fields in the source and destination tables, with arrows marking any mapping that it detects. To create additional mappings, drag fields from the source query on the left to the destination table on the right. (Scroll bars appear on both tables if required.) Click Next when all desired mappings are created.

  4. If you Specify a new or existing table, or after you have identified the mappings in an existing destination table, DPL presents options for handling the export as shown below. Make your selections and click Next.

  5. When Digital Process Logic returns you to the Define table mappings dialog, you can create additional mappings between the source and destination files. When you have created all desired mappings, click Next.

  6. In Validation and Notification dialogue, select the drop down list to display all the validation rules defined in the fusion pack. This is optional. By default no rule is selected. Optionally you may specify the validation output filename %FPDIR% stands for fusion pack directory. This output file contains the result of the validation rule in HTML. This HTML file will be emailed as an attachment. In addition, you can optionally specify the email address to send the result of the export. Click on Test Email to check if the email configuration.

  7. Use the Summary dialog to verify your export template setup. To make changes, click Back. When all choices are correct, click Run Export to export the data. Select Finish when the export is completed. If you do not wish to export the data at this time, just click Finish.