I have an existing customer database in MySQL. Would like to migrate this data to CIM and manage it there.
Downloaded and read the Developer Guide (XML), tried to find database schema or at least a list of all the values that can be stored or associated with a particular customer. Aiming to map the existing database to CIM so I can figure out how to migrate everything.
I see the various input parameters are listed under various functions, but finding it a little tricky to try and build up a master list of all the parameters available.
Any advice or suggestions would be appreciated.
Solved! Go to Solution.
11-11-2011 07:45 AM
Schema at
https://api.authorize.net/xml/v1/schema/AnetApiSchema.xsd
Function is the
createCustomerProfileRequest
11-11-2011 09:18 AM
Well, it's just like profile creation if you're using regiar (not hosted) CIM, only you have to load the data from your database or file or whatever you have the data stored in and then run through it one record at a time. What format is your data stored in right now? Do you have a user associated with each set of data? I don't have an exact piece of code handy, but I'm familiar enough with the API that I can probably write something fairly quickly if your data is in CSV or mySQL format and doesn't require too much massaging. Figure like $150-$200 max, maybe less if it goes quickly. Time frame would be 2-3 days since I have another project I need to work on tomorrow, and I'll need a data sample (fake credit card is fine, but everything should be formatted exactly the way it will be in the real file).
If you want to do it yourself, look at the CIM.markdown file in the doc folder of your SDK, it will explain more or less how to do it.
12-26-2011 07:23 PM
Schema at
https://api.authorize.net/xml/v1/schema/AnetApiSchema.xsd
Function is the
createCustomerProfileRequest
11-11-2011 09:18 AM
You didn't mention which SDK you'll be working with, so I'm going to assume for the sake of argument you'll be using PHP. Download the SDK, look in the doc folder for a file called CIM.markdown. This will contain fairly straightforward code for creating profiles with shipping addresses and billing profiles and so on. The CIM XML guide, which you probably already have, gives a comprehensive list of the fields available, albeit perhaps a bit hard to understand without the markdown file mentioned above.
11-12-2011 05:43 PM
Thanks for the responses.
This site is actually ColdFusion. I'm going to guess there isn't an SDK for that. Is it even feasible trying to integrate CIM into a ColdFusion setup?
Thanks
11-21-2011 08:18 AM
Look like someone got the TransactionDetail API to work with ColdFusion successfully. With some code change, it should work with CIM too.
11-21-2011 08:30 AM
Thanks for the tips.
So what are my best options for migrating the existing data? Is there someway to automate this? Or are we pretty much looking at a manual re-entry for each existing record?
12-05-2011 08:19 AM
Even CF can do XML posts, so you ought to be able to just run through all your records one at a time, fill the values into an XML template, post to Authorize.net, then parse the return XML for profile ID's (or error codes). I don't code in CF, however, so I can't supply sample code.
EDIT: You could also try submitting a ticket to Authorize.net and see if they can import your data for you for a fee. This may be more efficient than coding an import yourself.
12-05-2011 10:19 AM - edited 12-05-2011 10:20 AM
Actually, for the purposes of migrating the data, a one-time operation (hopefully!), who says I need to code in CF? Could I just write a PHP script that reads the MySQL database, restructures the data as needed, and inserts it through the CIM API?
Integrating the CF site, however, would take a bit of CF futzing I'm sure.
12-15-2011 01:35 PM - edited 12-15-2011 01:36 PM
Sure. As long as your development environment supports PHP you could certainly use that to do your migration.
12-15-2011 01:47 PM
You -could- even write the entire interface with Authorize.net in PHP, there's no reason why 100% of your site has to be CF. Of course, this might mean duplicating your site template, but that's probably easier than figuring out Authorize.net in CF. There's already an excellent code base in PHP.
12-15-2011 02:44 PM