03-04-2017, 08:24 PM
Done!
So doing things by hand suck. I bit the bullet and wrote a few more applications to scrub databases, transform data files, parse the exported data, create relationships with all of the data and build batch files to further automate the process.
Then there was the task of analyzing all of the images and building their thumbnails (in hindsight I could have disabled thumbnails - but oh well...) That was the longest part. And when you make little mistakes like forgetting a "\" or something and then having to re-run the entire process over again wasn't fun. In the end I was a bit glad I wrote the applications since re-running stuff was as simple as hitting F5 in the IDE.
In the end, there were 6,189 total images to upload and 3,094 posts to rebuild.
As for how many in-line links were lost over the years... I'd put the estimate between 20 and 40. Out of the current inline images that weren't pruned in prior years there were 99 and 36 were dead-links. However, thanks to the Internet Archive Wayback Machine I was able to recover 33 of them. The other 3 weren't entirely lost since, believe it or not, I actually remembered what they were and was able to find a similar image.
We're actually in better shape now than where we were last week.
All that's left now is to make a slight code change to display the attachment file names (you can see it if you hover the mouse over the image)
Anyway, that's for another day. Now it's time to drink beer.
So doing things by hand suck. I bit the bullet and wrote a few more applications to scrub databases, transform data files, parse the exported data, create relationships with all of the data and build batch files to further automate the process.
Then there was the task of analyzing all of the images and building their thumbnails (in hindsight I could have disabled thumbnails - but oh well...) That was the longest part. And when you make little mistakes like forgetting a "\" or something and then having to re-run the entire process over again wasn't fun. In the end I was a bit glad I wrote the applications since re-running stuff was as simple as hitting F5 in the IDE.
In the end, there were 6,189 total images to upload and 3,094 posts to rebuild.
As for how many in-line links were lost over the years... I'd put the estimate between 20 and 40. Out of the current inline images that weren't pruned in prior years there were 99 and 36 were dead-links. However, thanks to the Internet Archive Wayback Machine I was able to recover 33 of them. The other 3 weren't entirely lost since, believe it or not, I actually remembered what they were and was able to find a similar image.
We're actually in better shape now than where we were last week.
All that's left now is to make a slight code change to display the attachment file names (you can see it if you hover the mouse over the image)
Anyway, that's for another day. Now it's time to drink beer.