Data input in MySQL from different sources

ยกเลิก โพสต์แล้ว 5 ปีที่ผ่านมา ชำระเงินเมื่อจัดส่ง
ยกเลิก ชำระเงินเมื่อจัดส่ง

I need someone who has a basic knowlege of database and Excel files interacting with database.

I am working with rivers water inflow data and I need to input in my database (MySQL) some data from different sources. So, the job is to create interfaces which can help me to input data in my database as described below:

1. Observed water inflow (RDH)

The source of these data is a daily report in Excel file called RDH. So, the idea Is to get and input in our database just the data for the rivers that we have in our database (there is a list of which rivers we work).

2. Observed water inflow (manually insert)

There are some inflow data that is not in RDH report, so we also need a spreadsheet template which we insert the data in a spreadsheet and we also insert data in database. I also be able to give information by powerplant name, but to in data base we have per powerplant ID, so it Is necessary to convert it (making relation with a table)

3. Observed rain (manually insert)

This process is pretty much the same as the last one. We need to input data manually in my database with other type of information, so the idea is to create another user interface for that.

NOTE: Most of data we have to register the date/time we are inserting it. If we already have the same data in the database I don’t want to overwrite it, we will need to inform the validity of this data in the BEGIN_DATE and END_DATE fields in database.

please start your bid with your favorite color so I can make sure that you have read this description.

การเขียนโปรแกรมฐานข้อมูล Excel MySQL VBScript

หมายเลขโปรเจค: #17997427

เกี่ยวกับโปรเจกต์

30 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

freelancer 30 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $152

schoudhary1553

I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid เพิ่มเติม

$250 USD ใน 4 วัน
(410 รีวิว)
8.2
amranreza70

Hello Sir, I am a professional data entry expert and I have also database concept in different database technology. It will be great to have a nice chat on project. I am a top rated preferred freelancer and I wi เพิ่มเติม

$99 USD ใน 3 วัน
(124 รีวิว)
6.9
aaronc333

Hello, My Favorite color is blue like the river colors in project description :) We can make it unique with start/end dates to prevent duplicated data. Also if possible please provide the sample cls file for #1 เพิ่มเติม

$225 USD ใน 5 วัน
(3 รีวิว)
6.4
vw7209238vw

Green is may favorite color. Hi I know exactly how to develop an automation to make what you are asking for, I can read some excel files I can find in a folder and open it, connect to your mysql database and populate p เพิ่มเติม

$195 USD ใน 7 วัน
(75 รีวิว)
6.3
idragon712

" RED COLOR" Dear Sir I have read your description carefully. You want to develop a script that parse excel file and store it on db. I have rich experiences with that. I hope we can discuss about the project in mo เพิ่มเติม

$200 USD ใน 3 วัน
(19 รีวิว)
6.1
prakash2813

Hi there, I am java developer with 7+ years of experience in web and desktop development. I cam make a software for you to connect with any MySQL database with database inputs. With nice and robust Graphical Interfa เพิ่มเติม

$200 USD ใน 3 วัน
(31 รีวิว)
5.4
dobreiiita

Hello I am Software and Database development expert and interested in this project. I have reviewed the details of the application you are looking for and confident to handle it perfectly. Please communicate to เพิ่มเติม

$250 USD ใน 7 วัน
(49 รีวิว)
5.2
engmalaa

Blue. I Can do it using Odoo. But the database will be poatgresql. Is that OK?

$555 USD ใน 10 วัน
(30 รีวิว)
5.0
abubakar4248

White Hey I'm a professional software engineer having +3 years experience in this field. i have lot of expertise in Database Development i will provide professional and quality work according to your requirements withi เพิ่มเติม

$50 USD ใน 1 วัน
(8 รีวิว)
3.7
sunnylalwani

Favorite color is green I read all your description and I will create an interface that will help you to input the data with some validation that help in removing duplication data. Data will be inserted from user int เพิ่มเติม

$111 USD ใน 3 วัน
(8 รีวิว)
4.1
ig149

Color is Green. Hi , SQL Server Expert here , Well get your project done in very short time. Looking forward to work with you .

$100 USD ใน 3 วัน
(12 รีวิว)
3.8
vipingfreelancer

Hello, I can complete this task because i am computer science graduate engineer and I have knowledge about MySql database. I have done many project on MySql. You can go through my work portfolio for further concern. I เพิ่มเติม

$60 USD ใน 3 วัน
(7 รีวิว)
3.1
vinodbansal

Hello As a highly skilled Database Developer, I read your posting for a new Database Developer with interest. With more than 10 years’ experience as a Database Developer, I am adept in query writing, information sec เพิ่มเติม

$200 USD ใน 3 วัน
(2 รีวิว)
3.0
Priyanshu1

Hi If you want to use mysql database I will suggest the application to be made in php and can we hosted on the web or on your laptop. Do you want to update it automatically or manually when you upload a file or click เพิ่มเติม

$200 USD ใน 3 วัน
(2 รีวิว)
3.1
kaisarseu

Dear sir , i have worked this before. So i am perfect about this work. Otherwise i have own domain and hosting also. I have completed BSc in cse and Running MSc in Software engineering at Poland. เพิ่มเติม

$35 USD ใน 3 วัน
(0 รีวิว)
0.0
Pavlov1224

'''''''''''''''''''''''''''''''' I like BLUE color. '''''''''''''''''''''''''''''''' Dear Client I read your job post carefully and I fully understood what you want. Time!!! Accuracy!!! I don't เพิ่มเติม

$55 USD ใน 3 วัน
(0 รีวิว)
0.0
khalillahmar

.......

$111 USD ใน 3 วัน
(0 รีวิว)
0.0
snehapatil2702

Hello Sir I am very good in typing i have learned sql so i know very well how to extract data and add in sql database.

$30 USD ใน 3 วัน
(0 รีวิว)
0.0
$166 USD ใน 3 วัน
(0 รีวิว)
0.0
jasv18

He trabajado con relacionando a traves de multipleas herramientas dbms como mysql y la suite de paquetes de office de microsoft y se me hace bastante facil personalizar procesos para el empleador según el requerimiento เพิ่มเติม

$83 USD ใน 6 วัน
(0 รีวิว)
0.0