OAK!Merge 13.2.0 is released. It includes the new Enterprise version, command line options for logging, and a bug fix for deleting records selected for deletion.
The new Enterprise version includes the SalesForce Data Migration Kit for converting a SalesForce database into ACT!
The command line options for logging allow users running unattended merges to select the logging level they desire for each merge.
The Logging Level Switch is optional. The default level is “Full”. The default level will be used either when no level is specified or invalid level is specified.
The 4 possible values are:
- None (or “0”) for “No Logging”
- Errors (or “1”) for “Errors Only”
- ErrorsWarnings (or “2”) for “Errors and Warnings”
- Full (or “3”) for “Full Logging”
The new manual is also posted at
OAK!Merge Full manual in PDF format (12 mb)
I have downloaded a trial version of your software to use on ACT Premium 2011. I am trying to add a sample Opportunity to my database from an Excel 2010 spreadsheet. When I click run, I get this error message:
OakMerge.Engine.EngineException: Cannot load Source ‘MS Excel 2007-2010 (xlsx)’ data. —> System.Data.OleDb.OleDbException: The connection for viewing your linked Microsoft Excel worksheet was lost. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at OakMerge.DL.MSOffice.DataAccess.MSExcelConnection._ReadTable(DataTable dt, List`1 columns) at OakMerge.DL.DataAccess.DAConnection.ReadTable(DataTable dt, List`1 columns) at OakMerge.Engine.Merge.STEngine.LoadSource() — End of inner exception stack trace — at OakMerge.Engine.Merge.STEngine.LoadSource() at OakMerge.Engine.Merge.STEngine.RunImpl()
If I can get past this error message and see a successfully imported Opportunity record, I’ll purchase the software. Otherwise, it’s useless.
Only OAK!Merge 13.3.3 or later works with other sites using Excel 2010. Sorry you are having trouble
I have cc’d this to [email protected]
I am not sure why your Excel connection is not working. Make sure the spreadsheet is not open by excel
You can save as a XLS and for 2007 and try that; or Save as comma separated value (CSV) and use that.
If you need to import regularly from this Excel file; let support know and send them a sample.
Alan