Completed

Build XML stream query and send values of event on the SQL database

1. The program will follow XML stream where a query will be made.

2. The query interval must be able to be determined

3. The program must work as a service (and I want to test it on command prompt or other way)

4. XML is situated in a path or address like [login to view URL] (it can also be on a different pc like 10.10.10.1234:5656 / xxxxxxxxcurrent .) But it always has to be in the same network as the program.

5. The name of the service can be defined by itself (XMLtracker Machine1)

6. The XML file contains EVENTS that can be tracked like:

<Header creationTime="2018-10-07T11:47:15Z" sender

<Streams>

<DeviceStream name="NH1234" uuid="005">

<ComponentStream component="Device" name="NH1234" componentId="NH401111009_0">

<Events>

<PowerState dataItemId="NH401111009_41" timestamp="2018-09-24T22:31:55.934Z" name="power_state_"sequence="6983808">ON</PowerState>

<Program dataItemId="NH401111009_44" timestamp="2018-10-07T09:26:35.930Z" name="program" sequence="26399754">3724</Program>

7. If the event’s value has changed (for example Program changes 0001 -> 3724), the following values will be written in the SQL database like:

id device program createddate createddateshort

1 NH1234 3724 2018-09-24T22:31:55.934Z 2018-09-24

createdtimeshort headercreationtime

09:26:35 2018-10-07T11:47:15Z

8. I want to be able to specify what events I will follow and write the event’s value into a corresponding place in the SQL database (tables). For example:

address and port=[login to view URL]\NH1234

database=computer or ip \SQLEXPRESS

XMLevent name='Program'

TABLE=[Device][Program][CreateDate][Createdateshort][CreateTimeshort][HeaderCreationTime]

9. There are several addresses and machines to track.

10. SOURCECODE needed.

Skills: SQL, XML

See more: receive xml stream php app test, save xml table sql database, xml sending php post values, spark sql complex types, stream analytics to sql database, from_json spark sql, spark from_json example, spark structured streaming kafka json, azure event hub to sql database, how to get previous row value in sql, sql: selecting rows where column value changed from previous row, insert xml records sql database net, xml stream php, send data php sql html, build xml flash, setup xml sql database, build php script query game server, send mail msdn sql, extract data sql database xml file, vba listbox values append sql

About the Employer:
( 1 review ) Lappeenranta, Finland

Project ID: #17914161

Awarded to:

RockStone435

I have read details. However, I dont understand you completely. It appears that an automated script is required, which will keep reading an XML file and will send it to database after processing. The script can be More

€650 EUR in 15 days
(175 Reviews)
8.3

27 freelancers are bidding on average €951 for this job

mahmoudgamal008

I can design the application as windows service that runs on the backgorund with predefined schedule, I can also make it a feature to control the schedule. With a GUI or command prompt to test and monitor the service. More

€250 EUR in 5 days
(31 Reviews)
5.4
schoudhary1553

This is Vibrant Webtech and I was glad to see that you're looking for help for project Build XML stream query and send values of event on the SQL database. I've delivered more than 400 + projects in the last 5 years More

€1500 EUR in 10 days
(7 Reviews)
5.2
jacekphp

Moi, I am an XML expert (my master thesis was about XML) and I have successfully worked with multiple Finnish companies. I can help you with the project. Can we discuss it in details, please? Best regards, Ja More

€1400 EUR in 10 days
(4 Reviews)
5.6
expertcoder1vw

Hi, I'm an expert Windows application developer and can develop this application for you using C++. Delivery within 4 weeks or less (because of testing / communications needed). Good quality work done. Tha More

€2000 EUR in 30 days
(31 Reviews)
5.5
bestit4u

Hi I have mastered web site development and I have already made similar site with this. My name is Shan Bin and I'm a Chinese developer. I have 6 years of web development experience such this projects. I am a highly More

€444 EUR in 10 days
(7 Reviews)
4.3
mingxiao2008

Hello , Dear I have read your project description and I am realized that I have done similar project When you contact to me , I can provide my similar project that has been done. Best Regards

€1500 EUR in 10 days
(3 Reviews)
4.5
Batista111

Hi, I am very interested in your project because react.js, React Native, Redux ,Angular,Laravel and Mobile Apps are my favorite skills. I am ready to start working now but please if possible share with me exact and More

€1166 EUR in 45 days
(4 Reviews)
4.0
polarjin2017

Hello? How are you? I have good skills in xml with back end side... So I think we can work together. Hope to work with you. Thank you.

€777 EUR in 3 days
(7 Reviews)
4.1
acronymsolutions

Hi, I am 12+ years experienced Database Programmer at CMMI-5 level company. I have 20 member team of different Technology. We are working on : RDBMS :Oracle,MySQL,PostgreSQL, MSSQL Server 7.0/2000/2008R2 and Onward More

€999 EUR in 15 days
(24 Reviews)
5.2
shiningdevelopor

Dear client I can make your job perfectly I have experienced about xml stream I think that your job is excellent If u want me, I m sure about your job I have experienced for 6+ years and also I m full stack d More

€811 EUR in 10 days
(4 Reviews)
4.0
NewHorizons2016

Hi there, I'm a Windows software developer with vast experience going back to the 90s. I specialise in C++ and C, which is ideal for developing WIndows Services. I also have various XML parser and writer librari More

€500 EUR in 7 days
(2 Reviews)
3.5
bhaveshkhatarani

Hi, we will complete your project with in your time requirement. we have great skills in php, Angular JS,Node JS, Laravel Coddeigniter, Wordpress, Magento , HTML/CSS, Database query, AJAX, Jquery. we are ready More

€888 EUR in 10 days
(3 Reviews)
3.3
VirtualBrainInc

Hello, I have briefly read the description on project , and I can deliver as per the requirements however I need us to discuss for more clarity on the details, deadline and budget as well. 1. Web Development Samp More

€2500 EUR in 10 days
(1 Review)
2.8
€1111 EUR in 14 days
(4 Reviews)
3.3
rafwiel

Hello My name is Rafal, i am professional Windows desktop developer, i work with .Net C#, you may find examples of my work in my portfolio. I am experienced with creating Windows services and obviously SQL. I have More

€1200 EUR in 10 days
(2 Reviews)
2.4
visnevschi

Hello. As I understand, you need a windows service that will be monitoring of XML changes on another server. See what the change was and insert relevant information in database. If so, I can make it fully configurable More

€450 EUR in 7 days
(1 Review)
1.6
lavizsolutions

Hi, Can you please share me few xml files, is all files have same data? Lets discuss here [login to view URL] 1. Case Management system. [login to view URL] More

€1166 EUR in 10 days
(1 Review)
2.6
yasha53

Hi, I’m Oleksandr Yatsunyk from Ukraine (UTC+2) I can do this with Java and MySql. I'm new here so can do this just for good feedback.

€222 EUR in 10 days
(0 Reviews)
0.0
€1166 EUR in 7 days
(0 Reviews)
0.0
sergeylitv83

Hello , I would like to make your project. I am experienced Java developer and my goals is responsibility , clear and professional coding and attention for details. You can send me your requirements and details of job More

€230 EUR in 6 days
(0 Reviews)
0.0