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

€100-2000 EUR

Completed

Posted

over 5 years ago

€100-2000 EUR

Paid on delivery

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.

SQL

XML

Project ID: 17914161

About the project

23 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

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 run using a command prompt. However, some points are not clear. For instance, particularly point 8 and 9. Can you please clarify if there will be an on the fly creation of table? or we will be creating all tables without script intervention. I also didnt get you on point 9, please clarify. I have worked in XML creation as well as processing. I have also created automated scripts to process XML files. So it appears to be an interesting job to me. Looking Forward. Tx

€650 EUR in 15 days

5.0

(171 reviews)

8.4

23 freelancers are bidding on average €995 EUR for this job

@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 and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.I have more than 5 year of experience in SQL, XML. Please ping me for more discussion.

€1,500 EUR in 10 days

5.0

(22 reviews)

6.0

@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

€1,500 EUR in 10 days

5.0

(5 reviews)

5.5

@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. Thanks for considering my bid. Bests, Steve

€2,000 EUR in 30 days

4.9

(35 reviews)

5.6

@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, Jacek

€1,400 EUR in 10 days

4.7

(4 reviews)

5.6

@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

4.7

(13 reviews)

5.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 libraries(high performance), which can be used to parse yoru XML data, and then forward it on to your SQL DB. Should be able to do this for you, within 7-10 days. Let me know Thanks Om

€500 EUR in 7 days

5.0

(4 reviews)

4.2

@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 read project description few times, but i'm affraid i will need additional explanation. For example this part: The name of the service can be defined by itself (XMLtracker Machine1) Could you explain it please? Defined by itself?

€1,200 EUR in 10 days

5.0

(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 like list of servers to check, events and so on. Let me know if I understood correctly your requirements.

€450 EUR in 7 days

5.0

(1 review)

1.6

@itsparx

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requirements. We have right skills to work on this assignment. We are a team of professionals including experienced analysts, designers, project managers, developers and QA people having great expertise in web applications development mainly on core PHP, PHP with open sources (Joomla, Wordpress, Codeigniter, Cake PHP), .NET, Asp.NET, Vb.NET, HTML 5 etc. and mobile applications on ios and Android platform. Our award = superb result = happy client. In a good partnership, good results happen. Good cooking makes good eating!BWe consider our client as our partner. I am ready to discuss with you with best Regards

€1,711 EUR in 7 days

0.0

(0 reviews)

0.0

@vw8001203vw

Hi I have experience in php and perl to parse xml data and i can write a script to manage this through command line. Ready to discuss. Thank you

€250 EUR in 5 days

0.0

(0 reviews)

0.0

@AltisSoft

Hi, We shall design your requirements using a user friendly screen so that you can do the settings dynamically. It will be very easy to use. To get the idea just check some of our work sample screen shots from our freelancer portfolio. Do you want to access from multi locations. If yes we shall design your software so that you can access online database. If you are interested then we can show you a quick demo so that you can understand our level of work. It will be simple and easy to use. Let me know your opinion and let's have a discussion. Regards Kaushik

€250 EUR in 10 days

0.0

(0 reviews)

1.5

@JamesMX

Hello! I have huge experiencie working with XML files. It can work with a Windows service installed at the same PC than SQL Server. You will have a control panel (Desktop of Web App) where you can define the paths to look for XML's. You also can define the Events to track there.

€1,444 EUR in 10 days

0.0

(0 reviews)

0.0

@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.0

(0 reviews)

0.0

@rodegrec

We can have a windows console application running as a service triggered by windows task scheduler. The application will parse the XML files in all the desired locations and store the data in your database. We can also use entity framework for this. I have done similar projects (not on freelancer) which do this.

€222 EUR in 10 days