Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Can't import issues via CSV

database
migration

I've been trying to import issues into our Gemini instance with the data import utility (v4.2.1) via CSV. I can successfully import products, but the issues are never carried over. I even tried importing an unmodified copy of the sample CSV, and still no issues were imported, only the products. How do I get issues into my instance using CSV?

KSUser
· 1
KSUser
Replies (4)
helpful
0
not helpful

Do you get any errors? If so what are the errors? Which version of IIS are you running?


Simran
· 1762
Simran
helpful
0
not helpful

I receive "5 Project(s), 0 issue(s) imported successfully. To view detail click on View log". There should be ten issues imported.

This appears at the end of the output from DebugView:

00000213 4.72712851 [2468] CounterSoft.Gemini.DataImport 4.2.1 Build 3250: Create table of custom fields
00000214 5.57382011 [2468] CounterSoft.Gemini.DataImport 4.2.1 Build 3250: Exception occurs on custom fields creation. Exception has been thrown by the target of an invocation.
00000215 5.57382011 [2468] An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
00000216 5.57382011 [2468] An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
00000217 5.57382011 [2468] An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name. :: CounterSoft.Gemini.WebServices :: at CounterSoft.Gemini.WebServices.BaseService.ThrowResponseException(WebResponse response)
00000218 5.57382011 [2468] at CounterSoft.Gemini.WebServices.BaseService.ProcessResponse[T](String url, Object obj, RequestType requestType)
00000219 5.57382011 [2468] at CounterSoft.Gemini.WebServices.BaseService.GetResponse[T](String url, Object o, RequestType r)
00000220 5.57382011 [2468] at CounterSoft.Gemini.WebServices.CustomFieldsService.CreateCustomFieldLookup(CustomFieldLookupEN lookup)
00000221 5.57382011 [2468] at CounterSoft.Gemini.DataImport.Mapping.CustomFieldsImporter.ImportCustomFields(Hashtable& projectsLUT)
00000222 5.59325600 [2468] CounterSoft.Gemini.DataImport 4.2.1 Build 3250: Exception occurs . Invalid URI - Requested Resource could not be found. :: CounterSoft.Gemini.WebServices :: at CounterSoft.Gemini.WebServices.BaseService.ThrowResponseException(WebResponse response)
00000223 5.59325600 [2468] at CounterSoft.Gemini.WebServices.BaseService.ProcessResponse[T](String url, Object obj, RequestType requestType)
00000224 5.59325600 [2468] at CounterSoft.Gemini.WebServices.BaseService.GetResponse[T](String url, Object o, RequestType r)
00000225 5.59325600 [2468] at CounterSoft.Gemini.WebServices.CustomFieldsService.DeleteCustomField(Int32 id)
00000226 5.59325600 [2468] at CounterSoft.Gemini.DataImport.Mapping.CustomFieldsImporter.ImportCustomFields(Hashtable& projectsLUT)
00000227 5.59325600 [2468] at CounterSoft.Gemini.DataImport.Mapping.BaseImporter.Importprojects()
00000228 5.59786510 [2468] CounterSoft.Gemini.DataImport 4.2.1 Build 3250: 5 Project(s), 0 issue(s) imported successfully.
00000229 329.01718140 [2468] CounterSoft.Gemini.DataImport 4.2.1 Build 3250: End Importing


KSUser
· 1
KSUser
helpful
0
not helpful

We are running IIS 7.


KSUser
· 1
KSUser
helpful
0
not helpful

In order for you to import custom fields you have to create the custom fields in Gemini first. Otherwise remove them from the CSV.


Simran
· 1762
Simran