Search found 518 matches

by webmaster
Sat Mar 05, 2022 8:09 am
Forum: Q/A
Topic: Only export to CSV if not empty?
Replies: 1
Views: 786

Re: Only export to CSV if not empty?

I'm assuming you have a table that you don't want to export if it's empty? Supposing you have a table called Test , you can first create a query by right-clicking your table ( Data.Test in this case) in Project Explorer , selecting Create Query , leaving everything with the default values and pressi...
by webmaster
Wed Feb 02, 2022 9:52 pm
Forum: Q/A
Topic: Selectors: Extracting multiple rows of data into individual table columns
Replies: 2
Views: 1056

Re: Selectors: Extracting multiple rows of data into individual table columns

You can do this using a single selector that selects all images. But note that the columns must be already defined (they cannot be created dynamically at run-time). Since each column will always extract the first item selected by the selector, you can use Sequence.Skip to skip images like this: extr...
by webmaster
Fri Jan 28, 2022 11:24 am
Forum: Q/A
Topic: Extracting data from iframe on another domain
Replies: 2
Views: 1034

Re: Extracting data from iframe on another domain

I'll just copy/paste my response to the other similar question. Just right-click Text.Iframe_url and select Output Result (or alternatively, left-click it and press the space bar). A placeholder [name] at the bottom will appear: Text.Iframe_url as [name] Then replace the [name] placeholder with a va...
by webmaster
Fri Jan 28, 2022 11:21 am
Forum: Q/A
Topic: Iframe
Replies: 4
Views: 10653

Re: Iframe

You're pretty close. Just right-click Text.Iframe_url and select Output Result (or alternatively, left-click it and press the space bar). A placeholder [name] at the bottom will appear: Text.Iframe_url as [name] Then replace the [name] placeholder with a variable name, such as url , and finally repl...
by webmaster
Sat Jan 22, 2022 4:48 pm
Forum: Q/A
Topic: Action.ExportQuery
Replies: 2
Views: 1058

Re: Action.ExportQuery

This function needs an actual query, not a query name as the first argument, so something like this would work: Action.ExportQuery · "select * from MyTable" · "hello.csv" · true If the query is large or has multiple lines, you can also use a script at Project Explorer > Scripting > Scripts since scr...
by webmaster
Sun Sep 26, 2021 10:22 pm
Forum: Q/A
Topic: While Loop Function in recurring actions
Replies: 1
Views: 1616

Re: While Loop Function in recurring actions

That's now easy to do (since version 3.2.7.9) with the WhileAny function. In the documentation there's an example showing how to stop the extraction when a post with a certain text is found. In your case, you could, first create a query at Project Explorer > Data Flow > Queries that gets the latest ...
by webmaster
Tue May 11, 2021 8:38 pm
Forum: Q/A
Topic: Sequencing Click to Load additional Elements, then, Extraction Logic
Replies: 1
Views: 2488

Re: Sequencing Click to Load additional Elements, then, Extraction Logic

Note that clicking a button 50 times and then extracting the content involves exact same steps as, in a site that has pages, clicking the next button to turn the pages 50 times, and then extracting from the 51st page. So you can use Browser.TurnPages to repeatedly click the button (or even better, B...
by webmaster
Tue May 11, 2021 8:28 pm
Forum: Q/A
Topic: How to proceed on Last Page
Replies: 1
Views: 2173

Re: How to proceed on Last Page

That's how it's meant to work, when there is no next button, it extracts the current page and then it stops. Are you not getting results from the last page?
by webmaster
Wed Apr 21, 2021 5:44 pm
Forum: Q/A
Topic: example of IF
Replies: 1
Views: 2325

Re: example of IF

If this is an element on a page, such as a title, you first need to create a selector that selects this element (suppose you call it Header ), and then use the following code: Sequence.IfAny · Select.Header · [ifAny] · Sequence.Empty Then just replace [ifAny] with whatever actions extract from the p...
by webmaster
Sat Jan 09, 2021 6:32 pm
Forum: Q/A
Topic: How to login to pages
Replies: 3
Views: 4477

Re: How to login to pages

Here's how to use the login premade. If that doesn't work, this is how to use the fill form wizard to login.