Brant at 01:11, 3 November 2014

2014-11-03T01:11:05Z

← Older revision		Revision as of 01:11, 3 November 2014
Line 41:		Line 41:

	-bExport for a single branch		-bExport for a single branch

	-VKeep a backup of export files		-VKeep a backup of export files

Brant at 01:10, 3 November 2014

2014-11-03T01:10:43Z

← Older revision		Revision as of 01:10, 3 November 2014
Line 41:		Line 41:

	-bExport for a single branch		-bExport for a single branch
			-VKeep a backup of export files

	<nowiki>-t<Table></nowiki>Export only the nominated table. To export multiple tables: -tProduct\|Customer\|Size Use "\|" as table name separator		<nowiki>-t<Table></nowiki>Export only the nominated table. To export multiple tables: -tProduct\|Customer\|Size Use "\|" as table name separator

Trevor at 04:56, 23 January 2009

2009-01-23T04:56:42Z

← Older revision		Revision as of 04:56, 23 January 2009
Line 1:		Line 1:
			Created: 19 June 2008. Last Reviewed: 23 January 2009

	'''EEE Data Exporter'''		'''EEE Data Exporter'''

Lucy at 00:34, 23 January 2009

2009-01-23T00:34:27Z

← Older revision		Revision as of 00:34, 23 January 2009
Line 56:		Line 56:


	[[Image:]]		[[Image:EEE_Export_syntax.JPG]]

Lucy: Summary of command line exports for EEE Exporter

2009-01-23T00:29:23Z

Summary of command line exports for EEE Exporter

New page

'''EEE Data Exporter'''

While the EEE Data Exporter graphical interface is useful for ad-hoc purposes, it is normally necessary to configure a regular, scheduled transfer of data from Enabler Enterprise to Enabler POS installations. This is a two-step process:

Identify the tables (record types) that need to be sent from Enabler Enterprise Edition to Enabler. Make an ASCII file listing these tables. The standard installation of EEE Data Exporter creates FILELIST.TXT in the installation directory. This should be copied sideways and edited if necessary to your requirements.

Schedule a regular execution of the Data Export application for all stores. This should be scheduled using the built in Windows Scheduled Tasks. When scheduling the Exporter for unattended execution, use the command line options documented below:

<nowiki>Export.exe -i|-f -w<WorldRegionCode> -c<CountryCode> -r<RegionCode> </nowiki>

<nowiki>-s<SubregionCode> -b<BranchCode> -xN|U|A -t<Table>|<@TableList> </nowiki>

<nowiki>-m<CompanyCode> -d</nowiki>

Command Line Options:

-iPerform incremental export of nominated table(s)

-fPerform full export of nominated table(s)

-xNExport new data only (only valid with -i)

-XUExport only unacknowledged data (only valid with -i)

-XAExport both new and unacknowledged records (only valid with -i)

-w Export for all branches in nominated world region

-cExport for all branches in nominated country

-rExport for all branches in nominated region

-sExport for all branches in nominated sub-region

-bExport for a single branch

<nowiki>-t<Table></nowiki>Export only the nominated table. To export multiple tables: -tProduct|Customer|Size Use "|" as table name separator

-t@FileListExport all tables in the TXT file FileList

<nowiki>-m<n></nowiki>Export data for specified company, or EEE instance (Company 1 is

default). <nowiki><n> is company number (1, 2, 3 etc).</nowiki>

-dDisplay progress.

If -w, -c, -r, -s, -b not specified then export will run for all branches.

By running the command export -? The syntax of the export command is shown as per the box below.

[[Image:]]

'''Sample FILELIST.TXT'''

Division Maintenance

Department Maintenance

Class Maintenance

Product Category Maintenance

Customer Category Maintenance

Customer Maintenance

Supplier Maintenance

Brand Maintenance

Colour Maintenance

Size Maintenance

Season Maintenance

Style Maintenance

Product Maintenance

Barcode Maintenance

Discount Reason Maintenance

Return Reason Maintenance

Payouts Reason Maintenance

Variance Reason Maintenance

Stock Adjustment Reason Maintenance

Stock Location (Bin) Maintenance

Club Membership

Customer Card Maintenance

Markdown Maintenance

Customer Discount Maintenance

Promotion Header Maintenance

Promotion Detail Maintenance

Promotion Exception Maintenance

Colour Profile Maintenance

Colour Profile Colours Maintenance

Size Profile Maintenance

Size Profile Sizes Maintenance

Region Maintenance

Branch Maintenance

Till Maintenance

Club Maintenance

Forward Price Change

Tenders Maintenance

Nuance Delivery Hotel Maintenance

Nuance Departure Cities Maintenance

Nuance Destinations Maintenance

Nuance Flights Maintenance

Nuance Nationalities Maintenance

Nuance Pickup Branches Maintenance

Nuance Sale Type Maintenance

Analysis 5 Maintenance

Analysis 6 Maintenance

Analysis 7 Maintenance

Analysis 8 Maintenance

Analysis 9 Maintenance

Analysis 10 Maintenance

Kit Components

Purchase Orders

Purchase Order Cancellations

Interbranch Transfer Header Maintenance

Interbranch Transfer Line Maintenance

CPN Inter-Branch Maintenance

CPN Supplier Maintenance

User Maintenance

User Class Maintenance

Add On Sales Maintenance

Costs Maintenance (Replacement Costs)

Discount Subreason Maintenance

Price Maintenance

MinMax Maintenance

Export Commands: - Revision history

Brant at 01:11, 3 November 2014

Brant at 01:10, 3 November 2014

Trevor at 04:56, 23 January 2009

Lucy at 00:34, 23 January 2009

Lucy: Summary of command line exports for EEE Exporter