• 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

here is one for you
Code: 
        <topic topic_id="topic_1" category_id="Category_49" public_name="Broldrad Dimback" prefix="Centaur" suffix="Family">
            <overlay/>
            <section partition_id="Partition_157">
                <snippet facet_id="Facet_173" type="Hybrid_Tag">
                    <annotation><p class="RWDefault"><span class="RWSnippet">NG</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_174" type="Hybrid_Tag">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Centaur</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_175" type="Hybrid_Tag"/>
                <snippet facet_id="Facet_176" type="Labeled_Text"/>
                <snippet facet_id="Facet_177" type="Hybrid_Tag">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Male</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_178" type="Hybrid_Tag"/>
                <snippet facet_id="Facet_179" type="Hybrid_Tag"/>
                <snippet facet_id="Facet_180" type="Hybrid_Tag"/>
                <snippet facet_id="Facet_181" type="Hybrid_Tag"/>
                <snippet facet_id="Facet_182" type="Picture"/>
                <snippet type="Multi_Line">
                    <contents><p class="RWDefault"><span class="RWSnippet">Noble</span></p></contents>
                </snippet>
            </section>
            <section partition_id="Partition_158">
                <snippet facet_id="Facet_183" type="Hybrid_Tag"/>
                <snippet facet_id="Facet_184" type="Hybrid_Tag"/>
                <snippet facet_id="Facet_185" type="Portfolio"/>
                <snippet facet_id="Facet_186" type="Statblock"/>
            </section>
            <section partition_id="Partition_159"/>
            <section partition_id="Partition_160">
                <snippet facet_id="Facet_187" type="Hybrid_Tag"/>
            </section>
            <section partition_id="Partition_161"/>
            <section partition_id="Partition_162">
                <snippet facet_id="Facet_188" type="Hybrid_Tag"/>
            </section>
            <section partition_id="Partition_163"/>
            <section partition_id="Partition_164">
                <snippet facet_id="Facet_189" type="Labeled_Text"/>
                <snippet facet_id="Facet_190" type="Labeled_Text"/>
            </section>
            <section partition_id="Partition_165">
                <snippet facet_id="Facet_191" type="Hybrid_Tag"/>
            </section>
            <section partition_id="Partition_166">
                <snippet facet_id="Facet_192" type="Hybrid_Tag"/>
            </section>
            <section partition_id="Partition_167">
                <snippet facet_id="Facet_193" type="Hybrid_Tag"/>
            </section>
            <section partition_id="Partition_168">
                <snippet facet_id="Facet_194" type="Date_Game"/>
                <snippet facet_id="Facet_195" type="Date_Game"/>
                <snippet facet_id="Facet_196" type="Date_Game"/>
            </section>
            <section partition_id="Partition_169">
                <snippet facet_id="Facet_197" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Play</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_198" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Angry</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_199" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Even-tempered</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_200" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Optimistic</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_201" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Unscrupulous</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_202" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Spontaneous</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_203" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Cautious</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_204" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Disagreeable</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_205" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Reserved</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_206" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Heterodox</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_207" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Surreal</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_208" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Agnostic</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_209" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Inclusive</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_210" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Occasional</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_211" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Never</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_212" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Fearful</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_213" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Church</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_214" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Pilgrim</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_215" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Excessively Touching Others</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_216" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Collecting</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_217" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Hypochondria</span></p></annotation>
                </snippet>
                <snippet facet_id="Facet_218" type="Tag_Standard">
                    <annotation><p class="RWDefault"><span class="RWSnippet">Spinner</span></p></annotation>
                </snippet>
            </section>
            <section partition_id="Partition_170"/>
            <tag_assign tag_id="Tag_1"/>
        </topic>
 
Hi Arg-Ha,

There is a stray "<overlay/>" at the beginning of the topic.

I can only think that this is being added because it is in the structure file that you're using.
Inside your structure file there is a <category> or <category_global> with a category_id of "Category_49".
Could you provide that category/category_global block please?
 
