CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Integrating CiviEvent with Third Party External Website
Pages: [1]

Author Topic: Integrating CiviEvent with Third Party External Website  (Read 751 times)

mcarson

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 5
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.4.22
Integrating CiviEvent with Third Party External Website
May 30, 2010, 05:19:40 pm
I am working as a volunteer/IT consultant where my job is to implement CiviCRM on a local server (i.e. localhost) - Windows IIS!

The company already owns a hosted website where events are created using a third party system. This system allows registration by contacts for events, similar to CiviEvent. The company does not want to replace the current system but rather investigate about integration between the two systems.

Is it possible to:
1.    Export event data on a schedule to a 'standard' file (xml)
2.    Send this via http to remote system (up to third party to develop this end)
3.    When a file (xml) is received from remote system, the events database is updated with attending contacts

Basically, is there any info you can provide on the structure of the MySQL CiviEvent system so I can research/investigate if it is possible to perform exports and imports of event/attendee data?
If this is possible (MySQL scripts?), I wouldn't have a problem with coding a small utility (albeit in .NET) to perform the actions. As for php, I am getting better - it's starting to look a LOT better than ASP.NET!

Thanks in advance,

Mark

PS. I have been documenting every step involved in this current project undertaking, which is going well so far. This current requirement is almost fundamental to the company, I would be very grateful for any assistance. 
“Anyone who has never made a mistake has never tried anything new.” - Albert Einstein
"If you are travelling at the speed of light and you turn on your headlights, would they work?" - Unknown

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Integrating CiviEvent with Third Party External Website
May 31, 2010, 02:07:50 am
I don't know if your approach is really recommended, but you can see here http://en.flossmanuals.net/CiviCRM/DevelopAPI for more info about various APIs to do what you want. The REST API may be useful for this.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

mcarson

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 5
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.4.22
Re: Integrating CiviEvent with Third Party External Website
June 02, 2010, 02:10:43 am
Thanks for the reply.

I was more interested with information on the MySQL data structure in order to generate a SQL script to extract relevant records and later add/update information later. (only researching at the moment)

Is there anywhere that can assist?

Thanks

Mark
“Anyone who has never made a mistake has never tried anything new.” - Albert Einstein
"If you are travelling at the speed of light and you turn on your headlights, would they work?" - Unknown

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Integrating CiviEvent with Third Party External Website
June 02, 2010, 03:15:24 am
I definitely wouldn't recommend directly querying the DB, but anyhow there is here some VERY old diagrams http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+ERD+2.0 which are only partially relevant today b/c this is an older version of CiviCRM.

Beyond that I would say to just examine the schema directly--the table and field names are mostly intuitive and the structure overall is fairly standard.

HTH
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Integrating CiviEvent with Third Party External Website

This forum was archived on 2017-11-26.