Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
Version 2.14 is available
The tool now presents a list of the available top-level arrays in a JSON file, so that the user can choose which array is to be used as the data source for the data import. (This fixes the problem reported by apoca6 in http://forums.wolflair.com/showpost....&postcount=548 ) Farling Author of the Realm Works Import tool, Realm Works Output tool and Realm Works to Foundry module Donations gratefully received via Patreon, Ko-Fi or Paypal |
#551 |
Junior Member
Join Date: Jun 2011
Posts: 13
|
You are a Legend thank you
|
#552 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
Farling Author of the Realm Works Import tool, Realm Works Output tool and Realm Works to Foundry module Donations gratefully received via Patreon, Ko-Fi or Paypal |
#553 |
Junior Member
Join Date: Jun 2011
Posts: 13
|
lol, would you want to be?
Next question, looking at my data, some of the fields were split so instead of alignment, i have a 4 or 5 columns with variations, some for C some for G (in the case of CG), is it possible to add multiple items to one field and have them concatenate? so 'C' 'blank' 'blank' 'blank' 'G' in the alignment field would parse as 'CG' into RW? Hope that makes sense? I can work around it if not. |
#554 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
Quote:
So you could write a function which will examine various other columns and decide what the single new combined value should be. For example, the following javascript for a custom column merges several columns into a single D&D 5E spell duration field Quote:
Quote:
Quote:
Farling Author of the Realm Works Import tool, Realm Works Output tool and Realm Works to Foundry module Donations gratefully received via Patreon, Ko-Fi or Paypal Last edited by Farling; June 1st, 2020 at 02:24 AM. |
||||
#555 |
Junior Member
Join Date: Jun 2011
Posts: 13
|
I keep trying to avoid Javascript, but guess i will have to look into it
It has Java in the name so i guess i am halfway there with my basic level of Java?! Thanks for taking the time to reply, it is appreciated! |
#556 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
From what I've read, this is a very misleading name :-)
Farling Author of the Realm Works Import tool, Realm Works Output tool and Realm Works to Foundry module Donations gratefully received via Patreon, Ko-Fi or Paypal |
#557 |
Junior Member
Join Date: Jun 2011
Posts: 13
|
well i am hacking it together, ok.
The two existing custom columns were all i needed really; where the data was split into several columns, they just needed combining into one, similar to the derived example field. It will take a bit to do, but means i can import everything easily now without going back in to adjust everything individually you are a life/sanity saver with this program |
#558 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,625
|
Version 2.16 is now available
This version adds a new javascript function for derived columns. row.hasColumn(name) will return true only if a column called "name" exists in the model. This allows you to use the same javascript for multiple different data sets which might merely have a different number of named columns, e.g. (entries/1, entries/2 in one file, and entries/1, entries/2, entries/3 in another file; or perhaps entries/3/caption might exist, but no entries/1/caption or entries/2/caption). Farling Author of the Realm Works Import tool, Realm Works Output tool and Realm Works to Foundry module Donations gratefully received via Patreon, Ko-Fi or Paypal |
#559 |
Junior Member
Join Date: Dec 2013
Posts: 10
|
I have a question. I'm currently building a excel CSV file that wil randomly generate all kinds of intel for towns/cities. I want to take it a step further and have it also generate one or more item shops or other buildings in these towns.
I know I can use the import tool to load up my towns, but is there a way to have it create "sub-topics" at the same time? for example if my csv looks like this: Town name, some town data; Shop name; shop data Could I get: Topic: Town name (with the town data in correct snippets) -- Subtopic Shop name (with the shop data in the correct snippets) |
#560 |
|
|