on 2012 Jun 18 3:26 PM
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.
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:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
74 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.