Import from Excel / CSV

Top  Previous  Next

Import from Excel / CSV

Bookmarks (incl. bookmark properties) can be imported from the first sheet of an Excel workbook or an CSV file. Supported file extensions are xls, xlsx and csv.

 

The first row must contain the field names that should be imported. The following rows must contain the values of the bookmark properties (one bookmark per row).

 

The following screenshot shows a typical Excel sheet:

 

import_excel

 

You only have to specify the fields that you want to import. The smallest sheet would be a table with only one column that contains the URL field.

 

Supported fields:

 

General

Topic

Field

Description

wswid

Unique WebSite-Watcher bookmark ID that is written when you export bookmarks.
If this ID is available when importing bookmarks, then WebSite-Watcher will use that ID to identify a bookmark. Otherwise a combination of URL/check_macro/postdata is used.

name

Bookmark name

url

URL of the bookmark. If no wswid is available, then this field must be available, otherwise the row will not be imported.

url2

Alternative check URL

check_macro

Source code of a check macro

postdata

PostData if the bookmark is checked via the POST command

 

Filter

Topic

ignore_filter

Manual ignore filter definitions with one filter per line.

watch_filter

Manual watch filter definitions with one filter per line.

ignore_removed_elements

Special filter: Ignore removed elements. Valid values: 0 or 1

ignore_html_tags

Special filter: Ignore all HTML tags. Valid values: 0 or 1

ignore_upper_lower

Special filter: Ignore upper/lowercase. Valid values: 0 or 1

ignore_dropdown

Special filter: Ignore entries in dropdown and list boxes

filter_sort_content

Special filter: Sort page content.

Valid values:

0 = no sorting

1 = sort page content by words

2 = sort page content by sentences

 

Keywords

Topic

highlight_keywords

Highlight keywords. One keyword per line.

same_keywords_as_above

Use same keywords as above. Valid values: 0 or 1

update_on_keywords

Updates on keywords. One keyword per line.

 

AutoWatch

Topic

autowatch

Enable AutoWatch. Valid values: 0 or 1

autowatch_automatic

Enable or disable automatic time configuration

Valid values:

1 = Use Automatic time configuration

2 = Use the manual "Check every..." time configuration

autowatch_check_every_value

Value of the "Check every..." time configuration

autowatch_check_every_unit

Unit of the "Check every..." time configuration

Valid values:

s = seconds

m = minutes

h = hours

d = days

autowatch_check_every_time

Time value for "Check every X days"

autowatch_max_one_update_per_day

Option "Max one update per day". Valid values: 0 or 1

autowatch_only_check_between

Only check in specified time frame.

Format: HH:MM-HH:MM

If a cell doesn't use exactly that syntax, then the cell value is ignored.

autowatch_dont_check_between

Don't check in specified time frame.

Format: HH:MM-HH:MM

If a cell doesn't use exactly that syntax, then the cell value is ignored.

autowatch_check_on_days

Check only on certain days.

Valid values: x = don't check, 1=check

Format: 7 characters with x or 1, the first character is Monday, the second character is Tuesday, etc.

Example: xxxxx11 (check only on Sat and Sun)

 

Check

Topic

alert_on_initialization

Alert/Actions on initialization. Valid values: 0 or 1

alert_on_update

Alert/Actions on update. Valid values: 0 or 1

alert_on_error

Alert/Actions on error. Valid values: 0 or 1

alert_on_error_count

Alert after X errors in a row. Valid values: 1-99

check_technology

Technology to check web pages

Valid values:

1=Default

2=Internet Explorer/Browser

3=Screenshot

delay_after_page_loaded

Number of seconds for option "Delay after page has loaded". Only in combination with check technology "IE/Browser" or "Screenshot".

follow_javascript_redirections

Enable option "Follow javascript redirections". Valid values: 0 or 1

This option should only be enabled when the page cannot be checked without it!

disable_optimizations

Enable option "Disable optimizations". Valid values: 0 or 1

This option should only be enabled when the page cannot be checked without it!

scroll_pages_down

Number of pages that should be scrolled down during a check. Only in combination with check technology "IE/Browser" or "Screenshot".

 

Actions

Topic

action_sendmail

Enable bookmark action Send e-mail. Valid values: 0 or 1

action_sendmail_format

E-Mail format

Valid values:

html = send mail in HTML format

text = send mail in text format

action_sendmail_attach_changes

Attach file with highlighted changes. Valid values: 0 or 1

action_sendmail_attach_new

Attach new version of the page. Valid values: 0 or 1

action_sendmail_attach_old

Attach old version of the page. Valid values: 0 or 1

action_sendmail_ignore_css

Ignores CSS definitions when sending e-mails in HTML format. Valid values: 0 or 1

action_sendmail_emails

Alternative e-mails. Multiple e-mails must be separated with a comma or a blank.

action_sendmail_queue_with_priority

Send before other e-mails. Valid values: 0 or 1

action_sendmail_subject

Alternative subject. The subject field supports the same variables as available in the program configuration.

action_sendmail_template

Optional e-mail template.

action_mark_as_read

Enable bookmark action Mark as read.

If you don't open bookmarks within WebSite-Watcher (eg. when reading changed bookmarks only in your e-mail client), then you should also enable the Mark-As-Read action.

action_export

Enable the bookmark action Export. Valid values: 0 or 1

action_export_filename

Export filename. Supported variables can be found in topic Actions

action_export_pageversion

Valid values:

0 = Version with highlighted changes

1 = New version

action_export_format

Valid values:

0 = HTML format

1 = Text format

2 = Complete web page

 

Options

Topic

jump_to_first_change

Jump to the first highlighted change. Valid values: 0 or 1

jump_to_first_keyword

Jump to the first keyword (within highlighted changes). Valid values: 0 or 1

prevent_horizontal_scrolling

Prevent horizontal scrolling. Valid values: 0 or 1

offset_before_change

Offset before the first highlighted change in pixel.

show_removed_content

Show removed elements at the bottom of the page. Valid values: 0 or 1

show_last_change_marker

Show last change marker. Valid values: 0 or 1

dont_check

Enable the option "Don't check". Valid values: 0 or 1

 

Ignore updates

Topic

ignore_updates_is_blacklist

Defines if the entered words/phrases are a blacklist (1) or a whitelist (0). Valid values: 0 or 1

ignore_updates_words

Words/phrases

ignore_updates_min_char_count

Required number of characters. A value larger than zero means that this option is active.

 

Troubleshooting

Topic

troubleshooting_ignore_css

Ignore document CSS definitions. Valid values: 0 or 1

troubleshooting_ignore_text_color

Ignore document text color. Valid values: 0 or 1

troubleshooting_ignore_background_color

Ignore document background color. Valid values: 0 or 1

troubleshooting_dont_ignore_noscript

Don't ignore NOSCRIPT parts. Valid values: 0 or 1

troubleshooting_dont_optimize_offlinebrowsing

Don't prepare anything for offline browsing. Valid values: 0 or 1

 

Notes

Topic

note

Bookmark note. Multiple lines are supported.

infofield1

Additional info field #1

infofield2

Additional info field #2

infofield3

Additional info field #3

Export to Excel

WebSite-Watcher can export bookmarks to an Excel file with the same fields as described above. This makes it for example possible to export bookmarks to Excel, change them there and re-import them into WebSite-Watcher.




Translate document: