[Excel] WidowMakers XML Writer Tool

How to make a map. Official Handbook, Guides, Tutorials and more...

Moderators: Cartographers, Global Moderators

Forum rules
Please read the Community Guidelines before posting.

[Excel] WidowMakers XML Writer Tool

Postby WidowMakers on Tue Nov 11, 2008 6:16 pm

Here it is everyone. I made and excel based XML writer. There are instructions on the first tab of the excel file.

Update:
-zipped files for smaller download
-fixed a couple formatting issues in excel file. This did not affect XML output.
-added a tab to output all XML at once
Tool Version 4
Excel 2007
http://www.fileden.com/files/2007/6/15/ ... el2007.zip

Excel 2000
http://www.fileden.com/files/2007/6/15/ ... el2000.zip

Output The TEST.xml passed the XML checker.
http://www.fileden.com/files/2007/6/15/1180567/TEST.xml

Follow the instructions and it works.
I made a very basic circle of territories that can attack left and bombard right. Plus there are starting neutrals and auto deploy bonuses as well. I also coded in required continent bonuses and overrides.

Let me know what you think. Once we agree it works and is good, we can give it to the community.

WM
Last edited by WidowMakers on Thu Nov 13, 2008 6:19 am, edited 1 time in total.
Image
Colonel WidowMakers
 
Posts: 2772
Joined: Mon Nov 20, 2006 9:25 am
Location: Detroit, MI
Medals: 71
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (3) Terminator Achievement (1)
Fog of War Achievement (2) Teammate Achievement (1) Random Map Achievement (2) Cross-Map Achievement (3) Ratings Achievement (2)
General Achievement (6) Clan Achievement (10) Map Contribution (21) General Contribution (14)

Re: WidowMakers XML Tool

Postby RjBeals on Tue Nov 11, 2008 7:32 pm

Dude... Seriously...

:shock:
User avatar
Private RjBeals
 
Posts: 2500
Joined: Mon Nov 20, 2006 5:17 pm
Location: South Carolina, USA
Medals: 21
Standard Achievement (2) Doubles Achievement (1) Terminator Achievement (1) Freestyle Achievement (1) Cross-Map Achievement (1)
General Achievement (7) Map Contribution (6) General Contribution (2)

Re: WidowMakers XML Tool

Postby wcaclimbing on Tue Nov 11, 2008 8:15 pm

Thats a huge Excel file :shock:

I'll give it a try once Panama is ready for XML.
Image
User avatar
Private 1st Class wcaclimbing
 
Posts: 5598
Joined: Fri May 12, 2006 10:09 pm
Location: In your quantum box....Maybe.
Medals: 27
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (1) Terminator Achievement (4) Freestyle Achievement (2)
Fog of War Achievement (2) Speed Achievement (1) Teammate Achievement (1) Cross-Map Achievement (2) Ratings Achievement (2)
Tournament Achievement (2) General Achievement (1) Clan Achievement (1) Map Contribution (1) Tournament Contribution (1)
General Contribution (2)

Re: WidowMakers XML Tool

Postby yeti_c on Wed Nov 12, 2008 4:37 am

I'll check it out later WM... if it's good - then with tools like this - then there's no reason Mapmakers can't make their own XML anymore.

C.
Image
Highest score : 2297
User avatar
Lieutenant yeti_c
 
Posts: 9670
Joined: Thu Jan 04, 2007 9:02 am
Medals: 46
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (3) Terminator Achievement (1)
Assassin Achievement (1) Freestyle Achievement (1) Fog of War Achievement (3) Cross-Map Achievement (3) Ratings Achievement (3)
General Achievement (1) Map Contribution (13) Tournament Contribution (1) General Contribution (10)

Re: WidowMakers XML Tool

Postby MrBenn on Wed Nov 12, 2008 5:52 pm

There's no real reason they can't right now....
Image
PB: 2661 | He's blue... If he were green he would die | No mod would be stupid enough to do that
User avatar
Lieutenant MrBenn
Retired Team Member
 
Posts: 7062
Joined: Wed Nov 21, 2007 9:32 am
Location: Off Duty
Medals: 67
Standard Achievement (3) Doubles Achievement (3) Triples Achievement (2) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (2) Manual Troops Achievement (3) Freestyle Achievement (2) Nuclear Spoils Achievement (2) Fog of War Achievement (3)
Speed Achievement (1) Teammate Achievement (2) Cross-Map Achievement (3) Ratings Achievement (3) Tournament Achievement (2)
General Achievement (6) Clan Achievement (1) Map Contribution (7) Tournament Contribution (2) General Contribution (15)

Re: WidowMakers XML Tool

Postby yeti_c on Thu Nov 13, 2008 1:39 am

MrBenn wrote:There's no real reason they can't right now....


Agreed!

C.
Image
Highest score : 2297
User avatar
Lieutenant yeti_c
 
Posts: 9670
Joined: Thu Jan 04, 2007 9:02 am
Medals: 46
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (3) Terminator Achievement (1)
Assassin Achievement (1) Freestyle Achievement (1) Fog of War Achievement (3) Cross-Map Achievement (3) Ratings Achievement (3)
General Achievement (1) Map Contribution (13) Tournament Contribution (1) General Contribution (10)

Re: WidowMakers XML Tool

Postby WidowMakers on Thu Nov 13, 2008 6:54 am

Updated files in first post.
    -Added New tab in file that groups all XML to one page. (easier to copy into text doc)
    -Zipped the files
    -Added 2 version - Excel 2000 and 2007

WM
Image
Colonel WidowMakers
 
Posts: 2772
Joined: Mon Nov 20, 2006 9:25 am
Location: Detroit, MI
Medals: 71
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (3) Terminator Achievement (1)
Fog of War Achievement (2) Teammate Achievement (1) Random Map Achievement (2) Cross-Map Achievement (3) Ratings Achievement (2)
General Achievement (6) Clan Achievement (10) Map Contribution (21) General Contribution (14)

[Excel] WidowMaker's XML Writer Tool

Postby WidowMakers on Sat Nov 15, 2008 9:42 am

Hello everyone,
With all of the XML I am going to need to write for the USA Map Pack, I made and excel based XML writer. There are instructions on the first tab of the excel file.

Once you use it once it is real easy and it allows a user to setup all of the XML features (most of them) without typing or copying/pasting text.
You only need to enter you territory names once and the rest of the time you select them from the initial list.

Features:
    -Only input territories once and then the rest of the file references that list (no more typos)
    -Select border and bombard territories easily. Each excel cell has a drop down list of every territory (see 1st feature)
    -Set auto-deploy and/or neutral starting values for any territory
    -Name Continents and then select all territories in those continents from drop down lists
    -Set Required and Override requirements for continents (This feature is used when a map has 5 territories and there is a bonus for holding any 3, 4 or all of them)
    -Has 4 output tabs (Title, Continent, Territory and ALL). Just follow instructions and copy desired tab contents into XML text file.

Tool Version 4
Excel 2007
http://www.fileden.com/files/2007/6/15/ ... el2007.zip

Excel 2000
http://www.fileden.com/files/2007/6/15/ ... el2000.zip

I have already made several test XML files and a XML for the USA:West map. They all pass the checker.
Follow the instructions and it works.

Let me know what you think.

WM
Image
Colonel WidowMakers
 
Posts: 2772
Joined: Mon Nov 20, 2006 9:25 am
Location: Detroit, MI
Medals: 71
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (3) Terminator Achievement (1)
Fog of War Achievement (2) Teammate Achievement (1) Random Map Achievement (2) Cross-Map Achievement (3) Ratings Achievement (2)
General Achievement (6) Clan Achievement (10) Map Contribution (21) General Contribution (14)

Re: WidowMaker's XML Tool

Postby Kaplowitz on Sat Nov 15, 2008 11:29 am

:O
You're amazing...

edit: maybe you should put your bonus generator in the same excel file
Image
User avatar
Private 1st Class Kaplowitz
 
Posts: 3088
Joined: Tue May 01, 2007 5:11 pm
Location: Doin' it for da lulz.
Medals: 6
Standard Achievement (2) Doubles Achievement (1) Assassin Achievement (1) Speed Achievement (2)

Re: WidowMaker's XML Tool

Postby WidowMakers on Sat Nov 15, 2008 1:42 pm

Kaplowitz wrote::O
You're amazing...

edit: maybe you should put your bonus generator in the same excel file
Sure I can do that. Plus if people don't want to use it then they can just enter their own bonus numbers
Image
Colonel WidowMakers
 
Posts: 2772
Joined: Mon Nov 20, 2006 9:25 am
Location: Detroit, MI
Medals: 71
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (3) Terminator Achievement (1)
Fog of War Achievement (2) Teammate Achievement (1) Random Map Achievement (2) Cross-Map Achievement (3) Ratings Achievement (2)
General Achievement (6) Clan Achievement (10) Map Contribution (21) General Contribution (14)

Re: WidowMaker's XML Tool

Postby cairnswk on Sat Nov 15, 2008 7:39 pm

