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
------------------------------
Comments
-
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 itemsI 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 Sonosite0 -
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 itemsI 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 itemsI 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
------------------------------
0