How to delete the content of a field on multiple items

arnaud laroche
arnaud laroche Member, Data Exchange Posts: 2

I would like to delete the content of a field ("description") of 70 items. The field is a fully customizable one (HTML).

I thought I could do that with a round trip export/import: 

  • exporting the 70 items in Excel
  • making the cells of the column "description" empty
  • re-importing the field "description"

It doesn't seem to work.

Am I doing something wrong?

Thank you

------------------------------
arnaud laroche
------------------------------

Comments

  • Alex Frain
    Alex Frain Member, Data Exchange, Jama Connect Interchange™ (JCI) Posts: 27
    edited June 2023

    I just tried this out in our Test instance running 8.79.3 and encountered the same "issue".  I performed a roundtrip export of some items, deleted the text from some of the items' description fields, and performed a roundtrip import.  The post import window indicated 0 items were updated and I confirmed none of the description fields were cleared in Jama.

    I did a 2nd test where I updated the text in the description for a single item in the roundtrip Excel file that was originally generated and left the description field cells blank that I cleared the first time.  I performed another roundtrip import and the single item whose description I updated did get updated in Jama but the items' whose descriptions I originally cleared in the Excel file were still not updated.

    The description field for this item type in our Jama instance is not set to "Required" so I would assume this should work.

    ------------------------------
    Alex
    Fujifilm Sonosite
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 06-23-2023 08:06
    From: arnaud laroche
    Subject: How to delete the content of a field on multiple items

    I would like to delete the content of a field ("description") of 70 items. The field is a fully customizable one (HTML).

    I thought I could do that with a round trip export/import: 

    • exporting the 70 items in Excel
    • making the cells of the column "description" empty
    • re-importing the field "description"

    It doesn't seem to work.

    Am I doing something wrong?

    Thank you

    ------------------------------
    arnaud laroche
    ------------------------------
    Alex
    Fujifilm Sonosite
  • arnaud laroche
    arnaud laroche Member, Data Exchange Posts: 2
    edited July 2023

    Thank you Alex for the confirmation of the "issue" in your environment too.

    Best regards,

    Arnaud.

    ------------------------------
    arnaud laroche
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 06-27-2023 09:29
    From: Alex Frain
    Subject: How to delete the content of a field on multiple items

    I just tried this out in our Test instance running 8.79.3 and encountered the same "issue".  I performed a roundtrip export of some items, deleted the text from some of the items' description fields, and performed a roundtrip import.  The post import window indicated 0 items were updated and I confirmed none of the description fields were cleared in Jama.

    I did a 2nd test where I updated the text in the description for a single item in the roundtrip Excel file that was originally generated and left the description field cells blank that I cleared the first time.  I performed another roundtrip import and the single item whose description I updated did get updated in Jama but the items' whose descriptions I originally cleared in the Excel file were still not updated.

    The description field for this item type in our Jama instance is not set to "Required" so I would assume this should work.

    ------------------------------
    Alex
    Fujifilm Sonosite
    ------------------------------

    Original Message:
    Sent: 06-23-2023 08:06
    From: arnaud laroche
    Subject: How to delete the content of a field on multiple items

    I would like to delete the content of a field ("description") of 70 items. The field is a fully customizable one (HTML).

    I thought I could do that with a round trip export/import: 

    • exporting the 70 items in Excel
    • making the cells of the column "description" empty
    • re-importing the field "description"

    It doesn't seem to work.

    Am I doing something wrong?

    Thank you

    ------------------------------
    arnaud laroche
    ------------------------------