Home » PLAYER'S HQ 1.13 » v1.13 General Gameplay Talk » Where in XML files can I find certain data? (Need help browsing XML files)
book95.png  Where in XML files can I find certain data?[message #341524] Fri, 26 June 2015 22:10 Go to next message
DC_da_big is currently offline DC_da_big

 
Messages:11
Registered:June 2015
I'm trying to create spreadsheet table containing certain data about weapons found in JA2 v1.13 mod. Goal is to compare weapons to make a decision about "standard issue" weapons for my teams.
I'm aware there is link to similar table on ja2v113.pbworks.com. But that table is outdated and I want better structure of table.

Manually copying data from weapon description box is not an option. I simply don't have that much time. Currently I use "import data from XML" feature of Microsoft Excel. I've found almost all data I need in XML files located in \Data-1.13\TableData\Items\

But I can't find following data:
- APs to Attack (as found in weapon description box).
- APs to Burst (as found in weapon description box).
- APs to Autofire (as found in weapon description box).
- Damage (as found in weapon description box).
- Info about attachment slots available for weapons.

Could you please tell me where in XML files I can find above data?

If above data can be calculated from another data found in XML files I'll appreciate if you tell me the algorithm.

Report message to a moderator

Private
Re: Where in XML files can I find certain data?[message #341525 is a reply to message #341524] Fri, 26 June 2015 23:11 Go to previous messageGo to next message
Deleted.

 
Messages:2634
Registered:December 2012
Location: Russian Federation
You can open weapons table in XML Editor then copypaste data to Excel using ctrl+c, ctrl+v on selection.

[Updated on: Fri, 26 June 2015 23:12]




Left this community.

Report message to a moderator

Lieutenant

Re: Where in XML files can I find certain data?[message #341552 is a reply to message #341525] Wed, 01 July 2015 00:19 Go to previous message
DC_da_big is currently offline DC_da_big

 
Messages:11
Registered:June 2015
Thank you. I've done that. Though directly importing XML files to Excel table was much more lucrative in terms of data.
I also received much help from guys at IRC channel. Thank you all.

Now I have two XLSX files containing info for v1.13 Build 7609:
1) Merges of items.
2) All weapons.

Tables can be used for comparing weapons and making reasonable decisions. There are several natural flaws in data, though. Like "APs to Burst" and "APs to Autofire" sometimes don't exactly match data found in game. And weight of weapons from XML tables don't match weight found in game. While problems with APs difference is understandable (due to calculation variations), I have no slightest idea why there is a problem with weight differences.

I can upload both files somewhere if someone needs them.

Report message to a moderator

Private
Previous Topic: Micky O'Brien's Worst Nightmare
Next Topic: General Questions to Build 7609
Goto Forum:
  


Current Time: Fri Jun 12 18:13:08 GMT+3 2026

Total time taken to generate the page: 0.00516 seconds