Assuming the CRM is web-based, that certainly could be done using screen-scraper. The simplest way would probably be to first save your Excel spreadsheet as a CSV file. You could then set up a screen-scraper script similar to the one exemplified in our seventh tutorial ([url]http://www.screen-scraper.com/support/tutorials/tutorial7/tutorial_overview.php[/url]). After that, you would probably use a technique similar to the one we illustrate in our fifth tutorial ([url]http://www.screen-scraper.com/support/tutorials/tutorial5/tutorial_overview.php[/url]). I'm guessing, though, that the CRM would likely require some sort of authentication, so you'd need to deal with that as well.
If you're looking to tackle this project yourself, you'll probably want to start by going through our first few tutorials. After that, if you feel like you have a pretty good feel for screen-scraper, you can probably take it on. If you're open to the idea of outsourcing the project, feel free to drop us a request for a free quote ([url]http://www.screen-scraper.com/services/services.php[/url]).
Web Data Extraction
Can I scrape from Excel
Hi Graham,
Assuming the CRM is web-based, that certainly could be done using screen-scraper. The simplest way would probably be to first save your Excel spreadsheet as a CSV file. You could then set up a screen-scraper script similar to the one exemplified in our seventh tutorial ([url]http://www.screen-scraper.com/support/tutorials/tutorial7/tutorial_overview.php[/url]). After that, you would probably use a technique similar to the one we illustrate in our fifth tutorial ([url]http://www.screen-scraper.com/support/tutorials/tutorial5/tutorial_overview.php[/url]). I'm guessing, though, that the CRM would likely require some sort of authentication, so you'd need to deal with that as well.
If you're looking to tackle this project yourself, you'll probably want to start by going through our first few tutorials. After that, if you feel like you have a pretty good feel for screen-scraper, you can probably take it on. If you're open to the idea of outsourcing the project, feel free to drop us a request for a free quote ([url]http://www.screen-scraper.com/services/services.php[/url]).
Kind regards,
Todd Wilson