cancel
Showing results for 
Search instead for 
Did you mean: 

Exporting syndicated records from MDM

Muniyappan
Active Contributor
0 Kudos
63

Hi,

i am working in PI. we integrationg mdm using pi with JMS systems.

our project development is done.now support is going on.

every day nearly 100 records have been sysndicated from mdm to other application through PI.

At the end of the day i need to send the report saying that this many records passed from PI.

And i have to list down the records in xl sheet which has nearly 20 columns.

to do this i need to go sxmb_moni to get the xml and copy paste the records in xl sheet.

for one records i need to do the copy pasting for 20 times(20 columns).

is there any was to export the records from MDM which are sydicated for perticular day?

like simple example: i have 10 records which are updated today for 4 times.

in the archive folder i will be having 40 xml files once the records are picked by PI.

i want to export these 40 records into xl sheet.

please help me on this.


View Entire Topic
Former Member
0 Kudos

Hi,

If i understand correct,only those records that get updated on day to day basis are syndicated.

I am not sure if a field "Update Date" is available (Pls check with MDM resource). If available, you can select the records based on "Update date" and have them syndicated with all columns/fields into excel sheet.

Second option would be to open the xml file that is obtained from PI.

When you open an XML file in Excel, you are prompted to select one of the following methods to import the XML data: 

  • As an XML list
  • As a read-only workbook
  • Use the XML Source task pane

Select to open an XML source document as a "read-only workbook".The rest of the tags are sorted alphabetically and placed across.

Let me know if this helps.

Regards,

Ali

Message was edited by: Mir Ali

Muniyappan
Active Contributor
0 Kudos

Hi Mir Ali,

first option

we have update date  field in mdm.

my question is for example i have record which is having the country Id 100.

if this record is updated 3 times on 20/06/2012.

then i can see only one record for country Id 100 not three records on 20/06/2012.

i want every version of the updated records as it is present in the archive folder.

second option

opening xml as read-only workbook it is working as you said.

but i have two xml files one has 15 columns(elements) and another one 20 colums(elements).

if i do the same for these two files while combining it will create inconsistency.

Regards,

Muniyappan.

Former Member
0 Kudos

Muniappan,

I think u must find a possible workaround with excel itself. I do not think of a better way.

former_member193350
Active Participant
0 Kudos

Hi,

You can also syndicate the updated records using "Suppress Unchanged Records" option in MDM Syndicator.

This will syndicate only those records that are updated from previous time stamp.

Regards

Prateek Agarwal