About This File
This Marionette Script creates multiple space objects from worksheet data.
A very nice and time saving Marionette script to automate a routine peace of work.
Please consider, that the the script takes the area column and calculate the square with that. If you have a language settings with comma instead of points for decimal seperator, the calculation will fail. Use points as decimal character or eliminate decimal places in your list
What's New in Version 1.0.3 See changelog
This Network gets Data from an external Text (Tab oder character Separated)
A Highlight in this Networks are the following Nodes:
1. Data Mapper
This Nodes is able to easy-configurate in a Dialog Window, which column should be written in wich record field.
"Data Mapper" - Node is very powerful and can handle different kind of records and data input. The number of output values
is matched to the Standard "Set Record Format" it repeats the Values by the number used Fields so the Input of ex. 100 Lines
with 4 columns results in 400 items.
2. Get Field Names
Is able to return Fields of a Record format. So you don't have to manually write Record Format and Field Names
3. The Settings will be saved at the Data Mapper Node. So you don't have to create configuration every time you run the Script
The Script seems to be a little more complex because it can be easy-used with different Type of Files, Also Filters Error Lines out of the Textfile.
Minimal adjustment for 2021 (Input field width was wrong, so with some files the dialoge looked not nice ). Also attached an example Text File. Note: If you use another kind of File (other columns than the example file) you can easily configure mapping with the data mapper Node.