Q: How can I troubleshoot an error in ACT!PAK when I try to transfer notes and history from ACT 6 into Excel or ASCII text??? Error code from ACT!PAK is “ACTPAK encountered an ERROR Transfering records to Excel(20): Method ‘~’ of object ‘~” failed” A: Always backup your database before doing any mainteance or exporting. It is always good to do a test transfer of the data from the ACTdemo database to make sure that will work before repairing at your production database, If you can’t export the ACTDEMO database, you should verify check the version of Excel is 2000, 2002 or 2003 or reinstall ACT 6. It you can TRANSFER from the ACTDEMO database without error, then you need to work on your production database. When ACT!PAK was doing a TRANSFER to excel it probably ran into some ACT data it could not handle or some corrupted ACT indexes.… read more →
Q: Does OAK!Merge 10 or 9 work with ACT 2009 (ver 11)? A: No, you need to upgrade OAK!Merge to Match the version of ACT you are using If you install ACT! 11, OAK!Merge 10 will install and startup, but can not access the newer database structure/schema. You will get an error saying “Cannot open connection to a merge destination”
Q: When will OAK!Merge Advanced Version be out? A: The Advanced Version is being beta tested now. Version 10.3.4 is in beta since 4/1/08 and will go public as 10.3.5 in Sept/October The features in the Advacned version are listed in the product roadmap at http://www.oakpro.com/OakMerge10/Features_roadmap.htm They include merging Opporutnites, Activities; using Excel or Access as a source, and unattended operation.
Q: Use Tab or Comma as delimiters A: We recommend comma, quote delimited over TAB delimited based on our testing with OAK!Merge 9 Several files that were tab delimited were not importable, but when opened in excel and saved as CSV (comma delimited) they did work. Some TAB delimited fields worked OK. We have also been able to get some CSVs from excel that would not import, to properly import by opening in ACCESS and exporting from ACCESS as a CSV, setting the field delimiter to a double quote. Alan Lee www.oakpro.com
Q: Why do your samples in OAK!Merge sample folder all have a column with ‘End’ filled in? A: Is has become a “best practice” to fill in a dummy field as the last field of a CSV file with data. Just ignore it when mapping your import source data. It is not required, just a good practice. This is due to errors with importing records with different numbers of fields. Ensuring a value is always in the last column helped avoid this problem. Also, if you see the “end” field in your data after an import, it helps trouble shoot the import file. It may have extra or be missing field delimiters like double quotes. We recommend you add a dummy field to the end of each import file structure or ensure the last data field has data for all records as a best practice. The reasoning is… Older versions of Excel would not output extra comas on rows with no data in the last few fields, so each… read more →
Welcome to the WWW.OAKPRO.com blog for News, Tips, and Support on Oakhurst Sofware Products by E Tech Systems. We will post sales and support questions and answers here for to seach. Submit your new support questions by email to Support@oakpro.com Thanks and welcome aboard! Alan Lee President E Tech Systems