01-TranslationFile.xlsx (62.2 KB)
25-Extracting Text Type Names from Revit.dyn (37.9 KB)
I must be going crazy. I have tried to generate a multiple worksheet excel file that will allow me to send an all inclusive file to someone that knows Spanish and can then just translate straight across from the documented English fields in the Second column of each worksheet (English column) in the third column (Spanish). See Attachments.
I thought I was onto something good but now I have an issue where I cannot seem to organize my thoughts (in the graph) to get the Shared parameters I am using to populate the Spanish text types throughout the entire project document. Seem simple, Get all text types that do not contain the word Spanish in the type name and then get the contents of those elements and export out to the 2nd column in the spreadsheet. Then I do just the opposite to get the Spanish counterpart by finding all the types that do contain the word Spanish in the type name and then export all of those elements contents into the 3rd column of the worksheet. The screen snips I took of the project are showing Sheet and View names that are Shared params, But I am also using the same strategy for all the notation in sheets where we have a 3mm Arial text type that is in English on the top of each note and then we are using a text type with Spanish in the type name to propagate the translated text below.
Clear as mud?
I really need help, believe me, it’s not like I haven’t tried!
Thanks everyone,
Dave