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: Islington, London Posts: 4,743	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: Gainesville, FL USA Posts: 3,353	too bad I already gave out my code to bring it into Access. I guess that's what I get for being quick... __________________ If not perfection, 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,556	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, 03:56 PM	#9 (permalink)
theasfl Hall Of Famer Join Date: Apr 2004 Location: Coral Springs, FL or Orlando, FL (UCF) Posts: 7,774	well **...now I regret switching majors from computer science to chemistry (with Digital Media in between)... __________________ All-Sports Fantasy League** The ASFL 21 different games, 8 sports. Now trying to fill up our Fantasy Football leagues. 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, 04:59 PM	#11 (permalink)
kq76 Moderator Join Date: Nov 2002 Posts: 5,328	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! __________________ Interactive Online League Directory - find or advertise a league today! (now OOTP9 compatible, thanks for the space jazzrack!) Canadian Baseball League - one of the last OOTP6.5 leagues still left, running since April 2002 SGCBL - a Lord of the Rings themed league with a very friendly membership and a commish constantly looking to improve the smallest of things

05-18-2006, 08:49 AM	#2 (permalink)
rdomico Major Leagues Join Date: Mar 2002 Location: Monaca, PA Posts: 491	When does the contest end?

05-18-2006, 08:50 AM	#3 (permalink)
Marc Duffy SI Marketing Wizard Join Date: Mar 2004 Location: Islington, London Posts: 4,743	May 30th

05-18-2006, 01:18 PM	#8 (permalink)
canadiancreed Hall Of Famer Join Date: Aug 2004 Posts: 9,776	blah and here I just got give an assignment. Ugh

05-18-2006, 04:37 PM	#10 (permalink)
billethius All Star Reserve Join Date: Apr 2004 Posts: 806	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-23-2006, 11:06 AM	#14 (permalink)
rdomico Major Leagues Join Date: Mar 2002 Location: Monaca, PA Posts: 491	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: Islington, London Posts: 4,743	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: Islington, London Posts: 4,743	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	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode