topic Re: Import of file descriptions to Document Library in Alfresco Archive

Import of file descriptions to Document Library

stillontheedge — Tue, 14 Jun 2011 13:42:55 GMT

I am working on setting up a Share site for our engineering department, and I have run into a snag. We currently have all our drawing data stored in an access database, and would like to move it over to alfresco (without retyping it). Is there a way I can access the document library database and imp

Re: Import of file descriptions to Document Library

mrogers — Tue, 14 Jun 2011 14:41:19 GMT

My suggestion would be to write a tool that imports your metadata into alfresco. Others may be able to come up with better or different solutions.

If I were doing it I'd dump the access database into a format that was easy to process and then run a script that reads each line of the export and updates the corresponing node in alfresco.

Re: Import of file descriptions to Document Library

stillontheedge — Tue, 14 Jun 2011 14:46:10 GMT

Where are those nodes located, and how can I access them?

Re: Import of file descriptions to Document Library

mrogers — Tue, 14 Jun 2011 14:50:39 GMT

You may also like to look at this. http://blogs.alfresco.com/wp/pmonks/2009/10/22/bulk-import-from-a-filesystem/

I was presuming you had already imported your drawings somehow (e.g. ftp) and then wanted to associate your metadata with them.
So the import script would be something like.

For each line in the export file
{
read the export file
find the node in alfresco.
update the properties.
}