Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Latest Approach : </p> <ol> <li>We allow ga to load normally.</li> <li>We store a reference to ga dom element in a global variable (gaClone).</li> <li><p>We set a timeout of 30seconds. We also set another global variable (loadedGoogleAnalytics) and set it to 0 initially. When ga loads, we set this variable to 1. On the timeout expiry, we check whether ga was loaded or not. If not, we delete the dom element ga.</p> <pre><code>&lt;script type="text/javascript"&gt; var loadedGoogleAnalytics = 0; var gaClone; var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-123456789-1']); _gaq.push(['_trackPageview']); _gaq.push(function() { loadedGoogleAnalytics = 1; //console.log('GA Actualy executed!'); }); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); gaClone = ga; })(); setTimeout(function() { //console.log('timeout fired'); if (loadedGoogleAnalytics != 1) { gaClone.parentNode.removeChild(gaClone); } }, 30000); &lt;/script&gt; </code></pre></li> </ol> <p>[I have verified this approach with one of my actual GA accounts and i am able to see all the realtime tracking]</p> <p>Previous Approach [Note: Ga does not execute if we try to place it in (document).ready();] [This solution does not work]</p> <pre><code>&lt;script type="text/javascript"&gt; $(document).ready(function() { var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-123456789-1']); _gaq.push(['_trackPageview']); srcUrl = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; $.ajax({ url: srcUrl, cache: true, dataType: "script", success: function(data) { //console.log('got the script'); }, error: function() { //console.log('failed to get the script'); }, timeout: 30000 }); }); &lt;/script&gt; </code></pre> <p>Hope this helps</p>
    singulars
    1. This table or related slice is empty.
    1. POIf Google Analytics goes down, how do I keep my site working?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJaspal Singh
    1. USJaspal Singh
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIf Google Analytics goes down, how do I keep my site working?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTBountyClose
    1. COThat gets the ga.js file asynchronously which is good and I like the timeout idea. However it still doesn't initiate the request to actually send the data to Google Analytics. If you watch the NET panel in firebug, nothing is actually sent and if you monitor Google Analytics Live section no page hits come through. So this solves half the problem but the ga.js code is not run when it finishes downloading. I think that ga.js initiates something else which sends the data to google analytics, or it requests a 1x1px gif file or something.
      singulars
      1. PO
      1. USzuallauz
    2. COOk I've figured something out, the _gaq array needs to be initialised in the global scope so it can't be initialized inside the $(document).ready function. I've got something working with a setTimeout which loads the ga.js code and __utm.gif after 10 seconds. Now to see if it'll work with the $.ajax.
      singulars
      1. PO
      1. USzuallauz
    3. COAlso interesting note on the jQuery.ajax timeout property: "In Firefox 3.0+ only, script and JSONP requests cannot be cancelled by a timeout; the script will run even if it arrives after the timeout period." so I've been testing on Firefox which is another issue. I'll switch to Chrome for testing.
      singulars
      1. PO
      1. USzuallauz
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload