In Progress

Database management app

Project Description:


Create Windows program that runs in the background and on start up on the client's computer that grabs CERTAIN data from [url removed, login to view] file (SQL ServerCE 3.5 File) and saves it on our web server. Create a second Windows program on our machine(s) that retrieves the data described above and ADDS it to the .SDF file (SQL ServerCE 3.5_File).

Details of design:

Three terms: 1) Client = client machine (Windows), 2) FTP = Web server, 3) Server = Our local machine(s) (Windows).

The Windows program on the clients computer has an input for First Name, Last Name and Password and email address associated with it. Client can input this data on install or by accessing program from tray. The client SQL file will have data under the heading SIM101. This field will ultimately be changed to the client name and password in the following format (Last Name+FirstName+Password) on the Server machine. At the appropriate time(s)and if there is a change from the last time a file was written, Client uploads it to FTP (address as specified in an ftp file). Client program runs in the background and on startup on the client machine and otherwise requires no user management. There is a button for the client to hide it and there are controls in the tray to make it show or to exit.

If new files are present, Server downloads client files and integrates them into [url removed, login to view] DB. Only relevant data is transferred associated with the Sim101 key on Client and the data associated with that key is integrated into Server DB in the proper format but on the Server it is labeled with the above given client name instead of Sim101. Server control has an input for where the .SDF file is kept. Compression will be used if relevant. No FTP information can be viewed on Client machine. As mentioned, there is a file on FTP that specifies the ftp address and password for all clients.

The above transfer will occur each day starting at the specified time(s). There is an server side file that specifies the interval and/or the end time (specified in Eastern Time). For example, the transfer may occur starting at 930 AM Eastern Time and additionally at 30 minute intervals until the end time which is the final upload for the day. If it seems the files are large which they probably will not be, then set the intervals to the user's log in time instead of clock intervals (i.e. 30 min after the hour). In order that clients do not all send files to FTP at the same time, the transfers can occur off a slightly random time on the client.

There is never more than one file for each client on the ftp. Only the most recent, so old files will be removed. Further, the client will only send a file to ftp if there has been a change since the last file was written. On the server: If the file is found to be smaller than previous uploads, then a line is appended to a server side file that shows the date and time, Last Name+FirstName+Password, and the words "File is Smaller" On the Server: Scan the file nt_order column labeled "filled" for any values > a specified amount (default to 1). If any value in this column exceeds the default level then a line is appended to a server side file that shows the date and time, Last Name+FirstName+Password, email (live link) and the words "Contracts Exceeds Default of [+ Default Value].

The above may be done for any number of clients. For example we expect to be able to handle as many as 200 clients and ideally we will only have client send data once per day as specified in the FTP located file. This defaults to 1630 Eastern Time.

The resulting SQL ServerCE 3.5_File on the Server machine will be organized in such a way that it can be read by NinjaTrader. NinjaTrader is the program that created the original files and is the program that will read the appended files.

Client will use a Windows installer and will have a license we will provide in the installation procedure. Code will work on any windows machine.

Skills: .NET, C# Programming, Software Architecture, Windows Server, XML

See more: ninjatrader nt_order, the value of project management, email address management, design it architecture on line, computer program downloads, client information management, client information app, architecture design on line, architecture design app, starting an app, level it app, email database management, app machine, project management contracts, sql server random, sdf, order management app, ninjatrader, integrated database, database management, database management project, data compression, create a new app name, net ftp server client, sql installer net database

About the Employer:
( 155 reviews ) birmingham, United Kingdom

Project ID: #5375937

Awarded to:


A proposal has not yet been provided

$200 USD in 7 days
(11 Reviews)

15 freelancers are bidding on average $358 for this job


A proposal has not yet been provided

$1052 USD in 15 days
(94 Reviews)

Hi, How can we discuss more about job? After that we will put our final price. Do you have any sample reference link? That woks like your spec. Thanks Geeky

$257 USD in 7 days
(74 Reviews)

Hello, You will be able to directly communicate with our technical expert. Please find below URLs of recent .NET projects developed by our technical experts: [login to view URL] [login to view URL] [login to view URL] www. More

$180 USD in 9 days
(17 Reviews)

Hi Employer I have Have read the requirement and i am fully confident to start this project with you. You can view my profile and we can have further discussion if you would like [login to view URL] Experties are in Vb.Net C More

$194 USD in 10 days
(55 Reviews)

Hi, An ASP.NET,c#,vb ,SqlServer,JQuery,Javascript expert here. Please feel free to discuss the project with me. I would like to have a detailed document of your requirements. Thanks, Murtaza

$500 USD in 10 days
(13 Reviews)

I have more then 6 years of experience in Web and windows application development. I am proficient in: * ASP.NET * C# 2.0, 3.5 and 4.0 * AJAX * jQuery * WCF * MVC 2.0, MVC 4.0 Razor * SQL Server 2005 2008 201 More

$515 USD in 20 days
(5 Reviews)

Hello, I have some questions about your project. 1) What is license checking mechanism in installer? do you have any ready to use library for this or the implementer of project will provide this? 2) I couldn't fully More

$277 USD in 7 days
(1 Review)

Hello. More 20 years programming experience. I would like suggest to divide whole job in steps. If/when previous step satisfied both sides, then go to next. Regards. ------------------------------------------------- More

$555 USD in 3 days
(1 Review)

I develop this type of applications every day. I believe I can help you achieve quickly what you need.

$188 USD in 3 days
(2 Reviews)

Hello sir,  I have seen your requirement of the project and can do the mentioned requirement with good efforts and 100% completion with good quality and on time completion. Website Implementation Done :  ------- More

$275 USD in 24 days
(0 Reviews)

Ready to work on your proposal,we have expert team of APP,developer as they have vast experience in APP building,we worked APP for many clients,many projects similar to features you mention also, been worked. Kindly ha More

$200 USD in 6 days
(0 Reviews)

Hello, I am Sumeet Shah from India. I am a Software Engineer with good experience in developing Distributed systems using Dot Net Framework (Winforms, MSSql, WebServices, ASP.NET/MVC, jQuery, Ajax, Json, Entity Fram More

$200 USD in 15 days
(0 Reviews)

Will discuss further and agreed on the final requirements and shape and functionality of the program in initial 05 days (or less). After that i'll start working on it and will provide you the prototype in 15-20 days an More

$500 USD in 30 days
(0 Reviews)

Respected joroaytechnology , Nice to see your esteemed project posted in the project blogs. We KWALITET SOFTWARE TECHNOLOGIES LLC is specializes in providing ecommerce, business applications and branding solutions whic More

$277 USD in 3 days
(0 Reviews)