Challenge - Your name in lights?

Marc Duffy · 05-18-2006, 06:17 AM

With the arrival of the SQL dump feature in OOTPB 2006, we're looking to see how creative people in our community can be and we're throwing open a challenge.

The challenge

We're looking for two SQL import tools which import for mySQL and MS Access. This could be in the way of PHP and VB Script or ... something else.

Whilst we're not telling you how to go about this, we believe the tool should scan a folder (user selectable) for *.sql files, open each of these files, and execute each line in a existing or newly created database as an SQL command.

All our *.sql files contain sql commands with one statement per line.

Check out The Road to Release feature titled "I need to take a dump" (http://www.ootpbaseball2006.com/news...ews=view&id=81)

The tool with the best interface and the most options will win

Win what I hear you cry

A free copy of OOTP Baseball 2006 (if you have already ordered I will refund you)

In addition, we will place your name in the credits and give your tool placement on our website!

Any questions, please post here.

rdomico · 05-18-2006, 08:49 AM

When does the contest end?

Marc Duffy · 05-18-2006, 08:50 AM

May 30th

jarmenia · 05-18-2006, 09:39 AM

too bad I already gave out my code to bring it into Access. I guess that's what I get for being quick...

silvam14 · 05-18-2006, 09:41 AM

Quote:

Originally Posted by jarmenia

too bad I already gave out my code to bring it into Access. I guess that's what I get for being quick...

Hey, Jarmenia, I'll vouch for you. I know you created that code. You should submit it.

SSG Troyer · 05-18-2006, 10:42 AM

And I promise not to enter ... unless I come up with something of my own.

Not likely.

jarmenia · 05-18-2006, 01:15 PM

Quote:

Originally Posted by silvam14

Hey, Jarmenia, I'll vouch for you. I know you created that code. You should submit it.

Its ok, it still needed to be cleaned up. I've got bigger and badder plans...

canadiancreed · 05-18-2006, 01:18 PM

blah and here I just got give an assignment. Ugh

theasfl · 05-18-2006, 03:56 PM

well ****...now I regret switching majors from computer science to chemistry (with Digital Media in between)...

billethius · 05-18-2006, 04:37 PM

I've got a setup file ready to go but it appears that the largest zip file that I can upload here is 100kb and the smallest that I can get my setup file is ~250kb. Any thoughts?

kq76 · 05-18-2006, 04:59 PM

I don't think I'll have time for this myself, but I just wanted to say I love this! Contests rocks!

Best of luck to all those participating. I very much look forward to seeing whatever you come up with!

fauteuil7 · 05-19-2006, 11:36 AM

Quote:

Originally Posted by theasfl

well ****...now I regret switching majors from computer science to chemistry (with Digital Media in between)...

That's alright, I did German Lit (and International Politics), so unless there's going to be a contest involving "Faust" I think I'm pretty useless here.

Andreas Raht · 05-19-2006, 12:50 PM

Quote:

Originally Posted by billethius

I've got a setup file ready to go but it appears that the largest zip file that I can upload here is 100kb and the smallest that I can get my setup file is ~250kb. Any thoughts?

Please send your setup files together with brief instructions how to install and how to use the program to Marc Duffy at marc.duffy@sigames.com. Thank you!

rdomico · 05-23-2006, 11:06 AM

Are there going to be 2 winners? One for Access and one for MySQL?

I am asking because my utility should work with both.

Marc Duffy · 05-24-2006, 04:33 PM

I was hoping that the winning "tool" would cover all the available export types (SQL, Access and CSV)

billethius · 05-24-2006, 05:05 PM

Quote:

Originally Posted by Marc Duffy

I was hoping that the winning "tool" would cover all the available export types (SQL, Access and CSV)

What needs to be done with the CSV data? CSV opens natively in excel, so it wouldn't need to be imported into anything. Or is the idea to import csv data into access/mysql?

rdomico · 05-24-2006, 05:39 PM

Quote:

Originally Posted by billethius

What needs to be done with the CSV data? CSV opens natively in excel, so it wouldn't need to be imported into anything. Or is the idea to import csv data into access/mysql?

I agree. What would you do with it? It doesn't even makes sense to import CSV into access/mysql if you already have the *.sql files.

Andreas Raht · 05-25-2006, 04:04 AM

Quote:

Originally Posted by Marc Duffy

I was hoping that the winning "tool" would cover all the available export types (SQL, Access and CSV)

Sorry Marc, but I don't think that this would be a good idea. IMHO there should be a tool for MS Access, that should be a Windows program, and a tool for mySQL that should run on UNIX, most likely written in PHP or Perl, and no tool at all for CSV files. Just my 0.02

Marc Duffy · 05-25-2006, 04:09 AM

Well, at least one of the entries so far has been cross compatible

You are the judge so it's in your hands Andreas

Andreas Raht · 05-25-2006, 04:23 AM

Quote:

Originally Posted by Marc Duffy

Well, at least one of the entries so far has been cross compatible

You are the judge so it's in your hands Andreas

Well if the tool could cover both formats that's fine too... but I guess most people will want to import into their mySQL database using a Unix tool, just because the database is on a Unix machine (their web server).

But there are also mySQL databases running on Windows, so if the tool can handle them, too, using ODBC for example, that will be great! I guess we need all of the possible pairings

Windows tool to import into Access
Unix tool to import into mySQL
Windows tool to import into mySQL
Mac tool to import into mySQL
Unix tool to import into Access doesn't make much sense i guess

But I assume #1 and #2 are the most important.

05-18-2006, 06:17 AM	#1 (permalink)
Marc Duffy SI Marketing Wizard Join Date: Mar 2004 Location: Old Street, London Posts: 4,737 Thanks: 0 Thanked 6x in 2 posts	Challenge - Your name in lights? With the arrival of the SQL dump feature in OOTPB 2006, we're looking to see how creative people in our community can be and we're throwing open a challenge. The challenge We're looking for two SQL import tools which import for mySQL and MS Access. This could be in the way of PHP and VB Script or ... something else. Whilst we're not telling you how to go about this, we believe the tool should scan a folder (user selectable) for .sql files, open each of these files, and execute each line in a existing or newly created database as an SQL command. All our .sql files contain sql commands with one statement per line. Check out The Road to Release feature titled "I need to take a dump" (http://www.ootpbaseball2006.com/news...ews=view&id=81) *The tool with the best interface and the most options will win* Win what I hear you cry A free copy of OOTP Baseball 2006 (if you have already ordered I will refund you) In addition, we will place your name in the credits and give your tool placement on our website! Any questions, please post here.

05-18-2006, 09:39 AM	#4 (permalink)
jarmenia Hall Of Famer Join Date: Mar 2002 Location: Tampa, FL USA Posts: 4,289 Thanks: 27 Thanked 46x in 31 posts	too bad I already gave out my code to bring it into Access. I guess that's what I get for being quick... __________________ When is good enough, good enough?

05-18-2006, 10:42 AM	#6 (permalink)
SSG Troyer All Star Starter Join Date: Dec 2001 Location: Somewhere to the left of 2nd base Posts: 1,593 Thanks: 28 Thanked 5x in 4 posts	And I promise not to enter ... unless I come up with something of my own. Not likely. __________________ MWT Did Tennesee Delaware Mississppi's New Jersey? Idaho ... Alaska!

05-18-2006, 01:18 PM	#8 (permalink)
canadiancreed Hall Of Famer Join Date: Aug 2004 Posts: 11,025 Blog Entries: 1 Thanks: 463 Thanked 116x in 85 posts	blah and here I just got give an assignment. Ugh __________________ Once upon a time I stated if I ever got a warning it was time to go. It looks like that day has finally come.

05-18-2006, 03:56 PM	#9 (permalink)
theasfl Hall Of Famer Join Date: Apr 2004 Location: Coral Springs, FL or Orlando, FL (UCF) Posts: 7,985 Thanks: 2 Thanked 6x in 2 posts	well **...now I regret switching majors from computer science to chemistry (with Digital Media in between)... __________________ All-Sports Fantasy League** The ASFL 22 different games, 9 sports. Please check out the website (www.theasfl.com/asfl2/). The league is free- if you're interested please fill out the signup form and/or email the commissioner. Miami Talons (ABL): 2004, 2005 & 2008 Champs

05-18-2006, 08:49 AM	#2 (permalink)
rdomico All Star Reserve Join Date: Mar 2002 Location: Monaca, PA Posts: 661 Thanks: 39 Thanked 20x in 12 posts	When does the contest end?

05-18-2006, 08:50 AM	#3 (permalink)
Marc Duffy SI Marketing Wizard Join Date: Mar 2004 Location: Old Street, London Posts: 4,737 Thanks: 0 Thanked 6x in 2 posts	May 30th

05-18-2006, 04:37 PM	#10 (permalink)
billethius All Star Reserve Join Date: Apr 2004 Posts: 806 Thanks: 1 Thanked 1x in 1 post	I've got a setup file ready to go but it appears that the largest zip file that I can upload here is 100kb and the smallest that I can get my setup file is ~250kb. Any thoughts?

05-18-2006, 04:59 PM	#11 (permalink)
kq76 Global Moderator Join Date: Nov 2002 Location: Vancouver Posts: 7,623 Thanks: 281 Thanked 332x in 190 posts	I don't think I'll have time for this myself, but I just wanted to say I love this! Contests rocks! Best of luck to all those participating. I very much look forward to seeing whatever you come up with! __________________ Useful Links: Manuals \| Downloads \| Newsletters \| Knowledge Base \| New Tech Support \| Updated Forum Rules Interactive Online League Directory - find or advertise a league today! Canadian Baseball League - uses OOTP11, running steadily since April 2002

05-23-2006, 11:06 AM	#14 (permalink)
rdomico All Star Reserve Join Date: Mar 2002 Location: Monaca, PA Posts: 661 Thanks: 39 Thanked 20x in 12 posts	Are there going to be 2 winners? One for Access and one for MySQL? I am asking because my utility should work with both.

05-24-2006, 04:33 PM	#15 (permalink)
Marc Duffy SI Marketing Wizard Join Date: Mar 2004 Location: Old Street, London Posts: 4,737 Thanks: 0 Thanked 6x in 2 posts	I was hoping that the winning "tool" would cover all the available export types (SQL, Access and CSV)

05-25-2006, 04:09 AM	#19 (permalink)
Marc Duffy SI Marketing Wizard Join Date: Mar 2004 Location: Old Street, London Posts: 4,737 Thanks: 0 Thanked 6x in 2 posts	Well, at least one of the entries so far has been cross compatible You are the judge so it's in your hands Andreas

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode