...writing SQL statements to: 1. Create tables 2. Upload CSV data (thousands of records) 3. Dedupe the uploaded data 4. Merge records based on rules 5. Provide the SQL Statements and help implementing for uploading more data at a later time I have MySQL server running with Workbench on a local computer, so I can test your work on larger data s...
...that exports data from my database. It generates files based on the table's name in the sql query. Each .csv is supposed to have only THAT TABLES data but, when generating the files, it exports all data from the query and it's joins. I also have a script that's supposed to import into another database, based on the .csv file names, those...
I need to pull data from a legacy Cobol application. I don't have much information about it, but I know it relies on .vix and .dat files for its database. What I need is a consulting about the better approach to extract data from those files and create csv files. The goal is to populate a SQL database with that legacy data.
...page you will find two things a. a set of long and lat defining a polygon for the city name provided. a: you will get those long and lat and put in a CSV file as one record in the following format City Name, Sub City Name, Date Retrieved, State, Points of polygon (would be lat , long | next point....)
...forecast weather data for game times, and positive/negative indicators with magnitude for major baseball statistics. • Option for user to drill down for a particular game to see more data, using an accordion/collapsible widget. • Automated back-end updating of statistics based on changes to game day information, and loading of data into database for
...Ocean, with some scripts that download large zipped csv files (one at a time), it then unzips the file and extracts the data in the file into my database tables. One of the files it downloads is very large (millions of rows, usually) and is causing a few problems with my scripts. i need a PHP and SQL expert to go in an optimise it. The errors I get
Requirement - I need you to develop a simple software which can transfer data from Excel or CSV file to sql, these file may carry 50 column and 10k rows . I would like this software to be developed using SQL , java or any other language its a B to C
I ...a functioning webpage which used d3 to update charts based on individuals moving sliders. At the moment the file pulls in data using D3.csv. To improve security, I'd like to change the input so the data is pulled in from an SQL database. If you are interested in the project please let me know what additional information you would need from me.
...Testing/Multi-Armed Bandit of items into the recommendation system. The data (user, item, feedback) for the recommended system is currently on CSV files but I will move to an SQL database later on. The recommender system will be connected to a web front end so knowledge of SQL and PHP will be beneficial. I will be able to provide more details over
...allow a user to select and upload a csv file and then map the csv data to the correct fields in the database. During the import process I need the script to either insert a field into the csv file (subuserid) OR insert the subuserid into the imported records. The subuserid field is coming from a cookie. The data that will be imported will be: first
...loaded into a SQL database hosted on Azure. Details / Requirements: - All 4 of the sites have user names and passwords and you will need to login to them - Some of the files will be in XLS format and other files will be in CSV - I have an M-Script to describe the transformation that's needed before loading the files - Importing into the SQL database:
Deliverables: 1. A Data base diagram / schema 2. SQL code to create the tables 3. MySQL workbench instructions to inject CSV file into data base I require someone to map out and create the database. The job will be to determine how many tables there should be and the logical separation and relation of each of these. The data attached is logistics data ...
We are looking for someone to help edit, complete and map our CSV to other vendors CSV such as Wayfair, Overstock, Amazon, Hayneedle etc.
We are a Canadian start-up looking for a Pentaho BI-ETL developer to independently perform the following tasks - Data Parsing from CSV file - SQL DB build - Logic framework & Pentaho transformation - Develop 3 interactive dashboards - Cloud setup environment
...I have an Apple Macbook computer. This must be done for MAC OS. I cannot use Microsoft Windows based programs.••• Project Number 1: I have 2 different lists. One list is a CSV file with every business in a certain state in the USA. The list includes business/entity name, the people who own and operate the business, the business address etc. The other
An extension of a PHP script is required. The script runs reliably and exports data from an SQL database to a CSV file. Now the corresponding data set is to be doubled in the export file for a certain value in the SQL database and a second value ("0 to 360") is to be added or subtracted with 180.
...monthly csv report will be generated which contains data. I am seeking to load this CSV file into a SQL database with separate tables for each key area. I require someone to map out and create the database (e.g determine the appropiate number of tables and design) and then sunsequently write the SQL code to create such a database. The data provide...