Forums › Cached › CSV Import
This topic contains 3 replies, has 0 voices, and was last updated by khultquist 12 years, 5 months ago.
-
AuthorPosts
-
June 15, 2012 at 11:38 am #24261
info@glowest.itGood morning,
I need to do a mass CSV item import inside a NS account, but I cannot import the data on some custom item fields because they are disabled or hidden.
Since I cannot edit the display type of these fields (they're from a locked bundle), nor create a custom form to enable hidden fields, how can I import this data?
Thank you,
Alessio
This is a cached copy. Click here to see the original post. -
June 16, 2012 at 8:34 pm #24262
felix.guinetHi Alessio,
In Advanced options of CSV Import tool, you can chose not to validate mandatory custom fields, so that your import can be successful, even if you don't have values for this kind of fields.
However, you seem to be looking for an update of disabled fields? Have you tried to do it manually in the UI? If you can't do it there, CSV import won't let you do it.
What about creating new custom item fields to store this information?
Thanks
-
June 18, 2012 at 2:08 am #24263
info@glowest.itRE: how to import data on disabled or hidden fields?
Hello Felix,
Thanks for your answer.
The custom item fields that are not accessible neither through UI nor CSV import come from a locked bundle.
The bundle is under our control (we are SDN partners), so the "best" way I know to do the import is:
– unlock the custom item fields on the deployment account (display type = normal)
– update the bundle on the customer account
– import CSV data (now the fields are visible on the field mapping UI): this will take some time and some iterations to correct CSV errors, leaving the custom item fields editable by all the users of the system
– lock again the custom item fields on the deployment account (display type = hidden)
– update again the bundle on the customer account
As you can see, the only procedure I know is very bad, causing data being accessible through the UI even on fields that should be hidden.
Do you know if there's a better way to do this import, or this is the unique way?
Thnk you again, have a nice day.
Alessio
-
June 18, 2012 at 8:14 am #24264
khultquistRE: how to import data on disabled or hidden fields?
What about using a user event script to unlock and then re-lock the fields… does a user event script have the permission level you need? If so, the script could look for a csv import, unlock the field, copy the value from a temp field, then re-lock the original field. Then when you are done with the import you can just remove the user event script from the account.
-
AuthorPosts
You must be logged in to reply to this topic.