Size_Lookup tables local storage

[denisyukJ]

Hello everyone,

I found folder in ADSK directory which contains lookup tables. Is it tables for default families?   

C:\ProgramData\Autodesk\RVT 2021\Lookup Tables\

My question is: can i store tables for all my families in this directoty and link them instead of uploading into family? For my goal it can be very useful feature. 

[RDAOU]

@denisyukJ 

That is the default location for the system Pipes and conduits...if you feel like centralizing all lookup tables there under different folder, feel free to do so... We keep each with the related components.

[ToanDN]

---

@denisyukJ wrote:

Hello everyone,

I found folder in ADSK directory which contains lookup tables. Is it tables for default families?   

C:\ProgramData\Autodesk\RVT 2021\Lookup Tables\

Yes they are for OOTB families.

My question is: can i store tables for all my families in this directoty and link them instead of uploading into family? For my goal it can be very useful feature. 

I would store my own look up tables in a shared, custom folder, preferably the same folder/subfolder where I store my custom families.  If you choose to store in the OOTB folder, because it is a local folder in your computer. it can only be accessed by you, not other team members.  And if for some odd reason you need to uninstall/reinstall/wipe your HDD then make sure to back up the tables.

---

[denisyukJ]

Thanks all of you, but feels i have to clarify my situation. I have daily updated .csv file where i can see number of goods in warehouse (it's can be also prive list). So i can make the parameter (Available in stock) and represent it in schedule. Problem is manual updating .csv table inside every family, because i have batch of them. It would be much easier store csv file in the PC folder and link to this file all of my families to update for one click. 

Sample file in attached. Revit 2021.

[barthbradley]

https://www.youtube.com/watch?v=USqZc-VE95Y

[RDAOU · Accepted solution]

@denisyukJ 

Placing the cvs in the folder you mentioned will not serve the purpose you are after...Regardless where you place the lookup table (in the folder you mentioned or elsewhere), when the .cvs is updated, it will need to be re-imported into the family 

• Either Manually (Open/Import & Replace/Save/Close)
• Or using a Batch import utility
  1. Either a plugin
  2. OR using Dynamo (you can try Orchid package it has a node to add Lookup table)

An alternative to the method you are using would be to use type catalogs (No formulas involved)...The family would have a generic type and the user loads the required types upon Inserting the family. This way, 

• you do not need to worry about pushing the csv back to the families since you only update the catalog file
• Downside: You (as an admin) will have multiple files to maintain.

Judging from the family sample you added, it seems that you you are more of an expert than the experts here 🙂 

[denisyukJ]

@barthbradley 

Thank you, i will check it later.

@RDAOU 

It works! But what is strange i have to open the family and manually select a look up table. Look at the gif below.

 

[RDAOU]

@denisyukJ 

That is because the operation is not done...what would you do if you were to do it manually in Revit?

1. you open the file
2. you load/add the lookup table .csv file
3. You apply / Save and close

So you are missing 1 step at the end Document.close node. but you need to pass it through after the Add Lookup is performed. While at it

• You could use a dictionary at the beginning to open all families in the directory rather than 1 by 1 
• You might also want to delete all backup files created from the save 

try the above...if you need help tag or pm me

[denisyukJ]

@RDAOU 

I did a selection of batch of families by excel spredsheet, but i have stacked with saving final version of them,

because i can't find AddLookupTable node with document output consequently i can't make a chain you mentioned above. 

You can find the script and excel spredsheet in attached.

[RDAOU]

@denisyukJ 

You do not need an excel sheet... just collect the .rfa from the directory where the families are saved

The node you are using is the same... just a different version where the output has been renamed

[denisyukJ]

@RDAOU 

If i connect AddLookupTable and Close node directly, then it shows error message. I thought it means i cant connect watch input with document output, is it?

[RDAOU]

@denisyukJ 

The error message is clear ... the node is expecting a Document + Boolean ... you are inputting String + Boolean.

you are plugging it to the wrong node. See previous reply in Message 8

You need to connect the BachgroundOpen to the Document.Close through a Passthrough node ...ie:

1. PT will hold the output from node 1 (Backgroundopen) till the output from node 2 (addlookup) is complete
2. then it will pass it to the Node 3 (close)