cancel
Showing results for 
Search instead for 
Did you mean: 

Migrate from Drupal (or, MySQL)

hbf
Champ on-the-rise
Champ on-the-rise
Dear all,

I am using a Drupal CMS to manage documents and would like to migrate to Alfresco.

The data model is rather simple: Each Drupal entity ("node" in Drupal jargon) has

- an associated document (file),
- a set of associated categories (taxonomy terms in Drupal jargon) like "organization", "resource for journalists", "contact", etc.
- a text describing the document (synopsis, abstract)
- depending on the taxonomy some more information: for instance, every node that is tagged "contact" has the fields "email", "homepage", etc. If a node is also tagged "copyrighted" then it has an (additional) field "copyright holder". And so on.
- a workflow field, i.e., exactly one of the following states: draft, waiting for approval, publised.

This information is all stored (except for the files) in a MySQL database and I would like to programmatically migrate this to Alfresco. Assuming I have a fair amount of programming skills, is this possible? Can I programmatically replicate my content in Alfresco? Is there an API for it? Maybe in PHP?

I am a complete novice as far as Alfresco is concerned, so please excuse my ignorance. I have heard only good things about Alfesco and therefore, the system is the number-one candidate. But before dwelving into it, we have to know whether migration is going to be a blocker or not.

I am very curiously waiting for an answer, or maybe somebody can even share a migration experience!

Many thanks,
Kaspar
2 REPLIES 2

pjongen
Champ in-the-making
Champ in-the-making
A good start would be:

http://forge.alfresco.com/projects/acpgeneratr/
You can use e.g. PHP or SQL te generate the required csv

and
http://wiki.alfresco.com/wiki/Step-By-Step:_Creating_A_Custom_Model
to create a custom model containing all the required attributes

hbf
Champ on-the-rise
Champ on-the-rise
Paul, thanks a lot for the two links! They seem to fit my needs.

I've also run across

  http://wiki.alfresco.com/wiki/Export_and_Import#Alfresco_Content_Package_.28ACP.29_File_Format

but have no idea yet what the differences are. So I'll start looking into your links first and when I've found out more, I'll get back.

Thanks,
Kaspar