Size_Lookup tables local storage

Size_Lookup tables local storage

denisyukJ
Advocate Advocate
2,044 Views
11 Replies
Message 1 of 12

Size_Lookup tables local storage

denisyukJ
Advocate
Advocate

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. 

0 Likes
Accepted solutions (1)
2,045 Views
11 Replies
Replies (11)
Message 2 of 12

RDAOU
Mentor
Mentor

@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.

 

 

 

 

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


0 Likes
Message 3 of 12

ToanDN
Consultant
Consultant

@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.


 

0 Likes
Message 4 of 12

denisyukJ
Advocate
Advocate

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.

0 Likes
Message 5 of 12

barthbradley
Consultant
Consultant
0 Likes
Message 6 of 12

RDAOU
Mentor
Mentor
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)

RDAOU_0-1632541853612.png

 

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 🙂 

 

 

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


Message 7 of 12

denisyukJ
Advocate
Advocate

@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.

mzHnkRbbDL.gif

0 Likes
Message 8 of 12

RDAOU
Mentor
Mentor

@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

 

 

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


0 Likes
Message 9 of 12

denisyukJ
Advocate
Advocate

@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. 

denisyukJ_0-1632764535672.png

You can find the script and excel spredsheet in attached.

 

0 Likes
Message 10 of 12

RDAOU
Mentor
Mentor

@denisyukJ 

 

 

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

 

RDAOU_0-1632770996030.png

 

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

 

 

 

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


0 Likes
Message 11 of 12

denisyukJ
Advocate
Advocate

@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?

 

denisyukJ_0-1632809298625.png

 

0 Likes
Message 12 of 12

RDAOU
Mentor
Mentor

@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)

 

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


0 Likes