Biz Connection Newsletter System comes with both an import and an export feature which allows you to import subscribers into your mailing list(s) database and export subscribers from the current subscribers database together with custom fields and other details.
Newsletters: Correct CSV format
Having trouble importing your CSV and you don’t know what’s causing the issue? Well here are some simple steps to check that your CSV file is in the correct format, if it isn’t then there are some simple instruction how to correct it:
Open the CSV using a simple text editor
Right click on your CSV file and open it with ‘NotePad’ or a similar sort of software. Is each entry on a new line? If it isn’t then the format is incorrect. If it is then your uploading CSV issues are from else where. Please contact Tribulant’s support team for assistance.
Below is an image of what the CSV file looks like if it is not correct.
If this is what your CSV looks like when you open it, no need to worry, its a quick fix.
Open your CSV with Microsoft Excel/iWork Numbers
We suggest using Excel, but Numbers does the same thing. Once your CSV is open, click Save As and make sure that the file type is ‘CSV (comma delimited) like the image below
IMPORTANT: When saving in Excel on Mac, please be sure to select “Windows Comma Separated Values (CSV)” when using Save As…
Save it again then open it up in NotePad again, you should notice that each entry will be on a new line. This is how it is meant to look and if it does then your CSV should upload without any issues. Below is an image of the correct layout.
This should be you sorted. As long as the CSV file has a new line for each entry in NotePad then there should be no hassles trying to upload it.
At some stage during your usage of the Biz Connection Newsletter Platform, you might need to export your current subscribers of either all lists or a specific mailing list for backup purposes or for alternate use.
The plugin allows you to export subscribers to a CSV spreadsheet which you can immediately download and an additional (optional) feature which allows you to email the CSV document to a specific email address as an attachment.
In order to export your subscribers, navigate to the “Newsletter” > “Import/Export” section of your dashboard. Scroll down past the “Import” section, until you see the “Export” heading.
1. Mailing List
You need to select the specific mailing list of which you’d like to export the subscribers from. There is also an option entitled “All Mailing Lists” which will export all the subscribers from all the available mailing lists.
2. Export Status
This is only visible depending on your selection for the mailing list. Check one of the boxes depending on which subscribers you wish to export.
3. Email Export
An additional feature is available, allowing you to email the exported CSV to an email address as an email attachment. In order to use this, check the “Send as an email attachment” checkbox and fill in the email address to which you’d like to send the exported file. The default email address in the field will always be the WordPress administrator’s email address.
4. Export Subscribers Button
Once you are satisfied with all of the above click this button to export your selected subscribers.