<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Migrate from Drupal (or, MySQL) in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/migrate-from-drupal-or-mysql/m-p/101653#M70611</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Dear all,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I am using a Drupal CMS to manage documents and would like to migrate to Alfresco.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The data model is rather simple: Each Drupal entity ("node" in Drupal jargon) has&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;- an associated document (file),&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;- a set of associated categories (taxonomy terms in Drupal jargon) like "organization", "resource for journalists", "contact", etc.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;- a text describing the document (synopsis, abstract)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;- 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.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;- a workflow field, i.e., exactly one of the following states: draft, waiting for approval, publised.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;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?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;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.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I am very curiously waiting for an answer, or maybe somebody can even share a migration experience!&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Many thanks,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Kaspar&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 21 Jun 2007 22:25:24 GMT</pubDate>
    <dc:creator>hbf</dc:creator>
    <dc:date>2007-06-21T22:25:24Z</dc:date>
    <item>
      <title>Migrate from Drupal (or, MySQL)</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/migrate-from-drupal-or-mysql/m-p/101653#M70611</link>
      <description>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", "resourc</description>
      <pubDate>Thu, 21 Jun 2007 22:25:24 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/migrate-from-drupal-or-mysql/m-p/101653#M70611</guid>
      <dc:creator>hbf</dc:creator>
      <dc:date>2007-06-21T22:25:24Z</dc:date>
    </item>
    <item>
      <title>Re: Migrate from Drupal (or, MySQL)</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/migrate-from-drupal-or-mysql/m-p/101654#M70612</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;A good start would be:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;A href="http://forge.alfresco.com/projects/acpgeneratr/" rel="nofollow noopener noreferrer"&gt;http://forge.alfresco.com/projects/acpgeneratr/&lt;/A&gt;&lt;BR /&gt;&lt;SPAN&gt;You can use e.g. PHP or SQL te generate the required csv&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;and&lt;/SPAN&gt;&lt;BR /&gt;&lt;A href="http://wiki.alfresco.com/wiki/Step-By-Step:_Creating_A_Custom_Model" rel="nofollow noopener noreferrer"&gt;http://wiki.alfresco.com/wiki/Step-By-Step:_Creating_A_Custom_Model&lt;/A&gt;&lt;BR /&gt;&lt;SPAN&gt;to create a custom model containing all the required attributes&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 22 Jun 2007 10:35:35 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/migrate-from-drupal-or-mysql/m-p/101654#M70612</guid>
      <dc:creator>pjongen</dc:creator>
      <dc:date>2007-06-22T10:35:35Z</dc:date>
    </item>
    <item>
      <title>Re: Migrate from Drupal (or, MySQL)</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/migrate-from-drupal-or-mysql/m-p/101655#M70613</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Paul, thanks a lot for the two links! They seem to fit my needs.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I've also run across&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp; &lt;/SPAN&gt;&lt;A href="http://wiki.alfresco.com/wiki/Export_and_Import#Alfresco_Content_Package_.28ACP.29_File_Format" rel="nofollow noopener noreferrer"&gt;http://wiki.alfresco.com/wiki/Export_and_Import#Alfresco_Content_Package_.28ACP.29_File_Format&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;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.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Kaspar&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sat, 23 Jun 2007 17:04:51 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/migrate-from-drupal-or-mysql/m-p/101655#M70613</guid>
      <dc:creator>hbf</dc:creator>
      <dc:date>2007-06-23T17:04:51Z</dc:date>
    </item>
  </channel>
</rss>