I was just introduced to this tool and I think it is amazing. I imported mundane gear without any hiccups however, when I went to import spells I get a:

"The following errors were encountered during import:
C++ Exception: Already in a span at line 1597 in file utility.cpp"


I am importing spells that may or may not have the same name as spells from another class (spells from different classes have different abilities but tend to use the same 'name'). Within this thread I have seen you ask for the realm works import file so I will attach that and the CSV file.

I think this tool will save me hours of data entry, I want to thank you for it.
 

Attachments

Mmurphy said:
I was just introduced to this tool and I think it is amazing. I imported mundane gear without any hiccups however, when I went to import spells I get a:

"The following errors were encountered during import:
C++ Exception: Already in a span at line 1597 in file utility.cpp"


I am importing spells that may or may not have the same name as spells from another class (spells from different classes have different abilities but tend to use the same 'name'). Within this thread I have seen you ask for the realm works import file so I will attach that and the CSV file.

I think this tool will save me hours of data entry, I want to thank you for it.
Click to expand...

The RWExport file seems to be a legal format, so I can only think that something is going wrong inside Realm Works. I tried importing it into a blank realm and I get the same error.

A quick search through your CSV file shows that you have the text "<1000#".
If I change the "<" to a "-" then the import works properly.

I think there is an additional step that I need to perform when creating text snippets to check for "<" and encode them in a silly way to get them to import properly.
 
Last edited:
Finally having a crack at this...and it looks awesome.

Its going to save me oodles of time when I figure it all out.

Is there a list of instructions for each of the new features ?

I am interested in creating the parent/child type entries and the snippet style, but being a very non-programming type person, have no idea on how to do those with a flat file.

Thanks
 
Happydevil43 said:
Is there a list of instructions for each of the new features ?

I am interested in creating the parent/child type entries and the snippet style, but being a very non-programming type person, have no idea on how to do those with a flat file.
Click to expand...

Hopefully step 2.6 in the first post covers the manner in which you can create parents to group your topics :)
 
@Happydevil43 There is a Add Parent button that lets you put the main articles in a parent container.

ALCON, The Add Parent Feature lets me put articles under a named container. That's fine. What I would like to do is create a second CSV / Load that can populate more snippets in the parent article. Currently, if I try to do that, I get two containers with the same name, instead of filling in the existing container withe the additional content. Is there a work around?

@Farling,
Is this a feasible feature request?
 
cas206 said:
ALCON, The Add Parent Feature lets me put articles under a named container. That's fine. What I would like to do is create a second CSV / Load that can populate more snippets in the parent article. Currently, if I try to do that, I get two containers with the same name, instead of filling in the existing container withe the additional content. Is there a work around?

@Farling,
Is this a feasible feature request?
Click to expand...

I think this would complicate the interface quite a bit, since there would have to be a way to choose the CSV file for each set of data and two sets of the individual topic fields.

You could always take the "imported" empty parent and put it as a child of the real populated parent :)
 
<category_global category_id="Category_49" name="Individual" global_uuid="1FB0297B-91C6-5D3A-00D0-6A935D3C6BA9"><overlay original_uuid="14A69BB6-25D0-869A-18F5-6A93BB0E6BA9" signature="90407" />
 
Arg-ha said:
<category_global category_id="Category_49" name="Individual" global_uuid="1FB0297B-91C6-5D3A-00D0-6A935D3C6BA9"><overlay original_uuid="14A69BB6-25D0-869A-18F5-6A93BB0E6BA9" signature="90407" />
Click to expand...

Ok, I'll need to experiment to see what this "overlay" snippet type is all about. In you category definition for the "Individual" there appears to be an overlay snippet as the very first snippet.
 
cas206 said:
@Happydevil43 There is a Add Parent button that lets you put the main articles in a parent container.
Click to expand...

Found that, and I am getting closer, but what does adventure area come under, I cannot see it in the list of available options ? unless I can't see it.

