Differences between revisions 5 and 36 (spanning 31 versions)
⇤ ← Revision 5 as of 2007-05-14 06:27:12 →
Size: 1429
Editor: bernie
Comment:
← Revision 36 as of 2009-08-25 01:50:24 → ⇥
Size: 4041
Editor: gonzo
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.
Line 4: Line 4:
= STOCK FILE IMPORT =
 * Stock Number		 The data '''MUST''' have

 * the columns in the correct sequence. Do NOT rearrange the column sequence.
 * the column headings exactly as they were in the original blank spreadsheet
All columns with data in them will be assumed to match the columns defined below. All columns 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"}}}
 . where XX => dr/cr/st/ca/gl for debtors,creditors,stock,categories,general ledger
Running {{{impXXmin -b "file_name"}}} will blank fields if the field is equal to zero or blank

Running {{{impstmin --qoh "file_name"}}} is used in stock to import the quantity on hand field, otherwise it will be ignored

To get an empty copy of the import file, run

{{{
expXXmin}}}
and specify the desired filename for the spreadsheet. Make sure that the filename ends with ".csv".

== STOCK FILE IMPORT - 50 fields ==
 * Stock/Style Number
Line 8: Line 29:
 * 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 11: Line 33:
 * Supplier Cost (in supplier currency)  * Supplier 1 Cost in SUPPLIER'S currency
 * Supplier 2 (supplier code - maximum of 8 characters)
 * Supplier 2 Product Code,
 * Supplier 2 Cost in SUPPLIER'S currency
 * Supplier 3 (supplier code - maximum of 8 characters)
 * Supplier 3 Product Code,
 * Supplier 3 Cost in SUPPLIER'S currency
 * Last Supplier Cost in LOCAL currency
Line 13: Line 42:
 * Tax Code (3=0%, 4=10%)
 * Other Charges (amount or % of supplier cost in local currency)
Line 15: Line 46:
 * Promotional Sell Price (Inc GST)
 * Promotional Start Date
 * Promotional End Date
Line 19: Line 53:
 * Unit (assume buy unit = sell unit, etc.)  * Buy Unit (assume buy unit = sell unit, etc.)
 * Hold Unit
 * Buy_Hold Factor
Line 22: Line 58:
 * Minimum,  * Minimum
Line 24: Line 60:
 * 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 27: Line 66:
 * Size run,
 * 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 31: Line 73:
= CREDITORS IMPORT =
 * Supplier code		  * Season
 * Rebate 1
 * Rebate 2
 * Print Labels
== CREDITORS IMPORT - 22 fields ==
 * Supplier_code
 * Supplier_name
Line 36: Line 83:
 * main_city
 * main_state
 * main_postcode		  * main_addr3 (City, State, Postcode)
Line 43: Line 88:
 * accounts_email
Line 45: Line 91:
 * 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 53: Line 104:
 * Title (Mr, Mrs, Miss, Dr, etc)
Line 56: Line 108:
 * State  * Address 3 (City, State)
Line 58: Line 110:
 * Country  * Zone (delivery zone or postcode)
 * Country (3 character country code)
Line 63: Line 116:
 * Contact  * Email Address
 * Contact Person
Line 66: Line 120:
= 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 73: Line 127:
== 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

  • the columns in the correct sequence. Do NOT rearrange the column sequence.
  • the column headings exactly as they were in the original blank spreadsheet

All columns with data in them will be assumed to match the columns defined below. All columns 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"

  • where XX => dr/cr/st/ca/gl for debtors,creditors,stock,categories,general ledger

Running impXXmin -b "file_name" will blank fields if the field is equal to zero or blank

Running impstmin --qoh "file_name" is used in stock to import the quantity on hand field, otherwise it will be ignored

To get an empty copy of the import file, run 

expXXmin

and specify the desired filename for the spreadsheet. Make sure that the filename ends with ".csv".

STOCK FILE IMPORT - 50 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 (supplier code - maximum of 8 characters)
  • Supplier 2 Product Code,
  • Supplier 2 Cost in SUPPLIER'S currency
  • Supplier 3 (supplier code - maximum of 8 characters)
  • Supplier 3 Product Code,
  • Supplier 3 Cost in SUPPLIER'S currency
  • Last Supplier Cost in LOCAL currency
  • Duty %
  • Tax Code (3=0%, 4=10%)
  • 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
  • Print Labels

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

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