Ruby on Rails - CSV File import

Selesai Dipasang Aug 14, 2006 Dibayar saat pengiriman
Selesai Dibayar saat pengiriman

I need a ruby on rails program that can import a CSV file into MySql tables. I would like the program to make use of the Fast CSV gem ([url removed, login to view]), but it is not a requirement. The program should enable the user to select a file and then import the information in the file to one of seven tables. The first character of each row within the file describes a certain type of data for the file. There are seven types of data: 1. H - Header Data - describe the race card. 2. R - Race - contains information about each race on a race card. 3. S - Starter/Horses - Contains info about each starter/horse on the card 4. E - Exotic Wagering - contains info about each exotic wager on the card 5. A - Attendance - recod contains info about the attendance and handle 6. C - Comments - contains comments about events occuring for a chart 7. F - Footnote - contains the chart footnote. The the number of fields for each record type is set forth below: 1. H - 7 Fields 2. R - 64 Fields 3. S - 93 Fields 4. E - 9 Fields 5. A - 8 Fields 6. C - 9 Fields 7. F - 4 Fields The program should include the script/code that creates the requisite tables and then then the code that actually inports the CSV file and inserts the records to the appropriate table and finally close the database tables and input file. Would be nice to display some sort of processing or percentage completed message but it certainly is not necessary. For your information and testing, I have included three files: 1. [url removed, login to view] - Record Descriptions by type. 2. [url removed, login to view] - Data definitions 3. [url removed, login to view] - Ssmple CSV file This project is should be viewed as the first phase of a much larger program/project. You can consider this module as a key administrator console function.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. To include installation instructions.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

My environment is MAC OSX with Ruby on Rails running on LightPD and MySql.

Teknik MySQL PHP Ruby on Rails Perancangan Perangkat Lunak Pengujian Perangkat Lunak

ID Proyek: #3723637

Tentang proyek

7 proposal Proyek online Aktif Aug 16, 2006

Diberikan kepada:

adidami

See private message.

$102 USD dalam 21 hari
(143 Ulasan)
6.1

7 freelancer rata-rata menawar $84 untuk pekerjaan ini

kieranj

See private message.

$63.75 USD dalam 21 hari
(46 Ulasan)
6.6
miguelgarcia78

See private message.

$85 USD dalam 21 hari
(76 Ulasan)
5.2
sidney137

See private message.

$102 USD dalam 21 hari
(10 Ulasan)
4.6
swissknife

See private message.

$68 USD dalam 21 hari
(20 Ulasan)
4.4
yuriirashkovskii

See private message.

$85 USD dalam 21 hari
(3 Ulasan)
3.6
popeketric

See private message.

$85 USD dalam 21 hari
(0 Ulasan)
0.0