Advertisement

03.25.2008 at 03:24PM PDT, ID: 23268858 | Points: 500
[x]
Attachment Details
finding difference between two XML files using XML::SemanticDiff
Zone: Perl Programming Language
I have two XML files with the data as attached. I am using the XML::SemanticDiff module to find the difference between the two XML files. I need to ignore the values for the names with "_id". As they are generated from same application they are assigned different ids. But I need to pull out all the other differences.

Please advise.
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:

<object_list_pass_rule_header type="collection"><object_list_pass_rule_header key_type="PASS_ID" key_value="10186" object_list_role="10" object_list_id="47436" displayName="" type="object"><object_list_key type="collection"><object_list_key key_type="PASS_ID" key_value="10186" object_list_role="10" object_list_id="47436" type="object"><object_list type="collection"><object_list object_list_id="47436" object_id="10000001" id="10508" type="object"/>
													</object_list><object_list_key_sheet type="collection"><object_list_key_sheet object_list_id="47436" property_id="14" property_value="10000001" type="object"/>
													</object_list_key_sheet></object_list_key>
											</object_list_key><rule_header type="collection"><rule_header rule_id="10508" init_object_id="0" object_id="10000001" rule_desc="Where tran stat = new or cancelled &amp; not matched replacement or deleted &amp; = our transactions" rule_name="Aexeo Cancels/Deleted Logic" rule_type="1" type="object"><rule_detail type="collection"><rule_detail rule_id="10508" expression_id="1" expression_logic="2294" init_attr_id="0" left_bracket="1" lhs_agg_function="0" lhs_attr_function="0" lhs_attr_id="32" lhs_attr_value="0" lhs_float="0" lhs_operator="0" operator="2059" rhs_attr_function="0" rhs_attr_id="0" rhs_attr_value="0" rhs_value="10045" rhs_value_curr=" " right_bracket="0" lhs_substr_start="0" lhs_substr_len="0" rhs_substr_start="0" rhs_substr_len="0" type="object"/>
														<rule_detail rule_id="10508" expression_id="2" expression_logic="2295" init_attr_id="0" left_bracket="0" lhs_agg_function="0" lhs_attr_function="0" lhs_attr_id="32" lhs_attr_value="0" lhs_float="0" lhs_operator="0" operator="2059" rhs_attr_function="0" rhs_attr_id="0" rhs_attr_value="0" rhs_value="10011" rhs_value_curr=" " right_bracket="0" lhs_substr_start="0" lhs_substr_len="0" rhs_substr_start="0" rhs_substr_len="0" type="object"/>
														<rule_detail rule_id="10508" expression_id="3" expression_logic="2295" init_attr_id="0" left_bracket="0" lhs_agg_function="0" lhs_attr_function="0" lhs_attr_id="32" lhs_attr_value="0" lhs_float="0" lhs_operator="0" operator="2059" rhs_attr_function="0" rhs_attr_id="0" rhs_attr_value="0" rhs_value="10015" rhs_value_curr=" " right_bracket="0" lhs_substr_start="0" lhs_substr_len="0" rhs_substr_start="0" rhs_substr_len="0" type="object"/>
														<rule_detail rule_id="10508" expression_id="4" expression_logic="2295" init_attr_id="0" left_bracket="0" lhs_agg_function="0" lhs_attr_function="0" lhs_attr_id="32" lhs_attr_value="0" lhs_float="0" lhs_operator="0" operator="2059" rhs_attr_function="0" rhs_attr_id="0" rhs_attr_value="0" rhs_value="10042" rhs_value_curr=" " right_bracket="0" lhs_substr_start="0" lhs_substr_len="0" rhs_substr_start="0" rhs_substr_len="0" type="object"/>
														<rule_detail rule_id="10508" expression_id="5" expression_logic="2295" init_attr_id="0" left_bracket="0" lhs_agg_function="0" lhs_attr_function="0" lhs_attr_id="32" lhs_attr_value="0" lhs_float="0" lhs_operator="0" operator="2059" rhs_attr_function="0" rhs_attr_id="0" rhs_attr_value="0" rhs_value="10043" rhs_value_curr=" " right_bracket="1" lhs_substr_start="0" lhs_substr_len="0" rhs_substr_start="0" rhs_substr_len="0" type="object"/>
														<rule_detail rule_id="10508" expression_id="6" expression_logic="2296" init_attr_id="0" left_bracket="1" lhs_agg_function="0" lhs_attr_function="0" lhs_attr_id="5220" lhs_attr_value="0" lhs_float="0" lhs_operator="0" operator="2064" rhs_attr_function="0" rhs_attr_id="0" rhs_attr_value="0" rhs_value="30" rhs_value_curr=" " right_bracket="0" lhs_substr_start="0" lhs_substr_len="0" rhs_substr_start="0" rhs_substr_len="0" type="object"/>
														<rule_detail rule_id="10508" expression_id="7" expression_logic="2296" init_attr_id="0" left_bracket="0" lhs_agg_function="0" lhs_attr_function="0" lhs_attr_id="5220" lhs_attr_value="0" lhs_float="0" lhs_operator="0" operator="2064" rhs_attr_function="0" rhs_attr_id="0" rhs_attr_value="0" rhs_value="3" rhs_value_curr=" " right_bracket="1" lhs_substr_start="0" lhs_substr_len="0" rhs_substr_start="0" rhs_substr_len="0" type="object"/>
													</rule_detail></rule_header>
											</rule_header></object_list_pass_rule_header>
										<object_list_pass_rule_header key_type="PASS_ID" key_value="10186" object_list_role="11" object_list_id="47437" displayName="" type="object"><object_list_key type="collection"><object_list_key key_type="PASS_ID" key_value="10186" object_list_role="11" object_list_id="47437" type="object"><object_list type="collection"><object_list object_list_id="47437" object_id="10000001" id="10532" type="object"/>
													</object_list><object_list_key_sheet type="collection"><object_list_key_sheet object_list_id="47437" property_id="14" property_value="10000001" type="object"/>
													</object_list_key_sheet></object_list_key>
											</object_list_key><object_list_pop type="collection"><object_list_pop key_type="POP_ID" key_value="1" object_list_role="11" object_list_id="47437" displayName="" type="object"><object_list_key type="collection"><object_list_key key_type="POP_ID" key_value="1" object_list_role="11" object_list_id="47437" type="object"/>
													</object_list_key></object_list_pop>
											</object_list_pop><rule_header type="collection"><rule_header rule_id="10532" init_object_id="0" object_id="10000001" rule_desc="Item Tran Status is Cancelled (Aexeo)" rule_name="Item Tran Status N or A" rule_type="2" type="object"><rule_detail type="collection"><rule_detail rule_id="10532" expression_id="1" expression_logic="2294" init_attr_id="0" left_bracket="0" lhs_agg_function="0" lhs_attr_function="0" lhs_attr_id="5002" lhs_attr_value="0" lhs_float="0" lhs_operator="0" operator="2059" rhs_attr_function="0" rhs_attr_id="0" rhs_attr_value="0" rhs_value="N" rhs_value_curr=" " right_bracket="0" lhs_substr_start="0" lhs_substr_len="0" rhs_substr_start="0" rhs_substr_len="0" type="object"/>
														<rule_detail rule_id="10532" expression_id="2" expression_logic="2295" init_attr_id="0" left_bracket="0" lhs_agg_function="0" lhs_attr_function="0" lhs_attr_id="5002" lhs_attr_value="0" lhs_float="0" lhs_operator="0" operator="2059" rhs_attr_function="0" rhs_attr_id="0" rhs_attr_value="0" rhs_value="A" rhs_value_curr=" " right_bracket="0" lhs_substr_start="0" lhs_substr_len="0" rhs_substr_start="0" rhs_substr_len="0" type="object"/>
													</rule_detail></rule_header>
											</rule_header></object_list_pass_rule_header>
										<object_list_pass_rule_header key_type="PASS_ID" key_value="10186" object_list_role="11" object_list_id="47438" displayName="" type="object"><object_list_key type="collection"><object_list_key key_type="PASS_ID" key_value="10186" object_list_role="11" object_list_id="47438" type="object"><object_list type="collection"><object_list object_list_id="47438" object_id="10000001" id="10533" type="object"/>
													</object_list><object_list_key_sheet type="collection"><object_list_key_sheet object_list_id="47438" property_id="14" property_value="10000001" type="object"/>
													</object_list_key_sheet></object_list_key>
											</object_list_key><object_list_pop type="collection"><object_list_pop key_type="POP_ID" key_value="2" object_list_role="11" object_list_id="47438" displayName="" type="object"><object_list_key type="collection"><object_list_key key_type="POP_ID" key_value="2" object_list_role="11" object_list_id="47438" type="object"/>
													</object_list_key></object_list_pop>
											</object_list_pop><rule_header type="collection"><rule_header rule_id="10533" init_object_id="0" object_id="10000001" rule_desc="Item Tran Status is &quot;C&quot; or &quot;D&quot;" rule_name="Item Tran Status C or D" rule_type="2" type="object"><rule_detail type="collection"><rule_detail rule_id="10533" expression_id="1" expression_logic="2294" init_attr_id="0" left_bracket="0" lhs_agg_function="0" lhs_attr_function="0" lhs_attr_id="5002" lhs_attr_value="0" lhs_float="0" lhs_operator="0" operator="2059" rhs_attr_function="0" rhs_attr_id="0" rhs_attr_value="0" rhs_value="C" rhs_value_curr=" " right_bracket="0" lhs_substr_start="0" lhs_substr_len="0" rhs_substr_start="0" rhs_substr_len="0" type="object"/>
														<rule_detail rule_id="10533" expression_id="2" expression_logic="2295" init_attr_id="0" left_bracket="0" lhs_agg_function="0" lhs_attr_function="0" lhs_attr_id="5002" lhs_attr_value="0" lhs_float="0" lhs_operator="0" operator="2059" rhs_attr_function="0" rhs_attr_id="0" rhs_attr_value="0" rhs_value="D" rhs_value_curr=" " right_bracket="0" lhs_substr_start="0" lhs_substr_len="0" rhs_substr_start="0" rhs_substr_len="0" type="object"/>
													</rule_detail></rule_header>
											</rule_header></object_list_pass_rule_header>
										<object_list_pass_rule_header key_type="PASS_ID" key_value="10186" object_list_role="13" object_list_id="47439" displayName="" type="object"><object_list_key type="collection"><object_list_key key_type="PASS_ID" key_value="10186" object_list_role="13" object_list_id="47439" type="object"><object_list type="collection"><object_list object_list_id="47439" object_id="10000001" id="10319" type="object"/>
													</object_list><object_list_key_sheet type="collection"><object_list_key_sheet object_list_id="47439" property_id="14" property_value="10000001" type="object"/>
														<object_list_key_sheet object_list_id="47439" property_id="10" property_value="1" type="object"/>
														<object_list_key_sheet object_list_id="47439" property_id="28" property_value="10139" type="object"><workflow_tool type="collection"><workflow_tool tool_id="10139" valid_for_execution="1" universe_id="1" note_paradigm="1" group_threshold="1" update_rows="1" name="Q-PERF CXL" description=" " business_logic_type="9" read_only="0" availability="1" icon="10015" feedback="1" first_step="0" auto_arrange="1" auto_arrange_direction="0" auto_arrange_gap="2000" type="object"><workflow_steps type="collection"><workflow_steps tool_id="10139" step_id="1" step_name="Set Last Proposal Date" step_description=" " left_pos="2787.5" top_pos="5925" height="525" width="1575" colour="0" shape="0" type="object"><step_components type="collection"><step_components tool_id="10139" step_id="1" component_index="0" component_type="2" component_id="29045" warning_message=" " title="Item Last Proposal Date = Now" next_component_id="1" left_pos="787.5" top_pos="1545" height="915" width="1575" type="object"><object_list_eventList type="collection"><object_list_eventList key_type="EVENTLIST_ID" key_value="10127" object_list_role="27" object_list_id="29045" displayName="Item Last Proposal Date = Now" type="object"><object_list_key type="collection"><object_list_key key_type="EVENTLIST_ID" key_value="10127" object_list_role="27" object_list_id="29045" type="object"><object_list type="collection"><object_list object_list_id="29045" object_id="10000001" id="10200" type="object"/>
																									</object_list><object_list_key_sheet type="collection"><object_list_key_sheet object_list_id="29045" property_id="20" property_value="Item Last Proposal Date = Now" type="object"/>
																										<object_list_key_sheet object_list_id="29045" property_id="14" property_value="10000001" type="object"/>
