I'm looking for a freelancer who can provide an application that will read certain fields within an XML file and import the data into a MSSQL database. The XML file will be written on a daily basis to a folder relevant to the device the XML data comes from. This is relative to Digital Video Recorders. so for example recorder1 will produce an XML file called [url removed, login to view] daily, into a folder called recorder1. Recorder2 will do the same, recorder3 the same and so on. I need to be able to tell the application where to find the [url removed, login to view] files for each recorder (there could be lots!)
The reading of the XML files needs to happen automatically, a daily event, and then the XML be deleted, ready for tomorrows file.
The MSSQL database needs to show the following fields of information from the XML file:
Each recorder in the database needs to have the following fields:
Recorder Name (Taken from the Foldername the XML file is deposited into
Camera 1 Name, Camera1 FPS, Camera1 Bitrate, Camera1 connection status
Camera 2 name, fps, bitrate etc etc
Camera 3 the same info
Camera 4 same
and so on up to a maximum of 16 cameras.
The record also needs to show the HDD size, amount used and amount free and its serial number for drives other than drive C (which is an internal DOM and will never change)
As I said this XML file is written automatically by the recorder, once it is written (into the folder relevant to the recorder on a seperate system) it should be interogated and the data posted into (imported/transferred/copied - whatever) the MSSQL database which is available to the server.
I can provide more detail if required - please ask.
I have uploaded an example XML file to play with(its a rar compressed file as its a little large - 5MB).
14 pekerja bebas membida secara purata $110 untuk pekerjaan ini
We are a group of software developers having more than 5 years of experience in sw developement we believe in providing high quality solutions in promised deadlines