Import/export in ccNewsletter

ccNewsletter comes with the option to import and export subscribers. Choosing “Import/Export” from the main “ccNewsletter” menu or the top navigation bar will display the “Import/Export” page. 

Import

Text file (.txt)

You can import users from a text file. When importing files, make sure they have the correct file extension visibly at the end of the file. For example, a file should be named import.txt. Pay extra attention to this if you are a Mac user. 

You can use one of the 3 file formats to import different kinds of data:

• Format 1: e-mail only: Add a e-mail address in this format per line: email@address.com,
• Format 2: name & e-mail: Add name and e-mail like his, one per line: name;email1@address.com, 
• Format 3: e-mail, name, status, subscription date: email1@address.com; Name 2; 1; 2012-08-21 11:30:01,

If “Text file” is selected in the “Import type” dropdown, new fields for delimiters will be shown:

• Column delimiter: specify a delimiter that separates the subscribers data. Examples a use a semicolon “;”. You can disable the column delimiter if you are only importing a list of e-mail addresses. 
• Row delimeter: specify a delimiter that seperates the individual subscribers. Examples a use a comma “,”.

Before importing you can choose to: 

• Delete subscribers: delete all subscribers or subscribers from a certain group (if you have any enabled groups), before importing the new text file
• Add subscribers: add subscribers to the all subscribers group or a certain group (if you have any enabled groups), before importing the new text file

CSV file (.csv)

CSV stands for “comma separated value”. With this option you can import users from a CSV file. When importing files, make sure they have the correct file extension visibly at the end of the file. For example, a file should be named import.csv. Pay extra attention to this if you are a Mac user. 

The CSV file formats are given in the following example:

• Format 1, e-mail only:
  email@address.com
  testname1@address.com
  testname2@address.com 
• Format 2, name and e-mail:
  name,email@address.com
  testname1,testname1@address.com
  testname2,testname2@address.com
• Format 3, name, email, status/enabled, subscription date:
  Name,E-mail,Enabled,”Subscription Date”,
  testname1,testname1@address.com,1,”2012-07-24 13:44:37″
  testname2,testname2@address.com,0,”2012-07-24 13:43:57″
  testname3,testname3@address.com,1,”2012-07-24 13:44:11″ 

Text area

You can import email addresses manually by entering them in the text area. Make sure that the email addresses you have entered have a correct structure (name@domain.com) and are separated by a comma. They can be listed behind each other or one per line, as long as there is a comma separating them. 

• Example: testname1@address.com,testname2@address.com

Export to csv

Subscribers can be exported to a CSV file. You can export all subscribers, or only the subscribers from a certain group (if you use groups in ccNewsletter). After export, you can import the same file back into ccNewsletter (on another website for example) by using the above CSV import function. 

CSV files can be read by most spreadsheet programs like Microsoft Excel and Google Spreadsheet. You can also use those programs to manipulate the file contents. There are also specialized CSV editing programs and tools for more advanced management of the files. To find them, google “windows CSV software” or “Mac CSV software” etc.