Import data from XLS file and API to MYSQL

I'm setting up a domain registration service using DRAMS ([login to view URL]) and [login to view URL] I need to import users and domain names from enom to the mySQL data base used by Drams. I have a XLS file with ALL user accounts I have access to enom API so it can be used to get all domains and on witch user account it belongs to ([_[login to view URL]][1]) The problem is that I don't want to import accounts and domains that already have a creditcard filed at enom. This can be checked using the API command GetAllAccountInfo I don't want my users to notice the transfer, so before pushing the domains to the drams account, all email adresses must be changed to my adress so they dont receive the push confirmation email. after the push set the email to the original I think it should be done like this, but you might have a better idea: 1. API: Extract all accounts from the API that does not have a creditcard on file Use the command GetAllAccountInfo 2. DRAMS MySQL: Import all user accounts on MySQL 3. API: Update all accounts email to my own (save original email addresses before) Use the command UpdateAccountInfo 4. API: Get all domains under each account Use command=getdomains&tab=sub_iown (I'm not sure about this one) 5. API: Push all domains to one specific general account (I can do the Pushing on a list wizard online if you give me the domain list) Use command PushDomain 6. API: Update all accounts email to the originals Use the command UpdateAccountInfo 7. DRAMS MySQL: Delegate each domain under right account We are talking about 400 users and 200 domain names ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Enom API MYSQL I will give you the .xls file, access to API (Thru IP) and access to the MySQL server