[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.

Re: WidowMaker's XML Tool

Postby WidowMakers on Sun Dec 21, 2008 2:25 pm

gimil wrote: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.
I think that is a great idea. Unfortunately I have no idea how to do that or that it could even be done with how I setup the file. Sorry.

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 gimil on Sun Dec 21, 2008 4:08 pm

WidowMakers wrote:
gimil wrote: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.
I think that is a great idea. Unfortunately I have no idea how to do that or that it could even be done with how I setup the file. Sorry.

WM


I wouldn't of though it was possible, but thought it was worth mentioning.
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 yeti_c on Mon Dec 22, 2008 2:54 am

It would be possible...

You'd need to code some VBA stuff though...

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: WidowMaker's XML Tool

Postby cairnswk on Mon Dec 22, 2008 6:07 am

yeti_c wrote:It would be possible...

You'd need to code some VBA stuff though...

C.


but gees, it would need a hell of a lot of code to import it back into the format that WM's s/sheet is in :?:
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 yeti_c on Mon Dec 22, 2008 6:34 am

cairnswk wrote:
yeti_c wrote:It would be possible...

You'd need to code some VBA stuff though...

C.


but gees, it would need a hell of a lot of code to import it back into the format that WM's s/sheet is in :?:


Yep!!!

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: WidowMaker's XML Tool

Postby WidowMakers on Mon Dec 22, 2008 9:27 am

cairnswk wrote:
yeti_c wrote:It would be possible...

You'd need to code some VBA stuff though...

C.


but gees, it would need a hell of a lot of code to import it back into the format that WM's s/sheet is in :?:
Exactly. The point of the tool was not to fix existing code but to make entirely new code for an new map. If someone is doing a revamp and they change a couple names or something then this toll is completely worthless to them.

If yeti wants to code the VB for it I will gladly let him but I still think it is not needed.

Plus the real reason I made this is that I HATE to type (as may of you can see from my posts) so allowing the territories to be entered once and then selected from drop down lists is great for me. The biggest help the tool has for me was that I did not have to deal with formatting issues. If the steps are followed the XML will not have any errors when the final code is copied into the text document and the XML is made.

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 e_i_pi on Wed Dec 31, 2008 12:22 am

yeti_c wrote:
cairnswk wrote:
yeti_c wrote:It would be possible...

You'd need to code some VBA stuff though...

C.


but gees, it would need a hell of a lot of code to import it back into the format that WM's s/sheet is in :?:


Yep!!!

C.

Did I mention I'm an Excel VBA programmer?
User avatar
Captain e_i_pi
 
Posts: 1770
Joined: Tue Feb 12, 2008 2:19 pm
Location: Corruption Capital of the world
Medals: 36
Standard Achievement (2) Doubles Achievement (3) Triples Achievement (3) Quadruples Achievement (3) Terminator Achievement (2)
Assassin Achievement (1) Freestyle Achievement (2) Fog of War Achievement (3) Speed Achievement (1) Cross-Map Achievement (3)
Ratings Achievement (3) Tournament Achievement (5) Clan Achievement (3) General Contribution (2)

Re: WidowMaker's XML Tool

Postby cairnswk on Wed Dec 31, 2008 3:31 am

e_i_pi wrote:....
Did I mention I'm an Excel VBA programmer?

e_i_pi...i've done some excel work also.
I hate the use of the drop downs pick lists that you have to go through with WM's tool, (sorry WM no offense for the great work you've done)
Is it possible to place thij whole continent/territory thing in to a set of formulas that would simply propogate out if you had two columns: first one for continent, next for territory (thrrough the use of concatenation and formulas.
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 Wed Dec 31, 2008 9:50 am

cairnswk wrote:
e_i_pi wrote:....
Did I mention I'm an Excel VBA programmer?

e_i_pi...i've done some excel work also.
I hate the use of the drop downs pick lists that you have to go through with WM's tool, (sorry WM no offense for the great work you've done)
Is it possible to place thij whole continent/territory thing in to a set of formulas that would simply propogate out if you had two columns: first one for continent, next for territory (thrrough the use of concatenation and formulas.
That still will not work Cairns. Some territories belong to multiple continents. The way I set it up was to allow each continent the possibility of having multiple territories. You are simple asking to have both pages into 1 and that would just make them even more HUGE than they are now. Plus each territory borders others right. If you wanted a Territory / continent list, you would still need to make sure that there was a bordering/bombardment list too. Plus if there was a territory that belonged to two continents then you would need to make space for that as well. Plus with override bonuses, you would need to have the excel program automatically understand what those are and auto generate the code. Right now it is all there just waiting to be turned on. Plus, the drop down list allows a person to never need to type after the initial territory is placed in the list. Of course a user can always type everything in as well.

All I know is that it saved me TONS of time with MU USA maps. I think I only had 6 errors (and 4 or them were coordinate based so they don't count) over all 6 maps after the first XML version. I think I spent around 2 hours total (maybe) doing all of the initial XML for all 6 maps.

And no offense taken cairns. Just to let you know this was the 4th version I actually made. The first was actually quite similar to your suggestion (not 100% but similar) and I found that there were issues in layout and it was easier to make it this way.

So feel free to rip it apart and do anything you want. It is not really editable from a layout perspective so any changes might really screw it up.

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 ZeakCytho on Wed Dec 31, 2008 10:00 am

e_i_pi wrote:
yeti_c wrote:
cairnswk wrote:
yeti_c wrote:It would be possible...

You'd need to code some VBA stuff though...

C.


but gees, it would need a hell of a lot of code to import it back into the format that WM's s/sheet is in :?:


Yep!!!

C.

Did I mention I'm an Excel VBA programmer?


Is there nothing you can't do?
User avatar
Captain ZeakCytho
 
Posts: 1251
Joined: Wed Sep 12, 2007 4:36 pm
Medals: 18
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (1) Quadruples Achievement (2) Fog of War Achievement (1)
Speed Achievement (1) Cross-Map Achievement (3) Ratings Achievement (3) Map Contribution (2) General Contribution (1)

Re: WidowMaker's XML Tool

Postby UnicornCan115 on Mon Aug 01, 2011 10:29 pm

Could you make a 2003 version, please?
Cook UnicornCan115
 
Posts: 15
Joined: Sat Jul 09, 2011 10:52 am

Re: WidowMaker's XML Tool

Postby natty dread on Tue Aug 02, 2011 4:15 am

WM is no longer active on the site. You could always use Mapmaker's friend.
Image
User avatar
Sergeant 1st Class natty dread
 
Posts: 13257
Joined: Fri Feb 08, 2008 8:58 pm
Location: fucked off
Medals: 49
Standard Achievement (2) Doubles Achievement (2) Triples Achievement (1) Quadruples Achievement (1) Terminator Achievement (2)
Manual Troops Achievement (1) Nuclear Spoils Achievement (1) Fog of War Achievement (1) Teammate Achievement (1) Cross-Map Achievement (3)
Ratings Achievement (3) General Achievement (12) Map Contribution (12) General Contribution (7)

Re: WidowMaker's XML Tool

Postby thenobodies80 on Thu Aug 11, 2011 12:28 pm

natty_dread wrote:WM is no longer active on the site. You could always use Mapmaker's friend.


The mapmaker's friend has a different purpose. The WM's excel spreadsheet in this topic can be use to create the whole xml file and not to help the mapmaker to calculate the bonuses. That is a different WM's spreadsheet. ;)

Give every man your ear, but few thy voice. Take each man's censure, but reserve thy judgment.
show
User avatar
Corporal 1st Class thenobodies80
Foundry Foreman
Foundry Foreman
 
Posts: 5640
Joined: Wed Sep 05, 2007 4:30 am
Medals: 70
Standard Achievement (3) Doubles Achievement (2) Triples Achievement (1) Quadruples Achievement (2) Terminator Achievement (2)
Assassin Achievement (2) Manual Troops Achievement (2) Freestyle Achievement (2) Nuclear Spoils Achievement (2) Fog of War Achievement (3)
Speed Achievement (2) Teammate Achievement (1) Cross-Map Achievement (3) Bot Achievement (1) Ratings Achievement (4)
General Achievement (8) Map Contribution (7) Tournament Contribution (6) General Contribution (17)

Re: [Excel] WidowMakers XML Writer Tool

Postby ender516 on Sun Aug 14, 2011 10:12 pm

People trying to generate entirely new XML files may find chipv's Map XML Wizard useful. The forum topic for it is here: viewtopic.php?f=648&t=105494
User avatar
Sergeant 1st Class ender516
Tech Contributor
Tech Contributor
 
Posts: 4451
Joined: Wed Dec 17, 2008 6:07 pm
Location: Waterloo, Ontario
Medals: 37
Standard Achievement (2) Doubles Achievement (1) Triples Achievement (1) Quadruples Achievement (1) Freestyle Achievement (1)
Fog of War Achievement (1) Teammate Achievement (1) Cross-Map Achievement (1) Ratings Achievement (3) General Achievement (9)
Map Contribution (5) General Contribution (11)

Previous

Return to Tools & Guides

Who is online

Users browsing this forum: No registered users and 0 guests

Login