Differences between revisions 4 and 25 (spanning 21 versions)
⇤ ← Revision 4 as of 2007-05-14 01:20:02 →
Size: 1292
Editor: JessicaMayo
Comment:
← Revision 25 as of 2008-09-24 04:59:49 → ⇥
Size: 3303
Editor: julius
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 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".

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
Line 5: Line 13:
 * Stock Number = 40 fields =
 * Stock/Style Number
Line 8: Line 17:
 * Category (Dept/Sub-department)
 * Supplier 1,		  * Category (Dept/Sub-department - maximum of 8 characters)
 * Supplier 1 (supplier code - maximum of 8 characters)
Line 11: Line 20:
 * 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.)
Line 12: Line 36:
 * Cost
 * Current Sell Price (Inc GST)
 * Unit (assume buy unit = sell unit, etc.)
Line 16: Line 37:
 * Minimum,  * Minimum
Line 18: Line 39:
 * 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)
Line 21: Line 44:
 * Parent,
 * Colour,		  * Attribute Group
 * Colour palette
 * Size run
 * Parent/Style number (this and next two columns are only valid for "child" items)
 * Attribute
 * Colour
Line 24: Line 51:
 * Season
 * Rebate 1
 * Rebate 2
Line 26: Line 56:
 * Supplier code  * Supplier_code
 * Supplier_name
Line 30: Line 61:
 * main_city
 * main_state
 * main_postcode		  * main_addr3 (City, State, Postcode)
Line 37: Line 66:
 * accounts_email
Line 39: Line 69:
 * other_city
 * other_state
 * other_postcode
 * abn
  * 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
Line 48: Line 82:
 * Title (Mr, Mrs, Miss, Dr, etc)
Line 51: Line 86:
 * State  * Address 3 (City, State)
Line 53: Line 88:
 * Country  * Zone (delivery zone or postcode)
 * Country (3 character country code)
Line 58: Line 94:
 * Contact  * Email Address
 * Contact Person
Line 61: Line 98:
 * Credit Limit
 * Delivery Address 1
 * Delivery Address 2
 * Delivery Address 3
= CATEGORY/DEPARTMENT IMPORT =
 * Category ID (Category code including department prefix, or just department prefix)
 * Category Name
Line 62: Line 106:
= DEPARTMENT =
 * Department ID
 * Department Name

= Category =
 * Department ID
 * Category ID
 * Category Name		 = GENERAL LEDGER IMPORT =
 * 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" - 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

  • 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

  • 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

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

GENERAL LEDGER IMPORT

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

Import (last edited 2024-11-08 05:38:48 by JennyTinsey)