I was just wondering if screen scraper could read input from something other than a CSV file? Can it read in from a table in a database or anything? Just wondering
We do that all all the time, but the code to do so isn't native to screen-scraper. Because we want to interface with any sort of DB, we just use a library based on the project's specific needs.
Thanks for the reply back. I would love to find out how you do it. I have a table in MS Access and need it to read in a field in the table to have it use as the input.
Here is an example we have on the community site working with a JDBC database connection. This would be a similar process I think for you. You'd probably look for a connector between java and you Microsoft Access database and then after establishing the connection, you'd be able to execute queries against the database in java.
This is a really common operation for many java users, so this should be really well documented all over the web. However, it's not the most simple thing in the world so don't give up if it doesn't work the first time :)
Thanks for the link Jason. I read over the first part and confused on what needs to go in the lib/ext folder. I know it says connector but I don't know what file needs to be in there from the mysql connector.
download the odbc driver and extract the .jar file from the .zip (alternatively you could do the msi for Microsoft products and install it). Then place that .jar file into the lib/ext folder. That would put it in the namespace for screen-scraper to import from. The rest of the document should be easier to follow after this step.
I believe Jason (jsncochran) was looking for an MS Access solution, actually.
Jason,
Here are two possible solutions.
1. Build your own JDBC-ODBC bridge jar file using sample Java code from this tutorial.
2. Utilize an existing MS Access JDBC driver developed by one of the companies found here.
Additional support regarding either of the above suggested solutions would fall outside of the scope of this forum and would need to be addressed at the source of the solution you choose.
Web Data Extraction
We do that all all the time,
We do that all all the time, but the code to do so isn't native to screen-scraper. Because we want to interface with any sort of DB, we just use a library based on the project's specific needs.
Jason Thanks for the reply
Jason
Thanks for the reply back. I would love to find out how you do it. I have a table in MS Access and need it to read in a field in the table to have it use as the input.
JDBC example
Hi,
Here is an example we have on the community site working with a JDBC database connection. This would be a similar process I think for you. You'd probably look for a connector between java and you Microsoft Access database and then after establishing the connection, you'd be able to execute queries against the database in java.
This is a really common operation for many java users, so this should be really well documented all over the web. However, it's not the most simple thing in the world so don't give up if it doesn't work the first time :)
Hope this example helps:
JDBC database example
Thanks for the link Jason. I
Thanks for the link Jason. I read over the first part and confused on what needs to go in the lib/ext folder. I know it says connector but I don't know what file needs to be in there from the mysql connector.
Jason
for example
the .jar file is going to go into the lib/ext folder. For example you could go here:
odbc
download the odbc driver and extract the .jar file from the .zip (alternatively you could do the msi for Microsoft products and install it). Then place that .jar file into the lib/ext folder. That would put it in the namespace for screen-scraper to import from. The rest of the document should be easier to follow after this step.
Hope that helps.
MS Access JDBC solution
Scraper,
I believe Jason (jsncochran) was looking for an MS Access solution, actually.
Jason,
Here are two possible solutions.
1. Build your own JDBC-ODBC bridge jar file using sample Java code from this tutorial.
2. Utilize an existing MS Access JDBC driver developed by one of the companies found here.
Additional support regarding either of the above suggested solutions would fall outside of the scope of this forum and would need to be addressed at the source of the solution you choose.
-Scott