| Email Attachments | |
Posted: Sat Nov 02, 2013 10:08 am |
Points: 0 |
|
bgannett |
GoldMine Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1820 |
Location: Pacific NorthWest |
|
|
|
|
|
|
|
GMPE 2013.1.0.249
As we all know, when sending emails with attachments and the location of the attachments moves, when you bring the sent email up in GM, it will not show the attachment. For this end user, their GMPE and attachments have been moved to a completely new and different server that generally has different paths.
Question: In GM, where is this attachment information stored for the sending email and if we cannot put the attachments in the original paths/locations, what would be the best way to make changes so that the attachments for the old outgoing emails can be seen?
Many thanks. |
|
|
|
|
| | |
Posted: Sat Nov 02, 2013 10:22 am |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
sure. There are SQL scripts that can be used to change attachments stored as being in one path to another. You'd just want to query the contsupp table (rectype L) to figure out the popularly stored paths and address those.
Beyond that, viewing th email in the browser via the right click menu is the easiest way for the users to find out where the email/GoldMine thinks the attachment is and then proceed to manually go locate it. |
|
|
|
|
| | |
Posted: Sat Nov 02, 2013 11:00 am |
Points: 0 |
|
bgannett |
GoldMine Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1820 |
Location: Pacific NorthWest |
|
|
|
|
|
|
|
Doug - thank you very much.
For your first suggestion, we have already taken care of that. GM's mailbox is currently located in d:\ProgramData\GoldMine\mailbox\attach. The 19,845 (L rectype) records show the those attachments are store in u:\goldmine\mailbox\attach. On the new server, the records were copied to drive D and were then mapped to their original u:\ location.
Your second comment is very useful - thanks. The attachments may not now be at that location but we may re-map their current location or, if needed, attempt to make changes to the settings so that GM is looking at a different location for the attachments for the sent emails. I know that the listing for the attachment locations for sent emails is NOT in Contsupp Rectype "L".
Thanks for your help. |
|
|
|
|
| | |
Posted: Sat Nov 02, 2013 11:05 am |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
I like this query for assessing what I'm dealing with as far as paths for attachments:
Code: |
select distinct address1 from contsupp where rectype='L' group by address1 having count(*) > 5 |
Yes, attachments aren't necessarily linked documents, but I find that looking at the links tends to give you the main spots they live. |
|
|
|
|
Posted: Sat Nov 02, 2013 11:32 am |
Points: 0 |
|
bgannett |
GoldMine Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1820 |
Location: Pacific NorthWest |
|
|
|
|
|
|
|
This is great - thanks.
I assume that most of settings in Rectype "L" are dealing with attachements for emails received and may not be dealing with attachments people connect to emails being sent.
Many thanks. |
|
|
|
|
Posted: Sun Nov 03, 2013 10:33 am |
Points: 0 |
|
bgannett |
GoldMine Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1820 |
Location: Pacific NorthWest |
|
|
|
|
|
|
|
One important, basic question. Where does GoldMine store the attachment location for outbound emails?
Thanks. |
|
|
|
|
| | |
Posted: Sun Nov 03, 2013 11:16 am |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
in the e-mail body & header (RFC822)
By default, however, most users have the 'store attachments as links' option turned on. This means that most users also generate contsupp (rectype L) records. That's why I generally trust the results of the contsupp query to tell me which paths are the ones to be concerned about in a server move. At some point, there is an acceptable level of loss -- especially when a user sent an attachment from the desktop of their xp workstation 3 years ago, deleted the file from the desktop three days later and now GoldMine still points to c:\documents and settings\jane\desktop\some_unimportant_long_gone.doc... |
|
Last edited by DougCastell on Sun Nov 03, 2013 11:24 am; edited 1 time in total _________________ Doug Castell
GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738 |
|
|
|
| | |
Posted: Sun Nov 03, 2013 11:22 am |
Points: 0 |
|
bgannett |
GoldMine Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1820 |
Location: Pacific NorthWest |
|
|
|
|
|
|
|
|
|
|
|
| | |
Posted: Thu Nov 14, 2013 3:12 pm |
Points: 0 |
|
Paul Laufer |
GoldBox Guru |
|
|
Joined: 27 Oct 2008 |
Posts: 125 |
|
|
|
|
|
|
|
|
There was a useful thread on this subject here:
http://frsconnect.frontrange.com/group_discussion.aspx?discussionid=4f3f71e783884c3e9bde0f04493c07fe
Doug's query was this...
Code: |
DECLARE @SEARCH AS VARCHAR(100)
DECLARE @REPLACE AS VARCHAR(100)
-- What do you want to search and replace
SET @SEARCH = 'C:\GoldMine'
SET @REPLACE = 'D:\Apps\GoldMine'
-- E-mail Attachments for all before GoldMine 8.5
UPDATE MAILBOX
SET RFC822= CAST(REPLACE(CAST(RFC822 AS VARCHAR(MAX)) ,@SEARCH, @REPLACE) AS TEXT)
WHERE RFC822 LIKE '%'+@SEARCH+'%'
-- E-mail Attachments for GoldMine 8.5 and higher
UPDATE MAILBOX
SET RFC822= REPLACE(CONVERT(VARCHAR(MAX),CONVERT(VARBINARY(MAX),RFC822)) ,@SEARCH, @REPLACE)
WHERE CONVERT(VARCHAR(MAX),CONVERT(VARBINARY(MAX),RFC822)) LIKE '%'+@SEARCH+'%'
-- Linked Documents
UPDATE CONTSUPP SET
ADDRESS1 = LEFT( REPLACE( RTRIM(ISNULL(ADDRESS1,'')+ISNULL(ADDRESS2,'')) + SPACE(41) , @SEARCH, @REPLACE) , 40 ) ,
U_ADDRESS1 = UPPER( LEFT( REPLACE( RTRIM(ISNULL(ADDRESS1,'')+ISNULL(ADDRESS2,'')) + SPACE(41) , @SEARCH, @REPLACE) , 40 ) ) ,
ADDRESS2 = SUBSTRING ( REPLACE( RTRIM(ISNULL(ADDRESS1,'')+ISNULL(ADDRESS2,'')) + SPACE(41) , @SEARCH, @REPLACE) , 41 , 40 ) ,
LINKEDDOC=CAST(REPLACE(CAST(LINKEDDOC AS VARCHAR(MAX)) ,@SEARCH, @REPLACE) AS TEXT)
WHERE RECTYPE='L'
AND U_ADDRESS1 LIKE '%'+LEFT(@SEARCH,40)+'%'
-- Word Templates
UPDATE FORMS SET
TEMPLATE = REPLACE (TEMPLATE,@SEARCH, @REPLACE) ,
LINKEDDOC=CAST(REPLACE(CAST(LINKEDDOC AS VARCHAR(MAX)) ,@SEARCH, @REPLACE) AS TEXT)
WHERE LINKEDDOC LIKE '%'+@SEARCH+'%'
-- Reports
UPDATE REPORT32 SET
LINKEDDOC=CAST(REPLACE(CAST(LINKEDDOC AS VARCHAR(MAX)) ,@SEARCH, @REPLACE) AS TEXT)
WHERE LINKEDDOC LIKE '%'+@SEARCH+'%'
-- Knowledge Base documents
UPDATE INFOMINE SET
LINKEDDOC=CAST(REPLACE(CAST(LINKEDDOC AS VARCHAR(MAX)) ,@SEARCH, @REPLACE) AS TEXT)
WHERE LINKEDDOC LIKE '%'+@SEARCH+'%'
UPDATE INFOMINE SET
NOTES=CAST(REPLACE(CAST(NOTES AS VARCHAR(MAX)) ,@SEARCH, @REPLACE) AS TEXT)
WHERE NOTES LIKE '%'+@SEARCH+'%' |
And then there was Shaulbel's adjustment to the mailbox one...
Code: |
DECLARE @SEARCH AS VARCHAR(100)
DECLARE @REPLACE AS VARCHAR(100)
declare @oldpath as varchar(100)
declare @trans as varchar(100)='Transfer-Encoding: base64' + CHAR(13) + CHAR(10)+ char(13) + char(10)
declare @newpath as varchar(100)
-- What do you want to search and replace
set @oldpath='\\xxx\'
SET @SEARCH = @trans + @oldpath
set @newpath='F:\'
SET @REPLACE = @trans + @newpath
UPDATE MAILBOX
SET RFC822= REPLACE(CONVERT(VARCHAR(MAX),CONVERT(VARBINARY(MAX),RFC822)) ,@SEARCH, @REPLACE)
WHERE
cast(cast(rfc822 as varbinary(max)) as varchar(max)) like '%' + @SEARCH + '%' |
|
|
|
|
|
| | |
Posted: Thu Nov 14, 2013 3:20 pm |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
we should probably combine those, once and for all... |
|
|
|
|
| | |
Posted: Tue Dec 03, 2013 12:05 am |
Points: 0 |
|
bgannett |
GoldMine Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1820 |
Location: Pacific NorthWest |
|
|
|
|
|
|
|
Client has attachments (invoices) that had been attached to thousands of out going emails. Before GM was moved from an ancient setup, the attachments were stored in weird mapped drives. Once moved to a new, clean server; the attachments were placed in the same mapped drive.
We recently discovered that at least one attachment for outgoing email was stored in a unique weird drive.
We are trying to determine how many attachments were stored in this unique Drive “P”. If the attachments had been stored as Rectype “L” in contsupp, then a simple SQL Query would provide the needed information. Unfortunately, in this case, the paths to the attachments for outgoing emails were not stored in Contsupp. They were stored in e-mail body & header (RFC822). My question, How can we determine how many attachments for outgoing emails were stored in Drive P?
Many thanks. |
|
|
|
|
| | |
Posted: Sat Dec 07, 2013 12:07 pm |
Points: 0 |
|
Paul Laufer |
GoldBox Guru |
|
|
Joined: 27 Oct 2008 |
Posts: 125 |
|
|
|
|
|
|
|
|
bgannett wrote: |
Client has attachments (invoices) that had been attached to thousands of out going emails. Before GM was moved from an ancient setup, the attachments were stored in weird mapped drives. Once moved to a new, clean server; the attachments were placed in the same mapped drive.
We recently discovered that at least one attachment for outgoing email was stored in a unique weird drive.
We are trying to determine how many attachments were stored in this unique Drive “P”. If the attachments had been stored as Rectype “L” in contsupp, then a simple SQL Query would provide the needed information. Unfortunately, in this case, the paths to the attachments for outgoing emails were not stored in Contsupp. They were stored in e-mail body & header (RFC822). My question, How can we determine how many attachments for outgoing emails were stored in Drive P?
Many thanks. |
Something like this should do ya....
Code: |
select top 5 cast(cast(rfc822 as varbinary(max)) as varchar(max)) as 'Email Body',* from MAILBOX
WHERE
cast(cast(rfc822 as varbinary(max)) as varchar(max)) like '%Transfer-Encoding: base64' + CHAR(13) + CHAR(10)+ char(13) + char(10) +'P:%' |
Take off the top 5 part for the whole thing. I left it there for testing viability of the query. |
|
|
|
|
| | |
Posted: Sat Dec 07, 2013 8:29 pm |
Points: 0 |
|
bgannett |
GoldMine Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1820 |
Location: Pacific NorthWest |
|
|
|
|
|
|
|
Paul - thank you very much. I will sure give it a try and let you know how it works |
|
|
|
|
Posted: Sat Dec 14, 2013 8:48 am |
Points: 0 |
|
Paul Laufer |
GoldBox Guru |
|
|
Joined: 27 Oct 2008 |
Posts: 125 |
|
|
|
|
|
|
|
|
How did it work out, Bob? |
|
|
|
|
ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|