Community
Showing results for 
Search instead for 
Do you mean 
Reply

Excel import error using 2011

Copper Contributor
Posts: 20
Country: United States

Excel import error using 2011

Hi, I am testing ACT Premium 2011, and when I try to import a file with 112 records from Excel to ACT, it imports the first 5 records, and then fails. Here is the message I get.  Any ideas?

 

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
   at Act.Framework.DataExchange.Act7.DatabasePhoneEntity.ToString()
   at Act.Devices.Entities.EntityFieldData.GetStringValue()
   at Act.Devices.Entities.FieldData.get_DataValue()
   at Act.UI.DataExchange.DataExchangeConfirmMatch.UpdateLabelsAndFields(String[] fieldNames)
   at Act.UI.DataExchange.DataExchangeConfirmMatch.LoadForContact()
   at Act.UI.DataExchange.DataExchangeConfirmMatch.OnLoad(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ContainerControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4952 (win7RTMGDR.050727-4900)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
ActSage
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Program%20Files/ACT/Act%20for%20Windows/ActSage.exe
----------------------------------------
Act.UI
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.UI/13.0.401.0__ebf6b2ff4d0a08aa/Act.UI.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.F...
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Act.Shared.Utilities
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Shared.Utilities/13.0.401.0__ebf6b2ff4d0a08aa/Act.Shared.Ut...
----------------------------------------
Act.Shared.Licensing
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Shared.Licensing/13.0.401.0__ebf6b2ff4d0a08aa/Act.Shared.Li...
----------------------------------------
Act.Shared.Diagnostics
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Shared.Diagnostics/13.0.401.0__ebf6b2ff4d0a08aa/Act.Shared....
----------------------------------------
Act.Shared.Win32
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Shared.Win32/13.0.401.0__ebf6b2ff4d0a08aa/Act.Shared.Win32....
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configura...
----------------------------------------
: file:///C:/Windows/assembly/GAC_MSIL/Act.Shared.Windows.Forms.Charting/13.0.401.0__ebf6b2ff4d0a08aa/...
----------------------------------------
ChartFX.WinForms
    Assembly Version: 7.0.2664.18481
    Win32 Version: 7.0.2664.18481
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ChartFX.WinForms/7.0.2664.18481__a1878e2052c08dce/ChartFX.WinFo...
----------------------------------------
ChartFX.WinForms.Base
    Assembly Version: 7.0.2664.18346
    Win32 Version: 7.0.2664.18346
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ChartFX.WinForms.Base/7.0.2664.18346__a1878e2052c08dce/ChartFX....
----------------------------------------
ChartFX.WinForms.Adornments
    Assembly Version: 7.0.2664.18371
    Win32 Version: 7.0.2664.18371
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/ChartFX.WinForms.Adornments/7.0.2664.18371__a1878e2052c08dce/Ch...
----------------------------------------
C1.Win.C1FlexGrid
    Assembly Version: 2.5.20042.160
    Win32 Version: 2.5.20042.167
    CodeBase: file:///C:/Windows/assembly/GAC/C1.Win.C1FlexGrid/2.5.20042.160__c9c7ad9c0a5706c9/C1.Win.C1FlexGrid....
----------------------------------------
C1.Common
    Assembly Version: 1.0.20031.116
    Win32 Version: 1.0.20042.118
    CodeBase: file:///C:/Windows/assembly/GAC/C1.Common/1.0.20031.116__e272bb32d11b1948/C1.Common.dll
----------------------------------------
AccountingLinkConversion
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Program%20Files/ACT/Act%20for%20Windows/Plugins/AccountingLinkConversion.DLL
----------------------------------------
Act.Devices.UI.Plugin
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Program%20Files/ACT/Act%20for%20Windows/Plugins/Act.Devices.UI.Plugin.DLL
----------------------------------------
Act.Survey.Plugin
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Program%20Files/ACT/Act%20for%20Windows/Plugins/Act.Survey.Plugin.DLL
----------------------------------------
Act.UI.InternetServices.Plugins
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Program%20Files/ACT/Act%20for%20Windows/Plugins/Act.UI.InternetServices.Plugins.DLL
----------------------------------------
ACTSPE2005
    Assembly Version: 13.0.43.0
    Win32 Version: 13.0.43.0
    CodeBase: file:///C:/Program%20Files/ACT/Act%20for%20Windows/Plugins/ACTSPE2005.DLL
----------------------------------------
System.Workflow.Activities
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.4203.4926 (NetFXw7.030729-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Workflow.Activities/3.0.0.0__31bf3856ad364e35/System.Wor...
----------------------------------------
System.Workflow.ComponentModel
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.4203.4926 (NetFXw7.030729-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Workflow.ComponentModel/3.0.0.0__31bf3856ad364e35/System...
----------------------------------------
Act.UI.Dialogs
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.UI.Dialogs/13.0.401.0__ebf6b2ff4d0a08aa/Act.UI.Dialogs.dll
----------------------------------------
Act.UI.WordProcessor
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.UI.WordProcessor/13.0.401.0__ebf6b2ff4d0a08aa/Act.UI.WordPr...
----------------------------------------
Act.Framework.MailMerge
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Framework.MailMerge/13.0.401.0__ebf6b2ff4d0a08aa/Act.Framew...
----------------------------------------
Act.CompositeExtensions
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.CompositeExtensions/13.0.401.0__ebf6b2ff4d0a08aa/Act.Compos...
----------------------------------------
System.Runtime.Remoting
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtim...
----------------------------------------
Act.Framework.Interop
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Framework.Interop/13.0.401.0__ebf6b2ff4d0a08aa/Act.Framewor...
----------------------------------------
C1.Win.C1Spell
    Assembly Version: 1.2.20041.42
    Win32 Version: 1.2.20043.50
    CodeBase: file:///C:/Windows/assembly/GAC/C1.Win.C1Spell/1.2.20041.42__f6f2c1ef135ddbd4/C1.Win.C1Spell.dll
----------------------------------------
Microsoft.mshtml
    Assembly Version: 7.0.3300.0
    Win32 Version: 7.0.3300.0
    CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.mshtml/7.0.3300.0__b03f5f7f11d50a3a/Microsoft.mshtml.dll
----------------------------------------
ActEmailConnectorMetaData
    Assembly Version: 1.0.0.0
    Win32 Version: 12.0.0.0
    CodeBase: file:///C:/Windows/assembly/GAC/ActEmailConnectorMetaData/1.0.0.0__ebf6b2ff4d0a08aa/ActEmailConnecto...
----------------------------------------
Act.Outlook.Sync.Common
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Outlook.Sync.Common/13.0.401.0__ebf6b2ff4d0a08aa/Act.Outloo...
----------------------------------------
Act.Framework.DataExchange
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Framework.DataExchange/13.0.401.0__ebf6b2ff4d0a08aa/Act.Fra...
----------------------------------------
Act.Data
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Data/13.0.401.0__ebf6b2ff4d0a08aa/Act.Data.dll
----------------------------------------
Act.Data.ActDb
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Data.ActDb/13.0.401.0__ebf6b2ff4d0a08aa/Act.Data.ActDb.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Act.Data.Resources
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Data.Resources/13.0.401.0__ebf6b2ff4d0a08aa/Act.Data.Resour...
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions...
----------------------------------------
System.EnterpriseServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.Enterp...
----------------------------------------
System.Workflow.Runtime
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.4203.4926 (NetFXw7.030729-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Workflow.Runtime/3.0.0.0__31bf3856ad364e35/System.Workfl...
----------------------------------------
Act.Framework.Synchronization
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Framework.Synchronization/13.0.401.0__ebf6b2ff4d0a08aa/Act....
----------------------------------------
System.ServiceModel
    Assembly Version: 3.0.0.0
    Win32 Version: 3.0.4506.4926 (NetFXw7.030729-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.ServiceModel/3.0.0.0__b77a5c561934e089/System.ServiceMod...
----------------------------------------
Act.UI.Resources.Views
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.UI.Resources.Views/13.0.401.0__ebf6b2ff4d0a08aa/Act.UI.Reso...
----------------------------------------
Act.Devices.Plugin
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Devices.Plugin/13.0.401.0__ebf6b2ff4d0a08aa/Act.Devices.Plu...
----------------------------------------
TAPIEx_Wrap
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Windows/assembly/GAC/TAPIEx_Wrap/1.0.0.0__ebf6b2ff4d0a08aa/TAPIEx_Wrap.dll
----------------------------------------
Act.Outlook.Service.Desktop
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Outlook.Service.Desktop/13.0.401.0__ebf6b2ff4d0a08aa/Act.Ou...
----------------------------------------
Act.Outlook.Service.Interfaces
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Outlook.Service.Interfaces/13.0.401.0__ebf6b2ff4d0a08aa/Act...
----------------------------------------
Act.Outlook.Service.Shared
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Outlook.Service.Shared/13.0.401.0__ebf6b2ff4d0a08aa/Act.Out...
----------------------------------------
Act.Shared.Messaging
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Shared.Messaging/13.0.401.0__ebf6b2ff4d0a08aa/Act.Shared.Me...
----------------------------------------
Act.Framework.BusinessLink.LinkConnector
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Framework.BusinessLink.LinkConnector/13.0.401.0__ebf6b2ff4d...
----------------------------------------
Act.Framework.SageIntegration
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Framework.SageIntegration/13.0.401.0__ebf6b2ff4d0a08aa/Act....
----------------------------------------
Act.Framework.BusinessLink.Messaging
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Framework.BusinessLink.Messaging/13.0.401.0__ebf6b2ff4d0a08...
----------------------------------------
Act.Outlook.Integration
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Outlook.Integration/13.0.401.0__ebf6b2ff4d0a08aa/Act.Outloo...
----------------------------------------
Microsoft.Practices.Unity.Configuration
    Assembly Version: 1.2.0.0
    Win32 Version: 1.2.0.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.Practices.Unity.Configuration/1.2.0.0__31bf3856ad364e...
----------------------------------------
Act.Outlook.Win.Integration
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Outlook.Win.Integration/13.0.401.0__ebf6b2ff4d0a08aa/Act.Ou...
----------------------------------------
Act.UI.Remoting.Common
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.UI.Remoting.Common/13.0.401.0__ebf6b2ff4d0a08aa/Act.UI.Remo...
----------------------------------------
Infragistics.Act.Win.UltraWinSchedule
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Infragistics.Act.Win.UltraWinSchedule/13.0.401.0__ebf6b2ff4d0a0...
----------------------------------------
Infragistics.Act.Win
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Infragistics.Act.Win/13.0.401.0__ebf6b2ff4d0a08aa/Infragistics....
----------------------------------------
Infragistics.Act.Shared
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Infragistics.Act.Shared/13.0.401.0__ebf6b2ff4d0a08aa/Infragisti...
----------------------------------------
Act.UI.ActivityViews.Widgets.TimeSelector
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.UI.ActivityViews.Widgets.TimeSelector/13.0.401.0__ebf6b2ff4...
----------------------------------------
autocomplete
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Windows/assembly/GAC/autocomplete/1.0.0.0__ebf6b2ff4d0a08aa/autocomplete.dll
----------------------------------------
Act.UI.Activities.Views
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.UI.Activities.Views/13.0.401.0__ebf6b2ff4d0a08aa/Act.UI.Act...
----------------------------------------
Act.UI.TabPage
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.UI.TabPage/13.0.401.0__ebf6b2ff4d0a08aa/Act.UI.TabPage.dll
----------------------------------------
Act.Shared.Windows.Forms.NotificationItem
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Shared.Windows.Forms.NotificationItem/13.0.401.0__ebf6b2ff4...
----------------------------------------
Act.UI.Calendar.Views
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.UI.Calendar.Views/13.0.401.0__ebf6b2ff4d0a08aa/Act.UI.Calen...
----------------------------------------
Act.UI.Groups.Views
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.UI.Groups.Views/13.0.401.0__ebf6b2ff4d0a08aa/Act.UI.Groups....
----------------------------------------
Infralution.Controls.VirtualTree
    Assembly Version: 2.3.0.0
    Win32 Version: 2.3.0.0
    CodeBase: file:///C:/Windows/assembly/GAC/Infralution.Controls.VirtualTree/2.3.0.0__3e7e8e3744a5c13f/Infraluti...
----------------------------------------
Infralution.Controls
    Assembly Version: 2.3.0.0
    Win32 Version: 2.3.0.0
    CodeBase: file:///C:/Windows/assembly/GAC/Infralution.Controls/2.3.0.0__3e7e8e3744a5c13f/Infralution.Controls....
----------------------------------------
System.Web
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4955 (win7RTMGDR.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
Infralution.Common
    Assembly Version: 2.3.0.0
    Win32 Version: 2.3.0.0
    CodeBase: file:///C:/Windows/assembly/GAC/Infralution.Common/2.3.0.0__3e7e8e3744a5c13f/Infralution.Common.dll
----------------------------------------
System.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
xhz_rb1c
    Assembly Version: 13.0.401.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Act.UI.Companies.Views
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.UI.Companies.Views/13.0.401.0__ebf6b2ff4d0a08aa/Act.UI.Comp...
----------------------------------------
c4nifdai
    Assembly Version: 13.0.401.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
_zr8f57j
    Assembly Version: 13.0.401.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Act.UI.Opportunities.Views
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.UI.Opportunities.Views/13.0.401.0__ebf6b2ff4d0a08aa/Act.UI....
----------------------------------------
Act.UI.Import
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.UI.Import/13.0.401.0__ebf6b2ff4d0a08aa/Act.UI.Import.dll
----------------------------------------
Act.UI.DataExchange
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.UI.DataExchange/13.0.401.0__ebf6b2ff4d0a08aa/Act.UI.DataExc...
----------------------------------------
Act.Devices.Entities
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Devices.Entities/13.0.401.0__ebf6b2ff4d0a08aa/Act.Devices.E...
----------------------------------------
Microsoft.Office.Interop.Excel
    Assembly Version: 10.0.4504.0
    Win32 Version: 10.0.4504
    CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.Office.Interop.Excel/10.0.4504.0__31bf3856ad364e35/Microso...
----------------------------------------
System.Deployment
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.d...
----------------------------------------
Act.Framework.DataExchange.Act6
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.Framework.DataExchange.Act6/13.0.401.0__ebf6b2ff4d0a08aa/Ac...
----------------------------------------
Act.Framework.DataExchange.OutlookSync
    Assembly Version: 13.0.401.0
    Win32 Version: 11.0.0.0\0
    CodeBase: file:///C:/Windows/assembly/GAC_32/Act.Framework.DataExchange.OutlookSync/13.0.401.0__ebf6b2ff4d0a08...
----------------------------------------
msvcm90
    Assembly Version: 9.0.30729.4926
    Win32 Version: 9.00.30729.4926
    CodeBase: file:///C:/Windows/WinSxS/x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.4926_none_508ed732bcbc0e...
----------------------------------------
Act.UI.Preferences
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.UI.Preferences/13.0.401.0__ebf6b2ff4d0a08aa/Act.UI.Preferen...
----------------------------------------
Act.UI.Contacts.Views
    Assembly Version: 13.0.401.0
    Win32 Version: 13.0.401.0
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Act.UI.Contacts.Views/13.0.401.0__ebf6b2ff4d0a08aa/Act.UI.Conta...
----------------------------------------

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Excel import error using 2011

Hello,
Are you exporting it as an Excel file? If so, try saving it as .csv file instead and importing it in that format.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Copper Contributor
Posts: 20
Country: United States

Re: Excel import error using 2011

The whole point is that I am testing the new 'direct import from Excel' functionality in 2011. I do not want to test with a .cvs. file.  My company is testing 2011 to see if we want to upgrade based on the new 'features'.

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Excel import error using 2011

I understand. My question is does the same thing happen if you import it as a .csv file. This will give us a better idea of where the issue lies.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Copper Contributor
Posts: 20
Country: United States

Re: Excel import error using 2011

Just ran a test. Yes it fails with the same file converted to .cvs

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Excel import error using 2011

OK. Check to see if duplicate checking is disabled. Go to Tools > Preferences, go to the Admin tab and click the Duplicate Checking button. Make sure the box to enable duplicate checking is checked. Then try the import again. There is an open issue where the type of error you are describing will occur is the duplicate checking option is disabled. This issue is currently under investigation.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Copper Contributor
Posts: 20
Country: United States

Re: Excel import error using 2011

Yes, the duplicate checking is turned on.

Copper Contributor
Posts: 20
Country: United States

Re: Excel import error using 2011

I figured out that the failure happens on one record. The record looks like all the rest, but when I delete it from the Excel file the import works. 

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Excel import error using 2011

I'm glad that you found the error and were able to resolve. For future knowledge, was there anything at all different about that record you deleted? Formatting, empty cells, etc.?

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Copper Contributor
Posts: 20
Country: United States

Re: Excel import error using 2011

I can't see any difference. There are other records with empty cells. I tried moving the record to the bottom of the spreadsheet and it still failed. Then just for the heck of it, I deleted the record from ACT and ran the import and it worked. So it seems to be an issue with the merge, since it can add the record as a new contact.