25.2. Import companies from 'pipe' (|) delimted file
To import a pipe delimited file follow these steps:
1. First create a spreadsheet with the following column headings:
Name, Address1, Address2, Address3, City, State, Zipcode, Website, Phone, Fax, Ticker, Email, Location
Note: Each heading must not have any spaces either before or after the word.
2. Each row will have information for only one company. You can add as many rows (companies) as you like.
3. Save the file as a normal spreadsheet.
4. Go to Start > Control Panel and choose Regional and Language Options
5. Click on Customize
6. Change the list separator field from a comma ’,’ to a pipe ’|’.
7. Click OK and again on the Regional and Language Options
You can change this back to a comma once we’re done.
8. Back to the spreadsheet.
9. Click on File > Save As
10. Choose CSV (Comma Delimited)(.csv)
11. click Save
12. In MyJobSearchPilot go to the Companies page.
13. Click on the Import Companies link
14. click Browse and choose the csv file you just created