I'd give it 9/10 for a first preview. Congrats WM. With some tweaking, i think it will be quite productive to use.
I used it this morning to create the xml file for Ottoman Empire, and it works very well.
I copied the image into the Tert worksheet, and used that to list the terts for easy referencing - i hate switching widows.. I still had to open the tool's xml file into the Java GUI to track the coordinates but this was easy.
I'm not sure if it was any less time consuming than copying and pasting the way i used to do it in a text editor, I seemed to spend a lot of time trolling the picklists.

As suggestion....WM
Can you look at combining the Territory bordering page where you use the picklists to determine the borders (nice use of data vaildation) and the Continent page where you have list the terts in each continent from the picklist. Perhaps a column in front of the tert names column that can be easily copied down to place the continent names in front of the terts. Just seems a double up of having to use the licklist twice.

Nice work and thanks. :)
User avatar
Corporal cairnswk
 
Posts: 11490
Joined: Sat Feb 03, 2007 8:32 pm
Medals: 50
Standard Achievement (2) Doubles Achievement (1) Fog of War Achievement (1) Speed Achievement (1) Teammate Achievement (1)
Cross-Map Achievement (1) Ratings Achievement (3) General Achievement (2) Map Contribution (35) General Contribution (3)

Re: WidowMaker's XML Tool

Postby WidowMakers on Sat Nov 15, 2008 8:56 pm

cairnswk wrote:As suggestion....WM
Can you look at combining the Territory bordering page where you use the picklists to determine the borders (nice use of data vaildation) and the Continent page where you have list the terts in each continent from the picklist. Perhaps a column in front of the tert names column that can be easily copied down to place the continent names in front of the terts. Just seems a double up of having to use the licklist twice.

Nice work and thanks. :)
I don't know if that will work since some territories are in multiple continents, especially for overrides. Or maybe I am just misunderstanding you.

WM
Image
Colonel WidowMakers
 
Posts: 2772
Joined: Mon Nov 20, 2006 9:25 am
Location: Detroit, MI
Medals: 71
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (3) Terminator Achievement (1)
Fog of War Achievement (2) Teammate Achievement (1) Random Map Achievement (2) Cross-Map Achievement (3) Ratings Achievement (2)
General Achievement (6) Clan Achievement (10) Map Contribution (21) General Contribution (14)

Re: WidowMaker's XML Tool

Postby cairnswk on Sat Nov 15, 2008 9:04 pm

WidowMakers wrote:
cairnswk wrote:As suggestion....WM
Can you look at combining the Territory bordering page where you use the picklists to determine the borders (nice use of data vaildation) and the Continent page where you have list the terts in each continent from the picklist. Perhaps a column in front of the tert names column that can be easily copied down to place the continent names in front of the terts. Just seems a double up of having to use the licklist twice.

Nice work and thanks. :)
I don't know if that will work since some territories are in multiple continents, especially for overrides. Or maybe I am just misunderstanding you.

WM

Point taken :)
User avatar
Corporal cairnswk
 
Posts: 11490
Joined: Sat Feb 03, 2007 8:32 pm
Medals: 50
Standard Achievement (2) Doubles Achievement (1) Fog of War Achievement (1) Speed Achievement (1) Teammate Achievement (1)
Cross-Map Achievement (1) Ratings Achievement (3) General Achievement (2) Map Contribution (35) General Contribution (3)

Re: WidowMaker's XML Tool

Postby gimil on Sun Nov 23, 2008 11:21 am

Ok WM added the tool to the map makers tools thread for you :)
What do you know about map making, bitch?

natty_dread wrote:I was wrong


Top Score:2403
User avatar
Corporal 1st Class gimil
 
Posts: 8605
Joined: Sat Mar 03, 2007 12:42 pm
Location: United Kingdom (Scotland)
Medals: 39
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (1) Freestyle Achievement (3) Fog of War Achievement (2) Speed Achievement (3) Teammate Achievement (2)
Cross-Map Achievement (2) Ratings Achievement (2) Map Contribution (7) Tournament Contribution (1) General Contribution (5)

Re: WidowMaker's XML Tool

Postby gimil on Sun Dec 21, 2008 1:58 pm

Small suggestion WM, would it be possible to add a function that allows you to import an XML file into the spreadsheet? Could make editing easier in the long run.
What do you know about map making, bitch?

natty_dread wrote:I was wrong


Top Score:2403
User avatar
Corporal 1st Class gimil
 
Posts: 8605
Joined: Sat Mar 03, 2007 12:42 pm
Location: United Kingdom (Scotland)
Medals: 39
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (2) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (1) Freestyle Achievement (3) Fog of War Achievement (2) Speed Achievement (3) Teammate Achievement (2)
Cross-Map Achievement (2) Ratings Achievement (2) Map Contribution (7) Tournament Contribution (1) General Contribution (5)

Next

Return to Tools & Guides

Who is online

Users browsing this forum: No registered users and 0 guests

Login