We have a confiform which has a smart classifier field with source from a different form for values. How do we import data into the confiform for the field as we have 1000+ rows to be imported with numerous fields
Form 1: 3 fields (Region, Country, City)
Form 2: 2 Field (Location), defined as smart classifier referenced to fields in Form 1 and Building, etc,
Form is working fine for new entries, but we would like to import records from a .csv file
What is the template / value we must have for location field while importing from CSV?
Europe, UK, London, Shard
We have tried different delimiters and it doesn't accept and we have tried changing the delimiter to | in order to avoid the , as delimiter but still fails.
Can you advise please?
As any "smart" field in ConfiForms, the smart classifier holds a reference to records. Basically an ID (in the UUID format) to the record it references
When you import your data from CSV you import "internal" values, that means for smart fields we expect the UUIDs
Thanks for the swift response.
(1) when we try to reference the id, it returns only the values as the fields in the source form are text fields.
(2) The form where the smart classifier is defined, if we try to return the value of id as NWINVMGTLocation.id it returns blank
(3) Plus, when you import what is the delimiter you will use to denote the value set as defined "Asean and South Asia : Asean : Singapore : Singapore : Changi"
Sorry, if these are basic questions but just we are stuck as we have large dataset and this will help significantly
Below is the sample export of the form values (example)
Location NWINVMGT Location.MasterRegion.id
Asean and South Asia : Asean : Singapore : Singapore : Changi Business Park Asean and South Asia
Africa and Middle East : Middle East : United Arab Emirates : Abu Dhabi : Etisalat Africa and Middle East
Greater China and North Asia : North Asia : Taiwan : Taoyuan : LongTan DC Greater China and North Asia
I think there is a misunderstanding here... each record has a unique ID in ConfiForms
When you have smart fields in your forms then they are connected to some other forms, right? And when you store the value into one of such fields you actually store an ID of a record from a target referenced form.
This is something like 770477f1-bf16-4d0d-bc8a-50612253f3ac
And these unique "values" you need to import via Import API when you want to import a value to a smart field
Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond. A long time favorite, Team Cale...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events