Import data in Table Grid

I have a CSV file which has lot of records. Each records contains a column which is of type "table". How can i import this data in JIRA? I am using tableGrid from Idalko.

Thanks,

Ankit

1 answer

This widget could not be displayed.

I hope you got an answer to this already.  I figured out that you have to do a 2 fold import of data.  I'm looking for a better way the next time i need to do an import to that plugin field, so i'm open to new ideas, but here is what i did.

  1. Import a number to the "Table Grid" field via the CSV import in JIRA
  2. Query the database to get the internal ID of all the issues you want to add the table values to.
  3. Use Excel to match up all the table grid field rows to their appropriate JIRA issue internal ID.
  4. Create a table in Excel with all the appropriate values for all your columns in your table grid editor table except the auto-incrementing ID column.
  5. Use your preferred DB insert method to insert the new rows into your table grid editor DB table.
    1. I prefer to use Talend Open Studio for Data Integration
      1. This allows you to read the actual Excel file and specifically transform the data in the application before it inserts into the db.
  6. Import another CSV similar to #1 above.  Import with a number into the "Table Grid" field which is equal to the number of rows in the Table Grid field that you imported manually into the database.

If you insert the data into the Table Grid Editor field's DB table before importing the number to the field via CSV, then the data will be in the table in the DB, but it won't show the field on the issue.  If you then import the number to the field via CSV import, it will then delete all the rows you added to the Table Grid Editor field's DB table.  So, you have to make sure you perform the action specifically in the order above.

Hope that helps if you haven't gotten an answer yet, and if you found a better way, please share.  Thanks.

Adam

 

*edit: I added the 6th step so that JQL filters such as "Table Grid Field" IS NOT EMPTY will work correctly because in step 1, the plugin will set the value to 0 in the db, which means that it is empty, so you have to import the number value again to get JQL to work.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published yesterday in Marketplace Apps

The 7 hacks of highly successful automation

...there's anything I've learnt from working, it's that people are lazy! No offense to anyone reading this, but it's true and we can all admit it. The easier you make something for someone, the more...

143 views 0 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you