Page 1 of 1

Wiki Table Generator (VBScript)

Posted: Wed Jul 26, 2006 1:54 pm
by Mug UK
OK, it's not great and it doesn't (yet!) do the styles at the top to change the colour and name the cells etc.

But it will generate a table of rows & columns that you specify. It also allows you to enter text for each column (or they're self-generated if you're not sure). Random colour styles are applied to each cell header too.

I coded it in VBScript for ease of use - so don't expect a super-GUI based product!

There are probably more than a few bugs in it .. if so, let me know here.


. Ability to start the cell numbering from any number, not just 1.
. Built in auto-text options so if you're doing a lot of level codes, you only have to enter "L" & "P" for the cell-text and it changes them to "Level" and "Password/Code".
. As above, but also present are "D- Disk #", "C- Contents", "R-Result" & "E - Effects"

Input for effects above can now be in lower or upper-case - I was being lazy in v0.6!

Unless some major bugs are found, I'm happy with this one as being the final one. Any other additions, then let me know below.

Current version = v0.8 - now has the proper line formatting inside.

Posted: Wed Jul 26, 2006 2:38 pm
by Zorro 2
Thanks a lot mister muguk !

Posted: Wed Jul 26, 2006 10:35 pm
by Mug UK
Having just used it to create a table of 125 rows x 2 columns for all The Source disks, it works quite well - even if I do say so myself :)

Probably does need an option to include a numbering scheme in the output to save you having to put 001, 002, 003 etc. into the table afterwards.

Posted: Thu Jul 27, 2006 8:19 am
by Mug UK
Auto-numbering scheme now present. Example output from v0.5:

Code: Select all

{| border="1" class="wikitable" style="text-align:left"
|+ Crackers plc
! style="background:#96ffef;" | Disk
! style="background:#87ffef;" | Contents
| 1 ||  |
| 2 ||  |
| 3 ||  |
| 4 ||  |
| 5 ||  |
| 6 ||  |
| 7 ||  |
| 8 ||  |
| 9 ||  |
| 10 ||  |
| 11 ||  |
| 12 ||  |
| 13 ||  |
| 14 ||  |
| 15 ||  |
| 16 ||  |
| 17 ||  |
| 18 ||  |
| 19 ||  |
| 20 ||  |

Have fun!

Posted: Fri Jul 28, 2006 12:04 am
by bodkinz
Thanks muchly.. hmmm i was in your vicinity back in the late 90's Ruislip was only 3 miles from me..

anyway.. thanks again for the util :)


Posted: Fri Jul 28, 2006 11:08 am
by Mug UK
Having a headache over v0.7 .. so will chew on it over the weekend.

What I'm trying to do is give an option to start the numbering later on (i.e. still have 10 rows, but start the numbering at 3 instead of 1 so you get 3 to 13 in the output) .. but it keeps going wrong somewhere in my code.

Was in South Ruislip from mid'97 to about summer-ish '98. Training games to work under PacifiST (using TOSBox to do the disassembly etc.) for the Regression Therapy Menus 1-3 ;)

Posted: Mon Jul 31, 2006 2:04 pm
by Mug UK
Fixed the problems with v0.7. Read the first post for all the extra whizz-bang (hardly!) options I've added.

Posted: Wed Aug 02, 2006 12:20 pm
by Mug UK
My brother is a bit of a Wiki expert as he helped create some auto-generating code for the GamerWiki to generate standard pages etc.

He's also pointed out that I'm not generating the tables correctly so I think I'll be doing a bit more research and add a few more options at the same time as fixing the problematic code. So expect a v0.8 soon :)

I've also created 2 x more Sticky's which have CSV 2 Wiki and a HTML table to Wiki code generators. Hope these two pages will help you all out.

Posted: Sun Aug 27, 2006 10:50 pm
by bodkinz
MUG you got v0.8 of the wiki table generator? :)

you mention a version 0.8 but i dont see it anywhere?

thanks in advance :)

Posted: Mon Aug 28, 2006 9:32 am
by Mug UK
Oops :oops: I thought I'd uploaded it after fixing those bugs in the output.

Will get it done a.s.a.p. Bodkinz. My apologies.

Posted: Tue Sep 05, 2006 11:33 pm
by Mug UK
Found a bug or two in 0.8 - one related to the last line not needing the extra '|-' but also one which is introduced if you *don't* want line numbers. So looks like a 0.9 will be available soon.

Also forgot to change the title in 0.8 to say it was 0.8 - it still says 0.7 :oops:

Any one think of anything else to add to make it a final preview before I try and make it into a "proper" windows apps with form etc.?

Posted: Wed Sep 06, 2006 10:59 pm
by bodkinz
Maybe this is asking too much.. but... how about after the numbering bit.. can it ask which if any need A,B,C added to them? i'm not explaining this too well.. but i think you know what i mean.. menus that are more than one disk.. etc etc..

like.. maybe enter a string 35AB 56ABC 96ABCDE etc etc

that would be a great help...

sorry if that is a bit complicated.. sounds like a lot of extra code..

anyway.. just a suggestion :)

Posted: Thu Sep 07, 2006 10:55 am
by Mug UK
The only problem with me doing that is that I use a loop to generate all the required rows.

The only way I could do it would be to generate an "xxA", "xxB" etc. for *every* single row and then you delete the ones you don't need.

This would work for a group which has a lot of multi-disk releases but not for those with only the one or two multi-disk releases.

It might be easier for you to generate extra rows and then just change the numbers afterwards - e.g. Group ZZZ has 30 releases of which 6 are mutliple-disks. So generate 37 rows but rename 31-37 to xxB and then cut & paste them into the proper place in the list.

Sorry that's not much of a help but it's just the way the code is written at present.

Posted: Thu Sep 07, 2006 10:29 pm
by bodkinz
No problems :) I thought i might be asking a bit too much with that.. doing it manually isn't a problem.. i guess my unhealthy interest in computers since 1980 has helped.. fast two fingered typist :)

Posted: Fri Sep 08, 2006 7:20 am
by Mug UK
Ah .. I taught myself my own method on an electric typewriter before I was 10 :oops:

Been using the same method ever since and keeps me up @ the 80 wpm mark 26 years later :)

Posted: Fri Sep 08, 2006 5:19 pm
by RetroGamerUK
muguk wrote:Been using the same method ever since and keeps me up @ the 80 wpm mark 26 years later :)

I think you are being a bit Modest there Mein √úberplakat.. :)