SugarCRM OpenX Integration?

[isay]

Hi there!

I need integration between SugarCRM and OpenX.

The desired functionality would be to initiate the process from Sugar: create an account, and then synch accounts with advertisers. In the best of worlds the synching should be both ways..

Anyone who developed such an interface?

Best regards,

Mikael
CRM @ iSay Consulting

[parhamdb]

Hi,
Shouldn't be so hard.
Just write custom logic so when ever you create an account, automatically create one in OpenX.
take a look at openX soap api here: https://developer.openx.org/wiki/dis...I+Tutorial+(v1)
you can probably do alot more then that, fully integrate openX with sugarcrm and have advertisers/publishers, their related zones, campaigns and everything controlled through sugarcrm.
take a look at my SugarCRM/JBilling integration:
demo.osintegra.com/sugarcrm/
username: demo1
password: demo1
I've done similar things in the past, let me know if you get stuck or need help with that.
its pretty much doing the same thing, creating and managing jbilling accounts through sugarcrm and related orders, invoices and payments ... so nobody needs to use JBilling's ugly api anymore and all is done through sugar's pretty UI.

Cheers,
Parham

[isay]

Great! Thanks! Will start looking at the openx API now.

Thanks for letting me into your demo-site. Wow, the jbilling-integration looks great. I never used jbilling, but this type of functionality - creating orders and invoices looks great. This is something I might need for another project... Fantastic that it can be done without the need for sugarcrm pro... Tough to implement?

[isay]

Ok, first milestone achieved. Synching Sugar accounts with OpenX advertiser...

parhamdb: A general question - how/from were do you initiate the comunication? Do you have a scheduled process running with sugar or is the interface triggered when you hit save? In the future I'd like the interface to update data from both ends... What kind of setup do you recommend?

Tank you for your help!

/Mike

[parhamdb]

Great Job isay!

Since account is a built in module and you don't want to mess with sugar's existing code and make your code upgrade safe, you should use "Logic Hooks". check that out. you can call OpenX's Soap right after save. If you check out logic hooks, you'll see some examples for this. to initiate soap calls, use sugarcrm's soap libraries(3rd party soap library shipped with sugar called nusoap). won't be that hard, let me know if you get stock, will do my best to help you out.

personally, I do hate scheduled jobs for any syncing. yes it is practical and may be less coding but just the idea of data modifications with delay is not my thing.

now, you need to associate sugar's account records with openx's account records for one way sync. you need to create another field in accounts table/module. lets say account_openx_id. so when ever you make modifications on the sugar side, you use this id to call openx to update with this id.

for two way sync, you need to pretty much do the same thing in openx, when ever you modify an account in openx, call sugar and create the account. this is going to be much harder, avoid it if possible. you have to have some mechanism to stop infinite loop, each one calling the other one's save...

if you have them both on the same database, you can use database views to have the data available in the other application in the format that the second application expects. but this trick pretty much works for read only data ( you can use views to update/insert/delete records in some situations, but avoid that since you will get complexity with caching).

Cheers,
Parham

[ajri02]

Hi,
]https://developer.openx.org/wiki/display/API/OpenX+APIgiaTutorialvang%28v1%29

But no direction for interation between openx and sugarcrm

[parhamdb]

Dear Ajri,
No there is no information on how to do the integration. You can use that API to create accounts in OpenX when you create accounts in sugarcrm.
Cheers
P

[dionysus]

this would be great

[nagarajkonaguthi@gmail.com]

Hi,
Shouldn't be so hard.
Just write custom logic so when ever you create an account, automatically create one in OpenX.
take a look at openX soap api here: https://developer.openx.org/wiki/dis...I+Tutorial+(v1)
you can probably do alot more then that, fully integrate openX with sugarcrm and have advertisers/publishers, their related zones, campaigns and everything controlled through sugarcrm.
take a look at my SugarCRM/JBilling integration:
demo.osintegra.com/sugarcrm/
username: demo1
password: demo1
I've done similar things in the past, let me know if you get stuck or need help with that.
its pretty much doing the same thing, creating and managing jbilling accounts through sugarcrm and related orders, invoices and payments ... so nobody needs to use JBilling's ugly api anymore and all is done through sugar's pretty UI.

Cheers,
Parham

Hello Parham,

Colud you please help me out in calling the Jbilling Webserivecs to update the active_date through sugracrm custom modules?

Please help me.

Thanks,
Nagaraj