Any tools for editing large amounts of item data?

Post » Mon Oct 15, 2012 4:28 am

For my mod, I am in the process of editing all the armor values for better balance, are there any tools or third party editors that could make this easier? I believe spiffyman was able to automate the process for his helluva balanced mod somehow, but I may be mistaken.
User avatar
Melung Chan
 
Posts: 3340
Joined: Sun Jun 24, 2007 4:15 am

Post » Sun Oct 14, 2012 11:23 pm

You could try the http://mw.modhistory.com/download--1662, but I'm not sure about automating the process. :smile:
User avatar
Breanna Van Dijk
 
Posts: 3384
Joined: Mon Mar 12, 2007 2:18 pm

Post » Sun Oct 14, 2012 10:20 pm

ok thanks, ill try it out, how is it different?
User avatar
My blood
 
Posts: 3455
Joined: Fri Jun 16, 2006 8:09 am

Post » Sun Oct 14, 2012 4:59 pm

All I know is that Enchanted Editor can edit all records there is in Bethesda's (Morrowind, Tribunal, Bloodmoon) esm files.

Don't ask me how it's different, because sometimes I don't have a clue what I'm suppose to do in there or can do. :tongue:
User avatar
Harinder Ghag
 
Posts: 3405
Joined: Wed Jan 17, 2007 11:26 am

Post » Sun Oct 14, 2012 5:29 pm

tes3cmd can automate changes. But it's pretty complicated. If you can tell me exactly what changes you want to make, I could try helping you with it.

Another option is that you might be able to use the CS to export the armor data as text files (File -> Export Data -> Armor), make changes to that, then import those changes.
User avatar
Dagan Wilkin
 
Posts: 3352
Joined: Fri Apr 27, 2007 4:20 am

Post » Sun Oct 14, 2012 6:13 pm

Oh, thanks alot, ill try both methods, Is there a specific format I should put the data in?

edit: I exported the armor data, its pretty confusing, is there a way to use excel or something?
User avatar
Celestine Stardust
 
Posts: 3390
Joined: Fri Dec 01, 2006 11:22 pm

Post » Sun Oct 14, 2012 5:04 pm

Oh, thanks alot, ill try both methods, Is there a specific format I should put the data in?
If you want help using tes3cmd, first tell me the kind of changes you want to automate, so I can figure out if it's the right tool for the job. I don't want to end up making more work for you, if it isn't :) Also, tes3cmd is a command line tool, without any GUI interface, so let me know if that's okay with you.

For the CS, I think the output of the export function is a tab-delimited text file. But I don't really have any advice for going in that direction.
User avatar
Sarah Kim
 
Posts: 3407
Joined: Tue Aug 29, 2006 2:24 pm

Post » Mon Oct 15, 2012 6:43 am

Oh, I dont think this something that I would be able to automate, since they dont follow any algorithm, but thanks alot for the offer, this is the data values for the curiasses, for the other parts (gauntlets, helms, etc.) I'll find some kind of formula for calculating them in relation to the curiass. This is the data, it might be a bit wierd because i copied and pasted from wordpad. If I could somehow inport from excel it would be so much easier but i dont think there is a method to do that.


-Light Armor-
weights:
Boots ≤12.0
Cuirass ≤18.0
Greaves, Shield ≤9.0
Bracer, Gauntlet, Helmet ≤3.0
Pauldrons ≤6.0
Name: Armor Rating: Cost (Curiass): Health: Weight:
Nordic Bearskin- 4 40 100 4
---------------------
Nordic Fur- 8 110 150 5
--------------------
Netch Leather- 10 250 180 6
------------------------
Chitin Armor- 13 370 200 8
------------------------
Imperial Newtscale- 16 500 350 10
------------------
Dark Brotherhood- 23 850 450 13
-----------------
Morag Tong Armor- 27 1200 400 11
--------------------------
Wolf Armor - 33 1600 500 13
---------------------------
Snow Wolf- 36 3400 500 15
----------------------
Glass Armor- 40 5500 600 18

-Medium Armor-
weights:
Boots &--#62;12.0, ≤18.0
Cuirass &--#62;18.0, ≤27.0
Greaves, Shield &--#62;9.0, ≤13.5
Bracer, Gauntlet, Helmet &--#62;3.0, ≤4.5
Pauldron &--#62;6.0, ≤9.0

Name: Armor Rating: Cost (Curiass): Health: Weight:


Imperial Chain Armor- 12 140 180 19
----------------------------
Dreugh- 18 350 300 20
-----------------------------
Imperial Dragonscale Armor- 24 550 400 21
------------------------------
Bonemold Armor- 24 650 500 22
---------------------------
Indoril- 30 1000 600 23
---------------------------
Bear Armor- 35 1550 600 24
---------------------------
Snow Bear- 40 2500 650 24
---------------------------
Orcish- 45 3500 700 25
--------------------------
Adamantium Armor- 50 5250 800 26
--------------------------
Royal Guard Armor- 55 6500 950 27
---------------------------
Ice Armor- 60 7500 1100 27

-Heavy Armor-
weights:
Boots &--#62;18.0
Cuirass &--#62;27.0
Greaves, Shield &--#62;13.5
Bracer, Gauntlet, Helmet &--#62;4.5
Pauldron &--#62;9.0

Name: Armor Rating: Cost (Curiass): Health: Weight:
Iron Armor- 10 70 200 30
---------------------------
Steel Armor- 15 180 400 35
---------------------------
Imperial Steel Armor- 20 320 400 35
---------------------------
Nordic Iron Armor 25 500 500 40
---------------------------
Imperial Silver Armor- 30 800 550 40
---------------------------
Imperial Templar Armor- 35 1200 650 50
---------------------------
Nordic Trollbone Armor- 40 1700 750 50
--------------------
Dukes Guard- 45 2400 900 55
------------------------------
Dwemer Armor- 55 3200 1250 65
----------------------
Nordic Mail Armor- 60 3900 1500 70
----------------------
Her Hands Armor- 65 5200 1750 75
--------------------
Ebony Armor- 70 7000 1900 80
--------------------
Daedric Armor- 80 8500 2100 90

general cost comparisons:
greaves- more than half curiass more than boots
boots=more than half of greaves
helmet- 3/4 of boots
shield- slightly more than helmet
Pauldron 3/4 helmet
gauntlet 3/4 pauldron
bracers- half pauldron
User avatar
Harinder Ghag
 
Posts: 3405
Joined: Wed Jan 17, 2007 11:26 am

Post » Sun Oct 14, 2012 5:27 pm

Oh, I dont think this something that I would be able to automate, since they dont follow any algorithm, but thanks alot for the offer, this is the data values for the curiasses, for the other parts (gauntlets, helms, etc.) I'll find some kind of formula for calculating them in relation to the curiass. This is the data, it might be a bit wierd because i copied and pasted from wordpad. If I could somehow inport from excel it would be so much easier but i dont think there is a method to do that.
I see. I guess it would probably be easier to try the CS export/import or just edit the armor records manually. There are only 280 armor records in Morrowind.esm, that's not too bad :smile:

As for doing things with excel, I found http://szazmyrr.com/mwmoddingtips.html:
Use File Export to get Comma Separated Values text files of the various object categories in the construction set. Import those files into Excel and you can sort and study and manipulate to your heart's content. As long as you do not change the file type from CSV, after you have made all your changes in Excel, you can save those changes as a CSV and TESCS will import it. (not just excel, any real db or spreadsheet proggie can import CSV text files )
User avatar
Sara Johanna Scenariste
 
Posts: 3381
Joined: Tue Mar 13, 2007 8:24 pm

Post » Mon Oct 15, 2012 6:45 am

Interesting find, ill try the excel thing. My mod completes most armor sets in the game plus expansions, so those are more records I need to cover. So again, thanks, you've been a huge help.
edit: The file export doesnt seem to separate the objects by comma, I dont know wether that ill interfere with excel import, but I will see
User avatar
Stat Wrecker
 
Posts: 3511
Joined: Mon Sep 24, 2007 6:14 am


Return to III - Morrowind