RPTools.net

Discussion and Support

Skip to content

It is currently Tue Apr 25, 2017 3:43 am 




Forum rules


PLEASE don't post images of your entire desktop, attach entire campaign files when only a single file is needed, or generally act in some other anti-social behavior. :)



Reply to topic  [ 28 posts ]  Go to page Previous  1, 2

Previous topic | Next topic 

  Print view

Author Message
User avatar  Offline
Deity
 
Joined: Fri Mar 20, 2009 4:40 am
Posts: 9189
Location: Netherlands
 Post subject: Re: Table Editor Tool (Excel) Update: Image Support
PostPosted: Thu Apr 19, 2012 5:02 am 
neofax wrote:
Just ran into a problem. Excel and LibreOffice CALC can only hold so many characters in a cell. The workaround is to unhide the columns and manually copy and paste the information into a text editor like notepad++ to make the context.xml.


I've added an extra entry in the xls tool to handle this issue.

_________________
GETTING STARTED WITH MAPTOOLS - TUTORIALS, DOCS, VIDEOS, TOOLS, ETC

My stuff
Excel Tools: Table and Light editors
MT Tools: Bag of Tricks: Tools for Maptool, Dungeon Builder I, Dungeon Builder II and onMouseOverEvent
Frameworks: Dark Heresy, Rogue Trader, Deathwatch, Black Crusade, Only War, SET Card Game, RoboRally
Wiki: Debugging Tutorial, Speed Up Your Macros, Working With Two CODE Levels, Shortcut Keys, Avoiding Stack Overflow, READ THIS


Top
 Profile  
 
 Offline
Kobold
 
Joined: Tue Mar 06, 2012 3:56 pm
Posts: 10
Location: Paris, France
 Post subject: Re: Table Editor Tool (Excel) Update: Image Support
PostPosted: Sat May 19, 2012 2:34 am 
Hi, I've run into a small issue that should perhaps be documented somewhere. I am using LibreOffice on macOS and I'm going through the job of modifying the tables using eclipse more than the calc sheet (it works pretty well) though creating them with the calculus sheet. Nevertheless, at the beginning I used macOS archive utility in order to zip and unzip and this is not working. Extension can be zip but there is something different wrt their compression algorithm. It works if you use the zip command in a terminal. Thus you should perhaps put this information in your doc (the excel file itself?)
Hope it helps


Top
 Profile  
 
User avatar  Offline
Deity
 
Joined: Fri Mar 20, 2009 4:40 am
Posts: 9189
Location: Netherlands
 Post subject: Re: Table Editor Tool (Excel) Update: Image Support
PostPosted: Sat May 19, 2012 3:26 am 
Thanks for the feedback

