Tickets via CSV/spreedsheet in jsm portal

[Mark]

Hi everyone,

We’ve set up an jsm instance for which we need that the end user should upload a CSV/spreadsheet and it has all the data like item name type quantity ... Etc and for each item jsm should create a ticket for it can you please suggest me any way to do so

[Andrea Robbins]

Hi Mark,

This would be available only via the REST API/scripting. When a ticket with the CSV file is attached is created, you could to a GET request to get the attachment from the ticket and a POST request to create the work items. Please read the documentation for more details on how to use these endpoints:

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-attachments/#api-rest-api-3-attachment-content-id-get

https://developer.atlassian.com/cloud/jira/service-desk/rest/api-group-request/#api-rest-servicedeskapi-request-post

However, just because something is possible, it doesn't make it best practice. I would reconsider why this requirement is needed as the people can create the tickets directly from the portal/Jira instead of having the CSV file import.

Thanks,

Andrea

[Trudy Claspill]

Hello @Mark 

Creating work items/tickets by uploading a CSV through the customer portal is not an available feature.

CSV imports can be done only by licensed user/agents and administrators of the Jira/JSM application, and only through the internally available UI, not through the customer portal.

[Trudy Claspill]

And there is not a native method to have JSM read an attached CSV file to then automate creation of the tickets. 

You could, however, have the customer submit one ticket with the CSV file attached and then have a JSM agent or admin create the tickets by executing the CSV file import.

[John Funk]

Hi Mark,

See that link below for guidance on importing from a CSV file. You will need to be an administrator to be able to do that. Also note that dates should be in the format in the CSV (and during the import use the same format) of YYYY-MM-DD.

https://support.atlassian.com/jira-software-cloud/docs/import-data-to-a-software-project-using-a-csv-file/

Try it first with just a handful or rows in the CSV to ensure you have things in order. 

[Mark]

Hi @John Funk  

I got your point but my requirement is to allow end users to upload the CSV/Spreedsheet via JSM PORTAL. That automatically creates new tickets is there any way we can do so

[John Funk]

No, that is not permitted for end users to submit CSV files to bulk create work items. That would be a dangerous practice. 

[Mark]

Can you please help me with any alternative and why it should be marked as a dangerous practice 

[Marc -Devoteam-]

Hi @Mark 

I agree with all the answers from my fellow community members ( @Andrea Robbins @John Funk @Trudy Claspill @Joseph Chung Yin )

My intiial question is why do you want this?

When using a JSM space you have a portal where members can raise tickets, with the information you require to be provided or use an email channel.

[Mark]

Hi @Marc -Devoteam- 

In my org my requirement is that sometimes it has to list of items for which they need to create a number of tickets for the assets quantity that needs number of tickets to be created on a one go and that too we need separate tickets for reporting purpose so instead of creating numberous tickets manually I want the users to create the tickets from there spreedsheet file and also we don't want to add them as an ajent in the insance they can add the tickets as customers

Based on this requirement we need this feature

[Marc -Devoteam-]

Hi @Mark 

As other members mention, this is not an option directly from a file, there needs to be an initial ticket created with the file attached, see the solution provided by @Andrea Robbins 

But it's a solution that is no recommended and it's bound to fail in cases, based on strange characters in the CSV wrong date formatting etc..

You could look a specific request on the portal where you ask this information in a form an based on a number field (also) in the form have an automation create the related number of ticketsd

[Joseph Chung Yin]

@Mark 

I agreed with @John Funk / @Trudy Claspill suggested.  Customers via Issue Portal to create issues using CSV file is not possible.  One will need full admin rights to create issues via CSV only via the Admin UI  or you will need to create custom REST APIs program as mentioned by @Andrea Robbins .

Sorry...

Best, Joseph Chung Yin