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.