|
Size: 2009
Comment:
|
Size: 3460
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 2: | Line 2: |
| 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". | 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: | Line 4: |
| = STOCK FILE IMPORT = | 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" - (minus minus qoh "filename") 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 - 44 fields = |
| Line 8: | Line 14: |
| * Category (Dept/Sub-department) * Supplier 1, |
* Category (Dept/Sub-department - maximum of 8 characters) * Alternate Category * Supplier 1 (supplier code - maximum of 8 characters) |
| Line 12: | Line 19: |
| * Supplier 2 | |
| Line 14: | Line 22: |
| * Other Charges (amount or % of supplier cost in local currency) | * Other Charges (amount or % of supplier cost in local currency) |
| Line 17: | Line 25: |
| * Promotional Sell Price (Inc GST) * Promotional Start Date * Promotional End Date |
|
| Line 21: | Line 32: |
| * Unit (assume buy unit = sell unit, etc.) | * Buy Unit (assume buy unit = sell unit, etc.) * Hold Unit * Buy_Hold Factor |
| Line 24: | Line 37: |
| * Minimum, | * Minimum |
| Line 26: | Line 39: |
| * Type (C = Consignment, D = discontinued, G = Gross (no qty), I = Inactive, M = Miscellaneous (fixed GP), S = scalable item, W = whole number only) | * Processing Type (C = Consignment, D = discontinued, G = Gross (no qty), I = Inactive, M = Miscellaneous (fixed GP), S = scalable item, W = whole number only) * Reporting Type * Statistical / Temporary (should be marked as a S or T) |
| Line 30: | Line 45: |
| * Size run, * Parent/Style number (this and next two columns are only valid for "child" items), * Colour, |
* Attribute Group * Colour palette * Size run * Parent/Style number (this and next two columns are only valid for "child" items) * Attribute * Colour |
| Line 34: | Line 52: |
= CREDITORS IMPORT = * Supplier code |
* Season * Rebate 1 * Rebate 2 = CREDITORS IMPORT - 22 fields = * Supplier_code * Supplier_name |
| Line 40: | Line 61: |
| * main_city * main_state * main_postcode |
* main_addr3 (City, State, Postcode) |
| Line 47: | Line 66: |
| * accounts_email | |
| Line 49: | Line 69: |
| * other_city * other_state * other_postcode * abn = CUSTOMERS IMPORT = |
* 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 = |
| Line 58: | Line 82: |
| * Title (Mr, Mrs, Miss, Dr, etc) | |
| Line 61: | Line 86: |
| * State | * Address 3 (City, State) |
| Line 63: | Line 88: |
| * Country | * Zone (delivery zone or postcode) * Country (3 character country code) |
| Line 68: | Line 94: |
| * Contact | * Email Address * Contact Person |
| Line 71: | Line 98: |
= DEPARTMENT = * Department ID * Department Name = Category = * Department ID * Category ID |
* 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) |
| Line 80: | Line 105: |
| = GENERAL LEDGER IMPORT - 8 fields = * GL code * GL Description * Post / No post * P/L or B/S * Debit / Credit * Level * Prime Parent * Second Parent |
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" - (minus minus qoh "filename") 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 - 44 fields
- Stock/Style Number
- Description
- Comment
- Category (Dept/Sub-department - maximum of 8 characters)
- Alternate Category
- 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
- Buy Unit (assume buy unit = sell unit, etc.)
- Hold Unit
- Buy_Hold Factor
- Barcode Number
- Quantity on hand
- Minimum
- Maximum
- Processing Type (C = Consignment, D = discontinued, G = Gross (no qty), I = Inactive, M = Miscellaneous (fixed GP), S = scalable item, W = whole number only)
- Reporting Type
- 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