Import any csv to load large data to lookup set in CM 24.3

Question

I am trying to create a lookup set using CM desktop , version 24.3 , and the lookup set has around 700+ entries. It would be better if we can import the values from a csv or any other method. Any help would be appreciated.
thank You.

Benny · Accepted Answer

Under Export Properties, you will be able to set the Export Data Source. 
 This can either be set to use either; 
 - An Existing Saved Search within Content Manager 
 - Items from one of the Content Manager Trays 
 
 To identify and target the items for extraction. 
 DataPort also comes with its own Help File which walks you through basic Import / Export setup if you get stuck 
 Good Luck! 
 Benny

Benny · Answer

Note that you can only open DataPort via the Administration Tab through the full CM Client, it is not available on the CM Desktop Client.

Martin Hurst · Answer

Hi Anupam Look at using the DataPort utility to import the lookup set, using the online help. 
 This by default only uses a Tab delimited format unless a custom importer is written. The easiest way to check how to format the import file is to export a lookup set and select all the relevant fields From the exported metadata file, you can then review the format and then provide alternate data, e.g. via a csv saved in Tab delimited format ( and also a UTF encoding) Then run a DataPort import project supplying the new metadata file and in the configuration map the fields(columns) in the metadata sheet to the lookup set fields.

Menu

Content Manager Discussions

Verified Answers

Import any csv to load large data to lookup set in CM 24.3

Tags:

Top Replies

Resources