Can we upload CIs in bulk from a csv file?

We have Employee CTD in VCM. We need to upload theinformation of the employees in bulk from a csv file including their classifications,channels and language details.Please let us know if this is possible to implement if yes then how.

Find more posts tagged with

Comments

Evan_Bench

This is an ideal use-case for BIS (Business Integration Studio). In fact, one of the sample integration scripts available reads a csv and creates Content Instances, assigns Channels, etc.

Here's a link to the docs https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=16679650&objAction=browse&viewType=1

If you've not used BIS before I can provide a nice training guide that shows you how to create BIS scripts to automate Content Creation or Migration.

One tiny problem is that you need to install BIS on your workstation. I'm pretty sure that TCS already has a license for BIS as I've seen BIS used in other projects TCS has implemented. Ask around in your team. If not, your client may already have a BIS license. It's not too expensive and does make developing WEM automation scripts quite easy!

Evan

Arun_Gahlot

If it helps anyway....

OR... if it is a one off thing , I would write a small program that could read the file and create content items in the stage that you are working with....

something like ContentInstance.newInstance() and then saving it... but by this time i am sure you have your answer with you....

Cheers,
Arun

Charles_Chen

There are many ways of doing this:

1. preferred way is to use VBIS (Vignette Business Integration Studio). Check in knowledgebase for user guide, and I believe it is free if you have VCM license already.

2. convert your csv file into SQL and load them into database following your content type table schema. After that, do content scan using the provided script in installdir/bin. It is even possible to use sqlloader to load your csv into database (oracle) as long as your csv is in same schema as your content type.

3. VCM API as you suggested it yourself.

4. convert your csv into XML in the format the vgnimport can understand, and then use the vgnimport script to import. To find out the xml format you can create a sample CI and export it so you can use it as a template.

Cheers,

Charles

From: eLink Entry: Discussion Group - Web Experience Management [v7webcontentmanagement@elinkkc.opentext.com]
Sent: 13 March 2012 14:13
To: eLink Recipient
Subject: Can we upload CIs in bulk from a csv file?

Can we upload CIs in bulk from a csv file?

Posted by arun.gahlot@vships.com (Gahlot, Arun) On 03-13-2012 09:54

If it helps anyway....OR... if it is a one off thing , I would write a small program that could read the file and create content items in the stage that you are working with.... something like ContentInstance.newInstance() and then saving it... but by this time i am sure you have your answer with you....Cheers,
Arun

[To post a comment, use the normal reply function]
Topic:	Can we upload CIs in bulk from a csv file?
Forum:	Discussion Group - Web Experience Management
Content Server:	Knowledge Center