Export Designer

Navigator > Setup > Data Interchange > Export Designer

Use the Export Designer to generate a MaxBasic script that will export data from a module. Data objects available are listed. This cannot be used for process type objects.

The script can generate export files in different formats, see the Generate button below.

You can run the generated script in Script Editor to export the selected data. Alternatively, you can Save the generated script, then either run it from EDI Exporting, or run it using the MaxBasic EDIExport function in a script.

Sample export script files are provided in the \Scripts\EDIExports\SampleExports directory. Corresponding import definition files for each export script are also provided, in the \Imports\EDIImports\SampleImports directory.


Select Data Module to export from
Data Modules		Select the data module to export data from.
	Next	Move to the next screen.
Select master fields and ordering
Fields		A list of available data fields is displayed. Select master fields. All master fields are selected by default.
Grid Toolbar
	Expand Toolbar `(Alt+F9)`	Expand the toolbar to give access to all toolbar options. Press `Esc` to close the expanded toolbar.
	Move record `(Shift+Up) (Shift+Down)`	You can reorder the fields to be exported.
	Select All Fields `(Shift+F4)`	Select all fields.
	Unselect All Fields `(Shift+F3)`	Unselect all fields.
	Sort List `(Ctrl+F2)`	Move Selected fields to the top of the list, and sort the unselected fields alphabetically.
	Previous	Return to the previous screen.
	Next	Move to the next screen. If Detail Fields exist, goes to Select detail fields and ordering, otherwise, goes to Ready to Generate.
Select detail fields and ordering
Fields		Some data objects have one or more Detail records. For example, INInvoiceData has Invoice header and Invoice line records. Select the detail fields and ordering as for master fields above. Where there are multiple detail records, this step will be repeated.
Ready to generate
	Previous	Return to the previous screen.
	Generate	Generates the MaxBasic script to extract the fields selected. The script is displayed in the Script Editor. The script defaults to generating a CSV or Excel output file, with the first line: `Option Print ",",Chr(34)` Options for creating a Tab Separated or Fixed Width file are included, but are commented out. To change the file type generated, place a comment ' character at the start of the above line. For a Tab Separated file, uncomment the line: `Option Print CHR(9)` For a Fixed Width file, use uncomment the line: `Option Print ""` For a Fixed Width file, you will need to use the RPad function to pad fields to the correct width.