but I have got it do most of what I want now, I'll still need to tweak it a bit.

EDIT: I figured out if I duplicate adventure area I can add it in as a parent and it shows up on the second level of the parent (cannot get it to show up as the top level).

worst case scenario is that I get the basic structure created and then go back in to tweak it. Have attached what I have done so far. I am sure there are many improvements to make yet.

Next to figure out is images and herolab files.
 

Attachments

  • csvimport.png
    csvimport.png
    34.8 KB · Views: 5
  • csvimport2.png
    csvimport2.png
    41.8 KB · Views: 5
Last edited:
At the moment the tool won't allow you to use the same category type for multiple levels of parent or the same as the base topic for importing.
 
Farling said:
At the moment the tool won't allow you to use the same category type for multiple levels of parent or the same as the base topic for importing.
Click to expand...

So does this mean I can't import a monster and have multiple action snippets or multiple trait snippets in the appropriate section? I want to have a snippet for each in the section but don't see a way to do it.
??
 
Last edited:
joe2chillo said:
So does this mean I can't import a monster and have multiple action snippets or multiple trait snippets in the appropriate section? I want to have a snippet for each in the section but don't see a way to do it.
??
Click to expand...

Multiple snippets in the same section should be handled by updating the definition of the category to have those extra snippets. The exported "structure file" will then have those extra snippets, and the CSV tool will make those available for you to map to specific CSV fields.

The reference to "Unique" categories refers to what category is chosen for each parent. So if you are importing a file of spells then you would use the "Spell" category for the individual field mapping; you could then use the "topic list" category as a parent, but you could not use a "Spell" category as a parent.

(Apologies if any of the above is not entirely clear, I've had flu for the past few days.)
 
Farling said:
Multiple snippets in the same section should be handled by updating the definition of the category to have those extra snippets. The exported "structure file" will then have those extra snippets, and the CSV tool will make those available for you to map to specific CSV fields.

The reference to "Unique" categories refers to what category is chosen for each parent. So if you are importing a file of spells then you would use the "Spell" category for the individual field mapping; you could then use the "topic list" category as a parent, but you could not use a "Spell" category as a parent.

(Apologies if any of the above is not entirely clear, I've had flu for the past few days.)
Click to expand...

Thanks. Got it. Next I need to figure out how to add on HL portfolios and image files. I think I saw that somewhere in the thread so going back to look now.
 
Error when importing

Every time I try to import the generated file to RW, I get the message:

The following errors were encountered during import:

Encountered validation error for the import XML: The element 'topic' in namespace 'urn:lonewolfdevel.com:realm-works-export' has invalid child element 'overlay' in namespace 'urn:lonewolfdevel.com:realm-works-export'. List of possible elements expected: 'alias, section' in namespace 'urn:lonewolfdevel.com:realm-works-export'.

I even tried just creating a super basic csv with only 4 columns and 1 monster. Any ideas on this?

UPDATE: I figured out the problem though not the cause. I read back through this thread and found someone with the same issue. You had mentioned that it had to do with an empty overlay. I searched the XML for <overlay/> and found several. I simply removed them. Then everything imported just fine.
 
Last edited:
Mult-line

One last question. I notice that the main post mentions that Mult-line quoted text is supported. What exactly does that mean and how does it work. I am trying to create a cell with spellcasting and then a new line for each level.

EXAMPLE:
Spellcasting. The bad guy is a 5th level spellcaster with these spells:
cantrip (at will): cantrip1, cantrip2, cantrip3
1st level (3 slots): spell1, spell2, spell3
2nd level (2 slots): spell1, spell2
3rd level (1 slot): spell1

I tried just doing a ALT-Enter in excel to create a line return but that doesn't seem to work. Also tried CHAR(10) in the cells for a line return but this did not work either. Is it possible to achieve what I want?
 
Last edited:
You must log in or register to reply here.
Back
Top