Reply
Highlighted
Member
Posts: 7
Registered: ‎11-11-2011
Accepted Solution

understanding database schema

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.

 

 


Accepted Solutions
Highlighted
Solution
Accepted by topic author Headwaters
‎08-21-2015 01:58 AM
Expert
Posts: 4,525
Registered: ‎03-08-2010

Re: understanding database schema

Highlighted
Solution
Accepted by topic author Headwaters
‎08-21-2015 01:58 AM
Posts: 1,609
Topics: 15
Kudos: 201
Solutions: 121
Registered: ‎06-23-2011

Re: understanding database schema

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.

View solution in original post


All Replies
Highlighted
Solution
Accepted by topic author Headwaters
‎08-21-2015 01:58 AM
Expert
Posts: 4,525
Registered: ‎03-08-2010

Re: understanding database schema

Schema at

https://api.authorize.net/xml/v1/schema/AnetApiSchema.xsd

Function is the

createCustomerProfileRequest

Highlighted
Posts: 1,609
Topics: 15
Kudos: 201
Solutions: 121
Registered: ‎06-23-2011

Re: understanding database schema

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.

Highlighted
Member
Posts: 7
Registered: ‎11-11-2011

Re: understanding database schema

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

Highlighted
Expert
Posts: 4,525
Registered: ‎03-08-2010

Re: understanding database schema

Look like someone got the TransactionDetail API to work with ColdFusion successfully.  With some code change, it should work with CIM too.

 

http://community.developer.authorize.net/t5/Integration-and-Testing/Transaction-Detail-API-and-Coldf...

Highlighted
Member
Posts: 7
Registered: ‎11-11-2011

Re: understanding database schema

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?

Highlighted
Posts: 1,609
Topics: 15
Kudos: 201
Solutions: 121
Registered: ‎06-23-2011

Re: understanding database schema

[ Edited ]

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.

Highlighted
Member
Posts: 7
Registered: ‎11-11-2011

Re: understanding database schema

[ Edited ]

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.

Highlighted
Posts: 1,476
Topics: 33
Kudos: 34
Solutions: 126
Registered: ‎09-14-2009

Re: understanding database schema

Sure. As long as your development environment supports PHP you could certainly use that to do your migration.


-------------------------------------------------------------------------------------------------------------------------------------------
John Conde :: Certified Authorize.Net Developer (Brainyminds) :: Official Authorize.Net Blogger

NEW! Handling Authorize.Net's Webhooks with PHP

Integrate Every Authorize.Net JSON API with One PHP Class (Sample code included)

Tutorials for integrating Authorize.Net with PHP: AIM, ARB, CIM, Silent Post
All About Authorize.Net's Silent Post
Highlighted
Posts: 1,609
Topics: 15
Kudos: 201
Solutions: 121
Registered: ‎06-23-2011

Re: understanding database schema

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.