Get output CSV semicolon separated values

[Brian Walker]

Hi, Im usin a Jira Comand Line (CLI) from bobswift

https://bobswift.atlassian.net/wiki/spaces/JCLI/pages/57639028/Example+output

is very nice, but I'm trying to get the data with semicolon (;) separated values, not comma (,)

acli --action getIssueList --filter "All Bartell Issues" --outputFormat 999 --file "test31.csv" --columns "Key,Summary,Assignee"

How I can set a delimeter parameter for the output of CSV

thanks a lot

Brian

[Ravya]

Hi @Brian Walker ,

Good day, I am Ravya Mutyala from Appfire support team. We have created a support request https://bobswift.atlassian.net/servicedesk/customer/portal/1/SUPPORT-7848 to better track your request. However, we couldn't add you as a reporter. Please sign up using this link https://bobswift.atlassian.net/servicedesk/customer/portal/1/user/signup and share the user name/id. We'll then add you as the reporter and confirm.

And with respect to your query, as of now we have only comma(,) is supported as a delimiter for CSV file export, however, we have raised an improvement for the support of semicolon (;) and our development team is actively working on the same: https://bobswift.atlassian.net/browse/ACLI-2173

Please feel to add yourself as a watcher so that you can receive all further updates that happen on the development request.

If you have any further queries please feel to signup our support channel and share us username/id so that we could discuss the issue further :) 


Regards,
Ravya

[Brian Walker]

Hi Ravya, thanks for your information, this app is very usefull, so inclusive if you have some extra delimiters during the development; I think it will be very usefull.

thanks a lot

Brian

[Ravya]

Hi @Brian Walker ,

Good day!

We would like to inform you that https://bobswift.atlassian.net/browse/ACLI-2173 is resolved and you can download the CLI snapshot from https://bobswift.atlassian.net/wiki/spaces/ACLI/pages/267233555/Downloads+-+Early+Access+Program+EAP

This is how it works after downloading the latest snapshot file.

Run your action command:

--action getIssueList --filter "All Bartell Issues" --outputFormat 999 --file "test31.csv" --columns "Key,Summary,Assignee"

And then convert the CSV file with the delimiter.

-a copyCsv --sourceFile test31.csv  --file out.csv --options delimiter=";"

You can also use other delimiters as per your requirement.

I hope the information helps.

Regards,
Ravya 

[Brian Walker]

Ravya great information that you have!

when I use the command line

"-a copyCsv --sourceFile test31.csv  --file out.csv --options delimiter=";""

did you use acli or another binary Linux or python instead?

thanks a lot!

[Avinash Bhagawati {Appfire}]

Hi @Brian Walker ,

Thanks for your response on this.

You can execute the copyCsv action same like getIssueList action from acli.

--action copyCsv --sourceFile data1.csv --file o_data1.csv --options delimiter=";"

 Please let us know if you have any issues, we are happy to help you!

Thanks,
Avinash

[Brian Walker]

Hi @Avinash Bhagawati {Appfire} thanks you very much for the clarification

Thanks

Brian