Wiki Table Generator (VBScript)

Moderators: Mug UK, Moderator Team

User avatar
Mug UK
Administrator
Administrator
Posts: 11141
Joined: Thu Apr 29, 2004 7:16 pm
Location: Stockport (UK)
Contact:

Wiki Table Generator (VBScript)

Postby Mug UK » Wed Jul 26, 2006 1:54 pm

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.

Added:

. 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.
You do not have the required permissions to view the files attached to this post.
Last edited by Mug UK on Sat Sep 02, 2006 1:20 pm, edited 9 times in total.
My main site: http://www.mug-uk.co.uk - slowly digging up the bits from my past (and re-working a few): Atari ST, Sega 8-bit (game hacks) and NDS (Music ripping guide).

I develop a free Word (for Windows) add-in that's available for Word 2007 upwards. It's a fix-it toolbox that will allow power Word users to fix document errors. You can find it at: http://www.mikestoolbox.co.uk

User avatar
Zorro 2
Administrator
Administrator
Posts: 2184
Joined: Tue May 21, 2002 12:44 pm
Location: Saint Cloud (France)
Contact:

Postby Zorro 2 » Wed Jul 26, 2006 2:38 pm

Thanks a lot mister muguk !
Member of NoExtra Team

User avatar
Mug UK
Administrator
Administrator
Posts: 11141
Joined: Thu Apr 29, 2004 7:16 pm
Location: Stockport (UK)
Contact:

Postby Mug UK » Wed Jul 26, 2006 10:35 pm

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.
My main site: http://www.mug-uk.co.uk - slowly digging up the bits from my past (and re-working a few): Atari ST, Sega 8-bit (game hacks) and NDS (Music ripping guide).

I develop a free Word (for Windows) add-in that's available for Word 2007 upwards. It's a fix-it toolbox that will allow power Word users to fix document errors. You can find it at: http://www.mikestoolbox.co.uk

User avatar
Mug UK
Administrator
Administrator
Posts: 11141
Joined: Thu Apr 29, 2004 7:16 pm
Location: Stockport (UK)
Contact:

Postby Mug UK » Thu Jul 27, 2006 8:19 am

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!
My main site: http://www.mug-uk.co.uk - slowly digging up the bits from my past (and re-working a few): Atari ST, Sega 8-bit (game hacks) and NDS (Music ripping guide).

I develop a free Word (for Windows) add-in that's available for Word 2007 upwards. It's a fix-it toolbox that will allow power Word users to fix document errors. You can find it at: http://www.mikestoolbox.co.uk

User avatar
bodkinz
Moderator
Moderator
Posts: 790
Joined: Fri Jul 02, 2004 8:32 pm
Location: London

Postby bodkinz » Fri Jul 28, 2006 12:04 am

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 :)

:cheers:
someone post something, i'm bored :)

User avatar
Mug UK
Administrator
Administrator
Posts: 11141
Joined: Thu Apr 29, 2004 7:16 pm
Location: Stockport (UK)
Contact:

Postby Mug UK » Fri Jul 28, 2006 11:08 am

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 ;)
My main site: http://www.mug-uk.co.uk - slowly digging up the bits from my past (and re-working a few): Atari ST, Sega 8-bit (game hacks) and NDS (Music ripping guide).

I develop a free Word (for Windows) add-in that's available for Word 2007 upwards. It's a fix-it toolbox that will allow power Word users to fix document errors. You can find it at: http://www.mikestoolbox.co.uk

User avatar
Mug UK
Administrator
Administrator
Posts: 11141
Joined: Thu Apr 29, 2004 7:16 pm
Location: Stockport (UK)
Contact:

Postby Mug UK » Mon Jul 31, 2006 2:04 pm

Fixed the problems with v0.7. Read the first post for all the extra whizz-bang (hardly!) options I've added.
My main site: http://www.mug-uk.co.uk - slowly digging up the bits from my past (and re-working a few): Atari ST, Sega 8-bit (game hacks) and NDS (Music ripping guide).

I develop a free Word (for Windows) add-in that's available for Word 2007 upwards. It's a fix-it toolbox that will allow power Word users to fix document errors. You can find it at: http://www.mikestoolbox.co.uk

User avatar
Mug UK
Administrator
Administrator
Posts: 11141
Joined: Thu Apr 29, 2004 7:16 pm
Location: Stockport (UK)
Contact:

