RealmWorks CSV Import Tool

[Arg-ha]

here is one for you

        <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>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;NG&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_174" type="Hybrid_Tag">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Centaur&lt;/span&gt;&lt;/p&gt;</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>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Male&lt;/span&gt;&lt;/p&gt;</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>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Noble&lt;/span&gt;&lt;/p&gt;</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>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Play&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_198" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Angry&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_199" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Even-tempered&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_200" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Optimistic&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_201" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Unscrupulous&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_202" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Spontaneous&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_203" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Cautious&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_204" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Disagreeable&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_205" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Reserved&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_206" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Heterodox&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_207" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Surreal&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_208" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Agnostic&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_209" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Inclusive&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_210" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Occasional&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_211" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Never&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_212" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Fearful&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_213" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Church&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_214" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Pilgrim&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_215" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Excessively Touching Others&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_216" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Collecting&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_217" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Hypochondria&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
                <snippet facet_id="Facet_218" type="Tag_Standard">
                    <annotation>&lt;p class=&quot;RWDefault&quot;&gt;&lt;span class=&quot;RWSnippet&quot;&gt;Spinner&lt;/span&gt;&lt;/p&gt;</annotation>
                </snippet>
            </section>
            <section partition_id="Partition_170"/>
            <tag_assign tag_id="Tag_1"/>
        </topic>

[Farling]

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?

[Mmurphy]

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.

[Farling]

Originally Posted by Mmurphy

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.

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.

[Mmurphy]

Thank you, I changed that text to "less than" and everything imported correctly.

[Happydevil43]

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

[Farling]

Originally Posted by Happydevil43

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.

Hopefully step 2.6 in the first post covers the manner in which you can create parents to group your topics

[cas206]

@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?

[Farling]

Originally Posted by cas206

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?

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

[Arg-ha]

<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" />