Too long url Bookmark adress

5 posts 0 new
Log in or register to post comments.

Too long url Bookmark adress

Hi,i need help with long url adress. When i want to get Bookmark url from QPR viewer, I get url more them 255 characters. If i want to use as hyperling in Sharepoint or in MS Office 2017, i get warning message "url is too long". Do you know how to get short url?I try to use http://goo.gl, this goo.gl Google: shortlink has been disabled. It was found to be violating our Terms of Service.

Example of our bookmark url (278 charakters):

http://qprportal.skanska.org/QPR2014-1/Portal/QPR.Isapi.dll?PGPLUGIN&*xlink&VTN=flowchart&SID=iOC0O7afk7waLIGssVmj7G8NmnQ69y97jOXe50r3ogkeMY8Ys.9u53&LAN=en%2c1&SMI=&PERIOD=latestforall&PMAIN=processes&PSUB=PGPLUGIN_processmaps&PPRM=MODELID%3D165850081%3F3_0_165850081_1827859317

thanks for help

Adam

I see three different ways to work around this:

1. Set up a manual URL redirection in IIS on the machine where the SharePoint is running. Of course, you would probably need to do a separate redirection for each overlength URL.

2. Set up your own URL shortening service in IIS on the machine where the SharePoint is running. I haven't checked, but I assume there could be ready made solutions for this.

3. Use some other external URL shortening service. I wouldn't recommend this, as it's a potential security risk.

This problem is very familiar especially with Sharepoint. We have solved it using a javascript redirection page stored in the QPR server. The page is easy to set, but of course all long url's require a separate page. Instructions for setting up can be found here: https://community.qpr.com/node/1704

Sorry I forgot to mention, that the material is currently published only for QPR's partners. I sent the material to your personal email.

The core of the solution is the redirect html page, which code is below:

<!DOCTYPE html>
<html>
  <head>
    <script type="text/javascript">
      function doRedirection(){
        window.location = "URL_HERE";
      }
    </script>
  </head>
  <body onload="doRedirection();">
  </body>
</html>

Error | QPR Community

Error

The website encountered an unexpected error. Please try again later.
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2006 MySQL server has gone away' in /var/www/html/includes/database/database.inc on line 2227 Call Stack: 26.4353 64067848 1. _drupal_exception_handler() /var/www/html/includes/bootstrap.inc:0 26.4354 64069496 2. _drupal_log_error() /var/www/html/includes/bootstrap.inc:2622 PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /var/www/html/includes/database/database.inc on line 2227 Call Stack: 26.4353 64067848 1. _drupal_exception_handler() /var/www/html/includes/bootstrap.inc:0 26.4354 64069496 2. _drupal_log_error() /var/www/html/includes/bootstrap.inc:2622 30.9162 87102656 3. DrupalCacheArray->__destruct() /var/www/html/includes/bootstrap.inc:0 30.9162 87103136 4. ThemeRegistry->set() /var/www/html/includes/bootstrap.inc:460 30.9162 87103480 5. lock_acquire() /var/www/html/includes/theme.inc:449 30.9164 87122120 6. lock_may_be_available() /var/www/html/includes/lock.inc:146 30.9164 87122560 7. db_query() /var/www/html/includes/lock.inc:167 30.9164 87122952 8. DatabaseConnection->query() /var/www/html/includes/database/database.inc:2406