1 2 3 Previous Next 35 Replies Latest reply on Nov 10, 2016 11:12 AM by RMacha

    Delete from Links Tab

    GZimme Apprentice

      Is there an efficient way to delete links?  What we have is everyone puts facebook, linked in, twitter..... links icons on their emails, and then Goldmine brings them in as links. Now we have a links tab with tons of these JPGs and a couple of valuable real links.

        • 1. Re: Delete from Links Tab
          DHunt Specialist

          Hi Gary,


          This could best be accomplished via the SQL Server Management Studio using a Delete Query.

           

          If you have Remote Users Synchronizing then the same Delete Query would need to be run on their systems.

          When building the Delete Query you might want to consider Filtering through the Query somewhat to only rid your system of certain Links.

           

          DJ

          • 2. Re: Delete from Links Tab
            John Neighbors SSMMVPGroup

            If you're not a synching environment, you can delete links directly via SQL (using SQL Server Mgmt Studio).  Of course, you'll want to be VERY CAREFUL using such a tool.

             

            If you are a synching environment, this can still be done via SQL, but would require some minor "programming" to make sure the deletion is sync-aware.

             

            Links are stored in the CONTSUPP table with a RECTYPE = 'L'.  However, Links created from incoming emails is one thing.  Links created other ways is another.

             

            There's a specific way that links are coded when they are created from incoming email.  Off the top of my head, I forget just how that is.  Since we don't have such created from our emails, I can't simply query our database to remind me of such.

             

            This query might help you identify the characteristic that would distinguish between links created from emails (that it sounds like you want to delete) and those created by other means (that you may wish to keep):

             

            select top 1000 * from contsupp where rectype = 'L' order by recid desc

             

            Also, the setting that is causing this, that is ON by default, but that I tend to see most people turn OFF, is located within the Retrieval tab within each user's E-mail Options:

             

             

            Hope this feedback helps.

            • 3. Re: Delete from Links Tab
              GZimme Apprentice

              THANKS for the replies... I could do a SQL delete query and thanks for the start on that.

              Question on Unchecking the "Save attachments as linked documents"....   If that is unchecked and I want to save an attachment can I do that?  Also, if it's not saved and there is an imbedded jpg in the email will that be missing for good?

              I guess I'm confused with how this would work since so many emails have pictures in/attached I would think you would want to keep that box checked.

              • 4. Re: Delete from Links Tab
                John Neighbors SSMMVPGroup

                If you UNCHECK the option in question, that simply means NOTHING will be AUTOMATICALLY placed on the LINKS tab as part of email retrieval.

                 

                Everything about the email itself will still be valid and intact.  All attachments, etc. will still be there.  You can then manipulate and do as you see fit with any attachments; whether or not that includes purposefully creating any Links tab entries for them is entirely up to you.

                 

                Hope this feedback helps.

                1 of 1 people found this helpful
                • 5. Re: Delete from Links Tab
                  GZimme Apprentice

                  OH!!!!   Light buld going on very brightly here!  Wow... so by unchecking the box... the Attachments are saved and placed and per the other check boxes etc but no link is written to the Links tab, RIGHT? 

                  • 6. Re: Delete from Links Tab
                    John Neighbors SSMMVPGroup

                    Absolutely correct! :-)

                    • 7. Re: Delete from Links Tab
                      TPorte Apprentice

                      Here is one such SQL query to find image files from the links tab, I think this one came from DCastell.  You could then change the select * to delete to get rid of them.

                       

                      Select * FROM ContSupp

                      WHERE rectype='L'

                      AND lastdate > getdate()-365

                      AND (

                      linkeddoc LIKE '%.gif%' OR

                      linkeddoc LIKE '%.jpg%' OR

                      linkeddoc LIKE '%.jpe%' OR

                      linkeddoc LIKE '%.png%')

                      2 of 2 people found this helpful
                      • 8. Re: Delete from Links Tab
                        Doug Castell Expert

                        Also helpful may be that I've written a utility that looks at the links tab, checks the file size on the linked file and deletes both the file and the link if it's under a particular size. 

                         

                        Who wants a copy? 

                        1 of 1 people found this helpful
                        • 9. Re: Delete from Links Tab
                          John Neighbors SSMMVPGroup

                          I do! :-)

                           

                          I'm always interested in adding another "tool" to the toolbox.

                           

                          Thanks, Doug!

                          • 10. Re: Delete from Links Tab
                            BJeffe Apprentice

                            Doug that sounds like a great utility and I would like a copy.

                            1 of 1 people found this helpful
                            • 11. Re: Delete from Links Tab
                              KSimps Apprentice

                              Sounds terrific.  I would appreciate a copy.  Thanks,

                              • 12. Re: Delete from Links Tab
                                TPorte Apprentice

                                DCastell   Count me in, Doug, and thanks!

                                • 13. Re: Delete from Links Tab
                                  Doug Castell Expert

                                  Ok, here you all go:  Winning the Fight Against Links tab Debris | Castell Computers

                                   

                                  (and before it's asked, no, it's not sync-friendly.)

                                  1 of 1 people found this helpful
                                  • 14. Re: Delete from Links Tab
                                    DHunt Specialist

                                    Downloaded your app, and the Internet Explorer Download Manager detected a Virus and Deleted the Download.

                                    1 2 3 Previous Next