Correct Matlab script to read and save csv files to Postgres -- 2
Budget: $10 – $40 USD
===================================================================
Please
- do not apply if you are not a real Matlab developer
- the project will be paid in ONE milestone when finished and working on my side
===================================================================
Hi,
I have a Matlab script that reads 5 different types of csv files and saves to a Postgres database as binary (bytes), column data and enums, but the script is not working 100% as expected.
You will have to:
1) re-create on your computer the Postgres DB with the script I attach in this zip folder
2) run the "insert_marg.m" script to read all the files of the Zip below
3) check the DB to see if the data has been inserted correctly
4) In "RalusRaws" databse table:
- check that column MSGID and RECTIME hold correct data (and are not interchanged: compare with the text file)
- check that each of the 3 files write data in the correct columns and missing columns in each file are left empty in the databse
- substring column names in data field for files *.stk and *.tcr files
5) substitute "fastinsert" by "sqlwrite"
To get the project awarded you must
- create the Postgres DB on your computer using my script attached
- connect to it using matlab
- send me an INSERT clause to demonstrate the connection
Please
- do not apply if you are not a real Matlab developer
- the project will be paid in ONE milestone when finished and working on my side
===================================================================
Hi,
I have a Matlab script that reads 5 different types of csv files and saves to a Postgres database as binary (bytes), column data and enums, but the script is not working 100% as expected.
You will have to:
1) re-create on your computer the Postgres DB with the script I attach in this zip folder
2) run the "insert_marg.m" script to read all the files of the Zip below
3) check the DB to see if the data has been inserted correctly
4) In "RalusRaws" databse table:
- check that column MSGID and RECTIME hold correct data (and are not interchanged: compare with the text file)
- check that each of the 3 files write data in the correct columns and missing columns in each file are left empty in the databse
- substring column names in data field for files *.stk and *.tcr files
5) substitute "fastinsert" by "sqlwrite"
To get the project awarded you must
- create the Postgres DB on your computer using my script attached
- connect to it using matlab
- send me an INSERT clause to demonstrate the connection