Database Setup And Automated import
Budget: $30 – $250 CAD
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.
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.