How to retrieve unique information from a .csv file (already exist) and send it in a mail to unique customer? - autoresponder software
I want a book to give my client and requires a username and password for access. I have already generated a list of unique combinations (user name and password) through the eBook software and stored in a file. Csv on my website. After successful order is processed by any system of order, I want to start a process.
This is the entire process:
- After the order is processed successfully, it will use the customer data (name, e-mail, etc.) into the order processing module, or some other method to gather customer data.
- The combination should be used only once to identify and files. Csv.
- Obtain information (username and password) for the customers through the creation of an e-mail or voice mail.
- The whole process is automatic so until it works again and again without my doing anything for any of my new clients.
How to encode the entire process?
Thursday, January 14, 2010
Autoresponder Software How To Retrieve Unique Information From A .csv File (already Exist) And Send It In A Mail To Unique Customer?
1 comment:
Opening and management of a file. CSV (flat files) from the application becomes a problem when using a database. Especially if you want to allow their customers to adapt / change the password. And it's much easier to add, update and delete rows and columns in the table (like adding and deleting records of clients or to change the password). I suggest you select a database with a type (such as MySQL, MSSQL or access to rigor) and create a table in CSV.
In addition, the CSV file, the performance data growth will be affected. This does not degrade as much when you use a database. With a database, it is easier) (and faster, a line that can access your client / password. Then you can use ODBC to retrieve data.
More than that, you can create relationships between tables, the table can be linked to access to the table of customer data, accounting spreadsheets, etc. So, if your client is in default of payment, you can connect through the accounts (with riGht table columns and coding).
Since I do not, what programming environment you know, I was not really easy to give examples. But surely start from the CSV file into a database to allow for growth and easy handling.
--- Update 1.40
Still used with the database system because it add the old and the need for new (database maintenance). I would add a column that is used called "used_flag" or the like, and with a 1 to a marked, and 0 if not used. You can even have a column "used_by" to the user who received a combination of user name password to a story in the box to select it.
So you need something like this:
Select Record password, username
ebook_table used_flag WO = 0 LIMIT 1;
This is the first line that contains an unused username / password combo box, and you can save record this handset.
So ...
# Used_by UPDATE SET ebook_table = &039; user@somehost.com, used_flag record = 1 where = 'XXXXX';
Where XXXXXX is the number that you save the previous selection.
With this update, the password / login combination is used, how and who had used it. You can even additional information, if you want the date, time, serial number, etc., with additional columns.
You want to make these two SQL queries in quick succession to avoid the problems of the races (two clicks on the Internet exactly) at the moment in time, given the same record. There are other considerations too. A database can prevent blocking problems. For example, a CSV file can be locked (file level) to other applications, which occur at the same time to prevent in time. MySQL, MSSQL, and Access can be configured for row-level locking, so that other users accessing the table when a user is locked a specific folder.
All the things that you occupy. With CGI, I would say that PHP-MySQL interfaces that will allow easy access to data from databases. I csend a sample code to do this if you need it. But I think if you install PHP (eg Apache or IIS), PHP MySQL has many very good examples.
You can wish me an e-mail if you need more information.
Post a Comment