Invoke wt.load.util.CSV2XML and wt.load.LoadFromFile commands from a java code
I am trying to bulk load wtdocuments into Windchill for which I have the content files and the attributes (name, number, description, version, state, IBAs etc) in an excel file. The usual method for bulk load is to create a CSV using the data in the excel file, then create an XML from the CSV (wt.load.util.CSV2XML) and finally load the documents into Windchill using the XML file (wt.load.LoadFromFile).
I am trying to create a java file which will read the excel file with the raw data, create a CSV and subsequently the XML file using it and then finally invoke the load command using the XML file. Before I put all of these together, I am trying out each step individually and am not able to figure out a way to invoke the wt.load.util.CSV2XML and wt.load.LoadFromFile from a java file. Has anyone tried that? Any ideas?
My scenario is same. we are migrating documents from network drives to Windchill 11.0. I want to know how to create a CSV (that can be used for CSV2XML utility) for bulk load using the excel file with attribute values in columns.