I have been testing the import process for Customers.
I generated my list from MYOB into a CSV file format via MYOB export.
I then imported that file in to a BLANK Excel Spreadsheet (worksheet sheet2).
Then I utilised manager BATCH CREATE in Customers to copy the table headings.
I then go back to Excel, this time on worksheet sheet1, past the columns in.
Then I simply used formulas to crab what i require from sheet2 into sheet1.
Up-to this point no issues.
Addresses is the only issue I have. MYOB provides Adress line1…>4, post code, state and city seperately.
So in excel worksheet1 i simply concatenate all these fields together, with a space between each field.
This address gets imported into manager as a single line as expected.
What do I use between each field to get the city, state & post code on separate lines in the address field in manager.
I have attempted to use Carriage Return (CR or CHAR(13)) and also Line feed (LF or char(10)) and combinations.
I even created a dummy customer and did an export, but the export does not export all details.
Anyone have any ideas.