import csv data into mysql
$10-100 USD
Paid on delivery
please see attached csv and sql files.
[login to view URL]
should keep datasets.
[login to view URL]
should get all data values for datasets
[login to view URL]
is list of datasets.
col 1 is industry code (see below)
some datasets are 'parents' of others.
structure is defined by the number od dashes in front of dataset name.
i.e.
1,"-All holders"
is a subset of
101,"Mortgage Debt Outstanding"
6,"--Major financial institutions"
is a subset of
303,"-By type of holder"
superset_id should be set accordingly
'root' dataset should have 'parent_id' of '0'
[login to view URL]
has actual data values for all datasets.
Both empty cells and cells, that have zeroes should be considered as
missing values and skipped
[login to view URL]
contains very basic class with some
methods, that may help you working with datasets and values.
for example: Data in this datasets is available per quarter, and database
needs a value of month.
- use q2m(...) method to convert quarter to month.
- get_dataset_by_code(...) will give you dataset id by code (see how code is constructed below)
- delete_datasets_by_source(…) will delete all data and datasets
e.t.c.
please do a quick review of this code. You are free to add your changes
to existing methods and create new.
Quick overview of database schema:
in datasets table:
`code` should be set to ‘mdo_<industry_id>’. For example 'mdo_202'
`sort` = ‘0’ for all datasets
`name` from column 2 of [login to view URL]
`component_id` = ‘0’ for all datasets
`superset_id` should have id of parent dataset. “root” dataset should have ‘0’ here.
`industry_id` from column 1 of [login to view URL]
`source` = ‘mdo’ for all datasets
`nodata` datasets 101, 202 and 303 have no data so ‘nodata' field for them should be set to ‘1’ and ‘0’ for others
the rest may be left empty.
in data table:
- `county_id` for this dataset is fixed and should be ‘100'.
- `year`, `month` and `val` - based on [login to view URL]
- `statefp` =‘0’ for all records
- `dataset` = id from datasets table
- `derived` = ‘NULL’ for all records (default)
The script should run in command line mode.
i.e. #php [login to view URL] <paremeter>
and accept parameters:
“create_datasets" - to fill datasets table
"import_data" - to import data values for existing datasets
both should perform appropriate cleanup
(delete all datasets and data prior to creating datasets)
(delete all data prior to importing data)
Feel free to ask any questions.
We will be adding many more datasets into this structure. This job only includes files, that are attached.
The code should be reasonably commented.
Minimal code is welcome.
Project ID: #9196363
About the project
22 freelancers are bidding on average $104 for this job
Hello! With 98% to 99% completion rate, 850+ successfully completed projects, and a 4.99 reputation (maximum possible, 5.0) (can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... y More
let us start ..............................................................................................
Hello, Hope You are doing well. ARITY INFOWAY is complete web based solutions company. We able to provide web solutions from scratch to hosting . We always go through every point of your projects scope and prov More
Hello, I'm an experienced php/mysql developer and so I can make the requested script within max a day after you accept my bid. Regards, Tamas
Hello, Greetings! I am writing to express my interest in your project. I believe that my skills & qualifications make me an ideal candidate for this project. I possess 5 years experience as a PHP lead , we have More
You don't need hire someone for this project. Import csv directly with phpMyAdmin and save it to sql file. To easy you can make it yourself. Happy new year!
This can be done as per the requirement. PHP script that will be delivered can be run through command line for performing two actions: 1) create dataset 2)import data. Both these actions will first cleanup the existing More
I have 2 years of experience moving data from different sources to SQL server. I currently work with MySQL.
We are database professionals and we will deliver you in less time with quality for sure. we have experts more than 11 yrs. Let us know. Thanks
I have 5 years experience on PHP and databases (mysql,mssql), 3 years experience on C# and .net. I will prepare and send your complete script, after this you can pay