I'm working on using CSV2TCXML and bulk loader to load some simple BOM's into my Teamcenter environment. Using the format from the Data Exchange manual, my upload is failing. Any help is much appreciated. Below are the details:
Here is the CSV for a single BOM line:
I run the following command successfully to convert to TCXML:
Tcperl csv2tcxml.perl BOMDataFile3.csv item=exist
Here's the import command:
tcxml_import -u=infodba -p=infodba -g=dba -bulk_load -file=e:\siemens\tcdata\csv2tcxml_perl\BOMDataFile3.csv.xml
Here is the error:
ERROR: Xml attribute [child_item = nNll2p5VPCpCRD] not found in database for [id9:PSOccurrence] element.
Solved! Go to Solution.
Yes, 000454 and 000455 preivously existed. I believe I created them manually. I'm not familiar with the UID. How would I determine if it exists?
I'm not sure if it matters, but we are using a subtype of Item, not Item itself. I also attempted to run this with parent_type and child_type in the csv, with identical results.
If you created them manually, then csv2tcxml will not see them, you should import Items also using csv2tcxml, then you will not have any problems.
If you create them manually, the UID will not match what csv2tcxml generates.
Perhaps there is a way to use manually created data, but I have not studied it yet.
NX 11 | SW 2016 | Creo 4 | TcUA 11.4
Evaluating: AW 3.4
Thanks all for your help. In the current migration I'm working on, there is no issue with only using CSV2TCXML created items. I believe I've got everything working as needed for now.
I too had the same problem importing a DNC database of items from a c# created csv. The items went fine but the I tried to build structure with already existing engineering items.
It doesn't sound like this is possible...
Does the ps_upload happen to support occurrence types as that is very important to our solution and I don't see that anywhere
If not I suppose the best option would be ips_upload.
As I mentioned above we ended up not needing it due to the nature of our upload. However, it is possible to create structures from a mix of new and existing items using CSV2TCXML. Jamie mentioned that you need to create a puid lookup file. Here's what the 11.4 Data Exchange documentations says about it:
Specifies a lookup file containing separate lines of puid/item_id value pairs for standard key values or puid/item_id/object_type value sets for multifield key values. For example, for standard key values, the lines are formattted as:
For multifield key values the lines are formatted as:
Instead of generating PUID values during the conversion process, the converter uses the file to obtain existing PUID values. Use this when the importing site has existing data, either created locally or previously migrated without using the converter, and you must migrate additional data that must be related to the existing data. You can generate the lookup file by running a simple SQL script to extract puid and item_id values from the Teamcenter database.
We liked the bulk loader method so much that we plan to set this up, enabling us to continue to use this method for bulk BOM uploads.