Import from Excel is not importing all columns
I am trying to import the following columns from an excel spreadsheet:
Priority, Source, Title, Description, Created, Type, ProjectId.
All columns but Source are being imported.
I have attached the xls and a screen capture of the items view in a rar archive.
H. Ray Long
· 108 |
|
Wednesday, November 7, 2012, 10:43:41 PM |
0
|
What did you map source to? |
||||
|
0
|
I mapped it to Source from the drop down list. I add a screen shot of the mapping to the import.rar archive. |
||||
|
0
|
Are you looking to import resources? Source is used for the originator of the item (email address) |
||||
|
0
|
I understand the difference between Resources and Source. I am importing the source of the item, which in our case is NOT an email and will never be. From looking at the items table 'orginatordata' is a varchar(255) it should hold any data, unless you have put unreasonable restrictions on your import function. I can enter whatever I want on the create and edit forms so baring any documentation(which is sorely lacking in my opinion) I want to import text data into this field. Is that a problem? If so maybe you should document that some where and it would have saved you and me a lot of time and frustration. |
||||
|
0
|
I received the following error when trying to import from excel. Unhandled exception: 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()]. Stack trace: at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder)
at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Object obj, ISessionImplementor session)
at NHibernate.Action.EntityIdentityInsertAction.Execute()
at NHibernate.Engine.ActionQueue.Execute(IExecutable executable)
at NHibernate.Event.Default.AbstractSaveEventListener.PerformSaveOrReplicate(Object entity, EntityKey key, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess)
at NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess)
at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event)
at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent event)
at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event)
at NHibernate.Impl.SessionImpl.FireSave(SaveOrUpdateEvent event)
at NHibernate.Impl.SessionImpl.Save(Object obj)
at Countersoft.Foundation.Data.Repository |
||||
|
0
|
ANSWER
Never mind. I found the cause of the error. You may want to consider a little better error message on your import if it fails. The import form gave me an error making me think the permission on the App_Data\Imports folder in the web application folder on the server did not have the correct permissions. |
||||
|