import attachments from csv file

[gonzalo zegarra]

Hi

Could you tell me an example of importing attachments from csv file?

i want to create massive issues and i need each issue has an attachment file.

thanks

[Arthur Gonçalves]

Hello Gonzalo,

As stated on the official documentation for CSV import:

Importing attachments

You can attach files to issues created from your CSV file. To do this, specify the URL of your attachment in an 'Attachments' column within your CSV file.

Assignee, Summary, Description, Attachment, Comment

Admin, "Issue demonstrating the CSV attachment import", "Please check the attached image below.", "https://jira-server:8080/secure/attachment/image-name.png", "01/01/2012 10:10;Admin; This comment works"

Admin, "CSV attachment import with timestamp,author and filename", "Please check the attached image below.", "01/01/2012 13:10;Admin;image.png;file://image-name.png", "01/01/2012 10:10;Admin; This comment works"

 URLs for attachments support the HTTP and HTTPS protocols and can be any location that your JIRA server must be able to access. You can also use the FILE protocol to access files in the import/attachments subdirectory of your JIRA Home Directory.

I hope it helps you! 

-- Arthur Gonçalves

[gonzalo zegarra]

hi this is the url: D:\Perfiles\17550001\Desktop\desempe\file1.xls D:\Perfiles\17550001\Desktop\desempe\file2.xls (i have 100 files) how can i indicate that url in the csv file that i'm going to import? thanks

[jawedshaikh]

Hi @Arthur Gonçalves ,

How to import multiple attachment for single issue.

[Sravan Kumar]

Hello All,

I am trying to bulk import with attachments, to start with I just tried and tested with 1 attachment, and it throwing me the error.

I placed the attachment in the imports folder and gave the location in the attachments column but its not taking it: I am giving the location correct? Please see the below Image and advice.

Thank You!!

[Luciano Fagundes]

Gonzalo,

You should add the attachment files into $JIRA_HOME/import/attachments folder. After that, mention the file name on the CSV file to be imported without the entire folder path (refer example below):

Assignee, Summary, Description, Attachment, Comment
Admin, "Issue demonstrating the CSV attachment import", "Please check the attached image below.", "https://jira-server:8080/secure/attachment/image-name.png", "01/01/2012 10:10;Admin; This comment works"
Admin, "CSV attachment import with timestamp,author and filename", "Please check the attached image below.", "01/01/2012 13:10;Admin;image.png;file://image-name.png", "01/01/2012 10:10;Admin; This comment works"

That should do the trick!

Cheers

L.F

[CMON.Consulting]

Hey!

I have not found much clarifications on the following:

If I am a common user on the system; how can I access a storage for attachments that can be accessed during CSV file import?

Lucianos reply is not sufficient to Gonzalez question unless he has access to the $JIRA_HOME file system

And I would think most users on corporate levels have no access to this...

So: how can you create a valid URL for csv file import of attachments without admin privileges?

[Maurício Britto]

Hello

I have other error:

Cannot parse 'file://C:/Program Files/Atlassian/Application Data/JIRA/data/attachments/HS/10000/anexo.png' as attachment info: Illegal character in path at index 17: file://C:/Program Files/Atlassian/Application Data/JIRA/data/attachments/HS/10000/anexo.png

File Contents:

ID,TIPO,AREA_TI,CATEGORIA,SUBCATEGORIA,TERCEIRA_CATEGORIA,TIPO_CHAMADO,TITULO,STATUS,STATUS_MACRO,SOLICITANTE,RESPONSAVEL,PRIORIDADE,DATA_SOLICITACAO,DATA_ENCERRAMENTO,DESCRICAO,PENDENCIA,SOLUCAO,RFC,ANEXO
"66973","Solicitação de serviço","SUPORTE","Sistemas","IFS","Solicitação de Acesso","Suporte","GTAS","Encerrado","Fechado","Jonatas Araujo Lopes Silva","Marcio Roberto Vera","Normal","2020-09-01","2020-09-09","Não estou conseguindo acessar o programa em nenhum PC","","Boa tarde! Favor efetuar nova tentativa de acesso. Qualquer problema entrar em contato com o ramal 1142 ou 1116.","0","file://C:/Program Files/Atlassian/Application Data/JIRA/data/attachments/HS/10000/anexo.png"

Can you help me?

Best regards

Mauricio