ContactImportSage

Created by: Lester Caine, Last modification: 15 Oct 2010 (17:16 BST)

CSV import of sage data ....

ACCOUNT_RE
NAME
ADDRESS_1
ADDRESS_2
ADDRESS_3
ADDRESS_4
ADDRESS_5
CONTACT_NAME
TELEPHONE
FAX
ANALYSIS_1
ANALYSIS_2
ANALYSIS_3
DEPT_NUMBER
VAT_REG_NUMBER
TURNOVER_MTD
TURNOVER_YTD
PRIOR_YEAR
CREDIT_LIMIT
TERMS
SETTLEMENT_DUE_DAYS
SETTLEMENT_DISC_RATE
DEF_NOM_CODE
DEF_TAX_CODE

The sage data is exported via a CSV dump from the reporting package ( pictures to be added ).

Data is transfered from the temporary sage table to contact_xref using an external sql script, where entries are created for the phone and fax details, along with VAT and turnover figure.