CiviCRM

As part of the effort to refine the useful documentation for non-developers I am trying to expand kreynen's 12 step program for an OMP install. I was tempted to post this as a wiki - but it is very rough, incomplete working path at a public access TV station that just has two staff. For those who have gone through the process or my be farther along - please feel free to comment and provide any feedback. What's missing - really help us break it down. We're moving slow and steady here. - Jason

-----

I've aggregated content related to the Open Media Project and CiviCRM from several sources (GDO, openmediaproject.org, blip.tv, DOM) and compiled it in list form here. This content deals with integrating CiviCRM and MERCI, establishing CiviEvents for classes, as well importing Facil data. My reason for doing this is because I completed importing data into MERCI, and am looking to re-import user data and focus attention on the CiviCRM side of things. I started looked at all these resources independently and realized it be good if they were all on one page.

I'm trying to deal w/ script "2_person_groups.sql" and I'm having a devil of a time getting through parts of this one (and I'm sure it'll happen again later on too).

I don't understand why there's a line CONCAT("Facil import: tblPerson.PersonID=", PersonID)   AS description, -- it seems to me that this pulls in a user ID number from a member and uses it as the group description. But that line makes sense in a subsequent script, so I think it might be an error due to copy and paste.

Also, the script doesn't work, at least for me at Boston.

In Portland last week, I discovered that Portland Community Media was using Hypertext Transfer Protocol Secure (HTTPS) instead of plain HTTP on the web server to protect data in CiviCRM. That makes sense. In Austin, our installation of CiviCRM is on the web server, but we haven't imported data from Facil yet. This past week, among other things, we're setting up a "data import environment", i.e. another Ubuntu instance on a PC, with Drupal and CiviCRM loaded.

Last week, channelAustin participated in Denver Open Media's demo of how they use CiviCRM with the Open Media Project (http://groups.drupal.org/node/18772)

In the past two days, 4 channelAustin staff (Communications Director & Webmaster, IT Director, Training Director, and Equipment staff) worked with David Strauss from Four Kitchens (http://fourkitchens.com/) to set up CiviCRM (http://civicrm.org/), analyze table schemas in our existing Facil database (MS Access 97), determine which Facil tables and fields we want to import into CiviCRM.