Bulk Export Documents along with metadata using large search list of records in DataPort

Question

Hi, I am new to CM and trying to export a large/bulk list from Content Management Verson 10.1 contents (files, documents) along with the metadata. 
 I have tried the DataPort utility for a record type and getting permissions error and checking with my Admin. 
 Do I need Admin access to export metadata and contents using the Dataport ? 
 Also, I have large list of records which I need to search and export and option to import my search list and export matching records. Thanks, AJ

[Scotty] 😬 · Accepted Answer

Hi Arjun, 
 DataPort is able to export records (including electronic attachments) based on your Saved Search. 
 Once you have created a search that encompasses your records, save it as a Saved Search 
 Once your search is setup then open Dataport: 
 Data Direction -> Export 
 Under Settings pick a directory that the 50k documents can be extracted into I tend to prefer DatabaseID and RecordURI for the name so the total path characters is smaller in length 
 
 Under Export Properties the 'Source' will be a Saved Search, then select your Saved Search for the 50K list 
 
 And then under Property List select any Additional Properties that you want to export. 
 You should have both an Export File which contains the metadata as well as the documents now existing in the directory picked above titled based on the selected drop down. 
 -Scotty

[Scotty] 😬 · Answer

Ahhh got you. 
 There is no real easy way to do that. 
 Possible Workaround: - For the records in question, apply them to a user label, then you can perform the search 'label:123' to find the items. This has the added benefit by easily being able to add / remove records from the label to then include them / not include them in the search. (You can copy and paste the record numbers from your CSV in bulk into your work tray to add them to your work tray and then add the user label or search by 'Work Tray' - have done this for 25k + items in the past just takes a while to paste in ) 
 
 If you want to stick with Numbers, I tend to keep my searches at about 1000 numbers at a time (although I do URIs so not sure if the upper cap is different) 
 I myself open up something like Notepad++, take 1000 numbers / lines, replace '
' with a ',' to condense them into a single string with a comma separating each entry, and then paste into the search. 
 Would be also possible for something like powershell to load the CSV, connect to CM via the SDK and Bulk create 'x' number of Saved Searches based on a 'split' amount ('x' record numbers). 
 -Scotty

Menu

Content Manager Discussions

Verified Answers

Bulk Export Documents along with metadata using large search list of records in DataPort

Top Replies

Resources