Export Commands:
From EnablerWiki
Created: 19 June 2008. Last Reviewed: 23 January 2009
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:
Export.exe -i|-f -w<WorldRegionCode> -c<CountryCode> -r<RegionCode>
-s<SubregionCode> -b<BranchCode> -xN|U|A -t<Table>|<@TableList>
-m<CompanyCode> -d
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
-t<Table>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
-m<n>Export data for specified company, or EEE instance (Company 1 is
default). <n> is company number (1, 2, 3 etc).
-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.
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
