Ditutup

SXML status report into MSSQL

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).

Kemahiran: .NET, Pengaturcaraan C, Visual Basic

Lihat lebih lanjut: status freelancer, play freelancer free, mssql freelancer, looking digital freelancer, freelancer xml file, freelancer video size, freelancer uploaded, freelancer said, freelancer reading, freelancer play, freelancer internal, freelancer hdd, freelancer folder, freelancer fields, freelancer detail, freelancer change name, free find freelancer, event freelancer database, 5mb file, mssql status, play video mssql, report example, freelancer info, up device, MSSQL

Tentang Majikan:
( 0 ulasan ) Potterspury, United Kingdom

ID Projek: #377920

14 pekerja bebas membida secara purata $110 untuk pekerjaan ini

djfd

Hi cctvsi! What is host OS(where xml files are) and target OS (where MSSQL DB is)? Regards!

$100 USD dalam 5 hari
(4 Ulasan)
3.9
sureec

please check PMB

$100 USD dalam 5 hari
(2 Ulasan)
2.8
raj321

Hi Please check PM Thanks

$100 USD dalam 5 hari
(0 Ulasan)
0.0
unicomplus

I have analised the attached xml file. So, a little conversation must clean up some details.

$120 USD dalam 4 hari
(0 Ulasan)
0.0
farhankhalid

Professional Work

$100 USD dalam 7 hari
(0 Ulasan)
0.0
cosmoinfosys2008

Dear Sir, Please check PMB for details. With Best Regards.

$100 USD dalam 4 hari
(0 Ulasan)
0.0
hwatemy

I have the same program with the same features you want, just a little differences wanted to be customized and added. Plz Check PMB

$90 USD dalam 4 hari
(0 Ulasan)
0.0
Innovader

Please view the PM

$150 USD dalam 7 hari
(0 Ulasan)
0.0
binupdm

Can provide you the optimal solution

$100 USD dalam 4 hari
(0 Ulasan)
0.0
sreevalli9

hi, I am having good knowledge in vb and c,c++ ready to start work

$50 USD dalam 15 hari
(0 Ulasan)
0.0
treasury7617

Hello. I think that task can simply written in VBScript and later scheduled. If xml files not having same format then this work a few complicated.

$75 USD dalam 5 hari
(0 Ulasan)
0.0
GlobalProduct

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

$75 USD dalam 30 hari
(1 Ulasan)
0.0
GeeVeee1

We can do your project. Please see the PM.

$200 USD dalam 5 hari
(0 Ulasan)
0.0
ssklyarov

Please check PMB

$100 USD dalam 5 hari
(0 Ulasan)
0.0
jimbo7

Looks straightforward. New here, but not to XML/PHP or XML/C#. PM me for details. Thank you. Jim

$125 USD dalam 2 hari
(4 Ulasan)
2.4