11-17-2008 11:42 AM
I encountered a problems with opening attachments that are placed on mapped locally network drive (e.g. B: -> \\PROMYK\CSSOFTDESK). They are placed in subfolder \Email and came from database conversion of old 6.0 DBF + files structure.
If I attach the UNC path - it works, but in the past we were using this mapping to avoid problems after migration of all the ACT database between various servers (for almost 10 years - so the server name was changed from time to time).
Now, we have a full database converted, with thousands of attachments links pointing B:\kontakty\Email\*.msg - and cannot open these attachments. On request I may send out a screen shot...
Thank you for any idea how to fix it!
11-17-2008 08:17 PM
Did you do the conversion on the server?
If so go to one of the client machines that can access the B: drive and do the conversion from there, remember if ACT! tries to convert the database and can't see the drive in question its going to skip these attachments.
Make sure when your on the client machine open up ACT! 6 take a look at the attachment, double click it make sure it opens, close ACT! 6, then open ACT! 11 on the client machine, do the conversion, once its done open the database up and check the attachments, then do a back up and restore as, to the server and share your database. This should work for you.
Hope this helps,
11-18-2008 02:36 AM
Thank you. I did so and... some more 'research'.
The problem is that it looks like most entries 'B:\kontakty\ACT\Email\oa_*.msg' in the new database are incorrectly written (re-created) after import. I found several entries (first 11 from a list of History at My Record) that read attachments properly!
Also, I found that 're-linking' the unfound attachments helps, i.e. the attached document can be found and open after I definine new attachment link to exactly same location and file, as the one that did not work after import! Literally the same path...
So, I found myselt that 'rewriting' entries into database fields migth help, but... it can't be done - no tools.
Regards & thanks,
11-18-2008 01:41 PM
You keep using the word import, If you are converting the database everything should come across including the attachments, as long as the attachments are where they say they are in the histories of ACT! 6.
Take a look at this KB
Can you please confirm that you are doing a conversion and not trying to import.
11-18-2008 02:15 PM
Thank you. Yes, what I name 'import' is the conversion process of course :-)
I was continuing my investigation and I found that during conversion the B: was resolved to previous UNC path: \\VENTUS\CSSOFTDESK path! How did I find it? Well, I entered the folder containing attachments in ACT!11 database and reviewed the contents of some files. And they point to UNC, not to B:\!!! So, the problem is that I changed the computer where the database is located now (our Business Server) from VENTUS to another computer and... That is the problem.
Temporarily I gave permission to access the old \\VENTUS\ ACT folder to all users and... it works. Temporarily, because we need to shut down old computer in short time.
Why the B:\ path was resolved, BTW?
11-19-2008 03:07 AM
11-19-2008 01:20 PM
Ok so during the conversion process you told ACT! To use shortcuts, to the attachments like they were set up in ACT! 6 and before,
The way you have done it now is much better, this way you have all of the attachments in one location, and if you set up Sync, the attachments will now sync if you wish.
Glad everything worked out