RealmWorks CSV Import Tool

[bishop618]

Ok I just sent you the links. Thanks for the quick response

[Farling]

I've had a quick look at the files, and the RWEXPORT file has a blank topic as the very first topic. I suspect this is being created from the blank line that appears in the CSV file (the very last line of the file).

It looks like the CSV import code I'm using treats a blank line as if it was a valid CSV record, so it creates a topic with no data whatsoever.

I will add this as a feature improvement for the next version, to check that the public_name (i.e. the topic title) is not empty.

[bishop618]

So how would I fix it/make it work now?

[Parody]

If the problem is what Farling described, delete any blank lines in the CSV file and (if present) the line ending at the end of the file and try it again.

Farling, it might be better if you checked for blank (post-trimming) lines in your file reading code and errored or ignored them then (or treated them as the end of the file). That'd separate a blank line from a line with empty data ("", "", "", ...) if you care.

[Farling]

Originally Posted by bishop618

So how would I fix it/make it work now?

The very last line in the file (which is blank) needs to be deleted.

An updated version of the tool (to be done soon) will ignore blank lines.

[bishop618]

Where exactly is this last line? It's still happening

[Farling]

Originally Posted by bishop618

Where exactly is this last line? It's still happening

A new version of the tool (v1.7) is now available which addresses this specific issue.

Blank lines in CSV files are now ignored during input, so the table of data at the bottom of the screen won't show any blank lines and, more importantly, no empty topics will be written into the RWEXPORT file.

Please try the latest version to see if it gets you past this little hurdle :-)

[bishop618]

Sorry but it's still happening with my imports

[Farling]

Originally Posted by bishop618

Sorry but it's still happening with my imports

The CSV file which you sent to me actually seems to work fine. It doesn't produce the blank topic that it seen in the RWEXPORT file that you sent me.

I tried putting a blank line into your CSV immediately after the header row, and that created a bad RWEXPORT file which looked very similar to your RWEXPORT file.

[Farling]

Thanks for the additional files. I have now tracked down the problem. It is linked to the realm structure having the Herb category as a child category of the General Equipment Article.

When the General Equipment Article is used as the parent topic for your import, my tool is erroneously creating a blank (unnamed) Herb article as the first child of that topic!