Neo Scavenger XML Data Editor

13 posts / 0 new
Last post
#1
Neo Scavenger XML Data Editor

Hi all,

I've made a Mod Editor to make it easier to view and modify the objects in the game XML database.

It is an excel spreadsheet with VBA that can parse and display the XML data from the game. I chose excel as it already knows
how to import an xml file into a spreadsheet.

This is what the spreadsheet looks like once the game data has been parsed:
[IMAGE( )

If you select the "Parse data" action it will parse the selected xml database and extract all of the tables and allow them to be viewed in separate userforms. You can then use the combobox to navigate through all of the data. Note that when that combobox is selected, the up/down arrows work and allow you to scroll through
all of the entries. (unfortunately the mouse-wheel scrolling isn't easily implemented in VBA).

You can open multiple copies of the forms, so if you wanted to compare two Encounters side-by-side, go to the neogameXML worksheet and click Show Encounters, and a new Encounters form opens. You can then scroll and select different encounters to view in the two Encounter forms.

You can load multiple datasets, so you can load your Mod and Mod0 datasets, copy and edit table entries from the original database, and save your edited Mod dataset.

Download the NEO_Data spreadsheet here:
[link]https://www.mediafire.com/folder/8brl05jcvejzl/Documents[/link]

-------------------------------------------------
Versions:

V1.14:
Corrected a problem outputting Ampersands to the XML file. They needed to be printed out as &_amp; rather than a simple &.
The program now informs you if you have unsaved modified form data, when you are changing the dropdown to select a different table entry.

V1.12:
• Corrected a problem with carriage-return characters. The XML import converts x0A characters into CRLF x0Ax0D so I had to convert them back when writing out the data.

V1.11:
• You can now edit and save your Mod data.
• You can parse multiple datasets and copy table entries from one dataset to another.
• Create new table entries by changing the ID number, then save the data.
• You can edit the data in the table on the worksheet directly, parse the data then output the XML file.

V1_2:
Multiple databases implemented! You can view the game dataset alongside your Mod and Mod0 datasets.

V1_1:
Fixes for reading Mod files.

-------------------------------------------------------------
If you haven't used excel VBA before, here is how you can inspect the code before enabling macros, to insure that the
code is benign:
http://superuser.com/questions/566992/how-to-inspect-view-an-excel-macro-before-enabling-macros-for-a-sheet

The majority of the parsing code is in the Module1.

******************************************************************
Coming features:
- hot spot linking from object to object. Example: doubleclick select a condition ID in an Encounter. Right click to open new Condition form with this ID selected and contents showing.
- It sure would be nice to have these userforms icon-izable. Not natively supported in VBA, looks difficult to do....
- XML Comments get lost when the XML file is imported, so I want to work on getting them copied.
******************************************************************

Oh, this is looking real nice.

IMAGE(http://steamsignature.com/status/english/76561198018532797.png)
RZU Weapons Mod ALPHA

Have you tried it yet?

I noticed your question in the other forum, and wanted to let you know that you can use the tool as a compare function in a really crude way. I'll need to add functionality to open and display mod databases in later version of the tool.

Anyways, to use it to compare: Open the spreadsheet and parse the currently load XML data (from 1.0 release of the game). Select the Encounters/Conditions/etc that you want to use as the template to compare to. Move the forms off to the side. Reload the XML data with the Import XML data button, but select your mod file. Click Read Game Data. You now have the new windows displaying the new data. You can then compare the forms visually to the old data forms. *CAUTION* Don't click the dropdown in the old data windows, as this will cause the form to reread the game data, and I haven't tested this...it will probably break.

I haven't got Excel on my desktop, laptop does, but that's busted. I tried using Excel Online but that doesn't seem to want to work. 'Spose I'm gonna have to get around to fixing my laptop.

IMAGE(http://steamsignature.com/status/english/76561198018532797.png)
RZU Weapons Mod ALPHA

Version 1.2 Uploaded.

Now supports importing multiple datasets, so you can view your Mod data alongside the base game data.

Version 1.11 released! You can now import an XML dataset, edit it, and save it out in XML format. You can copy table entries between different datasets and vie multiple datasets at the same time.

Hope you like it!

Please update to v1.12 to correct a problem with carriage-return characters.

Any possibility of getting a version of this out for those of us with 64 bit office?

Huh...I didn't even know Office came in 64bit. What happens, does it not even load the workbook?

you get this error when trying to load it in Excel 2010 64bit:

Compile error:

The code in this project must be updated for use on 64-bit systems.
Please review and update the Declare statements and then mark them with PtrSafe attribute

if possible move this to the correct section please, and if not possible alert kaaven to it so that he can.

OverHaul Mod
DevKit is an upgraded BBC mod.
Improve your mods.

New version...

V1.14:
Corrected a problem outputting Ampersands to the XML file. They needed to be printed out as &_amp; rather than a simple &.
The program now informs you if you have unsaved modified form data, when you are changing the dropdown to select a different table entry.

is this still working/a thing? picture needs updated. i'd like a video demo with a quick run-down of how it's used.

OverHaul Mod
DevKit is an upgraded BBC mod.
Improve your mods.