How can I import data from an existent MySql / SQL Server online database?
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. [Back to top] • When importing a .csv / .txt file I get an error 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: 1) Create a new .txt file with Notepad (it is very important that the file is created from scartch) 2) Open the old file with Notepad and copy all the text 3) Paste the text in the newly created file 4) Import the newly created file This should correct ANSI problems in most situations. Obviously this is a
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. 3. When importing a .csv / .txt file I get an error 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.
