Encerrado

Filemake Pro 12 database - horse racing

Need assistance in setting up a filemaker pro 12 database. The database is comprised of data of past horse races. The data is contained in a large number of comma delimited files. I need to be able to extract the comma delimited files into the appropriate fields and then analyze the data. Assistance is needed in setting up the relationships between fields as there are many elements involved.

I need to be able to analyze elements within individual races as well as across a wide number of races. Attached are the 2 types of comma delimited files which will be used as the basis for the database. One file contains all the entrants for all the races on a particular day at a particular track. The second file contains the results of all the races on a particular day at that track.

Attached is an excel file which contains the fields and field names of each csv file.

I have broken them down into the tables I believe I need. Sheet #1 contains the 1435 fields to be extracted from prx0101.csv 1) Race Info - Info about one specific race before the race was run. 2) Horse Info - Info and data about a specific horse in a specific race before the race was run. Each race will obviously have multiple horses. There are also a number of blank fields in the csv that I don't need.

Sheet #2 contains the 122 fields to be extracted from 2012resultsprx0101.csv. 1) Race info - Info about the race from after the race was run. Needs to be added to the race info table. 2) Horse info - Info and data about one speciifc horse from a specific race after the race was run. Each race has multiple horses and not all the entered horses will be in the results. I need to add a field that indicates a horse was "scratched" (was listed in entries but is not in results). 3) Wager info - Info about the different wagers which were available in the race, their payouts and which horses figured in those wagers.

I envision 3 tables 1) Race Info 2) Horse info 3) Wager info.

Where I have difficulty conceptualizing this database is in making the relationships between a race, the horses in that race and the results of the race, which does not include all the horses which were entered.

I also need to automate the process as much as possible for extracting the data into the relevant tables.

Thank You.

Habilidades: Administração de Bancos de Dados, FileMaker

Ver mais: filemaker horse racing, horse racing database filemaker, filemaker racing, horse, horse racing results, horse racing database, entrants, database needed filemaker, need horse, horse racing filemaker, horse races, filemaker data, horse racing data, database horse racing, racing data, extract database file, database track files, data entrants, scrape horse racing data database, comma delimited data extract, horse racing statistics database, horse results, racing results, horse data database, racing database

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #5099603

12 freelancers estão ofertando em média $590 para este trabalho

Macfilepro

Hello , my portfolio: [url removed, login to view] can you explain me what kind of column names in the csv file ? (this helps me to understand what kind of relationship need to build ) is this static csv Mais

$444 USD in 5 dias
(11 Comentários)
5.0
elboukharimu

Hi, I'm very interested helping you geting your data from your csv files, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there i Mais

$736 USD in 10 dias
(10 Comentários)
4.3
swarm22

I have +4 year experiences in database architecture and administrator . To Provide Well Documented , quality code and professional work. Thanks & Regards Hardik G. Dumaswala

$555 USD in 20 dias
(1 Comentário)
0.8
maxlogics

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Mais

$526 USD in 15 dias
(0 Comentários)
0.0
inoussakabore

Hi my Dear, i am a statistician engineer working as a data manager and data analyst there is 4 years. What you want it's what i master a lot. I am ready to start it for you. Let's go in PM please

$422 USD in 5 dias
(0 Comentários)
0.0
wsh2

Have just completed a [url removed, login to view] webscrape / database build program. The strength of the program is not only the fully functioning database, but also its ability to keep the data in it fresh and up to date on a dai Mais

$736 USD in 9 dias
(0 Comentários)
0.0
Cezary

Edit: I have made a small test and I think what you need is 3 tables , Race, Race Results and Horses The Wagers are a part of the Race so that is 1 table, RaceResults is the main table that connects all of them Mais

$777 USD in 20 dias
(0 Comentários)
0.0
joeknipp

Hello, I design clean, user-friendly databases with FMPro 12. I'd be happy to help you achieve your needs. I have just signed up for [url removed, login to view] so I do not have reviews. I have a very solid understanding of Mais

$500 USD in 10 dias
(0 Comentários)
0.0
avickmukherjee

Sir ,I have 2+ years experience in Filemaker Pro 12 [url removed, login to view] Importing From Csv files and analize this data depending of some conditions , I can make that very easily. Can I Show you an [url removed, login to view] me a cha Mais

$444 USD in 8 dias
(0 Comentários)
0.0
mango953

Hello, I looked at the file you attached but without columns headers I can't tell what each column information means. You also mention two files but I do not see a brake of one file from the other. My offer to you is t Mais

$555 USD in 7 dias
(0 Comentários)
0.0
eagleeyesvw

Hi, Good experience in filemaker pro database management and filemaker server. have 5years developments experience.

$444 USD in 3 dias
(0 Comentários)
0.0
Osgen

Basing from the initial information you provided, the project can be finished within 7 days. Please send complete details of the application you wish to be customized (e.g. Screen layouts, button placements, the Report Mais

$500 USD in 7 dias
(0 Comentários)
0.0
anishkumar200912

A proposal has not yet been provided

$800 USD in 9 dias
(0 Comentários)
0.0
amifreelancer31

Hi, Thanks for describing your requirements nicely. I have analyzed your requirements including the attached files and want to ensure you that I’ve lot of experience to work like this projects. I’m confident to offe Mais

$611 USD in 15 dias
(0 Comentários)
3.3