| |
forums.frontrange.com
FrontRange Solutions Community Forum
|
|
|
|
Attention Forum Members
Forums.frontrange.com has been set to “Read Only” status. You can no
longer start new discussions or add/edit existing threads. Instead,
please access FrontRange Connect at www.frontrange.com/community and create your
account for the FrontRange virtual community, FrontRange Connect.
Sign up for an account today. Participate in this interactive
community forum and leverage the new features and functionality by going to www.frontrange.com/community.
FrontRange Connect provides users with a dependable,
secure and feature-rich experience.
Benefits
of FrontRange Connect include:
·
Post discussions
and provide comments just as you did in the Forum
·
The ability to
create interactive Wikis, a shared workspace where you can build a
knowledgebase, develop documentation, share ideas and experiences, and more
·
Additional
features not found on the Forum including Event Calendaring, ability to
schedule Meetings, Private Messaging and more
·
Improved
stability and security over FrontRange Forum
·
Get support and
resources for all FrontRange products in one location
·
A network of
FrontRange experts and fellow FrontRange product users providing thousands of
combined years of experience in one place
|
|
| View previous topic :: View next topic |
| Author |
Message |
dougd
Joined: 29 Jan 2008
Posts: 8
|
 Posted: Tue Sep 23, 2008 3:47 pm Post subject: Delete old email, keep history |
 |
|
Goldmine v7.0.70302 with SQL 2000 on a Windows 2003 server.
I have a client that has inquired about deleting old email from their database, while preserving the history log itself. To be clear, they would like to keep the log entries for a contact's history, but want the underlying email message to be deleted after a certain time (2 years), so that double-clicking on the log entry cannot open the original email. In this instance GM is not used as a sales tool and the old email is deemed a liability to the organization after a certain amount of time.
I'm not sure Goldbox can even do this. Any suggestions?
Thanks. |
|
| Back to top |
|
 |
BobTaylor
Joined: 14 Sep 2007
Posts: 1261
Location: Jacksonville, FL
|
| Posted: Tue Sep 23, 2008 4:23 pm Post subject: |
|
|
GoldBox can. If you don't want to archive the E-mail, just use GoldBox's Global Delete of History, with the ""IF Email: Delete linked Mailbox record?" and the "Retain the Email Reference in History?" both checked. And, of course, you'd apply your date query.
_________________
Bob Taylor
Bob Taylor Consulting
(904)745-2903
www.goldboxbob.com
Consulting with GoldMine and GoldBox since 1997.
Also see me at http://www.castellcomputers.com/contactreview/phpbb2/ |
|
| Back to top |
|
|
dougd
Joined: 29 Jan 2008
Posts: 8
|
| Posted: Tue Sep 23, 2008 7:27 pm Post subject: |
|
|
| Thanks Bob. I'll go buy it. |
|
| Back to top |
|
|
bgannett
Joined: 14 Sep 2007
Posts: 2828
Location: USA
|
| Posted: Tue Sep 23, 2008 8:17 pm Post subject: |
|
|
I agree with Bob Taylor's suggestion. Backup before doing any of this.
_________________
Bob Gannett
Affordable GoldMine Support
*** Free Monthly Newsletter ***
253-627-2244
goldsupport@harbornet.com |
|
| Back to top |
|
|
BobTaylor
Joined: 14 Sep 2007
Posts: 1261
Location: Jacksonville, FL
|
|
| Back to top |
|
|
dougd
Joined: 29 Jan 2008
Posts: 8
|
| Posted: Wed Dec 31, 2008 11:10 pm Post subject: |
|
|
Well, I have the Goldbox 7 product installed and I am attempting to perform the email/history archive. I guess my problem is related to the SQL statement syntax.
As a test I'm using the statement -
CONTHIST.ONDATE = "11/19/2008"
I've tried multiple variations of the date, i.e. '11/19/2008' or ("11/19/2008"); however no records return and I know there is at least one of them.
Thanks again for any assistance and don't worry, this is a test system, so I'm not actively jeopardizing any production data. |
|
| Back to top |
|
|
BobTaylor
Joined: 14 Sep 2007
Posts: 1261
Location: Jacksonville, FL
|
| Posted: Wed Dec 31, 2008 11:28 pm Post subject: |
|
|
Well, the correct syntax is single, not double, quotes surrounding the date. And normally you don't use a specific date, but all ONDATEs that are less than or equal to a specific date; and it would be a date that's sufficiently far past that it would make sense to archive and delete records prior to that date. Something like
| Code: | | CONTHIST.ONDATE <= '11/19/2006' |
Don't forget that you can click the "odometer" button at the query screen, and get a quick count of how many records meet your criterion.
_________________
Bob Taylor
Bob Taylor Consulting
(904)745-2903
www.goldboxbob.com
Consulting with GoldMine and GoldBox since 1997.
Also see me at http://www.castellcomputers.com/contactreview/phpbb2/ |
|
| Back to top |
|
|
dougd
Joined: 29 Jan 2008
Posts: 8
|
| Posted: Thu Jan 01, 2009 4:45 pm Post subject: |
|
|
| BobTaylor wrote: | Well, the correct syntax is single, not double, quotes surrounding the date. And normally you don't use a specific date, but all ONDATEs that are less than or equal to a specific date; and it would be a date that's sufficiently far past that it would make sense to archive and delete records prior to that date. Something like
| Code: | | CONTHIST.ONDATE <= '11/19/2006' |
Don't forget that you can click the "odometer" button at the query screen, and get a quick count of how many records meet your criterion. |
Thanks for the prompt response. It helped me get a little closer.
I can perform the dry run and get the expected results. However, when I unclick the 'dry run' check box in order to do it for real, I receive the following program alert message -
File does not exist: HADELTBL.DBF
File: c:\golbox7\gx4funcs.prg
Routine: RESETDBHDR
Line: 3827
Do I have to create this table manually?
Thanks again. |
|
| Back to top |
|
|
BobTaylor
Joined: 14 Sep 2007
Posts: 1261
Location: Jacksonville, FL
|
| Posted: Thu Jan 01, 2009 6:09 pm Post subject: |
|
|
No, but I don't know the solution. First, ensure that you have the latest update to GoldBox 7. Then try again. If that doesn't work, you'll need to call or write to Dave Petonic, giving him the full error info that you gave me (the line number might change, if you updated). He should be able to resolve it for you.
_________________
Bob Taylor
Bob Taylor Consulting
(904)745-2903
www.goldboxbob.com
Consulting with GoldMine and GoldBox since 1997.
Also see me at http://www.castellcomputers.com/contactreview/phpbb2/ |
|
| Back to top |
|
|
dougd
Joined: 29 Jan 2008
Posts: 8
|
| Posted: Thu Jan 01, 2009 10:16 pm Post subject: |
|
|
| BobTaylor wrote: | | No, but I don't know the solution. First, ensure that you have the latest update to GoldBox 7. Then try again. If that doesn't work, you'll need to call or write to Dave Petonic, giving him the full error info that you gave me (the line number might change, if you updated). He should be able to resolve it for you. |
Thanks yet again for your assistance Bob. |
|
| Back to top |
|
|
BobTaylor
Joined: 14 Sep 2007
Posts: 1261
Location: Jacksonville, FL
|
|
| Back to top |
|
|
|
|
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
|
Powered by phpBB © 2001, 2005 phpBB Group
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
