Problem with exported lookup table

[Anonymous]

I have a Revit family (made in Revit 2016) with a lookup table attached. When I export the lookup table in Revit 2018 and then import that same csv file without editing it it gives me this error : 

Invalid formula found in the "%1!s!" parameter in the "BMG_default" type.
You will need to import the correct table or edit the formula in order to continue.

The lookup table has not been changed or edited after the export. Because of this problem I can't change the lookup table without redoing all the old settings etc. 

I can not post the family because it is a confidential family. Hoping someone solved this problem already.

[L.Maas]

Might be an issue with the header naming in the csv file.

Can you upload the csv file (or headerline and first row of data)?

[Anonymous]

The first problem is that in earlier revit versions the lookup table used ##number##feet and now ##other##. After this change I do not know how to get it to work. 

The .csv is attached. 

[L.Maas · Accepted solution]

In the CSV file you have

Type_ID##number##feet, Control_ID##number##feet,

This is not correct (anymore?) as a number cannot be feet

This should be:

If the parameters are numbers

Type_ID##number##general,Control_ID##number##general,

Or

if the parameters are of type length

Type_ID##length##feet, Control_ID##length##feet,

[Anonymous]

It was a .csv exported from the family. The change to ##other## did not work, but the one to ##number##general did. Thank you very much !!