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.
Well the <br> sounded like a great idea, but it did not work.
The below line is a snippet of what was pasted in to a BatchUpdate and also a batch create
eg Shop 2 383 Nepean Highway <br>PARKDALE<br>VIC<br>3195
What you see above is what is displayed in the customer address including the <br>.