Simply create a script in any server-side language (Asp, PHP, etc) which will show all your database records in a “csv” format (one record on each line, fields separated by comma or semicolon); then, when importing, tell SendBlaster the url of this page. This also applies to any online database, such as postgres, SQL server, etc.
How to import mailing lists category Page 2 of 2
The file probably contains non-ANSI characters: if an “end-of-file” character is encountered, which should not be present in an ANSI file, this error could occur. Please make sure your csv file contains ANSI characters only. If you want to convert it and / or correct it, here is what you can do:
- Create a new .txt file with Notepad (it is very important that the file is created from scartch)
- Open the old file with Notepad and copy all the text
- Paste the text in the newly created file
- Import the newly created file
This should correct ANSI problems in most situations. Obviously this is an emergency trick only: configure the program you are exporting from so that it creates ANSI-compliant files.
This is due to a bug in a Microsoft dll used by SendBlaster, which has not been corrected by Microsoft yet. It is caused by the <!DOCTYPE…> tag in the opening part of the page, just before the <html> tag.
In order to avoid the error, before importing the page open it with any text editor (Windows Notepad is ok) and remove the <!DOCTYPE…> declaration (even better, remove anything before the opening <html> tag).
