Jump to content
Server Maintenance This Week. ×

Copy Data Only From Web Viewer


Robert Schaub

This topic is 4972 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

  • 1 month later...

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!

Link to comment
Share on other sites

  • 1 year later...

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"

Link to comment
Share on other sites

This topic is 4972 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.