Migrate data from IBM content manager to openText Livelink

[uthangavel]

Hi

we have a specific requirement to migrate data from IBM content Manager version 4 to OpenText content server 10.0.0. we have wrote a script to extract the data in xml format from IBM to directory level. We could not able to find a proper solution to load the data in batch to content server.



Recently I come across your forum posts regarding migration, It is really interesting to know more about the utility object Importer and exporter. And how to write the scripts to have all our data on content server with basic categories created for each documents (for eg: document name, owner and creation date).

regards,
Ram

 

[appnair]

I think you are the poster who is doing this on KB as well.I am not sure what exactly you are trying to understand.If at all you are a technical person approaching the project you have to do your own research,that is not going to come from me or anybody else in this forum.For the record the OI/OE is a utility that OT has produced that makes the uploading of documents with metadata easier.For doing that you have to atleast spent a day looking at OI,its configuration and how to do it by doing small batches.That is how I proceed in my endeavours.When somebody gave me the project to migrate filenet data i first looked at OI and then once I understood how to create a folder and document with OI on livelink I created a program to create node files for doing bulk stuff.I expect a technical person to know that a XML file is nothing special,it is just a text file that any programming or script language can do.I have used vba,perl,java,C# in my projects to create the xml load files.Darrin has written an excellent article for you to look as well.
Just because the filenet dump is xml that would not work with OT's OI because that xml is specific to OT.If you have stuff in XML you should resaerch how to transform it that may speed your project.
Please run manual exports to understand the interface then write what you are going to do you will ahve no problems then.


Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[uthangavel]

Hello Mr.Nair
i wrote a code to import xml file to OT, but the script which i posted on KB is like uploading the document one by one. i mean in control file we have to specify the as many nodes to import as many files. but we have more than 500,000 records. how to load this document all at a time. my actual question is, how to import write the code to have repeated process to load the file instead of writing as many <node></node>.

can you please help to write the control file to have batch import.

regards,
Udhay

 

[appnair]

That my friend is not possible to do if you do not know how to amend livelink using its programming language called oscript.In your case you have to divide 500000 by 1000 which means you will have 500 control files by 1000 nodes each .Your job is to generate these control files and feed it to OI's agent which using its DOMparser will pick it up when it is time.I said DOMparser because when I look in builder in its OI code I see the dropin say that.I am not sure if it is a saxparser or not.
Now why did OT do it that way that is because to migrate huge stuff in/out of livelink the people like you did not need to understand lapi,websvcs or oscript.Since it is in XML any program can churn that out so long as this intermediate programmer can understand the syntax of OI node creation.
If you are still unconvinced pay a lot of money to OT for their "Integration Center" product which will give you a programming interface and its instruction set or reinvent the wheel by writing this with lapi,websvcs or oscript.For most people like me OI and OE is so much better rather than many competing products.Most high volume ingestion programmes like syntergay also uses some sort of common file technology like csv,xls or as in the case OI.So bite the bullet and try to write a program to generate more than one node instruction set in a xml file.
If you are a MS centred guy pick something like VBA or vbscript you will see how easy this task is.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[uthangavel]

Hello Mr. Nair,

Thanks for your reply Mr.Nair, i will try to write the control file as you advised. really appreciate your help.

Have a great day.

regards,
Uday