Copy link to clipboard
Copied
I am trying to create a schedule importer in Cold Fusion - where a league can do their schedule in XLS first, then import it into the database.
www.slopitchleagues.com - there is an automatic system they can use - but have to enter them manually...
So I've had a request to do it with an XLS file...
An example of the XLS fields required are below...
Basically starting on the 6th row (instructions on prior rows)
And importing till last row...
Home Team ID | Away Team ID | Field ID | Date | Time | League ID |
548 | 154 | 35 | 26-Jul-10 | 6:00 PM | 128 |
154 | 548 | 35 | 26-Jul-10 | 7:30 PM | 128 |
561 | 536 | 35 | 27-Jul-10 | 6:00 PM | 128 |
536 | 561 | 35 | 27-Jul-10 | 7:30 PM | 128 |
548 | 532 | 35 | 28-Jul-10 | 6:00 PM | 128 |
532 | 548 | 35 | 28-Jul-10 | 7:30 PM | 128 |
Thoughts...
Copy link to clipboard
Copied
Let them copy and paste it into a textarea. You'll end up with tab delimited data.
Copy link to clipboard
Copied
Some options:
1. Use CFSPREADSHEET. Allow users to upload an xls file which is then read by CFSPREADSHEET. The data from the resulting query object can then be inserted into your database.
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec17cba-7f87.html
2. Use your database's import tools, if any. If your database supports importing data from xls you could let your users upload an xls file. Then use the database's import features to import the data from the spreadsheet. What database are you using?
Either of the options above would use CFFILE to allow the user to upload files to the server.
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-738f.html
Copy link to clipboard
Copied
Will look into...
I am using MS Access