Differences between revisions 28 and 42 (spanning 14 versions)
⇤ ← Revision 28 as of 2008-10-10 04:08:11 →
Size: 3430
Editor: julius
Comment:
← Revision 42 as of 2009-09-24 02:12:11 → ⇥
Size: 4581
Editor: test02
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

 * 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".
Line 6: Line 12:
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 {{{
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
Line 8: Line 17:
XX is can be dr/cr/st/ca/gl for debtors,creditors,stock,categories,general ledger Running {{{impstmin --qoh "file_name"}}} is used in stock to import the quantity on hand field, otherwise it will be ignored
Line 10: Line 19:
= STOCK FILE IMPORT - 44 fields = 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 - 53 fields ==
Line 19: Line 34:
 * Supplier 2  * 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
Line 22: Line 42:
 * Tax Code (3=0%, 4=10%)
Line 41: Line 62:
 * Statistical / Temporary (should be marked as a S or T)  * Statistical (separate field in Rel 11 - mark items with an S)
 * Temporary (separate field in Rel 11 - mark items with an T)
Line 55: Line 77:
= CREDITORS IMPORT - 22 fields =  * Print Labels
 * Lead Time (days)
== CREDITORS IMPORT - 24 fields ==
Line 66: Line 90:
 * accounts_email  * web_address
Line 75: Line 99:
 * Account_Name
Line 78: Line 103:
= CUSTOMERS IMPORT - 23 fields =  * Supplier Charges GST
== CUSTOMERS IMPORT - 27 fields ==
Line 102: Line 128:
= CATEGORY/DEPARTMENT IMPORT - 2 fields =  * Category Price Group
 * Stock Pricing Level
 * Special Price End Date
 * Point Rates
== CATEGORY/DEPARTMENT IMPORT - 21 fields ==
Line 105: Line 135:
= GENERAL LEDGER IMPORT - 8 fields =  * Category Type
 * Group_price_start_date
 * Group_price_end_date
 * Discount_Markup
 * Group1_DM
 * Group2_DM
 * Group3_DM
 * Group4_DM
 * Group5_DM
 * Group6_DM
 * Group7_DM
 * Group8_DM
 * Group9_DM
 * Group10_DM
 * Group11_DM
 * Group12_DM
 * Group13_DM
 * Group14_DM
 * Bonus Point Per Value
== GENERAL LEDGER IMPORT - 8 fields ==

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 - 53 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 (separate field in Rel 11 - mark items with an S)
  • Temporary (separate field in Rel 11 - mark items with an 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
  • Lead Time (days)

CREDITORS IMPORT - 24 fields

  • Supplier_code
  • Supplier_name
  • main_contact
  • main_addr1
  • main_addr2
  • main_addr3 (City, State, Postcode)
  • main_country
  • main_phone
  • main_fax
  • main_email
  • web_address
  • 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
  • Account_Name
  • Credit Terms (in days)
  • Past End of Month
  • GL Sundry Invoice Expense Account
  • Supplier Charges GST

CUSTOMERS IMPORT - 27 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 Price Group
  • Stock Pricing Level
  • Special Price End Date
  • Point Rates

CATEGORY/DEPARTMENT IMPORT - 21 fields

  • Category ID (Category code including department prefix, or just department prefix)
  • Category Name
  • Category Type
  • Group_price_start_date
  • Group_price_end_date
  • Discount_Markup
  • Group1_DM
  • Group2_DM
  • Group3_DM
  • Group4_DM
  • Group5_DM
  • Group6_DM
  • Group7_DM
  • Group8_DM
  • Group9_DM
  • Group10_DM
  • Group11_DM
  • Group12_DM
  • Group13_DM
  • Group14_DM
  • Bonus Point Per Value

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)