Documentación de la Base de Datos de CMI

La base de datos IMC es una base de datos mysql que contiene información de cada IMC (activos y los pendientes), información de contactos y documentos de procesoenviados durante el proceso de registro de nuevos IMCs (al menos, los enviados después de que la base de datos fuera operacional),regional y otra clasificación esquemática, e información de los canales XML sindicados por varios IMCs. La base de datos está hospedada en los servidores "noam" (base de datos) y "edna" (aplicación web) y usada por los grupos de trabajo imc-commwork, new-imc y syndication.

Traduce la interfaz de la base de datos

Nos gustaría hacer la web accesible para todos. Si eres capaz, añade una traducción de este fichero: strings.txt (si puedes usa un editor que resalte el código con colores para evitar typos, y usa codificación HTML). Puedes mandárselo por email a mark y/o imc-commwork (mira abajo). Gracias!

¿Cómo funciona?

IMC records are added to the database when someone fills out the form at newimc.indymedia.org -- the applicant is provided a password allowing her/him access to that entry in the database. Data (not necessarily in its entirety) can be viewed and edited via the links at the db web app. "Advanced" displays almost all the data fields in the IMC database, whereas by default these are limited to commonly used ones. After updates to the database are completed, an admin will need to "refresh cities" and "refresh contact" in order to push those changes live. By the way, to quickly go thru each and every IMC one at time (to review/add/update data), go to http://contact.indymedia.org/?adv=adv&order=date_modified+asc&limit=1 -- each time you click save, the oldest-modified IMC will pop up.

Syndication channels: You can normally leave the aggregation level at 0. 1 is for channels aggregated from other sources, 2 aggregated from other aggregates, etc. URI is the uri of the rss/xml resource. Link, title and description are supposed to be harvested from the rss itself -- although no one has yet written the code to do that.. If a channel is archived, it does not appear on the list of active channels but is still in the db for potential use in the future.

OK, what does it do?

The database is used to generate cities.inc, which is included in the left-hand nav bar by most IMCs; cities.xml, an XML representation of this list; contact information for each IMC at http://www.indymedia.org/contact.php3; various public information pages at contact.indymedia.org (e.g. a list of IMC newsfeeds at http://contact.indymedia.org/xml_table.php); and the right-column list of features from the local IMC sites on www.indymedia.org's front page. In an effort to make at least part of the database available in XML format, citiesinfo.xml is regenerated each day. You can send e-mail to all official IMC contacts. Many other potential uses exist.

The info in the imc table is used for http://www.indymedia.org/contact.php3, whereas the info in the contact table is confidential, for internal use only.

An XML listing of the info needed by volunteer.indymedia.org is maintained at volunteer.php (change the php to xml to access a cached version).

But... I can't logon!

If you would like a logon, please email the applicable global working group -- imc-commwork@indymediaSTOPSPAM.org, new-imc@indymediaSTOPSPAM.org, or syndication@indymediaSTOPSPAM.org. Each login is assigned to an imc (or superuser) and can edit all entries for that imc.

Info on user access

See the user list: regular users are restricted to editing just one IMC. Those with access to all data are called superusers. When superusers add new users or edit existing users, they use the "restrict to" dropdown menu to associate a user with her/his IMC. If a user is not assigned a specific IMC, the user becomes a superuser. The my imc page automatically provides links for each user to edit her/his user and IMC info.

To-do List

• List cities.inc by region and subregion.
• Figure out how to store timezone info. Done!
• Write code to pull XML channels, extract title and other fields, and update database.
• Add XML item tables linked to XML channel table.

Development

Checkout with:

svn checkout https://contact.indymedia.org/svn/contactdb/trunk

The web application is in maintained in a SVN repository at https://contact.indymedia.org/websvn/listing.php?repname=contactdb

There used to be a Bugzilla but no one used it so it's down until needed again...

-- MarkB - 26 Dec 2002

-- MarkB - 29 Aug 2003 (now storing timezones)

-- MarkB - 23 Jul 2004 (hosted on edna/noam not stallman; removed link to syndication.php3, currently offline -- but probably worth restoring?)

-- PaulWise - 08 Feb 2005 Fixed a coupla urls
to top