ConfiForm Import API wrong Data Format

[Maximilian Herbert]

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 

[Alex Medved _ConfiForms_]

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]

Yes. I import the record id

[Alex Medved _ConfiForms_]

record id or id?

How does it look like?

[Maximilian Herbert]

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

E.g. 

0e2100e0-4kei7-b400-7c1947e9kdb

[Alex Medved _ConfiForms_]

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]

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.

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.

[Alex Medved _ConfiForms_]

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