Home Home
  login

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.




Importing Excel Flat File into existing project

migration

Hello there, I have been trying to import issues into an existing project, to no luck.

I am now trying 1 issue to minimalize the chance on problems and that even does not work. It keeps sayng I have an invalid file / data and tells me to check the mandatory fields. It's an xls file and I have all the right fields included so I'm guessing maybe it's the data type. Something which I cannot find in the manual.

Anyone feel like checking?

issue number - 5000 issue title - blah blah project id - 43 project name - myproject project description - myproject description Project Archived - FALSE Project Read only - FALSE Project Leader Name - Project Security Scheme ID - 1 Type Scheme ID - 4 Priority Scheme ID - 2 Severity scheme ID - 2 Work Flow Scheme ID - 4 Component ID - 288 Component Name - NA Component Description - NA Version ID - 138 Version Name - 2010 Version Description - 2010 Version Number - 2010 Version Order - Version Released - FALSE Fixed in Version ID - 138 Affected Version ID - 138 Issue Components ID - 288 Raised By - Start Date - 29/03/2011 Due Date - 30/03/2011 Assigned To - coxg Type - Bug Priority - Low Severity - Blocking Issue Status - Solved Resolution - Complete Estimated Days - Estimated Hours - Estimated Minutes - Detailed Description - blahblah Comments - Commented By - Closing Comment - CustomFields ID - CustomFields Value -

I also have some questions:

The example flat file indicates that a project Id could be P001. In the database it's a numeric so I entered 5000 (which is higher then the highest current issue in our database) Is this correct? I also do this for the , Version ID and Component ID

Btw: I cant use the Import into existing ptoject(s) checkbox: it's grayed out

Thanks for any help!

NiQuil

NiQuil
· 1
NiQuil
Replies (3)
helpful
0
not helpful

Please send us the file and we will look into it: support at countersoft dot com. Project Id must be numeric the Pxxxx is just for display.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Thanks! I will send it now.


NiQuil
· 1
NiQuil
helpful
0
not helpful

Hi ,

Did you get this to work?

Getting the following error :

00000388 494.33026123 [4616] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Start assigning to issue FixedInVersion of source ID is 54
00000389 494.33026123 [4616] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Assigned issue FixedInVersion of destination ID is 54
00000390 494.33029175 [4616] CounterSoft.Gemini.DataImport 3.7.2 Build 2784: Issue skipped not created due to matched component not mapped. Source Issue Id is 287

Regards, Ganesh


dganeshm
· 1
dganeshm