Skip to content
  • Categories
Collapse
Solibri Society Forum
  1. Home
  2. Comments & Feedback
  3. Tech Talks
  4. Loading required values from Excel fails on booleans

Loading required values from Excel fails on booleans

Scheduled Pinned Locked Moved Tech Talks
4 Posts 2 Posters 1.1k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • _c__ Offline
    _c__ Offline
    _c_
    wrote on last edited by _c_
    #1

    I don’t think that this is fully operational: loading required property sets from excel doesn’t seem to work for boolean.

    • Create a rule 203 (Required Property Sets)

    • Test operational feature by loading a manual entry with a boolean value that must be True, like this:

    b5fcebc2-722a-4a93-9eb8-183b7db58d5a-image.png

    • Test not operational feature by loading the “True” value from excel. I used the standard template out of the box:

    8ebb2b88-9a0d-4905-8f60-f71f646b1ee8-image.png

    This never sets to “True”, it results always in “True or False” (any value):

    3e02c8d6-59af-43f9-92a8-5781321df53c-image.png

    c

    1 Reply Last reply
    0
    • MattiM Offline
      MattiM Offline
      Matti Solibrians
      wrote on last edited by Matti
      #2

      The German Excel example for this rule has a problem.
      The true/false value in Excel for German Solibri needs to be as Text “Falsch” or “Wahr”. The Excel boolean value is not working.
      Here is the fixed example.

      Erforderliche Eigenschaftensatze.xlsx
      image.png
      37bd8a58-d96d-409c-b44a-5339d1726527-image.png

      1 Reply Last reply
      1
      • MattiM Offline
        MattiM Offline
        Matti Solibrians
        wrote on last edited by
        #3

        Note: There will be small improvement to this rule in the next release:

        • Adds support for =, ≥, ≤ operators in Excel import
        • Adds support for Excel boolean cells with all languages in Excel import
        1 Reply Last reply
        0
        • _c__ Offline
          _c__ Offline
          _c_
          wrote on last edited by
          #4

          Thank you!

          c

          1 Reply Last reply
          0

          Copyright © 2025 Solibri Inc. | Powered by NodeBB

          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories