• 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

JustinThomason said:
I don't quite understand what is wrong with my CSV. Is it because there are room names that are the same (like "Rat Tunnels" or "Entrance"?). If that's the case, that's an annoyance of this module and, frankly, lots of other modules as well - I might be able to deal with it, but it would be a pain. However, When I tried to import, I got references that topics were said to be used more than once, but I could only find a single instance of the name in the CSV.
Click to expand...

Hi,

The "topic more than once" error is when the same row in the CSV table is
being inserted more than once. You can have the same name on different rows without causing any issues (other than if you try to create a relationship, since it will pick the first [or all?] topics).

The problem I saw was that the way you had the parents set up, the same row from the table was being added to several different parents.

e.g. several topics were being put under both the parents "Level 0B: The Cloister of the Frog-God" title and "Level 0B: The Cloister of the Frog-God: The Cloister".

I'm not sure if you intended the same topics to appear twice in your realm.
 
daplunk said:
A crash during import. I would need to replicate the issue. But in our experience adding multiple names to snippets is a sure fire way to get the import to crash and in all cases we have been able to get around the crash by removing multiple names from the equation and nothing else.
Click to expand...

Do you have an example of the generated RWexport file that I could examine, so that I can see what is being put into the file?
 
I just tried to replicate it using a file I had made a few months ago. I deleted the original export so this was a fresh from using the csv. Unable to replicate which is a good thing. If I can make it happen again in the future I'll let you know.

Joe might have some crashing exports left. I tend to clean up the stuff that doesn't work.
 
Farling,

I'm really sorry to continue poking at this, but I have gone over my CSV multiple times and I do not see any problem with how I have structured the file. I decided to copy out the lines dealing with the Cloister of the Frog-God as a test since that was definitely causing problems. I'm attaching this as a .txt file so it can be reviewed.

Just using a few lines from each section, I'd expect the import to look something like this:

Level 0B: The Cloister of the Frog-God
---Background
Level 0B: The Cloister of the Frog-God: The Cloister
---Entrance
---Upper Temple
---Refectory
.
.
.
Level 0B: The Cloister of the Frog-God: Within the Vaults
---The Lower Temple
---Holding Cells
---Laboratory
---Lost Catacombs
.
.
.
Click to expand...

In fact, this is exactly how this same CSV imported the first time I used the tool. That was before you had added the controls to keep the main topic name from being an auto link, so I was having lots of false positives importing the text, but I still have that Realm, and it imported exactly as I would have expected.

attachment.php


Sorry to be a pain. I just really don't understand how else I could structure the CSV to get the nested structure that I need. I don't see how I'm calling on the same lines multiple times. Thanks again for your help.
 

Attachments

  • TestSubset-01.txt
    TestSubset-01.txt
    8.2 KB · Views: 8
  • RA_ImportedStructure.PNG
    RA_ImportedStructure.PNG
    56.5 KB · Views: 96
Question:

I may be crazy (actually no don't answer that.... :-) ), but I am sure that in one of the earlier builds there was an option to make a snippet a GM instruction... that seems to have disappeared ?

I can see snippet styles etc...

Did I miss something ?
 
Happydevil43 said:
I may be crazy (actually no don't answer that.... :-) ), but I am sure that in one of the earlier builds there was an option to make a snippet a GM instruction... that seems to have disappeared ?
Click to expand...
It's still there for Text Snippets: Snippet Options/GM Directions/Convert to GM Directions-only or Ctrl-G.
 
Version 1.49 is out

This version fixes a bug that JustinThomason found.

The string matching wasn't working properly when deciding which topics should be created as children of which parents. (The API call had been changed to prevent "regular expression" special characters from having any effect, in order to fix a previous bug report.)

If a possible parent name was present within another parent name, then both parents would have the topic created beneath them.

e.g. with the data lines:
Code: 
Parent,Prefix,Name,Suffix,Alt Name,Alt Name 2,Status Tag
Level 0B: The Cloister of the Frog-God,0B,Background,0B,0B,Area 0B,Empty
Level 0B: The Cloister of the Frog-God: The Cloister,CL1,Entrance,0B-CL,CL1,Area CL1,Empty
Level 0B: The Cloister of the Frog-God: Within the Vaults,DL1A,The Lower Temple of Tsathogga,0B-DL1,DL1A,Area DL1A,Empty

All three topics would appear under "The Cloister of the Frog-God" (since that title appears somewhere within the text of parent column), as well as appearing under their own (correct) specified parent.
 
Happydevil43 said:
Ahh - Thanks - It was a tick box.....I think ... I didn't dig deep enough.
Click to expand...

2 Questions - and I admit its been a while since I used this.... I just downloaded 1.49....

I am sure this file worked the last time I used it.. (I was starting a new realm)…

1. The GM Snippet thing - I cant find that in Farlings awesome tool - It used to have it there. Yes I can do it once it was imported - but thought I could do it on import. I cannot see any function anywhere for it.


2. Now I have the attached errors - I for the life of me can't see what's wrong. I am going to go back to an older version and see what happens. I can see one entry for each one...
 

Attachments

  • import_problem.JPG
    import_problem.JPG
    265.3 KB · Views: 3
Well blow me with a feather... after a few goes (and changing nothing), its decided to work...
The only thing I did different - I saved after I put each column in its corresponding place

Still cant find the GM Snippets.
 
Happydevil43 said:
Still cant find the GM Snippets.
Click to expand...

I think there is mention of "GM only" in the usage notes, but the button was removed very early on because it didn't do anything.

I have something working that generates GM-only parts to snippets, but it needs some more testing before I'll release it.
 
Farling said:
I think there is mention of "GM only" in the usage notes, but the button was removed very early on because it didn't do anything.

I have something working that generates GM-only parts to snippets, but it needs some more testing before I'll release it.
Click to expand...

Excellent!

You are a god amongst men.
 
Version 2.0 is out

The tool now supports generating GM Directions from CSV columns (including creating multiple snippets in the same section from multiple columns).
The tool has moved to the latest version of Qt (5.12.0) which supports 64-bit on Windows.
The tool has been renamed to reflect the fact that it no longer only supports CSV files.
 
Hey mate, I'm having some trouble with version 2.0 I get an error and CTD when I try to import, I attached the relevant files I think, anything else you need to help?
 

Attachments

ErinRigh said:
Hey mate, I'm having some trouble with version 2.0 I get an error and CTD when I try to import, I attached the relevant files I think, anything else you need to help?
Click to expand...

Hi Erin,

Can you do a divide-and-conquer to work out which part of the CSV is causing problems? It is 1,387 records long.

e.g. try doing only first half, and then only second half. Then split up the offending half, etc.
 
Well it took me the better of 3.5 hours, but I narrowed it down to this record (attached), though I don't know what is causing it, it seems to be something to do with the Callsign field when added to other names
 

Attachments

You must log in or register to reply here.
Back
Top