Import Excel Worksheet - Rule#203

paola bronzo

Hi everyone,

I am using version 9.12.1.9.
I noticed there are some anomalies with the rule#203.
1- the “numeric” value is not imported
2- the “update imported data” doesn’t work
Import excel Rule203.jpg
Does it happens also to you?

JSN

I have not really used it, but I think you would have to specify the Operator and the Numeric Value too then.

EDIT: You are right - this is either not user friendly enough, or just not working as it should.
Why is there not a good documentation of such things?

JSN

Turns out we are not alone.

https://society.solibri.com/topic/978/rule-203-numeric-value-without-unit?_=1610019703710

So yeah, the question left is now what hast to be inserted for “Unit” when you want to leave it out - because otherwise it works. If the specification is correct then updating is possible as well.

@Solibrians will you give us a hint?

paola bronzo

@jsn said in Import Excel Worksheet - Rule#203:

I have not really used it, but I think you would have to specify the Operator and the Numeric Value too then.
EDIT: You are right - this is either not user friendly enough, or just not working as it should.
Why is there not a good documentation of such things?

Yes, I should have specify the Operator and the Numeric value…but how?
What is the correct writing to put in excel so that it is automatically read by the rule?
You are right, we would need some more documentation.

paola bronzo

@jsn said in Import Excel Worksheet - Rule#203:

Turns out we are not alone.
https://society.solibri.com/topic/978/rule-203-numeric-value-without-unit?_=1610019703710
So yeah, the question left is now what hast to be inserted for “Unit” when you want to leave it out - because otherwise it works. If the specification is correct then updating is possible as well.

@Solibrians will you give us a hint?

Thanks @JSN !!! this is interesting!

paola bronzo

@JSN I did some tests with an excel worksheet formatted as shown below … but I can’t get the desired result.
Import excel Rule203_1.jpg
@Solibrians is there a guide on how to write the excel file so that all the possible values are read by the rule?

lasse.lindqvist

Hi. Can you try using Area/Length/Volume/Date as the unit?

paola bronzo

@lasse-lindqvist yes, I tried to do it but nothing changes … also the “update imported data” still does not work …

JSN

@paola-bronzo said in Import Excel Worksheet - Rule#203:

@Solibrians is there a guide on how to write the excel file so that all the possible values are read by the rule?

@lasse-lindqvist Yes, that would be great.

yes, I tried to do it but nothing changes … also the “update imported data” still does not work …

@paola-bronzo
Did you make sure the headers are all matching - at least when using units like m or m2, the full line should load correctly and then you are able to update …

JSN

@lasse-lindqvist

With Units it’s working as shown above, but what is the secret symbol for no unit now?
Afaik it’s not “”, " ", “*”, “-”, “_”, …

paola bronzo

@jsn Thanks ;)! Now It works!
Import excel Rule203_2.jpg

JSN

@paola-bronzo

Ok, let’s see if we also find out more about the lost symbol for no units.

In the meantime, a note about consistency and UX, as your table brought light into another very confusing thing.

@Solibrians Why is the import drop down menu header called “Unit” whilst in the UX dialog it’s clearly labeled with “Quantity”? This is confusing. Probably just a legacy thing, but still.

JSN

@lasse-lindqvist
With Units it’s working as shown above, but what is the secret symbol for no unit now?
Afaik it’s not “”, " ", “*”, “-”, “_”, …

Would be great to learn more about it as it still is a bit of a mystery and I have not yet found it out on my own …

tonigyllenberg

Hello!

This has been fixed in Solibri 9.12.7. Please try out the new version and let us know how it feels!

Kind regards,
Toni on behalf of the Solibri team

chris

@Solibrians Is there a guide how to write the excel file?

Matti

@chris

No guide. Try to use this as an example:

C:\Users\Public\Solibri\SOLIBRI\Samples\data\Required Property Sets.xlsx

john.lipp

@chris

Here is a XLSX that has a picklist/cheatsheet that you can use to copy/paste cells from to your required property sets sheet along with providing hints:

Required_Property_Sets_Picklist.xlsx

Some things things to note:

You can use asterisks and question mark wild card characters in your pset, property, and property values.
There are many ways to specify units (even gallons for volumes), and it should convert to your File > Settings > Units that you have set.
To set the True, False, True or False value for a boolean property, it goes in the “String Value” column
You can use any color you want (the picklist has some standard ones), and the percent is how transparent. NOTE: XLS will limit the colors so its better to use XLSX. NOTE: You see the colors in the Rule Tools.
Use a semicolon to separate an enumeration.
For the equal numerical operator, use ‘eq’. You can NOT use equals sign (=), though you can use >= and <=

Example :

chris

@john-lipp Thank you very much