Uploaded image for project: 'Insight Core - Server'
  1. Insight Core - Server
  2. ICS-999

Import into an Object Attribute fails, when the Attribute has an IQL filter in the Attribute configuration.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Low
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None
    • Affected Version:
      INSIGHT 5.7.0
    • Resolved Version:
      INSIGHT 6.0.1

      Description

      Hello
      I have Insight scheme was created on 5.5 version. Working fine "manualy" creating assets and CSV impot. After upgrade version to 5.7 manualy creating assets working but CSV import doesn`t (object type error). CSV import working only if i remove object attributes filters.

      @Computer
      Name (text, label)
      Asset type (Object, reference)
      Price (Object, reference, IQL filter "Asset type"=${Asset type} )
      Country (Object, reference)
      Town (Object, reference, IQL filter Country=${Country} )

      @Asset type
      Name (text, label)

      @Price
      Name (text, label)
      Asset type (Object, reference)

      @Country
      Name (text, label)

      @Town
      Name (text, label)
      Country (Object, reference)

      @Import job
      Name (identifier)
      Asset type (Label = ${Asset type} )
      Price (Label=${Price} )
      Country (Label = ${Country})
      Town (Label = ${Town} )

      import_log:
      Unable to parse object referencing IQL for attribute ObjectTypeAttributeBean [id=5658, name=Price, type=REFERENCED_OBJECT]. Will not be able to create references for IQL Name=PC12345 com.riadalabs.jira.plugins.insight.common.exception.IQLValidationException: IQLValidationException: IQL ""Asset type"=${"Asset type"}" has invalid syntax at position 15 with error message "mismatched input '"Asset type"' expecting

      {<EOF>, ' '}

      "

      Unable to update references on object PC12345 (null), ObjectTypeId: 413, Attributes: ...............[CREATE, HAVING_OBJECT_REFERENCE] due to validation exception. Check your attribute configuration <rlabs-insight-attribute-5658,The attribute 'Town' requires at least 1 value/s>

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mathias Mathias Edblom [Riada]
                Reporter:
                roman.bogancev@gmail.com Roman
              • Votes:
                2 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: