Most applications (including Goldmine, Palm Desktop, Microsoft Excel, Microsoft Access and FileMaker) will allow you to export data into a comma delimited text file (.csv)
Exporting from Outlook Express
Outlook Express allows you to export data in a CSV (comma separated values) format which can then be imported.
-
Launch Outlook Express and select File | Export....
-
Choose Comma Separated Values and click Export.
-
Choose a file name for the exported data and click Next.
-
Select Email Address field (select other required fields if you are going to pre-populate them into your survey before distribution).
-
Click Finish.
Exporting from Microsoft Outlook
Microsoft Outlook allows you to export data in a CSV (comma separated values) format which can then be imported.
-
Launch Microsoft Outlook and select File | Import and Export.
-
Select Export to a file and click Next
-
Select Comma Separated Values (Windows or DOS).
-
Select folder to export from and click Next
-
Save exported file and click Next
-
Click the Map Custom Fields button to select the necessary fields for the exported file.
-
Click Finish.
Exporting from Other Data Sources
You can import data into the system from any other application that can create a CSV (comma separated values) file.
-
Save your data source as a CSV file.
-
Ensure that:
-
This file contains Email field. Your survey will be sent to email addresses indicated in this file field.
-
This file does not contain fields which you do not want to import to your survey including field headings (such as Email, Name etc.), page brakes etc.
-
Only commas or semicolons or tabulation serve as delimiters/list separators (If your file contains other separators you may need to change Regional Settings on your computer).
-
Example of the CSV data file structure exported from the data source:
It contains name, email address, phone number, department and position columns:
Smith,John;JSmith@domain.com;674-67-61;Consulting;Chief Consultant
Brown,Barbara;BBrown@domain.com;786-44-09;Sales;Manager
Young,Peter;PYoung@domain.com;534-94-23;Promotion;Manager
Jordan,Mary;MJordan@domain.com;;Not known;Manager
Williams,Helen;HWilliams@domain.com;674-67-54;Consulting;Secretary