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

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
Community showcase
Posted Thursday in Marketplace Apps

You + one app + a desert island...

Hi all! My name is Miles and I work on the Marketplace team. We’re looking for better ways to recommend and suggest apps that are truly crowd favorites, so of course we wanted to poll the Community. ...

303 views 3 5
Join discussion

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