Databases
StackOverflow2013
Postsdbo
POAuto-download involving password and specific online clicking
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAuto-download involving password and specific online clicking
    primarykey
    data
    text
    <p>I want to use cron to do a daily download of portfolio info with 2 added complications:</p> <ol> <li>It needs a password </li> <li>I want to get the format I can get, when on the site myself, by clicking on "Download to a Spreadsheet </li> </ol> <p>If I use: </p> <pre><code>wget -U Chromium --user='e-address' --password='pass' \ https://www.google.com/finance/portfolio &gt; "file_"`date +"%d-%m-%Y"`+.csv </code></pre> <p>I Get the response: </p> <pre><code>========================================================================= --2013-10-20 12:16:13-- https://www.google.com/finance/portfolio Resolving www.google.com (www.google.com)... 74.125.195.105, 74.125.195.103, 74.125.195.99, ... Connecting to www.google.com (www.google.com)|74.125.195.105|:443... connected. HTTP request sent, awaiting response... 200 OK Length: unspecified [text/html] Saving to: ‘portfolio’ [ &lt;=&gt; ] 16,718 --.-K/s in 0.04s 2013-10-20 12:16:13 (431 KB/s) - ‘portfolio’ saved [16718] ========================================================================== </code></pre> <p>It saves to a file called "portfolio" rather than where I asked it to ("file_"<code>date +"%d-%m-%Y"</code>+.csv). When I look at "portfolio" in the browser it says I need to sign in to my account ie no notice is taken of the user and password information I've included. </p> <p>If I add to the web address the string I get by hovering on the "Download to a Spreadsheet" link:- </p> <pre><code>wget -U Chromium --user='e-address' --password='pass' \ https://www.google.com/finance/portfolio?... &gt; "file_"`date +"%d-%m-%Y"`+.csv </code></pre> <p>I get:</p> <pre><code>[1] 5175 [2] 5176 [3] 5177 [4] 5178 --2013-10-20 12:44:56-- https://www.google.com/finance/portfolio?pid=1 Resolving www.google.com (www.google.com)... [2] Done output=csv [3]- Done action=view [4]+ Done pview=pview hg21@hg21-sda2:~$ 74.125.195.106, 74.125.195.103, 74.125.195.104, ... Connecting to www.google.com (www.google.com)|74.125.195.106|:443... connected. HTTP request sent, awaiting response... 200 OK Length: unspecified [text/html] Saving to: ‘portfolio?pid=1’ [ &lt;=&gt; ] 16,768 --.-K/s in 0.05s 2013-10-20 12:44:56 (357 KB/s) - ‘portfolio?pid=1.1’ saved [16768] </code></pre> <p>and at this point it hangs. The file it writes at this point (‘portfolio?pid=1’) is the same as the 'portfolio' file with the previously used wget. </p> <p>If I then put in my password it continues:</p> <pre><code>pass: command not found [1]+ Done wget -U Chromium --user="e-address" --password='pass' https://www.google.com/finance/portfolio?pid=1 [1]+ Done wget -U Chromium --user="e-address" --password='pass' https://www.google.com/finance/portfolio?pid=1 </code></pre> <p>Any help much appreciated.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USStvnW
    1. USuser2900160
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POAuto-download involving password and specific online clicking
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. This table or related slice is empty.
 

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