• Please note: In an effort to ensure that all of our users feel welcome on our forums, we’ve updated our forum rules. You can review the updated rules here: http://forums.wolflair.com/showthread.php?t=5528.

    If a fellow Community member is not following the forum rules, please report the post by clicking the Report button (the red yield sign on the left) located on every post. This will notify the moderators directly. If you have any questions about these new rules, please contact support@wolflair.com.

    - The Lone Wolf Development Team

RealmWorks CSV Import Tool

Version 1.11 has just been released.

If you have a directory full of HeroLab portfolios for all your favourite NPCs, then you can now load those portfolios as part of the CSV import.

The version extends the functionality of version 1.10 so that you can load data from individual files for any of the following field types: Portfolio, Statblock, Rich_Text, PDF, Audio, Video, HTML, Foreign.

(Only Portfolio has been specifically tested, but it should work for any of the other snippet types too.)

The Portfolio snippet should be a file with the .por extension.
Statblock snippets should be a file with the .rtf extension.
 
Sorry for getting back on this so late. Good thing (maybe) that Bishop had a similar problem. Nice work resolving it!

I downloaded the newest version and went to load my CSV file. It only shows one line from the CSV.

After messing around with the file for some time I think it has to do with the last column having " in it (long text description field). I added a new blank column to the end of the file and that seems to fix the import (all lines are showing up).
 
Guyanthalas said:
After messing around with the file for some time I think it has to do with the last column having " in it (long text description field).
Click to expand...

There was a bug in the CSV reader which didn't handle " at the end of a line properly.
 
Last edited:
V1.12 has just been uploaded, and it fixes a bug where " at the end of a line was not being handled properly.
 
Version 1.14 has just been released which will convert URLs within a body of text into a clickable link within Realm Works.

The link detection might not be perfect, due to me having to find a suitable "regular expression" which satifies most possible combinations of URL patterns.

(DickNervous, this doesn't affect your request, which I'll look at another day.)
 
Version 1.16 has just been released to satisfy DickNervous's request (I used your example URL for testing).

When importing images, it is now possible to specify a web URL for the location of the image as an alternative to specifying a local file.

Note that the web URL must point directly at the image to be loaded (in techno-babble the http type must be "image/<something>").

Since web URL image fetching can be slow, the GENERATE button will now be disabled while the file generation is taking place. Once file generation is complete (or fails), the GENERATE button will return to being enabled.
 
Thanks Farling!

When I do the import it puts the live URL into the field in RW and I just click on it and the browser opens up with the image. I was hoping that it would put the actual image in there, but I am assuming that the issue is that the URL is to an API that generates the image, not an actual image file.

The only drawback to it working like this is that it would require an active Internet connection to work, which 99% of the time isn't an issue at all. So don't go crazy trying to figure it out.
 
DickNervous said:
When I do the import it puts the live URL into the field in RW and I just click on it and the browser opens up with the image. I was hoping that it would put the actual image in there, but I am assuming that the issue is that the URL is to an API that generates the image, not an actual image file.

The only drawback to it working like this is that it would require an active Internet connection to work, which 99% of the time isn't an issue at all. So don't go crazy trying to figure it out.
Click to expand...

Drop the column name onto the portrait/picture icon in the topic view, don't drop it into a normal text box. The tool will then fetch the image from the URL during the conversion process. (see attached picture)
 

Attachments

  • drop-picture.png
    drop-picture.png
    37.1 KB · Views: 8
Farling said:
Drop the column name onto the portrait/picture icon in the topic view, don't drop it into a normal text box. The tool will then fetch the image from the URL during the conversion process. (see attached picture)
Click to expand...

That is part of what I was doing wrong, but didn't solve the issue.

When I do the generate it tells me that the file was not found at the URL (because there is no actual file to find) and the URL is in the annotation. However, when I put the URL directly into RW by clicking the Folder Icon and entering it into the file box, it works.

For example, if I put this url, http://travellermap.com/api/jumpmap?sector=Troj&hex=3003&style=print&jump=1, as the file name I get the attached image.

I think the issue is that you are checking for a file, and when it doesn't exist, it puts the path (in this case the URL) in the annotation and nothing is put in the field for the actual file name. I assume that if the file doesn't exist the import into RW will fail, so it makes sense to do that check. However, in this particular case there is no file to find. Is there any way you can make that checking for the file something you can turn on or off? Like an INI file setting or something?

Thanks again for all your work on this awesome tool! Even if this one thing never works, it will save me HUGE amounts of time and effort getting data into RW. :)
 

Attachments

  • RW Map Example.JPG
    RW Map Example.JPG
    32.5 KB · Views: 5
DickNervous said:
For example, if I put this url, http://travellermap.com/api/jumpmap?sector=Troj&hex=3003&style=print&jump=1, as the file name I get the attached image.
Click to expand...

Unfortunately the above link provides a full HTML page, not just an image, so it isn't a trivial task to parse the HTML returned by the web site in order to find the image link within it.

It is returning a page that says that the URL has been relocated to https://travellermap.com/api/jumpmap?sector=Troj&hex=3003&style=print&jump=1

So if the "http:" at the start of your URLs is changed to "https:" then the import works properly :-)


The original location of the image (either URL or filename) is put into the snippet as the 'annotation' so that users know where it came from.

It seems that the web site is issuing a redirect from the http: address to the https: address, but my tool isn't handling the redirect properly.
 
Last edited:
Version 1.17 of the tool has been released which attempts to follow web redirection instructions when fetching images from a web URL.
 
Can't you right click the image in the web browser and save it locally? Wouldn't that give you a permanent local copy of the map you like and make it much easier to import into RW without having to use Farling's most excellent tool?
 
Viking2054 said:
Can't you right click the image in the web browser and save it locally? Wouldn't that give you a permanent local copy of the map you like and make it much easier to import into RW without having to use Farling's most excellent tool?
Click to expand...

If you have 100+ planets to enter into your Traveller campaign, then having the image automatically downloaded as part of the import process is a lot quicker than doing right-click/save-as 100+ times :-)
 
not if there is a redirect problem though, right? Anyway, right clicking is a work around, easy or not as one might think. Wouldn't you also have to copy 100's of URL's?
 
You must log in or register to reply here.
Back
Top