Exportación de datos a excel cortada o registros mezclados

Question

Hola a todos!!!

Estoy trabajando con filtros de Jira, el cual tengo guadado ya hace un tiempo. desde hace unos días al exportar los resultados en formato csv, seleccionando campos filtrados, para que me traiga las columnas que le puse el filtro, me está andando mal de la siguiente forma:

Si el filtro me da mas de 1000 registros por ejemplos 1200, solo expota en excel hasta la linea mil

Otra cosa que me psaso es que me trajo un registro con datos mezclados.

les ha pasado?

Gracias

Ana

Hannes Obweger - JXL for Jira · Answer

Hi @Analia Busso

just to add to Samuel's answer: If you're open to solutions from the Atlassian Marketplace, there's a number of apps available that work around Jira's 1000 issues limit. E.g., my team and I work on an app in which your export would be easy to do, without any further configuration or scripting: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Plus, you can export your issues to CSV or Excel in just two clicks, like so:

As mentioned above, JXL works around Jira's 1000 issues limit, so you can easily export your 1200 issues (and many, many more) in one action.

Any questions just let me know,

Best,

Hannes

Samuel Gatica _ServiceRocket_ · Answer

Hola @Analia Busso

Jira solo puede exportar 1000 incidentes a un CSV .

El siguiente documento muestra dos opciones alternativas para poder extraer el resultado completo Export Over 1000 Results to Excel from Jira Cloud

Yo personalmente te recomiendo usar Jira Cloud for Sheets

Use Jira Cloud for Sheets

Saludos

Sam