Differences between revisions 2 and 27 (spanning 25 versions)

IMPORTING FILES

Importing files is a quick way of getting data from one system, possibly manipulating it with third party software and (re)importing into CONTROL. The data must have columns in the following sequence and all columns with data in them will be assumed to match the columns defined below. All columns defined below past the last column with actual data in the import file, will be given the currently defined "default value".

To import the file you need to run:

impXXmin "file_name". impXXmin -b "file_name" = This will blank fields if the field is equal to zero or blank impstmin -qoh "file_name" - This is used in stock to import the quantity on hand field, otherwise it will be ignored

XX is can be dr/cr/st/ca/gl for debtors,creditors,stock,categories,general ledger

STOCK FILE IMPORT - 40 fields

Stock/Style Number
Description
Comment
Category (Dept/Sub-department - maximum of 8 characters)
Supplier 1 (supplier code - maximum of 8 characters)
Supplier 1 Product Code,
Supplier 1 Cost in SUPPLIER'S currency
Supplier 2
Last Supplier Cost in LOCAL currency
Duty %
Other Charges (amount or % of supplier cost in local currency)
Landed Cost
Current Sell Price (Inc GST)
Promotional Sell Price (Inc GST)
Promotional Start Date
Promotional End Date
Price Level 1
Price Level 2
Price Level 3
Price Level 4
Unit (assume buy unit = sell unit, etc.)
Barcode Number
Quantity on hand
Minimum
Maximum
Type (C = Consignment, D = discontinued, G = Gross (no qty), I = Inactive, M = Miscellaneous (fixed GP), S = scalable item, W = whole number only)
Statistical / Temporary (should be marked as a S or T)
On Internet (y/n)
Weight
Volume
Attribute Group
Colour palette
Size run
Parent/Style number (this and next two columns are only valid for "child" items)
Attribute
Colour
Size
Season
Rebate 1
Rebate 2

CREDITORS IMPORT - 22 fields

Supplier_code
Supplier_name
main_contact
main_addr1
main_addr2
main_addr3 (City, State, Postcode)
main_country
main_phone
main_fax
main_email
accounts_email
other_addr1
other_addr2
other_addr3 (City, State, Postcode)
Supplier_ABN
Supplier_Group
Payment_Type (E for eft, C for cheque)
BSB_Number
Account_Number
Credit Terms (in days)
Past End of Month
GL Sundry Invoice Expense Account

CUSTOMERS IMPORT - 23 fields

Customer Code
First Name
Last Name
Title (Mr, Mrs, Miss, Dr, etc)
Customer Name (Business name or Full Customer name)
Address 1
Address 2
Address 3 (City, State)
Postcode
Zone (delivery zone or postcode)
Country (3 character country code)
Main Phone
A/H Phone
Mobile Phone
Fax Number
Email Address
Contact Person
Group 1
Group 2
Credit Limit
Delivery Address 1
Delivery Address 2
Delivery Address 3

CATEGORY/DEPARTMENT IMPORT - 2 fields

Category ID (Category code including department prefix, or just department prefix)
Category Name

GENERAL LEDGER IMPORT - 8 fields

GL code
GL Description
Post / No post
P/L or B/S
Debit / Credit
Level
Prime Parent
Second Parent

-  ⇤ ← Revision 2 as of 2007-05-11 05:54:51 → 
  Size: 1276
  Editor: julius
  Comment:
+   ← Revision 27 as of 2008-09-24 05:03:29 → ⇥
  Size: 3340
  Editor: julius
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 2:
-Importing files is a quick way of getting data from one system, possibly manipulating it in a third party software and reimporting into CONTROL. The import must adhere to the following headings
+Importing files is a quick way of getting data from one system, possibly manipulating it with third party software and (re)importing into CONTROL. The data must have columns in the following sequence and all columns with data in them will be assumed to match the columns defined below. All columns defined below past the last column with actual data in the import file, will be given the currently defined "default value".
 Line 4:
