Author Topic: Spreadsheet or database of all RM spells?  (Read 2246 times)

0 Members and 1 Guest are viewing this topic.

Offline Agrikk

  • Neophyte
  • *
  • Posts: 16
  • OIC Points +0/-0
Spreadsheet or database of all RM spells?
« on: June 08, 2022, 12:02:43 AM »

I am looking for a complete list of all Rolemaster spells, including attributes and descriptions, from Spell Law and all of the Companions. I'll take it in excel, CSV or SQL format.

I know there is https://www.ekkaia.org/rpg/rm/spells.pdf but I'm not sure it is complete and doesn't have spell descriptions. Similarly http://roleplayingdb.internethill.com/rmSpellsDB.aspx looks interesting but I'm not sure if it's complete and it's missing spell descriptions. There is also this blog post but it doesn't look complete and downling a stack if individual files isn't fun.

Any ideas on where I might get a list?

Offline farseer22

  • Neophyte
  • *
  • Posts: 13
  • OIC Points +0/-0
Re: Spreadsheet or database of all RM spells?
« Reply #1 on: June 08, 2022, 05:50:44 PM »
I'm not 100% sure but it seems to me that such a list would cause some copyright issues. I think the lists without the description are about as far as you can go without violating copyright.

Offline Elrich Maltah

  • Neophyte
  • *
  • Posts: 92
  • OIC Points +0/-0
