CSV Client Examples

Action usage examples


convertCsv

--action convertCsv --file "build/output/csvcli/convertCsvCustomizedHtml.txt" --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --propertyFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/html.properties" --columns "column3, column1"

--action convertCsv --file "build/output/csvcli/convertCsvFile.txt" --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv"

--action convertCsv --file "build/output/csvcli/convertCsvVarying.txt" --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/varying.csv"

--action convertCsv --sourceFile "-"

--action convertCsv --sourceFile "-" --columns "1"

--action convertCsv --sourceFile "-" --findReplace "aaa:111" --findReplace "ddd:222"

--action convertCsv --sourceFile "-" --outputType "json"

--action convertCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv"

--action convertCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --augments "<a href=\"https://www.google.com/#q=%1%\">%1%</a>,<a href=\"https://www.google.com/#q=%column2%\">%column2%</a>"

--action convertCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --headingAugments ",augment 2" --columns "2,1"

--action convertCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --headingAugments ",augment 2" --columns "column2,1"

--action convertCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --headingAugments ",augment 2" --columns "column2,1" --outputType "json"

--action convertCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --headingAugments ",augment 2" --columns "column2,1" --outputType "table"

--action convertCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --headingAugments ",augment 2" --columns "column2,1" --outputType "text"

--action convertCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --headingAugments ",augment 2,augment 3"

--action convertCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --outputType "json"

--action convertCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --outputType "table"

--action convertCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --outputType "text"

--action convertCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --outputType "text" --select "column2:(32)|(22)"

--action convertCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/varying.csv" --outputType "json"

--action convertCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/varying.csv" --outputType "table"

--action convertCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/varying.csv" --outputType "text"

--action convertCsv --sourceFile "build/output/csvcli/status2.csv" --columns "1" --headingAugments "%NOT_FOUND%" --verbose

--action convertCsv --sourceFile "build/output/csvcli/status2.csv" --columns "1,2,3,4,5,6,7," --headingAugments ",,Successful,Failed,Skipped,Quarantined,Build" --augments ",,,,,,<a href=\"%url%\">%build%</a>"

--action convertCsv --sourceFile "build/output/csvcli/status2.csv" --headingAugments ",State,Success,Failed" --columns "state,testsfailed,testsSuccessful" --outputType "text"

copyCsv

--action copyCsv --file "build/output/csvcli/copyCsv.txt" --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --columns "3,2,1"

--action copyCsv --file "build/output/csvcli/copyCsvAppend.txt" --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --append

--action copyCsv --file "build/output/csvcli/copyCsvColumns.txt" --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --columns "3,2" --append

--action copyCsv --file "build/output/csvcli/copyCsvDelimiter.txt" --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --columns "3,2,1" --options "delimiter=;"

--action copyCsv --file "build/output/csvcli/copyCsvEmpty.txt" --sourceFile "-"

--action copyCsv --file "build/output/csvcli/status2.csv" --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/status.csv" --columns "completed, state, testssuccessful, tests failed, tests skipped, tests quarantined, build, url"

--action copyCsv --sourceFile "-" --findReplace "aaa:111" --findReplace "ddd:222"

--action copyCsv --sourceFile "-" --findReplaceScope "data-cell" --findReplaceRegex "(?s)\\n:' '" --quiet

--action copyCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --columns "3,2,1" --select "column2:(32)|(22)"

--action copyCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/simple.csv" --headingAugments ",augment 2,augment 3"

--action copyCsv --sourceFile "/opt/atlassian/pipelines/agent/build/src/itest/csv/resources/status.csv" --headingAugments ",State,Success,Failed" --columns "state,tests failed,tests Successful"

getClientInfo

--action getClientInfo

run

--action run -i "examplegear -a getProjectlist -f @temp --limit 5 --columns 1,3,4,5" -i "csv -a convertCsv --sourceFile @temp --headingAugments \"%1%,%2%/%3%\" --augments \"%1%,%2%<br>%3%\" --outputType text --columns 1,2,4 --options tableNoWrap"

--action run -i "examplegear -a getSpaceList -f @temp" -i "csv -a convertCsv --sourceFile @temp --headingAugments # --augments %#% --columns 1,2,5 --outputType text --options tableNoWrap"

--action run -i "examplegear -a getSpaceList -f @temp" -i "csv -a copyCsv --sourceFile @temp --headingAugments # --augments %#% --columns 1,2,5 -f @temp" -i "csv -a convertCsv --sourceFile @temp --outputType text --options tableNoWrap"

--action run --options "doubleQuoteAlternative=#" -i "examplegear -a getProjectlist -f @temp --limit 3 --columns 1,3,4,5" -i "csv -a copyCsv --sourceFile @temp" -i "csv -a copyCsv --sourceFile @temp --headingAugments #%1%,'%2% %3%'# --augments #%1%,'%2% %3%'# --columns 1,2,4"

--action run --options "doubleQuoteAlternative=#" -i "examplegear -a getProjectlist -f @temp --limit 3 --columns 1,3,4,5" -i "csv -a copyCsv --sourceFile @temp" -i "csv -a copyCsv --sourceFile @temp --headingAugments #%1%,'%2% \\n %3%'# --augments #%1%,'%2% \\n %3%'# --columns 1,2,4"

runFromList

--action runFromList --list "xxx, yyy" --common "--action getClientInfo --data ~@entry@~" --special " ~"

 

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.