Report Writer > Setup > Data Definition Export

Data Definition Export

You use this program to export one or more tables from the Report Writer Data Dictionary to a plain text file.

Once exported, you can use the Data Definition Import program to transfer the tables to another system and import them into the Report Writer Data Dictionary.

The facility to export and import these tables is particularly useful if you customized the standard data dictionary definitions or defined your own tables and you want to use these at another SYSPRO site. Alternatively, the facility can be used to assist support personnel in duplicating issues with reports that use custom data definitions because they can recreate the reports and data definitions on their own site.

Report Writer Export Data Definition

Field Description
File  
Export Select this to export the tables currently displayed in the Tables to Export list.
Close Select this to exit the program.
Export Select this to export the tables currently displayed in the Tables to Export list.
Available Tables This listview displays the tables currently available for export.
Assign Selected Select this to assign the tables currently highlighted in the Available Tables list to the list of tables to be exported (the Tables to Export list).

You can use the Ctrl and Shift keys together with your mouse pointer to individually highlight the tables you want to export.

Assign All Select this to assign all tables displayed in the Available Tables listview to the list of tables to export (the Tables to Export list).
Tables to Export This listview displays the table(s) currently selected for export.
Remove Selected Select this to remove the currently highlighted tables(s) from your list of tables to export.

You can use the Ctrl and Shift keys together with your mouse pointer to individually highlight the tables you want to remove from the Tables to Export list.
Remove All Select this to remove all tables from the current Tables to Export list.

Export Report Writer tables

This screen is displayed when you select to export one or more tables.

Field Description
Export file Enter the file name and the location of the file to use for the export.

This defaults to your working folder and file name REPPDD (i.e. ...\work\REPPDD.EDI)
Export location This option only applies if you are working in a client/server environment.
Client Select this to export the selected tables to the client machine.
Server Select this to export the selected tables to the server.
Start Export Select this to perform the export of the selected tables.

You are prompted to confirm the export.

If the export file name you entered already exists, a warning message is displayed. You can select to overwrite the existing file or to return to the previous screen to change the file name.
Cancel Select this to return to the previous screen without performing the export.

Listviews

The Available Tables and Tables to Export listviews can be sorted according to any of the columns, by using your mouse pointer to select the column name.

Exported File Layout

The exported file should have the following properties and layout:

  • The file must be a plain text file, suitable for the environment (i.e. Windows or Unix)

  • The file must have a header record indicating the following:

    • the date/time of export
    • the name of the operator who performed the export
    • a list of the actual table(s) in the export file
  • Each exported record must be prefixed with the 6 character file name from its source.
  • The file must have a footer comment to indicate the end of the export file.

Sample File Layout

The following is an example of the header record required for the export file:

# IMPACT.EDI Version 6.0.010 Format REPPDD Created: 2007/09/19 16:00

# Exported by: ADMIN - Systems Administrator

# Table: CrmContact

# Table: InvMaster

# Table: CustomMaster

REPTAB:xxxxx

REPCOL:xxxxx

REPKEY:xxxxx

REPLNK:xxxxx

The export and import programs must use the ADMEDI.MAS record layout to store the first header record in the file.

The FD should be supplemented with any other definitions required.

For example:

*

FD ADMEDI.

COPY "ADMEDI.MAS".

01 ADMED2-REC PIC X(3000).

where ADMED2-REC is a dummy record long enough to hold at least the longest record exported.