title: How to automatically download matching entries from Socorro and Bugzilla servers?
body: <p>This is part one of a complex question.</p>
  
  <p>The goal is to download all crash reports that have a bug id assigned to them (or just all of them) from the <code>Socorro server</code>. This needs to be done for several versions of the FennecAndroid product.</p>
  
  <blockquote>
    <p><a href="https://crash-stats.mozilla.org/topcrashers/?product=FennecAndroid&amp;version=49.0a1&amp;days=7" rel="nofollow">https://crash-stats.mozilla.org/topcrashers/?product=FennecAndroid&amp;version=49.0a1&amp;days=7</a>
    (there might be a better way to access the actual data instead of statistics I haven't found yet)</p>
  </blockquote>
  
  <p>But there is also a second part to this problem as for each downloaded crash report I have to download and store the corresponding <code>Bugzilla</code> bug entries indicated by bug id`s.</p>
  
  <p>And lastly I need to find a tool or method to import downloaded entries from both Socorro and <code>Bugzilla</code> into a local <code>MySQL database</code> (into different tables of course). </p>
  
  <p>Needless to say right now I don't know how to solve any of these problems, so any assistance in this matter is greatly appreciated!</p>