Fixing Data Ready For Importing
NOTE: Workshop Software recommends that you engage our services to carry out importing. While the import process may be something that you can do on your own, we often find that clients do not carry out the process correctly, or can sometimes end up investing more with us to fix the issues, and re-do the import. Workshop Software does not provide support around importing data, if you need our assistance, we are happy and willing to provide it, and may come at a cost. Please contact the support team if you require further details.
- Splitting up the First Name and Last Name - https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7
- Merge Company Names back together - https://support.office.com/en-us/article/Combine-the-contents-of-multiple-cells-3a86c317-6b91-4f1d-8781-203320aefdce
For the merging, you will need to sort by name on each column, starting at the last column, and moving back to the 3rd column. Once at the 2nd column, these are your first name and last name, and must remain split. http://www.contextures.com/xlSort01.html
Once you have the values in the first name, last name and Company Name columns, sort by company name http://www.contextures.com/xlSort01.html
C = Company
I = Individual
Put a C in the first row with a company name in it. Drag this field until the last company name
Do the same for I where there are only first and last names
Spitting up the address
This is only required if the Suburb, State and Postcode are in the same column as the address
Merge the address back together without the suburb, state and postcode - https://support.office.com/en-us/article/Combine-the-contents-of-multiple-cells-3a86c317-6b91-4f1d-8781-203320aefdce
The columns left over, rename them to the respective names "suburb, state, and postcode. The merged field, name "Address".
Phone numbers, and any number with a zero on the front, will remove the zero. Please follow this guide as the last step: http://www.upenn.edu/computing/da/bo/webi/qna/iv_csvLeadingZeros.html
Update the names of the Body types using this list: http://help.workshopsoftware.com/article/40-body-type-list If there is NO body type, or the body type isn't on this list, use the word SEDAN
Update the Transmission Types using this list: http://help.workshopsoftware.com/article/39-transmission-category-list If there is NO transmission type, or the type isn't on the list, use the word N/A.