How it will populate custom KVPs from ICON to Infomart

[Raj]

Hi All,

Presently populating Custom KVP Values in ICON database in G_CALL_USERDATA_CUSTOM table. So my question is how Infomart application will store these information from ICON db to Infomart db. If it is stores in which table we can see the data. If it not how to populate into Infomart db.


Thanks

[tony]

Raj,

I am certain I have answered this exact same question, already - but I don't see the post on here, anymore...

TT

[Raj]

Tony,

Thanks a lot for your quick respone.

Presently I can see the data related to multimedia in Infomart database. But I am not sure about custom KVPs that they are populating into the infomart db from ICON db(G_CALL_USERDATA_CUST table) . If I am not wrong we need to create some stored procedures for populating Custom KVPs from ICON db to Infomart db.

Please correct me if i am wrong.


Thanks

[tony]

You do need to create an XML file to "link" the KVP custom data being extracted by ICON...  The XML File must also be referenced in each of the relevant ICON Application parameters, in CME/CIM (usually defined under [i]adata-spec-name [/i] = [i]ccon_adata_spec.xml[/i]).  I also believe it is standard practice to save the XML in the same root directory as the ICON executable file, so that it can read off the settings.

Here is an example of the ICON XML (but the template is available on the installation CD...) - don't forget that there are 3 Custom Data Tables;

[color=blue]- <adata_spec>
  <public />
  <secure />
  <call />
- <call-cust>
  <key name="Skill" source="userdata" history="last" field="cust-data-1" />  </call-cust>
- <call-cust1>
  <key name="AccountType" source="userdata" history="last" field="cust-data-1" />
  </call-cust1>
  <call-cust2 />
  </adata_spec>[/color]

- Once this has been edited and saved in the correct File Directory, you should restart ICON.

You will also need to reference the KVP's in the Infomart Application in CME/CIM.  There is a Section in the CME/CIM Application Options called "[i]ixn-user-data-facts[/i]" - this is where the ICON KVP entires should be applied (e.g. Option_Name = "[i]cust-data-1[/i]", Option_Value = "[i]LAST[/i]")

- After applying these changes, the data *should* become available in the Infomart G_CALL_USERDATA_CUST Table...

TT

[Raj]

Tony,

As per my knowledge G_CALL_USERDATA_CUST Table resides in ICON db. My question was how Infomart ETL will populate this table information into Infomart database and which table we can see these information.


Please correct me if am wrong.

Thanks

[tony]

The relevant named Tables in Infomart are call-cust, call-cust1 and call-cust2.  If they do not exist then you will have to refer to your installation guides...


TT