Version 12.3.0 update is out. The current version of OAK!Merge is at Version 12.3.0 update is out. The current version of OAK!Merge is at http://www.oakpro.com/downloads/OakMerge12.zip UPDATE SUMMARY: – USER table support – Update record Manager – Office 2007 Excel/Access support – Link to opportunities – User interface improvements OAK!Merge 12.3.0 adds the ability to import users into ACT. Since it supports ACT to ACT merges too, this means you can MOVE users from one database to another. Note: passwords in the target database are set to blank in this type of a merge. We also added the ability to record manager on imports. This is very useful on contacts, history, note, or opportunity imports. 12.3 now supports Office 2007 versions of excel and access as sources. Since opportunities are now top level entities, you can not link activities and history to opportunities as well as contacts, companies, and groups. User interface… read more →
Subject: Questions about OAK!Merge How can I identify Contacts that are in 2 ACT! databases? i.e. find the dups? ———- ANSWER OAK!Merge can update a field, or add contacts to a group, for all the contact records that are in both databases. You can pick the fields to match on to determine if they are dups. Example: Assume you have • Database S with 15,000 contacts (the Source database) • Database T with 8,000 contacts (the Target database) • 2,000 of the contacts in Database T have exactly the same Contact Name, Company, and City as in Database S • You can use OAK!Merge to UPDATE a field in Database T of the 2000 dups to indicate it is also in Database S or you could add the 2000 contacts to a GROUP in Database T or both. You can use the Pro version of OAK!Merge to do an ACT… read more →
OAK!Merge 12.2 is released 1/10/10. It now writes to Secondary Contacts. The Pro Version has been out since Oct 2009. The feedback has been great. The new ACT 12 opportunities and products are working fine. The new PRO version also does ACT! to ACT! merges and appends data to CUSTOM TABLES.
Sample Run_OAKmerge.bat with Remarks to display as it runs rem batch file to run a merge from a stored profile in OAK!Merge called batch44 “C:\E Tech Systems\ACT\OAK!Merge 12\OakMerge.UI.ACT” batch44 rem “All Done- log files with results are in C:\E Tech Systems\OAK!Merge 12\Logs” rem rem remove the pause below to run unattended from a scheduler Pause
Version 12.1.1 released for OAK!Merge is released. It supports ACT! 9,10, 11 and 12. It also has support for Custom Tables and ACT! to ACT! Merges. The Features Roadmap was updated with versions and features here.
Question: can I use field mappings in any version of OAK!Merge? Answer: yes, field mappings are included in Basic and up versions. Note: In the Basic version you can save and use mappings. This is not the same as saving and using profiles. Mappings are only the field mappings. The profiles include the mappings AND the log-in/password, type of source and file name. Profiles are required for unattended automated merges. Profiles are not included in Basic. If you create and reuse field mappings you can import files repeatedly without having to redo the field mappings each time. The field order and field names need to stay the same.
<!– /* Font Definitions */ @font-face {font-family:”Cambria Math”; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:””; margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:”Calibri”,”sans-serif”; mso-fareast-font-family:Calibri; mso-bidi-font-family:”Times New Roman”;} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {mso-style-noshow:yes; mso-style-priority:99; color:purple; mso-themecolor:followedhyperlink; text-decoration:underline; text-underline:single;} p {mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:”Times New Roman”,”serif”; mso-fareast-font-family:Calibri;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; mso-ascii-font-family:Calibri; mso-fareast-font-family:Calibri; mso-hansi-font-family:Calibri;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} –> /* Style Definitions */ table.MsoNormalTable {mso-style-name:”Table Normal”; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:””; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:”Calibri”,”sans-serif”; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:”Times New Roman”; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:”Times… read more →
OAK!Merge Ver 11.1.4 released. It Supports ACT 9, 10, and 11. Bug and usability enhancements were included.