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

Re: understanding database schema

Thanks.

 

I downloaded the PHP SDK and CIM integration sample code. But where would I find some sample code to handle the migration of data? Or do I need to start from scratch on that?

 

Appreciate the tips.

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

Re: understanding database schema

Authorize.net may be able to do a one-time import for a fee, you'll have to submit a ticket or call to verify. Short of that, you'll just have to convert all the profiles to profile ID's by running them through the CIM API one at a time.

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

Re: understanding database schema

I asked Authorize.net about that, they don't offer any services for importing data.

 

I was just hoping somebody else had done this operation in PHP and I could see how they coded it.

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.

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

Re: understanding database schema

Thanks, I'm looking at that CIM.markdown file now and will get back in touch. Appreciate the offer of help.