Copy Data Only From Web Viewer

[Robert Schaub]

I am looking for an easy way to copy data from a web viewer. If I right click on the WV and choose [select All], Then a soft right click and choose [Copy] I can then paste it and parse out the content I want to use. I need a way to automate this because there are a thousand records.

I tried

GetLayoutObjectAttribut( "webviewer" ; "source" )

this only grabs the website address , which I already know , it's in the web viewer.

I also tried

GetLayoutObjectAttribut( "webviewer" ; "content" )

Which returns html. Which makes parsing a real P.I.A.

Anyone got any ideas on hoe to automate this?

[comment]

I am looking for an easy way to copy data from a web viewer.

Aren't we all…

Have you tried:

Go to Object [ Object Name: "MyWebViewer" ]

Select All

Copy [ ]

Paste [ Table::ExtractedText ]

This may work or not, depending on the site.

Alternatively, you could use some OS-level scripting, bypassing the web viewer altogether. I believe there's also a plugin or two that can do this.

[Robert Schaub]

Yes I did try that. I get nothing from the web. However it does copy everything else on th record.

[comment]

Can you post the URL of the site you are trying to scrape?

[Raybaudi]

Hi comment

this tecnique do not work on win.

Even by hand I can't give the FM menu command: select all ( really I can but with not effects )when the focus is on the WebViewer.

I have to give the IE menu command: select all by right clicking when into the WV.

[Robert Schaub]

Follow up

Best solutions so far

GetLayoutObjectAttribute ( "webviewer";"content" )

and a custonm function to parse the content you want out of the html.

This is the option I choose, I fished through the hmtl and got what I need to parse and move to fields in FileMaker

or

360Works has a plugin called WebAssistant which will grab the html and the strip the tags. This works great except it also strips all extra carrige returns which in some cases it is need to save them. Funny thing is if you copy a sting where returns are know to a non FM app like Word the returns are there but not in FM.

Anyway a good tool with lots of other functions.

[Cabinetman]

GetLayoutObjectAttribut( "webviewer" ; "content" )

Anyone got any ideas on hoe to automate this?

I have had to do a lot of the same thing and am using a program called Detagger.

One version can run from c prompt.

It takes a flat html file and strips out or even adds to it creating an importable tab del file by using a file you create.

WARNING - it takes some work to set it up if the page is complex and minor changes in the HTML of the web site can throw it off from time to time... But once you set it right it does help a good bit.

1. field1 = GetLayoutObjectAttribut( "webviewer" ; "content" )

2. export field contents of field1 to webpage.html

3. Run detagger on webpage.html creating webpage.txt in tab del

4. Import webpage.txt

http://www.jafsoft.com/detagger/

Good luck and feel free to message me for a little help. Lord knows I got a bunch of help myself!

[CliffS]

This thread has been very helpful to me!

I've just used it to get the raw html from a webpage into Filemaker. Once inside filemaker, I parse the html, searching for keywords.

Now, if only there were a way to copy text from a filemaker field and paste it into a specific fields in the web viewer!

[Laurence]

I am looking for an easy way to copy data from a web viewer. If I right click on the WV and choose [select All], Then a soft right click and choose [Copy] I can then paste it and parse out the content I want to use. I need a way to automate this because there are a thousand records.

I tried

GetLayoutObjectAttribut( "webviewer" ; "source" )

this only grabs the website address , which I already know , it's in the web viewer.

I also tried

GetLayoutObjectAttribut( "webviewer" ; "content" )

Which returns html. Which makes parsing a real P.I.A.

Anyone got any ideas on hoe to automate this?

To automate this in a script:

use the 'set field' command, then choose the field you want the source put into, then specify calculation: GetLayoutObjectAttribute ( "Browser" ; "content")

you need to alocate a name to the object (in the info section' e.g, "browser"