03-16-2011 12:49 PM
I am using Act 2011 on Windows 7. I want to merge data from a tab separated file into specific fields of an existing database. I thought I would be able to export the records including the GUID, create the new fields in both ACT and the text file, add data to the new fields in Excel and then import the data back into ACT. But it doesn't appear you can export the GUID.
Is there a way to export GUID as part of the data so it is recongized on the import?
Is there another way to to do the same thing?
The help files discuss the merge process doing matching, but is that only from one ACT database to another or will it work when merging from a text file into an existing ACT database?
Any help or pointers to other forum posts would be helpful. I have been unable to find anyting similar.
03-16-2011 01:36 PM
For an update merge as you describe I would suggest using an addon such as OakMerge.
03-16-2011 03:04 PM
09-14-2011 09:23 PM
I really wish I had not bought this product. Firslty, as this was an upgrade, I discovered I was noit entitled to any support. This is not made clear anywhere, and given the new features of 2012, is quite wrong and possibly a misrepresentation, as the term 'new' products is a debatable one. What is new? 2012 comes with integration with Google - a big change, esp for those who do not use Outlook. It needs to be stated very clearly that no support is available for upgrades, at the point of purchase or before. Not stating this is very poor practice.
I did manage to get a days support for 2012, and this was very full for that day. However the end result was a failure. We were unable to integrate ACT with Google on my PC. We tried everything. In the end, it was all blamed on the environment on my machine - and although a refund was offered - the only solutions suggested were either to try the program on another machine - not a possibility for me - or to reformat the hard drive! I simply do not accept that there is anything special on my PC preventing the program integrating with Google.
This was a blow tro me, as I had purchased 2012 only because of the integration with Google feature. Nothing much else has changed, and Scratchpad is a small matter
So caveat emptor, I fear.