Discussion:
TPAE Connectors - CI Sync from csv flat file
(too old to reply)
Kanon Yingwanna
2017-02-07 03:47:22 UTC
Permalink
Raw Message
Dear All,

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

Kanon.
Eddie Hartman
2017-02-07 18:20:46 UTC
Permalink
Raw Message
Post by Kanon Yingwanna
Dear All,
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
Kanon.
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:

task.logmsg(work.toXML());

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.

Good luck!
Kanon Yingwanna
2017-02-08 01:23:49 UTC
Permalink
Raw Message
Post by Eddie Hartman
Post by Kanon Yingwanna
Dear All,
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
Kanon.
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.
task.logmsg(work.toXML());
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.
Good luck!
Thank you for your quick response Eddie,your blog is very useful. Let my try to complete it as your recommended.
Kanon Yingwanna
2017-02-08 10:09:54 UTC
Permalink
Raw Message
Here are the custom attribute list on SCCD https://goo.gl/dSEqJe and the XML schema hierarchy when connect with TDI https://goo.gl/VJEaOj

I couldn't find my custom attribute in the schema hierarchy, My understanding is each CI attribute name will be the value of ASETATTRID and the value of the attributes will be kept in ALNVALUE.

So I'm not sure how to generate XML schema for that.
Do you have any idea?

Loading...