Import of file descriptions to Document Library

[stillontheedge]

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 import the data I want? If so, how? 

Any advice is greatly appreciated, as we are talking about 10,000+ drawings.

[mrogers]

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.

[stillontheedge]

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

[mrogers]

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.
}