Quote:
|
Quote:
One CSV file for each domain or other mechanic articles, and one CSV for the deities. You can freely map the named columns from your CSV file(s) into the corresponding fields in the actual topic/article format(s). There's no need to get a CSV list of column titles out of the tool first. |
This tools is amazing! It is a must-have when you prepare a big mechanics sections or story that can be put in CSV format :) I uploaded Dark Heresy 2nd in Realm Works and this tool saved me so much copy-pasting the equipment and other system-data!
http://forums.wolflair.com/showthrea...790#post253790 Question: Is there a way during the import to have the topics nested into specific article hierarchy? |
Quote:
If you want more information in the parent topic, then you can populate the newly created parent topic after import. |
Worked like charm. :)
|
Just started to use the too. First impression is great. I have yet to import something.
However I noticed that inactive Categories are showing up in the list. Maybe they should be hidden or flagged? I suppose you should not be able to import to inactive categories? |
Quote:
|
Quote:
Unfortunately, the structure export file doesn't include any flags to indicate which categories are "Inactive" or have the "Shown" flag not ticked. It will require a change by LWD to the export structure (adding an attribute to the category_global) before I know which categories are to be hidden. |
Oh okay :) Thanks for looking.
|
I'm trying to create clickable loot tables using links withing RW. I actually already made some manually, but it's SUPER tedious and time-consuming. I've included a screenshot of what I'd like the import to look like when done. I can't figure out how to do so. I've gotten as far as creating the labeled snippets, but can't seem to get them to be customizable for the import. Am I doing this wrong, or is this not possible?
I could edit the labels manually after the rest of the import, but that's not even possible from what I can tell. Any help would be appreciated! http://i.imgur.com/QslomcS.png |
What part isn't working in the import?
|
It imports successfully, but it looks like this. Ignore some of the names, experimenting with it right now.
Edit: All the "weapons" on the left are a result of the import. I'm hoping to have a list on the right hand side like my previous image. http://i.imgur.com/uwHUYPe.png |
Ah, I see what you are trying to do.
The tool isn't designed to put a complete CSV file into a single topic. It is designed to create a separate topic for each row in the CSV file. It would require a quite different structure to the program to be able to create a single topic with a separate snippet for each row in the CSV file. |
Quote:
|
But there's no reason with a little spreadsheet magic you couldn't get what you want.
you tried to put one file into each topic which doesn't work. What does work is putting a single row into a single topic. So figure out the structure these topics need, including these loot tables, and make them one row of the CSV. |
Quote:
|
Might be a dumb question but how do I import text strings containing commas without having the commas being interpreted as delimiters?
|
Quote:
Name,Titles “Name”,”Title01, Title 02” Best way to ensure all is in proper format is to fill the table in Excel and export in CSV. |
Quote:
|
Quote:
|
Quote:
In a CSV file commas mark the end of a column and the new line symbol marks the end of the row. Therefore to include either one in your data you need to wrap it in quotes. Since quotes themselves are treated as a special symbol if you need to include a quotation mark you need to wrap it in quotes as well. This is why I wrote above that for all but the most trivial CSV files it is far easier to build the file in Excel or some other spreadsheet program and then export it as a CSV rather than trying to build it by hand. |
Thanks a lot! I was aware of the quotes, but I put them around each delimiter and not around the whole text block, which makes it obviously easier. :-)
|
What is CSV?
|
Comma Separated Values.
It's a type of file format where each column of data is separated from the next by a comma, and each row ending with a newline character. It's a pretty universal way of sending tabular data from one place to another. Almost every data source will have a way to read CSV files. |
Quote:
|
I'm importing my first CSV file into this program as I type. Its a list of all the magic spells in 5e. I'm sure I'm going to have to figure some things out with it being overly aggressive on links (curse you 'light' spell!) but I'll figure those out as I go.
This might be outside the scope of what this tool does, but it would be a nice feature to be able to export existing articles, do mass clean ups in excel, then reimport to update in bulk. Thanks for putting time into this, its an excellent tool! |
Also, got this error importing my CSV file:
Quote:
|
Quote:
Perhaps something like Quote:
|
Hi, I've been getting this specific problem, with a few imports. Can someone please help me with this?
Thanks in advance The following errors were encountered during import: Encountered validation error for the import XML: The 'public_name' attribute is invalid - The value '' is invalid according to its datatype 'urn:lonewolfdevel.com:realm-works-export:top_level_name_type' - The actual length is less than the MinLength value. Invalid name specified |
Quote:
I will have a look to see what is going on. |
Ok I just sent you the links. Thanks for the quick response
|
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. |
So how would I fix it/make it work now?
|
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. |
Quote:
An updated version of the tool (to be done soon) will ignore blank lines. |
Where exactly is this last line? It's still happening
|
Quote:
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 :-) |
Sorry but it's still happening with my imports
|
Quote:
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. |
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! |
All times are GMT -8. The time now is 02:02 AM. |
Powered by vBulletin® - Copyright ©2000 - 2024, vBulletin Solutions, Inc.
wolflair.com copyright ©1998-2016 Lone Wolf Development, Inc. View our Privacy Policy here.