Forum Discussion
jwcolby54
Sep 17, 2023Explorer
I am a database analyst / programmer. I built a database using MS Access and scraped 103 records from the CA website, specifically for the 28a. I managed to miss 2 of the records currently out there. I have not done the same for the 25a simply because I am not interested in those and...
It was a bit of a pita doing this as I had to click on each and every one of the listings to get into the second page because the VIN and the miles are only available on the second page. Sigh.
But it is done. Now I have to check up occasionally to see new listings as they occur. BTW if there is anyone out there who can actually automate this using for example Python and wants to help me do this please do speak up. I managed to use the windows paste buffer to paste it into my db, from where I parse the 10 lines of text into the various prices and other fields.
I can export this thing out to an Excel spreadsheet if anyone is interested in seeing what is out there and how the prices break around the miles and year.
2018 prices range from $38850 with 136302 miles vs $46850 with 96850 miles.
2019s range from $39,350.00 for 150562 miles up to $46,850.00 for 117924 miles.
Of course I also have the location where each unit is being sold.
I have the VIN and did a basic lookup on it. Not much of interest to me in that.
It was a bit of a pita doing this as I had to click on each and every one of the listings to get into the second page because the VIN and the miles are only available on the second page. Sigh.
But it is done. Now I have to check up occasionally to see new listings as they occur. BTW if there is anyone out there who can actually automate this using for example Python and wants to help me do this please do speak up. I managed to use the windows paste buffer to paste it into my db, from where I parse the 10 lines of text into the various prices and other fields.
I can export this thing out to an Excel spreadsheet if anyone is interested in seeing what is out there and how the prices break around the miles and year.
2018 prices range from $38850 with 136302 miles vs $46850 with 96850 miles.
2019s range from $39,350.00 for 150562 miles up to $46,850.00 for 117924 miles.
Of course I also have the location where each unit is being sold.
I have the VIN and did a basic lookup on it. Not much of interest to me in that.
Jvacorn
Sep 12, 2024Explorer
I would be interested in your database export, although I have a 23A. Seems like they still have a lot of similarities. Thanks
About Motorhome Group
38,705 PostsLatest Activity: Jan 14, 2025