xEdit script - export item enchantment description + references

[overdev93]

Hi :)

 

There is a script from the "Automation Tools for TES5Edit" called "Skyrim - Export and import weapons and armor stats from spreadsheet" well which exports the formID, item name, damage and so on.

But I also need the enchantment description. Like it's in the game in you go to your inventory on a magic item.

 

I roughly understand the script but the problem is that the enchantment points to a magic effect that has the description text on it. also the text has a <mag> for the magnitude which also needs to be calculated or pasted in from another entry.

 

I edited the script that I get the enchantment ID and name but it just says "EnchWeaponFrostDamage01 "Frost Damage" [ENCH:00045C36]" for example which is of course not what I want.

Also I need the references of the weapons and armors exported but only the NPC and Cell references.

 

I can change a value in the script here and there but the things I need is much more complicated than that.

 

I seriously looked up every weapon in the game and have written off the item description/enchantment of it which is so time consuming and I don't want to do that for the armors as well.

 

BTW it's not Skyrim weapons and armors. It's from a total conversion.

[Guest]

Attach the script and I'll take a look.

 

Mind you, <mag> can not be reliable converted via xEdit. The reason is that the magnitude may be affected by other factors at runtime, such as skills.

What you can do is just replace <mag> with the base magnitude passed to the MGEF record.

[overdev93]

Thanks for taking a look

Skyrim - Export and import weapons stats from spreadsheet file.pas

[Guest]

This is the current format for the exported table:

'FormID;Name;Value;Weight;Damage;Speed;Reach;Crit.Damage;Crit.Mult'

What format is it supposed to be for all the descriptions?

[overdev93]

FormID;Name;Value;Weight;Damage;Speed;EnchantmentDescription;References;

[Guest]

Try the attached script below.

Example output:

FormID;Name;Value;Weight;Damage;Speed;EnchantmentDescription;References
[01000802];Dawnbreaker;78500;16.000000;24;0.900000;Burns for 50 points, and when killing undead, a chance to cause a fiery explosion that turns or destroys nearby undead.;3

NOTE: It turned out to be more complex than I thought it would be because I couldn't get the element directly from "EITM". Instead I had to get the integer FormID from the EITM element, find which file that FormID belonged to and then get the record from that file.

 

The output description is the first non empty magic effect description for that "ENCH" element. <mag>, <area> and <dur> are replaced with their base values. 

 

EDIT: Changed the enchantment element and magic effect element(s) to be from the winning override.

 

Skyrim - Export and import weapons stats from spreadsheet file.pas

[overdev93]

wow thanks for doing this

[Guest]

Uh, I forgot you wanted references from cells and NPCs only.

Here is an updated version.

• References from REFR and NPC_ records only. This will not cover references from leveled lists.
• Weapon description instead of enchantment MGEF description, if there is one available.
• Removed all the import code, since it's not necessary for what you need.

FormID;Name;Value;Weight;Damage;Speed;EnchantmentDescription;References
[01000802];Dawnbreaker;78500;16.000000;24;0.900000;Dawnbreaker's eternal purpose is the annihilation of undead, wherever they might lurk.;1

Requiem + 2H Dawnbreaker.

Skyrim - Export weapons stats from spreadsheet file.pas

[overdev93]

hm the reference isn't working.

for me there is no difference between the new script you posted and the last one. well when I use it I mean^^

 

but it's okay you dont need to keep working on it

[Guest]

14 hours ago, overdev93 said:

hm the reference isn't working.

for me there is no difference between the new script you posted and the last one. well when I use it I mean^^

 

but it's okay you dont need to keep working on it

What exactly isn't working about them?

[Guest]

Not sure whether this is what you want or not, but I've changed how to count references by only counting a reference if it's the winning override.

I've also fixed grabbing records from FormIDs. Previously, we were interpreting the integer FormID as a load order FormID instead of a fixed FormID, which could give you the wrong record.

 

This is how it counts references now:

function GetReferenceCount(e: IwbElement): cardinal;
var
  ref: IwbMainRecord;
  sig: string;
  i: cardinal;
begin
  Result := 0;

  for i := 0 to Pred(ReferencedByCount(e)) do begin
    ref := ReferencedByIndex(e, i);

    if not Assigned(ref) then
      continue;

    if not IsWinningOverride(ref) then
      continue;

    sig := Signature(ref);

    if (sig = 'REFR') or (sig = 'NPC_') then
      Inc(Result);
  end;
end;

And this is my result (Skyrim.esm has a NPC_ record referencing this weapon, but Requiem.esp overrides that record and removes the reference):

FormID;Name;Value;Weight;Damage;Speed;EnchantmentDescription;References
[00017009];Daedric Greatsword of the Inferno;2500;23.000000;24;0.750000;Deals 30 points of fire damage.;0

 

Skyrim - Export weapons stats from spreadsheet file.pas

[overdev93]

Oh sorry^^

 

I meant the exact records as a text like

 

[RFR:0007EDDF] (places ClothesCirclet04 "Kupfersaphirdiadem" [ARMO:000166FE] in GRUP Cell Temporary Children of CapitalCityBankNew "Ar, Bank" [CELL:0007EB50]

or

_15E_VatyrVaBossHeuschober "Vatyrfhrer im Heuschober" [NPC:000E746E]

[Guest]

And how is it supposed to concatenate all the references into one field?