ez Publish - Sugar CRM (Bridge)

Next topic

Author	Message
Anita H	Monday 29 December 2008 4:13:03 am Hi All, I'm interested in building up a bridge from ez Publish to sugar CRM or vice versa. Thinking of having e.g. customer classes in ez Publish which belong to an "owner" equals my contact who I'd like to keep in sugar CRM. The idea is to link automatically added customer classes from ez Publish to contact/lead in sugar CRM. However, does anyone have any experience with bridging ez Publish to sugarCRM and therefore experience I might learn from? Thanks Anita
Heath	Monday 29 December 2008 4:26:36 am Hello Anita, It seems like some software [1] has been created to fill the needs of sugarcrm and ezpublish projects. While others were planning together to create additional functional works. [5] [1] <i>http://www.sugarcrm.com/forums/showthread.php?t=17895</i> [2] <i>http://www.buildcms.com/tech_corner/modules/buildcms_sugarcrm_bridge</i> [3] <i>http://www.buildcms.com/tech_corner/documentation/buildcms_sugarcrm_bridge_register_lead</i> [4] <i>http://ez.no/developer/contribs/applications/buildcms_sugarcrm_bridge</i> [5] <i>http://ez.no/developer/open_funding/suggestions_for_new_functionality/sugarcrm_integration</i> [6] <i>http://ez.no/developer/forum/developer/soap_webservice_with_ez_publish_4_0</i> Cheers, Heath Brookins Consulting \| http://brookinsconsulting.com/ Certified \| http://auth.ez.no/certification/verify/380350 Solutions \| http://projects.ez.no/users/community/brookins_consulting eZpedia community documentation project \| http://ezpedia.org
Anita H	Monday 29 December 2008 7:04:19 am Thanks a lot, Heath. I had a look on the Bridge from buildcms. Then I was struggeling with different ideas whether an integration should be done - from ez Publish to sugar or sugar to ez Publish and/or - with library or directly on DB level, eg. with triggers However, as I just started with sugar (actually today) and still am a newbe to ez Publish I'll need to put in more thoughts. Anyhow if you've got an advise I'm more than happy. What I want to achieve: - custom classes brought up in ez Publish, e.g a product, belong to a contact. - the contact administration I'd like to do in sugarCRM - therefore I would like to push the instances of my ezPublish classes into the sugarCRM and therein link it with the respective contact (one contact could have many products) The product information in sugar is only meant for reading purposes (one way pushing data: always from ez Publish -> sugar - However, having said that I could easily think about a full integration as a phase two... So, not sure whether I succeeded in making clear what I wonna achieve but would be happy to receive any thought, advise, idea, example.... Thanks a lot Anita
Heath	Monday 29 December 2008 7:08:07 am I just now noticed to find a project which also provides related SugarCRM features. <i>http://projects.ez.no/nmsugarsoap http://svn.projects.ez.no/nmsugarsoap/trunk/</i> The above extension provides a simple contact datatype which provides a relation list of sugar crm contacts and stores a selection of one or many. This datatype can be added to any class like product, which sounded like part of what you were looking to add to your ez installation. (eZ <- Sugar) One might consider creating a library which provides for reading of information via soap from sugar. (eZ -> Sugar) I don't know offhand if their soap api provides for writing information if so you might just want to go with soap for writes as well to sugar. (Sugar <- eZ) I would avoid sql when working with the eZ db and use the ez php api instead to fetch information through php say from a sugar module. Cheers, Heath Brookins Consulting \| http://brookinsconsulting.com/ Certified \| http://auth.ez.no/certification/verify/380350 Solutions \| http://projects.ez.no/users/community/brookins_consulting eZpedia community documentation project \| http://ezpedia.org
/dev/null	Monday 29 December 2008 7:44:42 am Some development required in any case to end up with the polished solution you describe even using the available software solutions as a basis. eZpedia community documentation project: http://ezpedia.org
Anita H	Monday 29 December 2008 7:57:36 am sounds like a good starting point;-), downloaded the soap interface... Thanks a lot for your support, Heath. Will digg into it and ok, drop the idea of triggers ;-) ... cheers Anita
Softriva .com	Tuesday 16 February 2010 9:43:44 pm Hello, Any update regarding this issue? Thank you HAB

eZ debug

Timing:	Jan 18 2025 05:22:29
Script start
Timing:	Jan 18 2025 05:22:29
Module start 'layout'
Timing:	Jan 18 2025 05:22:29
Module start 'content'
Timing:	Jan 18 2025 05:22:30
Module end 'content'
Timing:	Jan 18 2025 05:22:30
Script end

Main resources:

Total runtime	0.8617 sec
Peak memory usage	4,096.0000 KB
Database Queries	73

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0047	587.9141	152.6250
Module start 'layout'	0.0047	0.0033	740.5391	39.4453
Module start 'content'	0.0080	0.8521	779.9844	687.5781
Module end 'content'	0.8601	0.0015	1,467.5625	20.1641
Script end	0.8616		1,487.7266

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.3998	16	0.0002
Check MTime	0.0013	0.1514	16	0.0001
Mysql Total
Database connection	0.0006	0.0744	1	0.0006
Mysqli_queries	0.7815	90.6905	73	0.0107
Looping result	0.0008	0.0889	71	0.0000
Template Total	0.8320	96.6	2	0.4160
Template load	0.0019	0.2249	2	0.0010
Template processing	0.8301	96.3347	2	0.4150
Template load and register function	0.0001	0.0154	1	0.0001
states
state_id_array	0.0009	0.1009	1	0.0009
state_identifier_array	0.0016	0.1843	2	0.0008
Override
Cache load	0.0018	0.2088	82	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0009	0.0998	4	0.0002
Fetch class attribute name	0.0012	0.1361	10	0.0001
XML
Image XML parsing	0.0030	0.3495	4	0.0008
class_abstraction
Instantiating content class attribute	0.0000	0.0029	13	0.0000
General
dbfile	0.0023	0.2665	29	0.0001
String conversion	0.0000	0.0009	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
6	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
7	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
24	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
18	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 57 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs