This "batch" concept is incredibly easy. In fact, you could have already done it, to be honest. Instead of adding the data to a spreadsheet, you can add it to a new table in a database. You can create a new table in the existing database you use for your server, or start a new database with a table just for the spells. Since you already have the column headings, export the data to a .csv file, then import it into a table. (In OpenOffice, choose Save As, not export. Csv is one of the options in the drop down menu.) You should be able to use existing headings (the first row) as your field names for the database when you import the data from csv.
This allows you to execute SQL against it, which will give you batch capability. The only difference between doing it straight in a database editor vs a spell editor is that the spell editor will be able to have some nice drop-down boxes (like you suggested) with labels instead of numbers. Actually, I intend to use both in the GUI, so people can easily associate "Beneficial" with, say, a 2 in that field. I know that with Java, the JDBC (the Java DB driver) allows direct execution of SQL against a database, so it will be virtually no work at all to allow for that. The work will come from creating the drop down boxes in the GUI that associate Beneficial with 2, for example.
Your giant table, as well as some info that AndMetal posted a link to on the wiki, will greatly reduce that work, and I thank both of you again for that.
__________________
eventual ServerOp of a less neglected custom legit server
|