Find Jobs
Hire Freelancers

Create a database and simple web gui

$10-30 USD

Imefungwa
Imechapishwa about 8 years ago

$10-30 USD

Kulipwa wakati wa kufikishwa
I have web crawler application that will import data like in the excel file attached. The db size will be around 2 gb. Need some to create a database that will contain all the fields like in the excel file attached and to be optimised for speed. Also need a webaplication / script / site where all this data from the database can be selected (by car make, type, year, engine etc..) and the ability to export the database data to excel. I will be inserting new prices every week, acctualy price updates, so I need to know how can we make database insertion via web crawler so the script can show me which products price has changed since last update. For example in my xls file, there have been 2 price updates (column k and l), and I want the script to be able to export only products whos prices changed from last price change in this case take a look at k3 costed 29,95 on 3.4.2016 and on 10.4.02 the cost was 25,95. so the price has changed for this product, I want it to be exported. Please give me suggestion on what would be the best way to do this. Because I know its a problem with this price changes, since everyweek there is a new "column" added to the database with its date. Or can it be done by inserting the price to the same product but with different date so the script can see when the price was added and sort data that way. This is an ongoing project, and updates will be needed every week (ofcourse the work will be payed). Open for any suggestions.
Kitambulisho cha mradi: 10182100

Kuhusu mradi

12 mapendekezo
Mradi wa mbali
Inatumika 8 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
12 wafanyakazi huru wana zabuni kwa wastani $85 USD kwa kazi hii
Picha ya Mtumiaji
Hi, I am a full time freelancer with over 16+ years development experience and over 12+ years experience in VB.NET Development. I have analyze the requirement and I can modify make use of your current script which import data into Excel to save database in DB. > The modified script module, will save database in DB where in to save DB Size, the replicated info about product including and the current price will be saved in a table and for each product the ProductID will be auto generated. > There will also be an additional table in DB that will hold last price with reference to the ProductID (internal) > This way we can have all historical price of product without much DB Space. I'll create a simple responsive interface protected with login/password that can be used to export the data based on filters and whether you need latest price sheet, or including last price sheet or only list of products which has price changes. I am dedicated to my work and provide 100% customer satisfaction and on time delivery, you can review my profile and feedback. I also provide support for any issue if required after job is done to retain my clients to get more works and references. I am looking forward for your response and waiting to start the job. Thanks & Regards Sandeep Verma
$50 USD ndani ya siku 2
5.0 (15 hakiki)
4.3
4.3
Picha ya Mtumiaji
Given the size of the database, you will most likely want to use a separate script that runs in the background and compares prices, generating a report. But this depends on 1) the typical amount of items you expect to have updates, and 2) the total amount of items you provide in each new file. The script approach: Upon inserting new data, a history table is populated with the 'Partnumber" and historical price. The background script can compare the new entries with the history table to see which have relevant changes. From there, we can generate a report easily with only the changed items. I am very into data processing, flows, and manipulation - hopefully I can help you on this project. Any questions, please let me know. Thanks! Bryan
$88 USD ndani ya siku 2
5.0 (1 hakiki)
0.8
0.8
Picha ya Mtumiaji
I am 8+ Years of Experienced Software Developer. ASP .Net , C# , VB .Net , Visual Basic, Excel VBA , MS SQL Server , MYSQL , Oracle , MS Access, Crystal Report, Telerik , Bootstrap , HTML 5 , CSS , Java Script are my working domain. I am confident to complete the project.
$200 USD ndani ya siku 5
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hy there! I am interested in your project. I already have done projects related to the databases. Entering the new record with a new date is a good option of the problem mentioned. Contact me for further discussions. Thank You.
$100 USD ndani ya siku 5
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hello Sir, Myself Charandeep Singh having 4 years of Bachelor's Degree in Computer Science and Engineering and more than 14 years of experience as a Software Programmer. We need to have 2 tables 1) Main table 2) Pricing table with date My Skype ID is deep_singh78. ####AREAS OF EXPERTISE##### Desktop applications (****14+ Years Experience****) Web Applications (****12+ Years Experience****) Windows Services (****7+ Years Experience****) C#, VB.NET (****10+ Years Experience****) ASP.NET/MVC/ Entity Framework (****5+ Years Experience****) XML (****5+ Years Experience****) JQuery (****5+ Years Experience****) MSSQL SERVER (****10+ Years Experience****) MySQL (****4+ Years Experience****) I have worked with mid to large scale projects including government and private in Sacramento, California for 12 years. My latest projects on includes technologies like MVC, Entity framework using Azure platform. Creating web jobs and anything related to creating databases , queues on azure platform. From the last 14 years I have been developing applications including Web, Desktop, Web, Mobile and Windows Services . I have been doing programming in C++, C ,C# , Visual Basic, VB.net. Regards Charandeep Sin
$200 USD ndani ya siku 2
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
A proposal has not yet been provided
$55 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
A proposal has not yet been provided
$29 USD ndani ya siku 5
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hi, the URL of products seems unique for every one of them. This can be use to "update" and inserting new price. The issue with the new price inserted and query "which product as a price update" is actually easy to do. It's mainly just the way the structure of the database would be done. Prices need to be in a separate table from the "products". This way you can put as many prices as you want and easy to sort them by price inserted. Feel free to ask any questions.
$61 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya CROATIA
Zagreb, Croatia
5.0
19
Njia ya malipo imethibitishwa
Mwanachama tangu Mac 25, 2010

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.