Postby Mug UK » Wed Aug 02, 2006 12:20 pm

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.
My main site: http://www.mug-uk.co.uk - slowly digging up the bits from my past (and re-working a few): Atari ST, Sega 8-bit (game hacks) and NDS (Music ripping guide).

I develop a free Word (for Windows) add-in that's available for Word 2007 upwards. It's a fix-it toolbox that will allow power Word users to fix document errors. You can find it at: http://www.mikestoolbox.co.uk

User avatar
bodkinz
Moderator
Moderator
Posts: 790
Joined: Fri Jul 02, 2004 8:32 pm
Location: London

Postby bodkinz » Sun Aug 27, 2006 10:50 pm

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 :)
:cheers:
someone post something, i'm bored :)

User avatar
Mug UK
Administrator
Administrator
Posts: 11141
Joined: Thu Apr 29, 2004 7:16 pm
Location: Stockport (UK)
Contact:

Postby Mug UK » Mon Aug 28, 2006 9:32 am

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.
My main site: http://www.mug-uk.co.uk - slowly digging up the bits from my past (and re-working a few): Atari ST, Sega 8-bit (game hacks) and NDS (Music ripping guide).

I develop a free Word (for Windows) add-in that's available for Word 2007 upwards. It's a fix-it toolbox that will allow power Word users to fix document errors. You can find it at: http://www.mikestoolbox.co.uk

User avatar
Mug UK
Administrator
Administrator
Posts: 11141
Joined: Thu Apr 29, 2004 7:16 pm
Location: Stockport (UK)
Contact:

Postby Mug UK » Tue Sep 05, 2006 11:33 pm

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.?
My main site: http://www.mug-uk.co.uk - slowly digging up the bits from my past (and re-working a few): Atari ST, Sega 8-bit (game hacks) and NDS (Music ripping guide).

I develop a free Word (for Windows) add-in that's available for Word 2007 upwards. It's a fix-it toolbox that will allow power Word users to fix document errors. You can find it at: http://www.mikestoolbox.co.uk

User avatar
bodkinz
Moderator
Moderator
Posts: 790
Joined: Fri Jul 02, 2004 8:32 pm
Location: London

Postby bodkinz » Wed Sep 06, 2006 10:59 pm

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 :)
someone post something, i'm bored :)

User avatar
Mug UK
Administrator
Administrator
Posts: 11141
Joined: Thu Apr 29, 2004 7:16 pm
Location: Stockport (UK)
Contact:

Postby Mug UK » Thu Sep 07, 2006 10:55 am

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.
My main site: http://www.mug-uk.co.uk - slowly digging up the bits from my past (and re-working a few): Atari ST, Sega 8-bit (game hacks) and NDS (Music ripping guide).

I develop a free Word (for Windows) add-in that's available for Word 2007 upwards. It's a fix-it toolbox that will allow power Word users to fix document errors. You can find it at: http://www.mikestoolbox.co.uk

User avatar
bodkinz
Moderator
Moderator
Posts: 790
Joined: Fri Jul 02, 2004 8:32 pm
Location: London

Postby bodkinz » Thu Sep 07, 2006 10:29 pm

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 :)
someone post something, i'm bored :)

User avatar
Mug UK
Administrator
Administrator
Posts: 11141
Joined: Thu Apr 29, 2004 7:16 pm
Location: Stockport (UK)
Contact:

Postby Mug UK » Fri Sep 08, 2006 7:20 am

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 :)
My main site: http://www.mug-uk.co.uk - slowly digging up the bits from my past (and re-working a few): Atari ST, Sega 8-bit (game hacks) and NDS (Music ripping guide).

I develop a free Word (for Windows) add-in that's available for Word 2007 upwards. It's a fix-it toolbox that will allow power Word users to fix document errors. You can find it at: http://www.mikestoolbox.co.uk

User avatar
RetroGamerUK
RetroLamerUK
RetroLamerUK
Posts: 2918
Joined: Fri Mar 26, 2004 6:37 pm
Location: Northwest England.

Postby RetroGamerUK » Fri Sep 08, 2006 5:19 pm

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.. :)


Social Media

     

Return to “Wiki Tools”

Who is online

Users browsing this forum: No registered users and 3 guests