Re: Spreadsheet or database of all RM spells?
« Reply #2 on: June 09, 2022, 07:38:08 AM »
The internethill site seems weird in that I can tell it's not from RM2. (There's no Magent or Dabbler profession in RM2.) The blog post also seems off, either as being from a later version of RM or a customized project (Santa's Ways?).

Offline B Hanson

  • Senior Adept
  • **
  • Posts: 655
  • OIC Points +0/-0
    • Rolemasterblog
Re: Spreadsheet or database of all RM spells?
« Reply #3 on: June 09, 2022, 11:21:58 AM »
Not sure if this helps

http://ftp.funet.fi/pub/doc/games/roleplay/systems/rolemaster/spells/

Rolemasterblog list was for my BASiL and SW lists
www.RolemasterBlog.com
Other stuff I've written: https://tinyurl.com/yxrjjmzg
Files Uploaded: https://tinyurl.com/y47cfcrc

Offline Agrikk

  • Neophyte
  • *
  • Posts: 16
  • OIC Points +0/-0
Re: Spreadsheet or database of all RM spells?
« Reply #4 on: June 10, 2022, 03:04:44 PM »
Thanks for the help y'all.

I think it's going to require quite a bit of legwork to get these spells assembled, but in the end I think it'll be worth it.

I'm trying to do something like what I did for my little herbs database:https://www.northbrilend.org/herbs/index.php


Offline Hurin

  • Loremaster
  • ****
  • Posts: 7,347
  • OIC Points +0/-0
Re: Spreadsheet or database of all RM spells?
« Reply #5 on: June 10, 2022, 04:33:37 PM »

I'm trying to do something like what I did for my little herbs database:https://www.northbrilend.org/herbs/index.php

That's a very helpful tool. Thanks for sharing.


'Last of all, Húrin stood alone. Then he cast aside his shield, and wielded an axe two-handed'. --J.R.R. Tolkien

'Every party needs at least one insane person.'  --Aspen of the Jade Isle

Offline The Chorned Jat

  • Neophyte
  • *
  • Posts: 25
  • OIC Points +0/-0
Re: Spreadsheet or database of all RM spells?
« Reply #6 on: June 10, 2022, 11:00:26 PM »
That is really neat!

Offline B Hanson

  • Senior Adept
  • **
  • Posts: 655
  • OIC Points +0/-0
    • Rolemasterblog
Re: Spreadsheet or database of all RM spells?
« Reply #7 on: June 11, 2022, 06:11:56 AM »
Cool. Feel free to cross reference against my list

https://ironcrown.co.uk/ICEforums/index.php?topic=15879.msg194132#msg194132
www.RolemasterBlog.com
Other stuff I've written: https://tinyurl.com/yxrjjmzg
Files Uploaded: https://tinyurl.com/y47cfcrc

Offline Hurin

  • Loremaster
  • ****
  • Posts: 7,347
  • OIC Points +0/-0
Re: Spreadsheet or database of all RM spells?
« Reply #8 on: June 11, 2022, 11:40:42 AM »
Would love to see one for RMU!
'Last of all, Húrin stood alone. Then he cast aside his shield, and wielded an axe two-handed'. --J.R.R. Tolkien

'Every party needs at least one insane person.'  --Aspen of the Jade Isle

Offline Agrikk

  • Neophyte
  • *
  • Posts: 16
  • OIC Points +0/-0
Re: Spreadsheet or database of all RM spells?
« Reply #9 on: August 12, 2022, 01:23:30 PM »
Cool. Feel free to cross reference against my list

https://ironcrown.co.uk/ICEforums/index.php?topic=15879.msg194132#msg194132

I'm looking at the shadow world herbs tab of that spreadsheet and there's a column with the format of
Code: [Select]
Agaath fM30NW berry chew

Is there a legend somewhere for what fM30NW means? Where was this herb list pulled from?

Offline B Hanson

  • Senior Adept
  • **
  • Posts: 655
  • OIC Points +0/-0
    • Rolemasterblog
Re: Spreadsheet or database of all RM spells?
« Reply #10 on: August 12, 2022, 03:09:50 PM »
Those codes are right from Rolemaster and SW, you should be able to find them in any of the books with an herb chart-the codes are right above the herb lists and usually in a boxed in format. I included them for reference.
www.RolemasterBlog.com
Other stuff I've written: https://tinyurl.com/yxrjjmzg
Files Uploaded: https://tinyurl.com/y47cfcrc

Offline Agrikk

  • Neophyte
  • *
  • Posts: 16
  • OIC Points +0/-0
Re: Spreadsheet or database of all RM spells?
« Reply #11 on: December 01, 2022, 10:13:28 AM »
I've made a start on my online database of spells here: https://www.northbrilend.org/spells/

It currently has spells currently collected from:
- Rolemaster 2e Spell Law (ICE 1200)
- Rolemaster 2e Companion I (ICE 1500)
- Rolemaster 2e Companion II (ICE 1600)
- Rolemaster 2e Companion III (ICE 1700)
- Rolemaster 2e Companion IV (ICE 1800)

and currently contains 6456 individual spells from 333 lists.

I am currently working on RMC5 which contains 1100 spells and let me tell you: this task is daunting. I tell myself that I'll do 1-2 lists a day and eventually I'll be done whenever it gets done.

Would anyone be interested in helping in this project?  Maybe I can set up a google doc of all the remaining lists to be done and people can sign up to do a couple.  I'd be happy to share the (rudimentary) format I'm using so the resulting .csv is easy to import into the database.

Offline Hurin

  • Loremaster
  • ****
  • Posts: 7,347
  • OIC Points +0/-0
Re: Spreadsheet or database of all RM spells?
« Reply #12 on: December 01, 2022, 06:50:51 PM »
That is a great resource! Thanks for posting and organizing it.

I am not able to contribute at this time, but just wanted to send some encouragement.
'Last of all, Húrin stood alone. Then he cast aside his shield, and wielded an axe two-handed'. --J.R.R. Tolkien

'Every party needs at least one insane person.'  --Aspen of the Jade Isle

Offline Agrikk

  • Neophyte
  • *
  • Posts: 16
  • OIC Points +0/-0
Re: Spreadsheet or database of all RM spells?
« Reply #13 on: December 21, 2022, 05:54:55 PM »
Added the 1100 spells from Rolemaster Companion 5, bringing the total number of spells in the database to 7545.

spells currently collected from:
- Rolemaster 2e Spell Law (ICE 1200)
- Rolemaster 2e Companion I (ICE 1500)
- Rolemaster 2e Companion II (ICE 1600)
- Rolemaster 2e Companion III (ICE 1700)
- Rolemaster 2e Companion IV (ICE 1800)
- Rolemaster 2e Companion V (ICE 1900)

I'll be working on RMC6 next, I think.

https://www.northbrilend.org/spells/


Offline Malim

  • Adept
  • **
  • Posts: 424
  • OIC Points +0/-0
Re: Spreadsheet or database of all RM spells?
« Reply #14 on: December 22, 2022, 06:53:51 AM »
There should be a https://donjon.bin.sh/  for RM2 and other RM editions
Sir Elor Blacke knight of Helyssa, Kytari Fighter lvl 25 (RM2)
Malim Naruum, Yinka Lord Bashkor lvl 27  (RM2)

Offline Agrikk

  • Neophyte
  • *
  • Posts: 16
  • OIC Points +0/-0
Re: Spreadsheet or database of all RM spells?
« Reply #15 on: December 22, 2022, 10:13:42 AM »
There should be a https://donjon.bin.sh/  for RM2 and other RM editions

Are you saying that it would be nice if donjon had the spells lists for RM2? Or are you saying that donjon has lists of spells for RM2 and I can find them there?

Because I had a look at the donjon site map and didn't see spells lists for rolemaster anywhere.

Offline Malim

  • Adept
  • **
  • Posts: 424
  • OIC Points +0/-0
Re: Spreadsheet or database of all RM spells?
« Reply #16 on: December 22, 2022, 10:45:43 AM »
That it would be nice if it was :D
Sir Elor Blacke knight of Helyssa, Kytari Fighter lvl 25 (RM2)
Malim Naruum, Yinka Lord Bashkor lvl 27  (RM2)

Offline Agrikk

  • Neophyte
  • *
  • Posts: 16
  • OIC Points +0/-0
Re: Spreadsheet or database of all RM spells?
« Reply #17 on: December 22, 2022, 11:12:45 AM »
Yes it would. After all the hours I've spent (and still will spend) on this spells database project, I can only wish that someone else had done it already. :D

Offline Malim

  • Adept
  • **
  • Posts: 424
  • OIC Points +0/-0
Re: Spreadsheet or database of all RM spells?
« Reply #18 on: December 23, 2022, 03:29:19 PM »
TBH!

You should contact jondon and see if they wanna host it!
Sir Elor Blacke knight of Helyssa, Kytari Fighter lvl 25 (RM2)
Malim Naruum, Yinka Lord Bashkor lvl 27  (RM2)

Offline PeerIntoChxTendies

  • Apprentice
  • *
  • Posts: 3
  • OIC Points +0/-0
Re: Spreadsheet or database of all RM spells?
« Reply #19 on: January 27, 2023, 11:16:59 PM »
I think I got what you need.  I sent you a PM