-= STOCK FILE IMPORT =
== Here are the fields currently supported on our standard stock import program. ==
Stock Number
+To import the file you need to run:
-Line 8:
+Line 6:
-Description
+impXXmin "file_name". impXXmin -b "file_name" = This will blank fields if the field is equal to zero or blank impstmin -qoh "file_name" - This is used in stock to import the quantity on hand field, otherwise it will be ignored
-Line 10:
+Line 8:
-Category (Dept/Sub-department)
+XX is can be dr/cr/st/ca/gl for debtors,creditors,stock,categories,general ledger
-Line 12:
+Line 10:
-Supplier 1,

Supplier 1 Product Code,

Barcode Number

Cost

Sell Price (Inc GST)

Unit (assume buy unit = sell unit, etc.)

Quantity on hand

Minimum,

Maximum

Weight

Volume

Parent,

Colour,

Size

= CREDITORS IMPORT =
Supplier code

main_contact

main_addr1

main_addr2

main_city

main_state

main_postcode

main_country

main_phone

main_fax

main_email

other_addr1

other_addr2

other_city

other_state

other_postcode

abn

= CUSTOMERS IMPORT =
Customer Code

First Name

Last Name

Customer Name (Business name or Full Customer name)

Address 1

Address 2

State

Postcode

Country

Main Phone

A/H Phone

Mobile Ph,

Fax Number

Contact

Group 1

Group 2

DEPARTMENT

DepartmentDepartment ID

Department Name

'''Category '''

Department ID

Category ID

Category
+= STOCK FILE IMPORT - 40 fields =
 * Stock/Style Number
 * Description
 * Comment
 * Category (Dept/Sub-department - maximum of 8 characters)
 * Supplier 1 (supplier code - maximum of 8 characters)
 * Supplier 1 Product Code,
 * Supplier 1 Cost in SUPPLIER'S currency
 * Supplier 2
 * Last Supplier Cost in LOCAL currency
 * Duty %
 * Other Charges (amount or % of supplier cost in local currency)
 * Landed Cost
 * Current Sell Price (Inc GST)
 * Promotional Sell Price (Inc GST)
 * Promotional Start Date
 * Promotional End Date
 * Price Level 1
 * Price Level 2
 * Price Level 3
 * Price Level 4
 * Unit (assume buy unit = sell unit, etc.)
 * Barcode Number
 * Quantity on hand
 * Minimum
 * Maximum
 * Type (C = Consignment, D = discontinued, G = Gross (no qty), I = Inactive, M = Miscellaneous (fixed GP), S = scalable item, W = whole number only)
 * Statistical / Temporary (should be marked as a S or T)
 * On Internet (y/n)
 * Weight
 * Volume
 * Attribute Group
 * Colour palette
 * Size run
 * Parent/Style number (this and next two columns are only valid for "child" items)
 * Attribute
 * Colour
 * Size
 * Season
 * Rebate 1
 * Rebate 2
= CREDITORS IMPORT  - 22 fields =
 * Supplier_code
 * Supplier_name
 * main_contact
 * main_addr1
 * main_addr2
 * main_addr3 (City, State, Postcode)
 * main_country
 * main_phone
 * main_fax
 * main_email
 * accounts_email
 * other_addr1
 * other_addr2
 * other_addr3 (City, State, Postcode)
 * Supplier_ABN
 * Supplier_Group
 * Payment_Type (E for eft, C for cheque)
 * BSB_Number
 * Account_Number
 * Credit Terms (in days)
 * Past End of Month
 * GL Sundry Invoice Expense Account
= CUSTOMERS IMPORT - 23 fields =
 * Customer Code
 * First Name
 * Last Name
 * Title (Mr, Mrs, Miss, Dr, etc)
 * Customer Name (Business name or Full Customer name)
 * Address 1
 * Address 2
 * Address 3 (City, State)
 * Postcode
 * Zone (delivery zone or postcode)
 * Country (3 character country code)
 * Main Phone
 * A/H Phone
 * Mobile Phone
 * Fax Number
 * Email Address
 * Contact Person
 * Group 1
 * Group 2
 * Credit Limit
 * Delivery Address 1
 * Delivery Address 2
 * Delivery Address 3
= CATEGORY/DEPARTMENT IMPORT - 2 fields =
 * Category ID (Category code including department prefix, or just department prefix)
 * Category Name
= GENERAL LEDGER IMPORT - 8 fields =
 * GL code
 * GL Description
 * Post / No post
 * P/L or B/S
 * Debit / Credit
 * Level
 * Prime Parent
 * Second Parent