Announcement

Collapse
No announcement yet.

Calculation of workflow when importing data

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Calculation of workflow when importing data

    This bug is about import and workflow

    There are 2 entities, entity_parent and entity_child, there is a many to one relationship between entity_child and entity_parent
    In entity_parent, there is a float field, total_value, which is the sum of float field ind_value of all its child, entity_child.
    and there is workflow for entity_child, when a entity_child is created, update the total_value of its parent, entity_parent by below formula

    entity_parent.total_value = entity_parent.total_value + entity_child.ind_value

    It works perfectly when i add the entity_child using web UI, the total_value of entity_parent shows the correctly value.

    However, when i import entity_child using import page with csv file, the total_value of entity_parent shows the wrong value

    e.g.

    ​​​ind_value of entity_child 1 = 1.5
    ​​​ind_value of entity_child 1 = 2.5

    after import total_value of entity_parent = 3
    if i add above 2 records using web UI, total_value of entity_parent = 4

    It seems that non-integer numbers are ignored when doing workflow calculation for import




  • #2
    Hello
    Can't reproduce. What type of field do you use? What decimal delimiter used is in system and which one is in file?

    Comment


    • #3
      the data type in crm is float
      the Field Delimiter in system and file are ","

      thanks.

      Comment

      Working...
      X