F
Fred Boer
Hello:
I am working on a process to automate searches (within Access) of web hosted
databases, specifically library databases, such as the Library of Congress,
to download cataloguing data into my library application. I have discovered
the SRU (Search/Retrieve via URL) protocol. It uses something called CQL
(Common Query Language). Has anyone had any experience using either of
these? An example of a working SRU is reproduced below; paste it into an
address bar to see how it works...
I think I can make this work with the following process:
1. User enters ISBN.
2. VBA code generates SRU with user ISBN.
3. Load the web browser control with the generated SRU
4. Scrape the text from the resulting web page
5. Parse and insert into form
Along the same lines...:
In professional library software, I have seen similar functionality, but
using commercial sites, such as Amazon.com. For example, the user enters an
ISBN, and book information is retrieved from Amazon - anybody know how that
works? The search urls seem similar to the example below...
Example:
http://z3950.loc.gov:7090/voyager?v...y=0672321017&maximumRecords=1&recordSchema=dc
Thanks!
Fred Boer
I am working on a process to automate searches (within Access) of web hosted
databases, specifically library databases, such as the Library of Congress,
to download cataloguing data into my library application. I have discovered
the SRU (Search/Retrieve via URL) protocol. It uses something called CQL
(Common Query Language). Has anyone had any experience using either of
these? An example of a working SRU is reproduced below; paste it into an
address bar to see how it works...
I think I can make this work with the following process:
1. User enters ISBN.
2. VBA code generates SRU with user ISBN.
3. Load the web browser control with the generated SRU
4. Scrape the text from the resulting web page
5. Parse and insert into form
Along the same lines...:
In professional library software, I have seen similar functionality, but
using commercial sites, such as Amazon.com. For example, the user enters an
ISBN, and book information is retrieved from Amazon - anybody know how that
works? The search urls seem similar to the example below...
Example:
http://z3950.loc.gov:7090/voyager?v...y=0672321017&maximumRecords=1&recordSchema=dc
Thanks!
Fred Boer