I have a rough MySQL DB schema designed and need help with 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
I need to pull data from a legacy Cobol application. I don't have much information about it, but...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....)
***Design and Develop an "Automatic Time table Generator" with the below specifications: Database: mySQL User Interface-> ASP.Net Core Application: .NET Server: Ubuntu 16.04 Architecture: MVC ***Deliverables: 1. Installation Guide 2. Source Code of the Product & all rights of sales , lease, extension 3. 6 months of support ***Able to define the below
Las tareas a realizar son las propias de integrar un ERP CRM como Dolibarr con Magento 2: Ambos sistemas están programados en PHP con Mysql independientes. Desde el punto de vista funcional los requerimientos para este conector de tienda online con Dolibarr serian: - La recepción inmediata del pedido en Dolibarr tras la confirmación en la tienda
I have a lookup table with following data in csv file it can be imported to mysql Table sic rmin rmax smin smax Calculations r1% r2% r3% r4% r5% - provided % s1% s2% s3% s4% s5% - provided % rmulti - provided 0-1 smulti - provided 0-1 calculate r= r1%xr1+ r2%xr2+ r3%xr3+ r4%xr4+ r5%xr5 s= s1%xs1+ s2%xs2+ s3%xs3+ s4%xs4+ s5%xs5 routmin=r x rmin
I need a PHP script that will 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
Hello, I have a huge data that needs to be ported from CSV to MYSQL. He/She who have previous work experience are welcome. He/She must be willing to work full-time until it gets finished. We have around 10GB of csv files and data correctness is most important.
Hello I have around 20GB of data need to be migrated from CSV to Mysql. Most of data is available at FTP server and most of data are financial related numbers. So the detail oriented approach needed. He/She must be willing to work full-time until it gets finished.
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
... Basic features: 1- Adding inventory 2- Inventory transfer 3- Sales Order entry manually and by uploading CSV format file The fields in most of the forms should be customizable. i-e, should add/rename or delete form fields. Need PHP, Mysql, JQuery expert who understand Multi-Vendor E Commerce business. Please bid with project document including
I need a java spring batch application to export data from CSV to MySQL. The application must run on a specific time every day. It will pick the CSV from the source and create records in MySQL. More we will discuss with selected freelancer on message.
Custom written PHP & MYSQL based timeclock. Web interface for management API interface for RFID readers. workers will 'tag on' and 'tag off' at start of day, breaks, lunch, end of day. Workers need a profile, managed from web interface to setup their expected working hours, overtime profile, manage rfid serial number etc. Manager to login each day and
I need a script able to download every day the CSV data from a list of URLs and upload it to my Amazon Web Services RDS MySQL database (in one table the data of every link). This script must be hosted in the server and must be triggered every day automatically.
group the excel file by name,ip,cost insert int...[login to view URL],ext_prefix for every group you made - you will find same trunk id from mysql will match multiple ext_prefix in xls insert into trunks_rules (trunk_id,ext_prefix,add_prefix,strip,allow) Example mysql and example xls attached Keep in mind that i want this for csv, xls and also xlsx
I have a csv file which looks something like this with no headers: 1,Bill,bill@[login to view URL] 5,Susan James,sjames@[login to view URL] 7,Joe Smith,joe@[login to view URL] Here's the challenging part: Import the afore mentioned into multiple tables using the first row (The numbers) as the identifier of the table to be entered into AND when entering it into said tables, only