topic Re: Bulk metadata update in alfresco community 5.1.f in Alfresco Forum

Bulk metadata update in alfresco community 5.1.f

sandeepreddy1 — Thu, 27 Apr 2017 17:06:39 GMT

Hai Everyone,I need to update Bulk metadata for bulk documents in alfresco.Example: I have uploaded 2000 documents in alfresco, for these 2000 documents i need to update metadata.like Title, Description and author etc.....Can anyone help me steps wise. how to update bulk metadata ...? in AlfrescoCan

Re: Bulk metadata update in alfresco community 5.1.f

vikash_patel — Fri, 28 Apr 2017 06:12:29 GMT

Create a rule on folder which and execute script which will update your metadata properties of your files

and using bulk import import all of your files to this folder. Link for bulk import

http://<<server>>:<<port>>/alfresco/s/bulkfsimport
Hope this will help you.

Re: Bulk metadata update in alfresco community 5.1.f

sandeepreddy1 — Fri, 28 Apr 2017 06:41:36 GMT

Hai Vikash Patel,

I tried this link http://localhost/alfresco/s/bulkfsimport

Import directory:

NodeRef: http://localhost/share/page/site/nfc-dms/documentlibrary

But it is showing empty, Actually i need to upload 2000 files and i need to

update metadata.

can you please explain steps wise.

On Fri, Apr 28, 2017 at 11:43 AM, vikash.patel@contcentric.com <

Re: Bulk metadata update in alfresco community 5.1.f

vikash_patel — Fri, 28 Apr 2017 07:15:48 GMT

please enter your folder location where all files exists in your system like

Import directory:: "E:\Backup Folder\all previous data\New folder"

and go to alfresco repository and find the folder where you wanted to upload your files get the noderef of that folder and enter it in example NodeRef: workspace://SpacesStore/5474a3c8-397e-4ab2-b208-a4a446790801

and initiate bulk import

Re: Bulk metadata update in alfresco community 5.1.f

sandeepreddy1 — Fri, 28 Apr 2017 08:34:28 GMT

Dear Vikash Patel,

I entered my folder location, I initiated bulk import., But it is showing

empty.

On Fri, Apr 28, 2017 at 12:46 PM, vikash.patel@contcentric.com <

Re: Bulk metadata update in alfresco community 5.1.f

muralidharand — Fri, 28 Apr 2017 08:41:14 GMT

Hi Sandeep,

Can you please add the screenshot before starting the BulkImport and after starting bulkimport ?

Re: Bulk metadata update in alfresco community 5.1.f

sandeepreddy1 — Fri, 28 Apr 2017 08:51:49 GMT

Hai muralidharand sir,

I attached screenshots,

Please find the attachments.

On Fri, Apr 28, 2017 at 2:11 PM, muralidharand <community@alfresco.com>

Re: Bulk metadata update in alfresco community 5.1.f

vikash_patel — Fri, 28 Apr 2017 08:52:30 GMT

Please go to that folder where you wanted to upload your files
Click on view-details of folder action
See in URL you will be find something like this Here nodeRef=somestring is given
http://<<server>>:<<port>>/share/page/site/test/folder-details?nodeRef=workspace://SpacesStore/c95ea4d8-5ae1-4bf9-bb5c-45772f…

please copy the value of nodeRef after "=" like this workspace://SpacesStore/c95ea4d8-5ae1-4bf9-bb5c-45772f
and paste it in nodeRef input of bulkImport

Re: Bulk metadata update in alfresco community 5.1.f

sandeepreddy1 — Fri, 28 Apr 2017 09:06:50 GMT

Dear vikash.patel and muralidharand,

I tested with 4 documents folder,

Now it is working fine, but i need to update bulk metadata.

Can you please suggest me.

On Fri, Apr 28, 2017 at 2:22 PM, vikash.patel@contcentric.com <

Re: Bulk metadata update in alfresco community 5.1.f

sandeepreddy1 — Fri, 28 Apr 2017 09:16:27 GMT

Dear vikash.patel and muralidharand sir,

Bulk Update metadata means, I need to update document properties like

Title, Description and author etc...

example: I uploaded 3000 documents, i have these 3000 documents properties

in excel sheet

i need to update these 3000 documents metadata from excel sheet,

Cay you please help me.,

On Fri, Apr 28, 2017 at 2:36 PM, SandeepReddy Vemuganti <

Re: Bulk metadata update in alfresco community 5.1.f

vikash_patel — Fri, 28 Apr 2017 09:24:50 GMT

This is simple way Create a rule on that folder and execute the script where you will create your logic to parse your excel sheet and check the file name which is uploading to the folder is exists in your excel sheet if yes then fetch the all other data of that row and update the property of your file in alfresco.

Re: Bulk metadata update in alfresco community 5.1.f

sandeepreddy1 — Mon, 01 May 2017 13:49:25 GMT

Can you please suggest me

Parse excel sheet and check the file name which is uploading to the folder is exists in excel sheet

Re: Bulk metadata update in alfresco community 5.1.f

sandeepreddy1 — Mon, 01 May 2017 13:51:59 GMT

Hai Vikash Patel,

please suggest code for Parse excel sheet and check the file name which is uploading to the folder is exists in excel sheet.