So the archive utility on your mac cannot properly handle the MT zip files?
It would be nice if an other mac user can confirm this (to make sure it's not an isolated issue) I know that Azhrei has a mac and Ive never heard anything about this.

If its confirmed I'll add it to the doc.

_________________
GETTING STARTED WITH MAPTOOLS - TUTORIALS, DOCS, VIDEOS, TOOLS, ETC

My stuff
Excel Tools: Table and Light editors
MT Tools: Bag of Tricks: Tools for Maptool, Dungeon Builder I, Dungeon Builder II and onMouseOverEvent
Frameworks: Dark Heresy, Rogue Trader, Deathwatch, Black Crusade, Only War, SET Card Game, RoboRally
Wiki: Debugging Tutorial, Speed Up Your Macros, Working With Two CODE Levels, Shortcut Keys, Avoiding Stack Overflow, READ THIS


Top
 Profile  
 
User avatar  Offline
Demigod
 
Joined: Mon Jun 29, 2009 9:37 am
Posts: 3108
Location: Germany
 Post subject: Re: Table Editor Tool (Excel) Update: Image Support
PostPosted: Sat May 19, 2012 9:23 am 
Kind of confirmed. I just did one test.

Code:
I ...
- made a copy of a working campaign file
- changed file extension to zip.
- decompressed it using mac os decompress tool (I just doubleclicked it)
  I am using Lion in case that matters.
- deleted the original renamed file.
- compressed the unpacked stuff
- renamed it again to cmpgn (tricky, once MacOS knew what file type this was it kept it as a zip file - had to use the information dialog instead of the simple rename function)
- tried to open it in MT b87, it failed telling me "java.io.IOException: Stream closed"

_________________
HELP: GETTING STARTED WITH MAPTOOLS - TUTORIALS, DOCS, VIDEOS, TOOLS, ETC.

most complete list of my maptool stuff


Top
 Profile  
 
User avatar  Offline
Deity
 
Joined: Fri Mar 20, 2009 4:40 am
Posts: 9189
Location: Netherlands
 Post subject: Re: Table Editor Tool (Excel) Update: Image Support
PostPosted: Sat May 19, 2012 10:56 am 
thanks! I guess thats enough for an update in the xls. Im still curious to Azh's reply to this. Ill pm him.

_________________
GETTING STARTED WITH MAPTOOLS - TUTORIALS, DOCS, VIDEOS, TOOLS, ETC

My stuff
Excel Tools: Table and Light editors
MT Tools: Bag of Tricks: Tools for Maptool, Dungeon Builder I, Dungeon Builder II and onMouseOverEvent
Frameworks: Dark Heresy, Rogue Trader, Deathwatch, Black Crusade, Only War, SET Card Game, RoboRally
Wiki: Debugging Tutorial, Speed Up Your Macros, Working With Two CODE Levels, Shortcut Keys, Avoiding Stack Overflow, READ THIS


Top
 Profile  
 
 Offline
Kobold
 
Joined: Tue Mar 06, 2012 3:56 pm
Posts: 10
Location: Paris, France
 Post subject: Re: Table Editor Tool (Excel) Update: Image Support
PostPosted: Sat May 19, 2012 11:21 am 
I think that at some point I will take some minutes to analyse differences between archive utility and zip. As soon as it's done, I'll post the message.


Top
 Profile  
 
 Offline
Kobold
 
Joined: Tue Mar 06, 2012 3:56 pm
Posts: 10
Location: Paris, France
 Post subject: Re: Table Editor Tool (Excel) Update: Image Support
PostPosted: Sat May 19, 2012 12:00 pm 
ok I did search a little the web. I think I've an explanation. If you consider the Archive utility, it has preferences and one concern archive format with three choices (in french :) ):
- archive compressé : means compressed archive
- archive standard : means standard archive whatever the actual meaning
- archive dans un fichier zip : zipfile archive
default is the first one and is probably not consistent wrt zip classical format.

I'm working on scripts to automate transformations thus won't have time to test my assumption.
Sorry


Top
 Profile  
 
 Offline
Kobold
 
Joined: Tue Mar 06, 2012 3:56 pm
Posts: 10
Location: Paris, France
 Post subject: Re: Table Editor Tool (Excel) Update: Image Support
PostPosted: Sun May 20, 2012 3:59 am 
Good morning

I worked a little and I think the solution is linked not to compression but to how archive utility is sorting thing in the archive. In fact, structure of the archive should be two files and a folder. When using archive utility you begin by creating a first folder in which these three files will be written. Here follows the small script I am using to transform a directory including only folders with these files into mttable. BTW I am pretty sure it works the same for every maptool exported file.
Code:
#!/bin/tcsh -f
# shell de transformation de tables en format dézippés vers des tables en format
# mttable. Tout les répertoires sont effacés après l'opération ne laissant que
# des fichiers mttable
#
# TODO :
#  - utiliser un argument pour préciser le répertoire que l'on utilise
#
# creation : Bruno Patin
# date de creation : 19/05/2012
#   structure de compression incorrecte.
# modification : 20/05/2012

echo "La commande ne fonctionne que dans le repertoire ou se"
echo "trouvent les tables a transformer. le repertoire actuel est"
echo `pwd`
echo "si vous n'etes pas sur de votre fait, arretez tout de suite"
echo "continuez (oui/non)"
set reponse = $<
if ( $reponse != oui ) then
   echo "arret du script"
endif

# verification d'absence de fichiers (ne fonctionne que sur des fichiers
# sans caractères indus (blanc, tab ou autres)
foreach i (`ls`)
   echo $i
   if (-f $i) then
      echo "pb"
      exit 1
   endif
end
echo "fin de vérification 1"

# transformation après vérification du contenu et suppression des répertoires ne
# répondant pas aux conditions
foreach i (`ls`)
   echo $i
   if (!(-f $i/content.xml) || !(-f $i/properties.xml)) then
      echo "pb dans "$i
   else
      cd $i
      /usr/bin/zip -r ../$i.mttable ./content.xml ./properties.xml ./assets
      cd ..
   endif
   /bin/rm -r $i
end


hope it helps


Top
 Profile  
 
 Offline
Dragon
 
Joined: Sun Sep 04, 2011 6:01 am
Posts: 260
 Post subject: Re: Table Editor Tool (Excel) Update: Image Support
PostPosted: Sun May 20, 2012 12:20 pm 
Since I don't have a MAC, this is what I guess is happening: The first option creates a tar/gzip, which creates (a) one big archive and then (b) compresses it. "zip", the third option, does it the other way around (b) and then (a). There are advantages and disadvantages to both ways. Neither usually gets the best compression rates, by the way. Only the second option is internal to Maptool (actually Java), while comprehending the second format necessitates a library to be added - which is not going to happen for 1.3b<anything>. It is unfortunate that the MAC uses the first option as default. (Half a decade ago, I would have said that it is unfortunate that Java went for the second option...)


Top
 Profile  
 
User avatar  Offline
Deity
 
Joined: Fri Mar 20, 2009 4:40 am
Posts: 9189
Location: Netherlands
 Post subject: Re: Table Editor Tool (Excel) Update: Image Support
PostPosted: Sun May 20, 2012 1:11 pm 
Thank you all for the feedback. I'll update the xls when time permits.

_________________
GETTING STARTED WITH MAPTOOLS - TUTORIALS, DOCS, VIDEOS, TOOLS, ETC

My stuff
Excel Tools: Table and Light editors
MT Tools: Bag of Tricks: Tools for Maptool, Dungeon Builder I, Dungeon Builder II and onMouseOverEvent
Frameworks: Dark Heresy, Rogue Trader, Deathwatch, Black Crusade, Only War, SET Card Game, RoboRally
Wiki: Debugging Tutorial, Speed Up Your Macros, Working With Two CODE Levels, Shortcut Keys, Avoiding Stack Overflow, READ THIS


Top
 Profile  
 
 Offline
Kobold
 
Joined: Fri Oct 16, 2015 12:45 pm
Posts: 4
 Post subject: Re: Table Editor Tool (Excel) Update: Image Support
PostPosted: Tue Apr 11, 2017 3:08 am 
The dropbox links to the files required for creating import files including support for images don't seem to work anymore? I just get 404 errors. Are the files hosted somewhere else now?


Top
 Profile  
 
User avatar  Offline
Deity
 
Joined: Fri Mar 20, 2009 4:40 am
Posts: 9189
Location: Netherlands
 Post subject: Re: Table Editor Tool (Excel) Update: Image Support
PostPosted: Tue Apr 11, 2017 3:26 am 
dropbox has been so nice as to break all public links on the entire internet. Chaos ensues...

links have been fixed.

_________________
GETTING STARTED WITH MAPTOOLS - TUTORIALS, DOCS, VIDEOS, TOOLS, ETC

My stuff
Excel Tools: Table and Light editors
MT Tools: Bag of Tricks: Tools for Maptool, Dungeon Builder I, Dungeon Builder II and onMouseOverEvent
Frameworks: Dark Heresy, Rogue Trader, Deathwatch, Black Crusade, Only War, SET Card Game, RoboRally
Wiki: Debugging Tutorial, Speed Up Your Macros, Working With Two CODE Levels, Shortcut Keys, Avoiding Stack Overflow, READ THIS


Top
 Profile  
 
 Offline
Kobold
 
Joined: Fri Oct 16, 2015 12:45 pm
Posts: 4
 Post subject: Re: Table Editor Tool (Excel) Update: Image Support
PostPosted: Tue Apr 11, 2017 7:56 am 
Thanks for the quick action and reply! :)

Now to figure out how to get around the zipping issue on my aging Mac. :)


Top
 Profile  
 
Display posts from previous:  Sort by  
Reply to topic  [ 28 posts ]  Go to page Previous  1, 2

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:

Who is online

In total there is 1 user online :: 0 registered, 0 hidden and 1 guest (based on users active over the past 5 minutes)
Most users ever online was 243 on Sun Nov 04, 2012 6:14 am

Users browsing this forum: No registered users and 1 guest





Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

Style based on Andreas08 by Andreas Viklund

Style by Elizabeth Shulman