Start your free trial to view this solution
Question Stats
Zone: Programming
Question Asked By: saibsk
Question Asked On: 03.25.2008
Participating Experts: 1
Points: 500
Views: 0
Translate:
Loading Advertisement...
03.25.2008 at 04:22PM PDT, ID: 21207410
jeffld:

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
03.26.2008 at 06:40AM PDT, ID: 21211450
saibsk:

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
03.26.2008 at 06:47AM PDT, ID: 21211536
saibsk:

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
03.26.2008 at 08:16AM PDT, ID: 21212526
jeffld:

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
03.26.2008 at 09:21AM PDT, ID: 21213316
jeffld:

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Handhelds / PDAs
  • Displays / Monitors
  • Components
  • Networking Hardware
  • Peripherals
  • Laptops/Notebooks
  • Storage
  • Servers
  • Desktops
  • New Users
  • Misc
  • Apple
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMWare
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMWare
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Community Advisor
  • Lounge
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • Community Advisor
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
03.25.2008 at 04:22PM PDT, ID: 21207410
jeffld:
Your XML is invalid.  Can you attach as files instead of a code snippet?
 
03.26.2008 at 06:40AM PDT, ID: 21211450
saibsk:
please rename the file extension to xml and the open it.
 
test.txt (667 KB) (Possible File Type Mismatch) 
XML file
 
 
03.26.2008 at 06:47AM PDT, ID: 21211536
saibsk:
Please ignore the previous file and look into this one. Please rename the extension to xml.
 
test.txt (665 KB) (Possible File Type Mismatch) 
XML file
 
 
03.26.2008 at 08:16AM PDT, ID: 21212526
jeffld:
The XML file is still invalid.

http://www.w3schools.com/xml/xml_validator.asp

Once you get your XML valid, then an expert should be able to assist.



 
03.26.2008 at 09:21AM PDT, ID: 21213316
jeffld:
I tried using saxonica and .NET xml parser.

Error on line 2 column 11 of file:/c:/JEFFD/XML/test.xml:
  SXXP0003: Error reported by XML parser: The markup in the document preceding the root
  element must be well-formed.
Processing failed

Running custom validation engine .NET XML Parser...
c:/JEFFD/XML/test.xml:2,12: Unexpected end tag. Line 2, position 12.
-----------------------------------
Validation complete with 1 error(s)
 
 
20080236-EE-VQP-29 / EE_QW_2_20070628