Database Setup And Automated import

$30-250 CAD

Selesai

Disiarkan

lebih dari 2 tahun yang lalu

$30-250 CAD

Dibayar semasa penghantaran

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 Projek: 32067550

Tentang projek

25 cadangan

Projek jarak jauh

Aktif 3 tahun yang lalu

Ingin menjana wang?

Alamat e-mel

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

Dianugerahkan kepada:

@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 dalam 1 hari

5.0

(83 ulasan)

6.4

25 pekerja bebas membida secara purata $191 CAD untuk pekerjaan ini

@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 dalam 2 hari

5.0

(158 ulasan)

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 dalam 2 hari

4.9

(38 ulasan)

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 dalam 7 hari

5.0

(23 ulasan)

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 dalam 1 hari

4.9

(28 ulasan)

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 dalam 3 hari

4.9

(40 ulasan)

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 dalam 7 hari

5.0

(23 ulasan)

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 dalam 5 hari

5.0

(4 ulasan)

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 dalam 1 hari

5.0

(30 ulasan)

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 dalam 7 hari

5.0

(2 ulasan)

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 dalam 1 hari

4.6

(4 ulasan)

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 dalam 7 hari

5.0

(3 ulasan)

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 dalam 7 hari

5.0

(1 ulasan)

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 dalam 7 hari

5.0

(2 ulasan)

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 dalam 7 hari

5.0

(1 ulasan)

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 dalam 1 hari

5.0

(3 ulasan)

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 dalam 2 hari

5.0

(1 ulasan)

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 dalam 7 hari

0.0

(0 ulasan)

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 dalam 2 hari

0.0

(0 ulasan)

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 dalam 14 hari