Aston Game

iLogic TitleBlock Project Data From Excel

iLogic TitleBlock Project Data From Excel

Issue:
You have a title block that uses prompted entry, and youd like to fill those fields in from data that is in a spread sheet. You know that the best way to set up a title block is to use the model files iProperties, but unfortunately you cant make changes to the title block that youve been provided. But there must be a better way than just editing each sheet and re-typing the same information over and over, right?
 

Solution:
Here is an iLogic rule that asks the user to browse for an spreadsheet. Then it reads in the data and matches the field name to the title block field, and if a match is found it writes the field value to the title blocks prompted entry field.


Here is an example spread sheet:



Here is an example Title Block:


 And here you can see the field text in the title block, with those that are prompted entries denoted by carats: < >


So the iLogic code gets the information from the spreadsheet and then writes it to the title block for every sheet in the drawing.


Ive added some lines to activate each drawing sheet and a delay timer to step through each text field so that you can watch the changes, but all of that could be removed if youd prefer to speed up the running of the rule.