nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

CSV Import API showing blank on Confiforms

Stephen Pease

@Alex Medved _ConfiForms_ helped me figure out how to import a CSV file so that it populated in a Smart Multi-Select field in Confiforms here: Solved: How to generate a confiforms macro multi-select li... (atlassian.com)

However, I needed to update my list using a new CSV file.

I went to the page and first selected "Cleanup API" which erased all the records. Then I followed the same process for importing the files, and after selecting "View/Edit Stored Data" I can see the whole list populated correctly like below:

Populated List.PNG

However, when I go back to my field that should contain this list, it is now showing blank. Strangely, if I scroll, it appears that the correct amount of records are there (it takes a long time to scroll and there are roughly 500 records, so it seems correct), however, everything is blank. See below:

Anyone have any idea what I might have done wrong? I appreciate any help. Additional info on the import is I am importing a single column CSV file using UTF-8 (and that is how the CSV was saved), but the list is correct on the page that holds the records, so not sure what is going wrong when linking the Confiform Macro so the Smart Multi-Select populates with the records (that are not blank). Thank you!

Accepted answers

Alex Medved _ConfiForms_

You are talking about updating your data, but at the same time use clean up APIs to remove it and then import APIs to import NEW data

This does not sound like an UPDATE

From what I can see on a screenshot is that you reference a "SkillName" field, but imported your data into a "Skill" field. So it basically does not have a "label" to show for the choices in the dropdown field and renders it as blank

Alex

All comments

Alex Medved _ConfiForms_

You are talking about updating your data, but at the same time use clean up APIs to remove it and then import APIs to import NEW data

This does not sound like an UPDATE

Alex

Stephen Pease

Hi Alex,

That is what I was thinking, but not sure where I am going wrong or where to fix that labeling. I was using clean up APIs because it removed all the records rather than me having to individually delete each one (or a large collection of them). Since a fair amount of changes to the list were required, I had assumed the fastest way was to remove all and just re-import a new list. When I look at the label it says "Skill [SkillName]" as you noted, but not sure which part applies to which part. In my CSV file it is just a column with a heading called "Skill."

Here are the steps I am taking, and for good measure, I changed the column heading to SkillName in the CSV, but I imagine I am doing something wrong at the import step.

1. After clean up API, the records are gone, now I import the CSV

2. Select the CSV file to import and click next

3. The next step is where I imagine I am doing something wrong. I am met with this window and normally I would just select the top left checkbox, which selects all records, then use the dropdown to select "SkillName" and import the records. I also normally de-select the "SkillName" header (I have also tried selecting it, but it just shows up as a record rather than a label or header).

4. Skills are imported along with the header (I can always remove it)

5. The list is still blank and the label has the strange "Skill [SkillName]" wording.

Any ideas where I am going wrong or how to fix the labeling if that's the issue? I'm at a loss. Thank you!

Alex Medved _ConfiForms_

Hard to tell really... Doe it render the same on the form? (not in preview mode)

Stephen Pease

Unfortunately yes. It's identical, where it appears to be the entire list of 500+ records, but just blank. It worked so perfectly before and I'm just not sure what happened differently. I agree with you though that the "Skill [SkillName]" could be a problem, just not sure why or where to fix it.

The whole list is there on the page being referenced and it looks perfect, but once I try to point to that list from a Confiforms macro, it shows blank BUT with the caveat that there are 500+ blank entries, so it at the very least is seeing the count of records, just not the records themselves. Is there another page or setting that I may be missing or something else that gets erased when I do a "Clean up APIs"?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

csv

confiforms