Database Setup And Automated import

$30-250 CAD

Finalizat

Data postării:

peste 2 ani în urmă

$30-250 CAD

Plata la predare

I have 2 CSV files that are updated daily that I want to import into a database that I can then use data studio to build out some dashboards. Will need to read the CSV files and put the data into the tables (cron) Will also need to create database tables and set them up for optimal speed. File 1 This file contains Order ID (Unique Identifier) Tracking Number, Carrier Name, Cost, Tax The file also contains other fields that will not be brought in. and we will want to ignore and lines that do not have an Order ID as they would be subtotal lines in the file. File 2 This file is all the order information such as the order number,shipping address, freight paid, order total, customer type, ship via and a few other fields.

Database Programming

MySQL

Database Administration

Database Development

ID-ul proiectului: 32067550

Despre proiect

25 propuneri

Proiect la distanță

Activ: 2 ani în urmă

Vrei să câștigi bani?

Adresa de e-mail

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal

Îți primești plata pentru serviciile prestate

Evidențiază-ți propunerea

Te înregistrezi și licitezi gratuit pentru proiecte

Acordat utilizatorului:

@infinityex

I can make import csv to mysql tables cron as php or node.js script within 1 day. I will make tables structure optimal with required indexes and optimal data types. I have 25 years experience in relational databases including development custom sql database.

$125 CAD în 1 zi

5,0

(83 recenzii)

6,4

25 freelanceri plasează o ofertă medie de $191 CAD pentru proiect

@nixtech

Hello Sir I can create script to update or insert data using corn. Can I have CSV file for review? I am willing to start right away Please check my profile for work and experience. Regards Hardeep

$250 CAD în 2 zile

5,0

(158 recenzii)

6,8

@hoisticdeveloper

Hi there, I am here certified Freelancer I have read your project description I can provide you quality work on time Hope you contact me to discuss more regarding this project. Thank you.

$200 CAD în 2 zile

4,9

(38 recenzii)

6,5

@Proolancer

Hello, I m a web and desktop developer with 10 years of experience in C# ,I did many management web system during my professional life, I can do your project in the deadline just contact me and we can discuss more about it. Best Regards Fouad

$240 CAD în 7 zile

5,0

(23 recenzii)

5,9

@carina0530

Hello, I'm fullstack expert, with over 10 years experience dealing with web, I can help import automatically. I've previously worked on the exact same project for another employer. When do you need this finished by? I understand how annoying it is, and can finish this for you quickly! Please send me message, so i can understand details for your project. Waiting for your reply. Best regards. Carina

$140 CAD în 1 zi

4,9

(28 recenzii)

6,1

@prakash2813

⭐⭐⭐⭐⭐ Hi there, I am java developer with 7+ years of experience in web and desktop app and game development. I have strong expertise in web crawler, web scraper, web monitor, web automation and b-o-t-s. I have read the details and looks an easy job for me. Have a look at my profile for my portfolio and similar projects I've completed with reviews. Message me, I would like to discuss further details over chat.

$250 CAD în 3 zile

4,9

(40 recenzii)

5,8

@ahmedkamran9

Hi, I’m a UK based database developer with many years of experience in Oracle, MySQL and SQL server databases. I develop load processes every week in my day job. I can certainly help you to automatically load the data into the database. I’m looking forward to work with you. Regards, Kamran

$125 CAD în 7 zile

5,0

(23 recenzii)

4,8

@LiveExperts

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. ..

$250 CAD în 5 zile

5,0

(4 recenzii)

4,6

@hoaxuyentri

Hello! I hope you are doing well. I am an experienced database administrator using Autoimport by procedure/cmdshell in ms sql server. You can refer my profile in link https://www.freelancer.com/u/hoaxuyentri I already read your project description and I am very interested in your project. I can help you to Database Setup And Automated import as your requirement. I will use sql server for setup and autoimport by procedure/cmdshell. I can start right now and will provide you the top quality work for sure. Please contact me to discuss more about the detail. Regards,

$60 CAD în 1 zi

5,0

(30 recenzii)

4,7

@ivsergeev99

Hello I am Database expert such as NOSql, MySql, MongoDB, MariaDB, Postgre and so on wiht over 7 years of experience. Please discuss more details via private chat. I will wait you. Thanks.

$200 CAD în 7 zile

5,0

(2 recenzii)

4,0

@sabribaccar71

Hello , I have seen your job requirements and I am sure that I can do your task efficiently in less timeline as we are a team of engineers of 3 people, each one has an experience of 5+ years we are specialized in web development and machine learning. Contact us for moreinformation Welcome :)

$100 CAD în 1 zi

4,6

(4 recenzii)

4,0

@fliudmyla1

Hi, Dear I`ve read your project post very carefully and I`m really interest in your project. I`ve rich 6+years of experience and knowledge in Database Converting. If you hire me, I can start right now and I`ll provide you with the best results to your satisfaction. I have the ability to do that. I would like to discuss more regarding project via chat. Please invite me to chatbox. Thanks for reading my proposal.

$200 CAD în 7 zile

5,0

(3 recenzii)

3,6

@vw1514518vw

Ready to create the database, write the code to automate the import/update Orders data from the 2 .csv files(scheduled run as needed) Best Rageh

$200 CAD în 7 zile

5,0

(1 recenzie)

3,7

@latinl

Hello, As a senior software developer I have rich experience DBMS, data entry, automatic updation, etc. I am always available on your time and budget so we can discuss anything. I will always try my best to get the best results. If you have desire to work with me, please respond me to discuss more. Looking forward to working with you. Best Regards.

$400 CAD în 7 zile

5,0

(2 recenzii)

2,8

@nolk

Hi there, I have long experience working with databases - from design/implementation up to fine tuning and support. I'll be happy to help you with your tasks. I can prepare all the tools in my model and then port it to your server, will just need couple of examples of CSV files.

$150 CAD în 7 zile

5,0

(1 recenzie)

2,4

@youshaarif

Hi, I showed a keen interest in your project as I hold notable experience in Python Development for office automation also I have worked on similar projects of data scrubbing and data transformation with MySQL databases, but I would love to hear more from you. If it seems feasible feel free to contact me. Best, Yusha. Best, Yusha.

$50 CAD în 1 zi

5,0

(3 recenzii)

2,0

@jinhui12

Hi Sir, This is Lan and I am an expert in automated processes, I can help you install the database and set up an automatic data import solution. Can we discuss more details about this project? Thanks, Lan

$130 CAD în 2 zile

5,0

(1 recenzie)

1,7

@jaiswalankit17

I have created databases, wrote sql queries and stored procedures. I also also created ssis oackage for automatuc csv file reader and data dymp in sql.

$199 CAD în 7 zile

0,0

(0 recenzii)

0,0

@maratproidrisov

Hi, Sir I have read your proposal carefully and I am sure I can deliver your idea with good quality. As a python expert, I have experience in dealing with DB administartion. Moreover, I am familiar with cron jobs. I have worked on dumping the db on the server by using cron. I hope we would have a good chat to discuss the details. Thanks. Best regards. Marat I.

$200 CAD în 2 zile

0,0

(0 recenzii)

0,0

@samueljansen

Looking into the project description, you will need an API to actually import the CSV and store it on your database (not only once, but probably 4 times a month, some policies of data cleaning, policies for maybe drop databases and reestar it over and all sort of things along these lines) Also seem like you still don't have the means to provide the infrastructure. Probably don't have a hosted database, neither VMs to host the API. I'm foreseeing a log of work hahaha, but I'm up for the challenge.

$250 CAD în 14 zile