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; } } }

How to generate a confiforms macro multi-select list from a csv file

Stephen Pease

Hi all,

I'm a bit of a newbie, but have been working with the confluence suite for a little bit and made some decent spaces using the confiforms macros. The most code I have stepped into is leveraging usernames for personalized emails from the IFTTT macro.

I couldn't find specifically what I am trying to do and hopefully it is simple.

I would like to populate a confiforms multi-select macro from a csv file. I have made these dropdowns before and they work great with the ability to type search and collect results, but I have a single column with about 500 entries and using the macro is taking a long time and as I reach roughly 150 I am noticing the macro choking when trying to save (it just spins and when saving or updating the page it doesn't take).

I having a hard time trying to find out how to take the list I have and essentially drop it into the confiforms macro for multi-select. Is this possible? The manual way is rough to say the least and I actually don't know if that many entries is a culprit of the slow response times. Thank you for any help you can offer!

Edit: To add a little more about what I'm trying to do:

I am having users enter in their skill sets and using a huge list of potential choices in a form that they can submit. Smaller dropdowns and multi-select have worked fine in the past, but I haven't had a list this big before. I came back after a few hours and it's still very sluggish and I can't seem to get past 160 entries but I'm not sure if this is a limitation of the macro. Also added some images for clarity in case I am using the wrong syntax in describing what I am using. Thanks again.

-------------

This is what I see when I try to save:

skill error.PNG

-------------

Here is the settings (multi-select)

---------------

Here is all I am able to get in the macro (160):

skill macro end list.PNG

Accepted answers

Alex Medved _ConfiForms_

Most probably you hit the limits on the macro parameter length that Confluence has (never seen this documented though)

Overall it is not a good method to put so many options into the configuration

Much better approach is to use OTHER form to import you data and then use it in the current form via Smart fields or using the CSV directly (basically a "web-service" like field)

This one is about excel file to be used as a source for ConfiForms field - https://wiki.vertuna.com/display/CONFIFORMS/Using+Excel+files+as+sources+for+ConfiForms+fields

But the 1st mentioned approach to use ANOTHER for keeping and managing choices in your field is a much better approach

Alex

All comments

Alex Medved _ConfiForms_

Most probably you hit the limits on the macro parameter length that Confluence has (never seen this documented though)

Overall it is not a good method to put so many options into the configuration

Much better approach is to use OTHER form to import you data and then use it in the current form via Smart fields or using the CSV directly (basically a "web-service" like field)

This one is about excel file to be used as a source for ConfiForms field - https://wiki.vertuna.com/display/CONFIFORMS/Using+Excel+files+as+sources+for+ConfiForms+fields

But the 1st mentioned approach to use ANOTHER for keeping and managing choices in your field is a much better approach

Alex

Stephen Pease

Hi Alex,

I feel like I'm getting close but am still a bit stuck. To your first point, you are correct, the macro starts getting errors and slowing around 150 entries, so I think that is about the limit for a multi-select from manual entry.

The second option you presented isn't an option for me, as I can't install additional APIs (provided I'm reading that instruction correctly).

The first option sounds about correct, but I am still having trouble pointing my multi-select form to the existing data.

I can make a CSV Table using the BobSwift CSV Table macro and it displays fine as a nice searchable tool for folks wanting to look at available skills, but I am trying to point to that single column of skills so that they populate in a multi-select dropdown for confiforms.

It feels like I am doing something backwards because when I open a new confiforms form field definition macro and try to use "Smart Multi-select" it is looking for a field, but that list doesn't exist as a field, so I can't figure out how to point it to that list as a field. The options are the other confiforms fields on the page, so I seem to be caught where I need to define the form when trying to create it.