Cannot update multiple component subscribtions through csv import

w.bos January 11, 2024

I have a CSV with one subscriber and I want to update its subscriptions to components.

I use this format:

  • email,NAME@MAIL.EXAMPLE,yes,COMPONENTCODE1,COMPONENTCODE2

The import only results in addressing the first component ID:

  • - when it is the same ID as the first component that is allready subscribed to, it does nothing;
  • - when it is not the same as the first component allready subscribed to, it changes it. (So the first component ID in de CSV is now the only one subscribed to.)

It ignores all compontents codes after the first one... what am I doing wrong?

Note that in de documentation it says the list should be semi-colon seperated... but in the example CSV it is comma separated. Only comma works for the first component.

1 answer

0 votes
Eugenio Onofre
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 11, 2024

Hi @w.bos

Welcome to the Atlassian Community.
As stated on the official documentation, component codes column should be a semi-colon separated list of component codes that you want the subscriber to receive notifications for. 

You should use a CSV file formated as below:

  • email,NAME@MAIL.EXAMPLE,yes,COMPONENTCODE1;COMPONENTCODE2;COMPONENTCODE3

Please remember to accept this answer in case it helps you resolve this issue as it may also help other community users in the future.

Regards,
Eugenio

w.bos January 16, 2024

Thanks Eugenio,

  • When I use "," as a seperator, at least it uses the first ID to subscribe to.
  • When I use ";" as a seperator between the ID's, it does nothing (there is no update, even if there are different ID's used).

Note that in the example upload file, the file has only "," a seperator...

Email Subscribers,,,,,,,,,,,,,,
type,email address,skip confirmation notification,component codes (optional),,,,,,,,,,,
email,first_email_subscriber@statuspage.io,yes,n097s9kg06ry,,,,,,,,,,,
email,another_example@statuspage.io,yes,0bnr0wzc16dv,,,,,,,,,,,
email,example_subscriber@statuspage.io,yes,0bnr0wzc16dvn097s9kg06ry
,,,,,,,,,,,,,, 
w.bos January 16, 2024

I have found the solution!

Until the first component ID it uses "," as a seperator.

From the first component and beyond it uses "tabs".

Eugenio Onofre
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 16, 2024

Great it worked! Documentation says it is semicolon so I will report it back to atlassian.

Thanks for sharing!

Like w.bos likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events