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.




Can import the first 30 rows from Excel, then get error

admin
database
Excel

Up till half an hour ago, import from Excel was working fine. I imported the first 30 rows from a file, but then I got the message:

"There seems to be a problem accessing the 'app_data/imports' folder. Please ensure you have given 'everyone' modify access to this folder.

I deleted the first 30 imported rows from the Excel file, then logged out and logged in again - but I still get the same message.

Any advice?
OldGrantonian
· 200 		OldGrantonian
Wednesday, November 14, 2012, 9:59:26 AM
Replies (7)
helpful
0
not helpful

Any errors in the system log?
Mark Wing
· 9108 		Mark Wing
Wednesday, November 14, 2012, 10:29:04 AM
helpful
0
not helpful

Here is an update.

Since my last post I have successfully uploaded a 2-row file. But I can't upload the same 2-row file again.

Sometimes, on entry to the Upload dialog, I choose a file, but the the first occurrence of the "Next" button is visible, but inactive. Sometimes that same button has an Ajax circular progress indicator.

It seems to me that the Gemini functionality is misbehaving, rather than any problems with our file permissions.


OldGrantonian
· 200 		OldGrantonian
Wednesday, November 14, 2012, 10:33:21 AM
helpful
0
not helpful

Update. I've successfully loaded the 2-row file once, and failed the second time.

Here are the errors, they occur in pairs. Let me know if you need the complete messages.

//////// could not insert: [Countersoft.Gemini.Commons.Entity.Issue][SQL: INSERT INTO geminiissues (projectid, reportedby, mailboxid, originatortype, originatorreply, originatordata, originatorprocessed, parentissueid, isparent, hierarchykey, repeated, fixedinversionid, issuetypeid, issuestatusid, issuepriorityid, issueseverityid, issueresolutionid, affectedversions, resources, components, watchers, votes, points, percentcomplete, estimatehours, estimateminutes, loggedhours, loggedminutes, visibility, summary, longdesc, userdata1, userdata2, userdata3, startdate, duedate, resolveddate, closeddate) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select SCOPEIDENTITY()] NHibernate at ..................

///////// String or binary data would be truncated. The statement has been terminated. .Net SqlClient Data Provider at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at ...........................
OldGrantonian
· 200 		OldGrantonian
Wednesday, November 14, 2012, 10:46:16 AM
helpful
0
not helpful

Please send us the file to support
Mark Wing
· 9108 		Mark Wing
Wednesday, November 14, 2012, 10:52:39 AM
helpful
0
not helpful

Do you mean the Excel file?
OldGrantonian
· 200 		OldGrantonian
Wednesday, November 14, 2012, 11:40:11 AM
helpful
0
not helpful

Yes please (import file)
Mark Wing
· 9108 		Mark Wing
Wednesday, November 14, 2012, 11:48:45 AM
helpful
0
not helpful
ANSWER

Looks like a false alarm.

Someone had entered a description in the "Title" field in Excel. So, the field was longer than the (very generous) permitted number of characters.

Thanks.
OldGrantonian
· 200 		OldGrantonian
Wednesday, November 14, 2012, 1:54:41 PM