Post by Kanon Yingwanna
I try to import CI and its CISPEC information by feeding from csv file to SCCD using TpaeIF connector. But what I can do success is for CI only, I couldn't import its CISPEC.
Because CISPEC was kept in the database in the different data dimension.
Could you please advise what's the proper solution to import CI and CISPEC from csv flat file by TDI?
Many thanks in advance
You can do this, but need to build a hierarchical entry to pass to the TpaeIF Connector. The web service it talks to handles writing to the normalized tables. I'm afraid I don't have examples of solutions to do this.
When you read using the Tpae Connector you get back a hierarchical entry. If you print this out in XML form you'll see what you have to build:
For some background on hierarchical entries, check out my blog posts on tdiingoutloud.com. If you search for 'xml tutorial' you'll see a number of posts on the subject.