ConfiForm Import API wrong Data Format

Maximilian Herbert
Contributor
June 19, 2024

Hey there,

 

so I have the following setup: 

I have a new Field „Test“ in my Form „Main“. It’s a Smart Dropdown field pointing on another form (with 2 values(answer1 and answer2)

I want to use the import api to give all of my existing entries in Form Main (~80) a value for this field (either answer1 or answer2) 

This works perfectly fine but there is one thing that does not work: if I want to filter the values in a table view it does not show the values correctly. 
e.G Filter is: !Test: answer1 but it still shows every entry. 
the thing is if I create a new entry and select the value answer1 in the form, it suddenly works. 

does the API import a wrong „format“? Anyone got a clue ? 

Greetz Max 

 

1 answer

0 votes
Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 19, 2024

Hi

When you import your data into the smart field - do you import an UUID of the record it is linked to?

Alex

Maximilian Herbert
Contributor
June 19, 2024

Yes. I import the record id

Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 19, 2024

record id or id?

How does it look like?

Maximilian Herbert
Contributor
June 20, 2024

ah sorry - my fault. It’s the ID. 

E.g. 

0e2100e0-4kei7-b400-7c1947e9kdb

Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 20, 2024

This looks right. Hard to tell really from here then what can be wrong

You can take a look at the RAW dataset export and see how the value differs from what you have imported with the one that you entered manually

Maximilian Herbert
Contributor
June 20, 2024

So I just compared it in the RAW dataset.
Honestly it looks exactly the same. Just as in the .XLS

 

I have a screenshot of the unfiltered database of the form.

Here you see 2 entries of the row that are not imported.

Screenshot_Import_Confiform.png

In the next picture you see two of the imported entries. As you see they differ from the ones above. Thats the only difference I can spot tho. No difference in the .xls / raw

Maybe one more thing to notice:

When you import data to this smart field you can even import data that is not existent within the smart referenced form. So in this case I could even import "Test" as value although its not a valid option.

Screenshot_Import_Confiform_2.png

 

Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 20, 2024

On the last screenshot, the way the value is rendered, actually indicates that is not found and is shown as is (looks like the text is imported, not the UUID)

Feel free to open a support ticket with us, providing the raw export to investigate

https://wiki.vertuna.com/display/VERTUNA/Support+Request+Form

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events