• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Import Data from XLS into Database

Participant ,
Jun 12, 2010 Jun 12, 2010

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 IDAway Team IDField IDDateTimeLeague ID
5481543526-Jul-106:00 PM128
1545483526-Jul-107:30 PM128
5615363527-Jul-106:00 PM128
5365613527-Jul-107:30 PM128
5485323528-Jul-106:00 PM128
5325483528-Jul-107:30 PM128


Thoughts...

TOPICS
Advanced techniques

Views

1.3K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jun 13, 2010 Jun 13, 2010

Copy link to clipboard

Copied

Let them copy and paste it into a textarea.  You'll end up with tab delimited data.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advisor ,
Jun 14, 2010 Jun 14, 2010

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Jun 14, 2010 Jun 14, 2010

Copy link to clipboard

Copied

LATEST

Will look into...

I am using MS Access

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation