Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Sun Oct 30 10:24:40 CST 2005
Dear List: I need to collect the order and download information from our web site where we will be selling The Sleep Advisor. Does option 3 below look like an easy and/or viable solution? Would I need to use ADO or can it be done in DAO (with which I am more familiar)? Does anyone have a code snippet to get this started? MTIA Rocky Smolin Beach Access Software http://www.e-z-mrp.com 858-259-4334 ----- Original Message ----- From: Zachary Naiman To: Rocky Smolin - Beach Access Software Cc: Rubin R. Naiman, Ph.D. Sent: Sunday, October 30, 2005 8:03 AM Subject: Re: Email Address for Sleep Advisor Orders hi Rocky, yes, we collect those email addresses also (from the beta test that my dad did i confirmed it). we have the following options for downloading the databases from online: 1) I could build a CSV creater (about 1 hr of work) where you put in a password to access a file that allows you to download each table as a csv 2) You could install a great program called SQLyog, which will allow you to see, download and manipulate the database in real time 3) You could download the MySQL ODBC driver here http://dev.mysql.com/downloads/connector/odbc/3.51.html and then configure access (using the log-in information that your Host company, CostCo, sent you) to synchronize tables, such that every time you open your access file you'll be looking at the current data on the server. I highly recommend #3 -- it's free and quick, and you'll probably have no trouble doing it since you're an access guy! Also, that's what I'm going to set up for my dad so that he can keep the Resources database up-to-date. If you set that up today, the tables of interest in terms of payments are: 1) paypal_payment_info: this table collects the data the PayPal posts to us after a transaction (the IPN data) 2) sleeprog: this table collects the Download data -- the name and email of the person with download rights, the number of downloads left (3,2,1 or 0) and a timestamp the other three tables you see are for the Resources page. let me know what you decide and how it goes if you do #3. z ----- Original Message ----- From: Rocky Smolin - Beach Access Software To: Zachary Naiman Cc: Rubin Naiman Sent: Sunday, October 30, 2005 7:52 AM Subject: Email Address for Sleep Advisor Orders Zach: Is it possible to collect the email address of people ordering the sleep advisor on line - not the download - obviously we'll have it from that - but for those who want the product shipped. What I'm thinking of is 1) to later collect the results of their assessment for analysis (I built in a back door for exporting their results like the Betas) and 2) building a mailing list for future products, updates, etc. Sometime this week I need to find out from you how to access and download the order records from our site. What's convenient for you? Rocky