Perl Import_Spells.pl

Krugus · #1 06-29-2009, 12:58 PM

Ok been doing some more research on this issue.

I'm using MySQL 5.0.77

From what I have read that in MySQL 4 and prior, if a column is set to ' ', it was just converted to a zero value but in MySQL 5 it will spit out the error "Incorrect integer value".

Further reading into this matter suggests its a sql_mode issue. It is suggested to get the old MySQL 4 behaviour back that one should execute set sql_mode = ' '; which they said an empty string means Traditional MySQL mode.

(if I'm wrong guys feel free to correct me at anytime!

)

Since the default value is empty (no modes set) and that is what set sql_mode = ' ' does.... I cleared my SQL Mode, left it empty. This setting is in your my.ini file (for those like me that didn't know :p ). There are a few different ways to access it. Directly by just finding your my.ini file and clear the SQL MODE... another way is to load up MySQL Administrator and goto Startup Variables, Click on Advanced Tab then slide about midway down in the Various box you you will find SQL Mode: You can clear it here as well.

Now after clearing this. I deleted my spells_new table. Sourced in the 230_spells_table.sql unmodified. Ran Perl import_spells.pl and it reported no errors and I had a full listing of spells (14799 of 14799).

So it was me all this time! Gah. What got me to do further research was when I tried to update my PEQ DB editor and the isbot filed spit out the error "Incorrect integer value". I looked on the boards, found no one else having this problem so off to Google I went. A few seconds later I found what my problem was. Sheesh.

So the moral of the story...... Search the Boards, Google it and do some research.

Anyways, just thought I would share

Randymarsh9 · #2 07-12-2009, 06:51 PM

I am having trouble with this script. When I double click it, it just immediately closes and when I run it from a command prompt I get this

Code:

install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains:
C:/Perl/site/lib C:/Perl/lib .) at (eval 4) line 3, <F> line 38.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Proxy, SQLite,
 Sponge.
 at import_spells.pl line 61

**GeorgeS** · #3 07-13-2009, 10:23 AM

That just reminds me to finish a new spell file importer...
I think many would benefit from this.

GeorgeS

**trevius** · #4 07-13-2009, 07:29 PM

Yeah, that would definitely be a handy tool to have. It would also be really nice to have a tool similar to the Ailia/Bleh spell editor for editing the spells table vs just being able to edit the spells file. I briefly spoke with Ailia about this recently and she said that there is a possibility that she will update the spells editor and share it with the community, but that it depends on how busy she is with other things and a few other factors. It would be really great to have a good spells tool that worked so well on the table.

GeorgeS, if/when you make the import tool, can you add in the option to export as well. Since a customized spell table means clients may need to use a custom spell file, it is good to have a simple way to export the file from the table as well. The scripts are actually fairly simple to run, but for people that aren't familiar with it, I can see how it might be tough to figure out. Plus, it will overwrite stuff without asking, so it might be nice to give a warning before overwriting any existing table/file or maybe an option to rename them before importing/exporting something that would overwrite existing data.

**GeorgeS** · #5 07-14-2009, 01:52 AM

Working on the tool now.

I'm about 1/2 done, and probably might be done in two days or so.

It will load and export.

GeorgeS

..can someone point me to this .pl file please?

Shendare · #6 07-14-2009, 10:27 AM

I believe it's this one:

http://code.google.com/p/projecteqem...port_spells.pl

**GeorgeS** · #7 07-15-2009, 02:27 AM

Ok, after some effort, I have it done

If you have trouble getting the perl program to work, this tool is for you!

spells_us.txt import/export ver 1.0.0
-- This tool allows one to import the SOF spells file and export.
-- Place your SOF spells_us.txt file in the main program folder.
-- The exported file is named spells_us_COPY.txt.

Non SOF files are not supported/will not work.

file is found on my site.. (if the .zip won't open, rename it to .rar)

Please report any bugs here

GeorgeS