Need Help Determine What Tables / Fields to Setup for SQL
$30-5000 USD
Pago na entrega
**OVERVIEW:**
We have 1,000's of flat text files that need to be imported into a mySQL DB. We need someone who can tell us what tables/fields we need to setup and how to link them.
**OUR GOAL:**
Our goal is to be able to import these flat text files into a SQL DB that will allow us to query the data properly. Many of the variable=data fields are similar so should be setup in a proper table. We will then need to query the DB to pull information from the records.
**EXAMPLES:**
Here is an example of a file we would import:
<[url removed, login to view]>
The file being imported is a flat variable=data format. If you look at the example you will see there are several items that should be put in a unique table. Example:
schedObjId_0
This should be put into a table called "Scheduled" because there is a schedObjId_0, schedObjId_1, schedObjId_2 and so on. Same goes with this example zoneObjId_0. There is a zoneObjId_0, zoneObjId_1, and so on.
DELIVERABLE:
1) We need someone who can understand from this list the best table/fields setup need to import correctly into a mySQL DB.
2) Deliver an SQL import file that will setup these tables and fields along with what field/data should be imported into them.
I know this is a bit difficult to explain so if you have questions please let me know.
ID do Projeto: #3550275