Upload Bulk Documents into Alfresco with Document properties using Excel sheet

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

sandeepreddy1

Hai Everyone,

I need to upload bulk documents into alfresco with documents properties using excel sheet. can anyone help me please.

example: if i will upload 100 documents i need to provide documents properties from the excel sheet.

It's urgent for me. suggest me friends please.

dbiggins

I don't believe you can directly bulk import objects / metadata with Excel. 

Bulk imports are done by having files and properties (and versions if needed) as separate files, and pointing the import script to the directory.  the Alfresco Docs have some very good examples and explanations at:  Using the Bulk Import tool | Alfresco Documentation 

Your options for turning your Exel into a usable format could be programmatic, like creating a program to walk the excel sheet and create the appropriate files.

So if you wanted to bulk import a file called sample.pdf, you would have a file called sample.pdf (the binary), sample.pdf.metadata.properties.xml (containing the metadata).  the metadata properties file might look like:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>exported from legacy data</comment>
<entry key="my:custom_date">1996-04-23T04:00:00.000Z</entry>
<entry key="my:custom_restrictons">Copyrighted Material</entry>
<entry key="my:custom_document_authors">author1</entry>
<entry key="type">my:document</entry>
<entry key="aspects">my:customAspect</entry>
<entry key="cm:title">Document Title</entry>
<entry key="myage_count">90</entry>
</properties>

Again, the import is pretty straightforward, you just need to get it in the correct format.

Dan