Build Application to Extract Data from XML File - repost
$250-750 USD
Cancelado
Publicado hace más de 10 años
$250-750 USD
Pagado a la entrega
I need an application that can extract data from multiple XML files (all the same format) that we receive from our clients every week to enable me to (a) view all the data under those XML headings easily and clearly within the application itself; and (b) to extract the data into a CSV / Excel Spreadsheet to send to our customers.
The XML file will be in the same format everytime, but will contain different records. The number of records could be as low as 5 and go up to 10,000 or more.
We need to extract the following data from the XML file into the application in this order:
ns1:Query_Results/ns1:Entity/ns1:RecordDetailInfo/ns1:SearchDate
ns1:Query_Results/ns1:Entity/ns1:GeneralInfo/ns1:AcccountID
ns1:Query_Results/ns1:Entity/ns1:RecordDetailInfo/ns1:EntityType
ns1:Query_Results/ns1:Entity/ns1:GeneralInfo/ns1:Status
ns1:Query_Results/ns1:Entity/ns1:GeneralInfo/ns1:Name
ns1:Query_Results/ns1:Entity/ns1:GeneralInfo/ns1:DOB
ns1:Query_Results/ns1:Entity/ns1:GeneralInfo/ns1:Country
ns1:Query_Results/ns1:Entity/ns1:WatchList/ns1:Match/ns1:EntityName
ns1:Query_Results/ns1:Entity/ns1:WatchList/ns1:MatchDetails/ns1:Entity/ns1:AKAs/ns1:Full
ns1:Query_Results/ns1:Entity/ns1:WatchList/ns1:MatchDetails/ns1:Entity/ns1:Reason
ns1:Query_Results/ns1:Entity/ns1:WatchList/ns1:MatchDetails/ns1:Entity/ns1:Descriptions/ns1:Description/ns1:Notes
** Please note (ns1:Notes), we must extract the entire note, both to the application and to the report - this is not reflected in the example below but you will see in the XML file that some of the notes are quite lengthy **
We will have several XML files delivered to us on a memory stick every week, these will be for different clients and therefore every time we extract the data from a new XML file this will need to be kept separate. We will also need to be able to retrieve data and the reports from historic XML files. ALthough there must be a method of deleting these should the information get too large for the database. THIS SECTION IS VERY IMPORTANT.
I have attached the following example documents:
1) Example XML document - we receive the XML in this format; and
2) An example of the layout of the report in Excel that we need to produce.
This application MUST work on a Mac OS 10.7.5 and above.
I have experience building XML Parsing programs in Java and C# and could make you a program in either to spit it out to Excel. I am really hoping I get chosen because I believe I can deliver the best results. Message me and let's talk details.