Importing data from password-protected web sites
When importing data from a web site, you can include a username and password in the URL (web site address) to give Dabble DB access to password-protected web sites.
The format is as follows:
http://username:password@website.com/page.html
Certain special characters, including most punctuation and any accented letters, must be URL-encoded. URL encoding uses two-digit hexadecimal numbers to replace the actual letters or punctuation.
As an example, if the username required is an email address, the dots and @ sign must be encoded.
info@dabbledb.com would become info%40dabbledb%2Ecom and the full URL would be
http://info%40dabbledb%2Ecom:password@website.com/page.html.
| Punctuation | Code |
|---|---|
| ! | %21 |
| * | %2A |
| ’ | %27 |
| ( | %28 |
| ) | %29 |
| . | %2E |
| ; | %3B |
| : | %3A |
| @ | %40 |
| & | %26 |
| = | %3D |
| + | %2B |
| $ | %24 |
| , | %2C |
| / | %2F |
| ? | %3F |
| % | %25 |
| # | %23 |
| [ | %5B |
| ] | %5D |
