Selasa, 05 April 2016

[smf_addin] Digest Number 3668

4 Messages

Digest #3668

Messages

Mon Apr 4, 2016 1:54 pm (PDT) . Posted by:

herbshack13

Hello,

I am trying to return the string "Rangers" (From "Apr 04, 2016") from the following query link:
http://sportsdatabase.com/mlb/query?output=default&su=1&sdql=game+number+%3D+1+and+%28%28league%3DNL+and+A%29+or+%28league%3DAL+and+H%29%29+and+-120%3E%3Dline%3E%3D-230+and+series+games%3E1+and+20140301%3Cdate%3C%3D20160404&submit=++S+D+Q+L+%21++ http://sportsdatabase.com/mlb/query?output=default&su=1&sdql=game+number+%3D+1+and+%28%28league%3DNL+and+A%29+or+%28league%3DAL+and+H%29%29+and+-120%3E%3Dline%3E%3D-230+and+series+games%3E1+and+20140301%3Cdate%3C%3D20160404&submit=++S+D+Q+L+%21++

As such:


=rchgettablecell("http://sportsdatabase.com/mlb/query?output=default&su=1&sdql=game+number+%3D+1+and+%28%28league%3DNL+and+A%29+or+%28league%3DAL+and+H%29%29+and+-120%3E%3Dline%3E%3D-230+and+series+games%3E1+and+20140301%3Cdate%3C%3D20160404&submit=++S+D+Q+L+%21++ http://sportsdatabase.com/mlb/query?output=default&su=1&sdql=game+number+%3D+1+and+%28%28league%3DNL+and+A%29+or+%28league%3DAL+and+H%29%29+and+-120%3E%3Dline%3E%3D-230+and+series+games%3E1+and+20140301%3Cdate%3C%3D20160404&submit=++S+D+Q+L+%21++",5,AG1,AG1,AG1,AG1,2)


This returns "Error"


If, however, I go back one as such:


=rchgettablecell("http://sportsdatabase.com/mlb/query?output=default&su=1&sdql=game+number+%3D+1+and+%28%28league%3DNL+and+A%29+or+%28league%3DAL+and+H%29%29+and+-120%3E%3Dline%3E%3D-230+and+series+games%3E1+and+20140301%3Cdate%3C%3D20160404&submit=++S+D+Q+L+%21++ http://sportsdatabase.com/mlb/query?output=default&su=1&sdql=game+number+%3D+1+and+%28%28league%3DNL+and+A%29+or+%28league%3DAL+and+H%29%29+and+-120%3E%3Dline%3E%3D-230+and+series+games%3E1+and+20140301%3Cdate%3C%3D20160404&submit=++S+D+Q+L+%21++",5,AG1,AG1,AG1,AG1,1)



"Dodgers" gets returned properly.


Any ideas?


Thanks,
Tom







Mon Apr 4, 2016 2:40 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, no fifth parameter possible. Unfortunately, the tables aren't
completely coded in HTML, so some of the table-based navigation won't work.

But you can do a cascading extraction, where the current line is your
starting point, as long as something in that line is unique to the line.
Would the boxscore URL be unique?

If so, take a look at the attached cascading extraction.

On Mon, Apr 4, 2016 at 1:54 PM, therber2@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hello,
>
> I am trying to return the string "Rangers" (From "Apr 04, 2016") from the
> following query link:
>
> http://sportsdatabase.com/mlb/query?output=default&su=1&sdql=game+number+%3D+1+and+%28%28league%3DNL+and+A%29+or+%28league%3DAL+and+H%29%29+and+-120%3E%3Dline%3E%3D-230+and+series+games%3E1+and+20140301%3Cdate%3C%3D20160404&submit=++S+D+Q+L+%21++
>
>
> As such:
>
> *=rchgettablecell("*
> http://sportsdatabase.com/mlb/query?output=default&su=1&sdql=game+number+%3D+1+and+%28%28league%3DNL+and+A%29+or+%28league%3DAL+and+H%29%29+and+-120%3E%3Dline%3E%3D-230+and+series+games%3E1+and+20140301%3Cdate%3C%3D20160404&submit=++S+D+Q+L+%21++
> "*,5,AG1,AG1,AG1,AG1,2)*
>
> This returns "Error"
>
> *If, however, I go back one as such:*
>
> *=rchgettablecell("*
> http://sportsdatabase.com/mlb/query?output=default&su=1&sdql=game+number+%3D+1+and+%28%28league%3DNL+and+A%29+or+%28league%3DAL+and+H%29%29+and+-120%3E%3Dline%3E%3D-230+and+series+games%3E1+and+20140301%3Cdate%3C%3D20160404&submit=++S+D+Q+L+%21++
> "*,5,AG1,AG1,AG1,AG1,1)*
>
> "Dodgers" gets returned properly.
>
> Any ideas?
>
> Thanks,
> Tom
>

Mon Apr 4, 2016 6:49 pm (PDT) . Posted by:

alanalden

Randy,
Amazing job with the site! I have two problems....


Physical Address (City / State)
I am trying to figure out the best way to import the address of a company into my database. I have looked at a number of sites and see that Yahoo probably has the best example:
http://finance.yahoo.com/q/pr?s=FB+Profile http://finance.yahoo.com/q/pr?s=FB+Profile
a) Is this the best / easiest example?
b) Can you provide an example of a formula/string to import this info. I would like to just import the city, state, and zip


TTM Research and Development
I have tried several without much success to import this (code 3344), but keep getting errors! Any advice or ideas? I really, really appreciate your help! Thanks....












Tue Apr 5, 2016 12:44 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried this, and it worked fine for me:

=RCHGetElementNumber("MMM",3344)

Do you have the latest element definitions? I had to redefine all of the
Google data elements on 2015-12-04. You can check your definition with:

=RCHGetElementNumber("Definition",3344)

Mine is (the change was to make all "http://" URL prefixes to "https://"):

Google;Annual Income Statement -- Research & Development -- FY1;
https://www.google.com/finance?fstype=ii&q=~~~~~;1;INCANNUALDIV;Research &
Development; ; ;0;</TABLE;0;0

========================================================================================

Something like this will get you the whole address section from the Yahoo
page:

=smfGetTagContent("http://finance.yahoo.com/q/pr?s=FB
","td",-1,"class=""yfnc_modtitlew1""")

Depending on how much uniformity there is in how the web page is coded,
this might extract the city, state, and zip from most:

=TRIM(smfWord(smfGetTagContent("http://finance.yahoo.com/q/pr?s=FB
","td",-1,"class=""yfnc_modtitlew1"""),3,"<br>"))

On Mon, Apr 4, 2016 at 4:55 PM, tikwart@... wrote:

>
> Randy,
> Amazing job with the site! I have two problems....
>
> *Physical Address (City / State)*
> I am trying to figure out the best way to import the address of a company
> into my database. I have looked at a number of sites and see that Yahoo
> probably has the best example:
> http://finance.yahoo.com/q/pr?s=FB+Profile
> a) Is this the best / easiest example?
> b) Can you provide an example of a formula/string to import this
> info. I would like to just import the city, state, and zip
>
> *TTM Research and Development*
> I have tried several without much success to import this (code 3344), but
> keep getting errors! Any advice or ideas? I really, really appreciate
> your help! Thanks....
>
>
>
>
>
>
>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar