Solved

wp pdf file short link problem

Posted on 2014-12-19
8
159 Views
Last Modified: 2014-12-26
While working on this wordpress site, I was adding text links to pdf files.  I used the shortcode.  Problem is, that the pdf file link, when clicked on, opens up a page which then has another link to the file and it also has the site design.  

Here is an example of how I DON'T want the pdf file displayed.  Click on link to view.
http://beta.citizensequalrightsalliance.org/?attachment_id=538

There are over 20 pdf files that do this in an over 200 page website.  The other pdf files use the long code and work good.  By good, I mean the pdf file itself opens up in a new window (without the site design).

Here is how I want the pdf files to display.  Click on link to view.
http://beta.citizensequalrightsalliance.org/wp-content/uploads/2014/12/action_guide.pdf

So, my question is simple but the answer might not be.  Is there a way to do a search or setup some sort of query so that I can search for the pages that use the shortcode pdf links (I know which ones are bad) and have the wp system tell me which pages they are linked on?
0
Comment
Question by:nsitedesigns
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 40509429
Do you have direct access to the database?
0
 

Author Comment

by:nsitedesigns
ID: 40509443
my programmer does.
0
 
LVL 70

Assisted Solution

by:Jason C. Levine
Jason C. Levine earned 500 total points
ID: 40509512
So this can be done via MySQL query.  The shortcodes are present exactly as typed in the wp_content table, post_content column.  Your programmer can do an update query using a regular expression to match the PDF shortcode and replacing it with a link.  

The trick will be generating that search/replace query.
0
MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

 

Author Comment

by:nsitedesigns
ID: 40509535
Won't that also show any shortcodes that also link to pages?  I use the shortcodes for page links and those work great.  Somehow I need to id the shortcodes as ones that go to a pdf file.
0
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 500 total points
ID: 40509540
The first step is to identify the shortcodes everywhere.  The second step is figuring out the pattern of the PDF ones to isolate just those.
0
 

Author Comment

by:nsitedesigns
ID: 40517652
We have now nearly 300 pages on this site.  Shortcodes are everywhere.  I don't know how we will be able to do what you advise since there is nothing specific about the shortcodes to the handful of links that are bad.  I will give you points anyways just for trying.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 40517655
if there was no identifiable pattern for the bad shortcodes, then there really isn't any other way to do this than manual search and replaces in the database.
0
 

Author Comment

by:nsitedesigns
ID: 40518472
thanks.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…
The viewer will learn how to dynamically set the form action using jQuery.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question