Uploaded image for project: 'Jira Platform Cloud'
  1. Jira Platform Cloud
  2. JRACLOUD-81964

Unable to import CSV file with 'Account' custom field. The value isn't mapped.

XMLWordPrintable

      Summary

      Using the CSV import, it's not possible to import the Account Custom Field provided by Tempo. The importer cannot match the value in the CSV with the existing 'Account' field value.

      Steps to Reproduce

      1. Create an Account in Tempo -> Accounts and assign to a project
      2. Create a CSV file with an 'Account' column with the same value as the Account Name that you've previously created
      3. Try to import the CSV file mapping the Account column with the Account field in Jira

      Expected Results

      The Import will successfully create/update the issues with the 'Account' value defined in the CSV file.

      Actual Results

      If the 'Account' field is not required in the Field Configuration, the issue will be properly created without the 'Account' value

      If the 'Account' field is required in the Field Configuration, the import will fail with the following error:

      Issue can't be created due to the error/s [ Account is required. ]

      Workaround

      • Using the Account ID (numerical value) mapped to the Account field instead should enable the CSV import.
      • If the field isn't required, remove the 'Account' column from the CSV file and add the value manually after the issues were created.
      • Set the 'Account' field as optional in the Field Configuration

        1. screenshot-1.png
          screenshot-1.png
          211 kB

            [JRACLOUD-81964] Unable to import CSV file with 'Account' custom field. The value isn't mapped.

            Ramiro Justet added a comment -

            Account ID is working on Cloud.

            Ramiro Justet added a comment - Account ID is working on Cloud.

            Neil Hunt added a comment -

            This is working for me (on Server) when I use the account ID rather than the key. You can retrieve a list of account IDs using
            https://YOUR_JIRA/rest/tempo-accounts/1/account

            Neil Hunt added a comment - This is working for me (on Server) when I use the account ID rather than the key. You can retrieve a list of account IDs using https://YOUR_JIRA/rest/tempo-accounts/1/account

            Martin Bayer [MoroSystems, s.r.o.] added a comment -

            It is working with account ID as value in CSV file on Server, can you try on Cloud?

            Martin Bayer [MoroSystems, s.r.o.] added a comment - It is working with account ID as value in CSV file on Server, can you try on Cloud?

            hannah.worsley added a comment -

            When I exported a csv, there wasn't a field for account so if you could validate what the mapping is looking at in terms of field and how we access this in the interim that would be a big help.

            hannah.worsley added a comment - When I exported a csv, there wasn't a field for account so if you could validate what the mapping is looking at in terms of field and how we access this in the interim that would be a big help.

            hannah.worsley added a comment -

            This is causing havoc for us as an agency!

            hannah.worsley added a comment - This is causing havoc for us as an agency!

              Unassigned Unassigned
              foselame Francisco Oselame (Inactive)
              Affected customers:
              11 This affects my team
              Watchers:
              16 Start watching this issue

                Created:
                Updated: