Merge multiple shared parameter files

[Sahay_R]

I know that this has been asked multiple times - but maybe someone has come up with something new? I have inherited multiple Shared Parameter TXT files - how can I bring them together  into one?

[barthbradley]

---

I thought that one SP file was the recommended and streamlined way to go? 

---

I don't understand the point of this whole exercise. Yes: one company SP text file is the way to go - ideally.  But, this didn't mean you "retrofit" existing elements. Shared Parameters created from different SP Text Files still report in Project Schedules.  Out of curiosity, what happens when you "include Linked elements" created from different SP Text Files?  

[Sahay_R]

The Linked Elements would be from other disciplines / consultants. Their SP files are on their own.......

[ToanDN]

---

@Sahay_R wrote:

And how did you take it out of Excel to TXT? When I take your file out of Excel to TXT, it goes kablooie again.....

---

Save As and choose Text (Tab Delimited) format.  When you close the file, Excel will ask to Save again, just ignore it.

[barthbradley]

---

@Sahay_R wrote:

The Linked Elements would be from other disciplines / consultants. Their SP files are on their own.......

---

It was a rhetorical question.  

Have a good day. 

Cheers. 

[Sahay_R]

That's exactly what I have been doing.....except that when I do the SaveAs, Excel shows me the TXT filename on the top bar, and does not ask me to save the file again.

[ToanDN · Accepted solution]

The two cells below have extra spaces in them.

[Sahay_R]

Wow. Talk about Revit being a spoiled diva. Worked finally! Thank you, @ToanDN !

[ToanDN]

---

@Sahay_R wrote:

Wow. Talk about Revit being a spoiled diva. Worked finally! Thank you, @ToanDN !

---

In the database universe, a blank in the wrong place can be vital, just like playing Russian Roulette.

[Anonymous]

Rina, did you figure out how to export excel to .TXT to get it work with Revit?

[Thomas_LECUPPRE_Let_it_BIM]

Pay attention to the encoding of the file, use VS Code to save it with the correct encoding if needed.

[julian_prifti_db]

hello everybody, i tried to merge two lists and it worked just by using a text editor and excel, but i have a very funny problem, the spetial german letters like "ü", "ö" etc. are aperaring as spetial characters. I would imagine that could be a issue of character coding like ascii or utf-8. Do you have any idea or approach how to solve this problem. thanks in advance Julian

[ReneBogersREBO]

Hi there,

I am at a company now, where own parameters are added to a standard-parameter file.

I want to split that file, so the standard-parameter file keeps on his own and the other parameters are in a company SP-file.

Can I just copy and past the lines with parameters to a new file (GUID needs to be the same I know!).

Can I adjust the group-numbers to the needed (new-group) numbers?

One other thing. There are a lot of parameters, that need to be contained, but the names need to be changed, for uniformity.

Is this wise to do? Or better make new parameters for this -> with the result that a lot of things have to be adjusted in the template-file for example.

Hope I made myself clear 😉

[arq_42]

Although it's not recommended at all , you can make these changes directly in the txt file.

Copy the existing file a couple of times (to keep a backup) and delete the lines you don't want to keep in each one.
You can modify groups aswell.

Regarding the third question, you can change the parameter names, keeping the GUID, BUT!!! Existing families and projects will keep the old name (although since it's the same GUID, they'll still talk to each other).
This can lead to situations like a new project with a parameter called ST_Height and a family in which that same parameter is called ST_hEIGHT.

The only way to fix this (that I've found so far) is to edit the family, delete the parameter with pyArchitect ("Delete Shared Parameter" tool), reinsert it, and reload the family into the project.

So, as said, you have to evaluate whether it is worth all the work, keeping the parameters as they are, or starting from scratch.

[ReneBogersREBO]

Hi Arc,

This is exactly what I thought! 😉

But I was not totally sure, that's why I asked.

Thank you for your quick reply.

I go into discussion here at the company

pyArchtect is new to me. Thank you

[arq_42]

pyArchitect is an extension to pyRevit, an open source plugin with a lot of useful tools based on python. Take a look 😉

[ReneBogersREBO]

I thought so, cause of the "py".

I use pyRevit to make custom toolbars/buttons for my Dynamo-scripts.

Still need to dive into everthing in pyRevit, but time is an issue! haha