OAK!Merge Ver 11.1.4 released. It Supports ACT 9, 10, and 11. Bug and usability enhancements were included.
OAK!Merge 11.1 is out of beta and released. It supports ACT 10 and 11, Not ACT 9. A later upadte it planned for ACT 9 support to be included.
Q: How do I get the EXCEL Transfer option to function in ACT!PAK. It is missing…..??? What you need to transfer info such as the notes and history from ACT 6 to Excel is the transfer option. It is standard with ACT!PAK. It will look like this when turned on : A: If you don’t see Excel Transfer option, it is usually because of 1 of 2 issues. 1. You don’t have Excel installed on this PC 2. You did not select Excel as your spreadsheet when you installed ACT!PAK Troubleshooting: You can select Excel as your spreadsheet under the Preferences/ Spreadsheet Mapping Menu option See attached screen shot for an example . Another option is you could uninstall and reinstall ACT!PAK, selecting EXCEL as your spreadsheet program during the install.
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 →