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_words

Special filter: Sort words. Valid values: 0 or 1

 

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

 

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!

 

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_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_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.

 

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.