Importing > 6000 requests from csv into a service management project

[Dusan Spaic]

Hi,

I want to import many requests tickets (lets say 12k for example) to a single JSM project. 

I tried using External system import with my .csv file that contains maximum allowed limit of 6k tickets - at the end of the process I selected a new project name and key and after some time, everything went well - I can find my 6k tickets into this newly created JSM project.

The problem I have is that when I try to import the rest (another 6k) tickets into the same JSM project - I get the warning that project already exist. It seems that with External system import tool it is not possible to add tickets from csv file into the existing project. 

I also tried tried using a configuration import file where in the projectData section i set "isExistingProject": true but this does not make the new project creation required at the end of the import.

Importing tickets from the previously created space via csv is not a option since there is a limit of only 250 tickets per csv file.

Thanks for help

[Dave Mathijs]

Hi @Dusan Spaic maybe this documentation article can be of help: Create work items with the CSV importer

This should allow you to import (additional) work items into an existing service space.

From what I can see, there is no limit on the number of records you can import.

[Dusan Spaic]

Hi, thanks for answering.
This documentation indeed does not mention any limit in the number of work items that can be imported into a existing project - but in reality there is a 250 items limit. 

It is important to mention that I am a admin in my instance where I try to import work items.

In External System Import I am required to import work items from csv file into a new project (I cannot import into the existing one).

[Marc -Devoteam-]

HI @Dusan Spaic 

You need to provide the following columns with data in you CSV.

- Project Name" and "Project Key"

[Dusan Spaic]

Hi @Marc -Devoteam- ,

That unfortunately does not change anything. In System Settings - External System Import the interface still asks me to select a destination project in a select box, with an error message saying "A project with that name already exists".

Also, importing this kind of CSV that contains the project name and key via Search - ... - Import from CSV still has a 250-issue limitation.

[Marc -Devoteam-]

Hi @Dusan Spaic 

This is strange as that selector should only relate to the project you want to import the issue in, not to create a project.

Try to switch to the old importer via the option in the information panel.

Are you able to import the work items then?

[Dusan Spaic]

Hi @mar ,

Using old importer experience worked!
With old interface, I can select existing project and import my csv issues without getting a "A project with that name already exists" error.

So this is a bug in a new import experience that was released. 

Thanks for your help!