Posts

Showing posts from August, 2023

ExportFileFilterByIndexList: VBA code to filter Blogger XML Backup/Export file based on Entry Index List text file

Image
Last updated on 25 Feb. 2024 25 Feb. 2024 Update: I rarely use the software covered in this post now. To see the current software for creating Blogger blogbooks that I use, please visit: Short User Guide to creating Blogger Blogbooks from Backup/Export File using ExportFileFilterAndGenBook and another VBA projects' macros/code (free and open source), https://ravisiyermisc.blogspot.com/2023/09/short-user-guide-to-creating-blogger.html .  Also see: Ported ExportFileFilterAndGenBook and ExportFileFilterByIndexList from VBA to BlogBackupToBook VB.Net single project of Visual Studio 2022 Community Edition, https://ravisiyermisc.blogspot.com/2023/09/ported-exportfilefilterandgenbook-from.html . Quick Info Top-level folder share: ExportFileFilterByIndexList,  https://drive.google.com/drive/folders/1t7IPjwuU791t58EJOZEmxrSbWeFBHiSF?usp=drive_link Version v3 sub-folder:  https://drive.google.com/drive/folders/1aPLQQV6mWOelBBeiIyK9tIrV7k-qk7ZE?usp=drive_link v3/Info.txt:  https://drive.goo

SplitBlogBookAndGenContentsLinks: VBA code to Split HTML blogbook into smaller HTML files and/or Generate Contents Internal Links List for it

Last updated on 30 Aug. 2023 Note: As of 30 Aug. 2023, this SplitBlogBookAndGenContentsLinks macro functionality has got incorporated into ExportFileFilterAndGenBook. To know more about the latter, please visit: ExportFileFilterAndGenBook: Filter Blogger XML Backup file based on date range, produce HTML Blogbook filtered by search string, Split it and Generate Contents Links (VBA project),  https://ravisiyermisc.blogspot.com/2023/08/exportfilefilterandgenbook-vba-code-to.html . Quick Info Top-level folder share: SplitBlogBookAndGenContentsLinks,   https://drive.google.com/drive/folders/1njj5PaAwPTgpfRePOArwDUq_oXwvHvdQ?usp=drive_link Version v1 sub-folder:  https://drive.google.com/drive/folders/1YZ5_63Nxic6Cg4Jx7a0sZMZsiTzVeWLT?usp=drive_link v1/Info.txt:  https://drive.google.com/file/d/14hvtQADzmx4cFpSQXyoXNZyKzUgJXlAn/view?usp=drive_link   End Quick Info This SplitBlogBookAndGenContentsLinks project renames the old SplitBlogBook project to a more appropriate name. [Ref: SplitBlogB

ExportFileFilterAndGenBook: Filter Blogger XML Backup file based on date range, produce HTML Blogbook filtered by search string, Split it and Generate Contents Links (VBA project)

Image
Last updated on 25 Feb. 2024 25 Feb. 2024 Update: I rarely use the software covered in this post now. To see the current software for creating Blogger blogbooks that I use, please visit: Short User Guide to creating Blogger Blogbooks from Backup/Export File using ExportFileFilterAndGenBook and another VBA projects' macros/code (free and open source), https://ravisiyermisc.blogspot.com/2023/09/short-user-guide-to-creating-blogger.html .  Also see: Ported ExportFileFilterAndGenBook and ExportFileFilterByIndexList from VBA to BlogBackupToBook VB.Net single project of Visual Studio 2022 Community Edition, https://ravisiyermisc.blogspot.com/2023/09/ported-exportfilefilterandgenbook-from.html . --- end 25 Feb. 2024 Update --- I decided to put up and publish this post now on 20 Aug 2023 while this work is in progress, as I wanted to ensure that whatever work I have done till now is available for interested readers.  Quick Info Top-level folder share: ExportFileFilterAndGenBook,  https:/

FilterXMLExportFile: VBA code to create XML file of XML entries of posts and pages matching a specified date range from Blogger XML Backup/Export file

Last updated on  9 Sep. 2023   9 Sep. 2023 Update: I rarely use the software covered in this post now. To see the current software for creating Blogger blogbooks that I use, please visit:  Short User Guide to creating Blogger Blogbooks from Backup/Export File using ExportFileFilterAndGenBook and another VBA projects' macros/code (free and open source), https://ravisiyermisc.blogspot.com/2023/09/short-user-guide-to-creating-blogger.html . end-Update 9 Sep. 2023 I decided to put up and publish this post now on 18 Aug 2023 while this work is in progress, as I wanted to ensure that whatever work I have done till now is available for interested readers. Quick Info Top-level folder share: FilterXMLExportFile,  https://drive.google.com/drive/folders/1xXkUn1et7hoXZM1kILymI9h4s4AT7eVi?usp=drive_link Version v2 adds Updated Date range match to version v1's Published Date range match. Version v2 sub-folder:  https://drive.google.com/drive/folders/1IodrPq-_kp1gP652PqJburkb5yl7xkKt?usp=dri

AddNewLineToEntryNodes: VBA code to add newline characters at start of entry nodes in Blogger XML Backup/Export file to enable easier viewing and editing in Notepad++

Last updated on  9 Sep. 2023   9 Sep. 2023 Update: I rarely use the software covered in this post now. To see the current software for creating Blogger blogbooks that I use, please visit:  Short User Guide to creating Blogger Blogbooks from Backup/Export File using ExportFileFilterAndGenBook and another VBA projects' macros/code (free and open source),  https://ravisiyermisc.blogspot.com/2023/09/short-user-guide-to-creating-blogger.html  . end-Update 9 Sep. 2023 Quick Info Top-level folder share: AddNewLineXMLExportFile,  https://drive.google.com/drive/folders/11Qr6rmw8k2sNu0dTWRvnwoVzYCtobV5S?usp=drive_link Version v1 sub-folder:  https://drive.google.com/drive/folders/1xHTEpOHFZihYakqYQnLnncxzSxDF6S33?usp=drive_link Info.txt,  https://drive.google.com/file/d/1GUVG5HzqznUsz1bgR08H8oCG08lSGPvV/view?usp=drive_link End Quick Info Microsoft Visual Basic for Applications (VBA) Sub./macro AddNewLineToEntryNodes adds newline characters at the beginning of all entry nodes in input Blogger

BlogExportFileSearchToBook: VBA code to produce HTML blog book from Blogger blog backup/export XML file optionally limited to content matching search string

Last updated on  9 Sep. 2023   9 Sep. 2023 Update: I rarely use the software covered in this post now. To see the current software for creating Blogger blogbooks that I use, please visit:  Short User Guide to creating Blogger Blogbooks from Backup/Export File using ExportFileFilterAndGenBook and another VBA projects' macros/code (free and open source),  https://ravisiyermisc.blogspot.com/2023/09/short-user-guide-to-creating-blogger.html  . end-Update 9 Sep. 2023 I decided to put up and publish this post now on 12 Aug 2023 while this work is in progress, as I wanted to ensure that whatever work I have done till now is available for interested readers. Code text file name suffix of gs.txt issue: Unfortunately, I have named some code copied as text files with suffix of gs.txt instead of vb.txt. Please excuse that error which came up as I was earlier working with Google Apps Script projects where I used gs.txt as suffix for code copied as text files. This program upgrades BlogExportFi

Generated blogbook of my Misc. Tech. WordPress blog using my VBA program WPBlogExportFileToBook

Last updated on 29 Feb. 2024 I decided to put up and publish this post now on 8 Aug 2023 while this work is in progress, as I wanted to ensure that whatever work I have done till now is available for interested readers.  Quick-Info: Public folder share having code and data: WPBlogExportFileToBook, https://drive.google.com/drive/folders/1YQ7HAEx-mkpY0GjRFAkicK5BjFDUcGfZ?usp=drive_link . ravisiyer.wordpress.com blogbook (in HTML) with pages, posts & comments and contents links (like table of contents): ravisiyermisctech.wordpress.2024-02-24.000-BlogBookwCLs.html (1.3 MB) (in v6 folder),  https://drive.google.com/file/d/10aRzozLYicANJJr4j98MKxyBmLMVWXsI/view?usp=drive_link  (download file and view in browser locally to see rendered HTML). --- end Quick-Info --- 29 Feb. 2024 Update Version 6 (v6 folder,  https://drive.google.com/drive/folders/1Hdy3BtFc6lnJ95GfoGp5QvydVxzTpv8A?usp=drive_link ) has latest version with some bug fixes described in info.txt . 29 Feb. 2024 End-Update 9 Aug

Very satisfied and happy after publicly sharing latest version blogbooks of my Blogger blogs, main parts of which (blogbooks) were generated by my VBA programs

Last updated on 9 Aug. 2023 I have 3 main blogs which I have updated (posted to) in the past months and years. All these 3 main blogs are on Blogger. There is one more blog (on Wordpress) to which I have posted in recent months and years, but that is a miscelleneous tech. blog and my posts there are not so important, IMHO.  The 3 main blogs I mentioned above are: 1) My spiritual blog - https://ravisiyer.blogspot.com/ - has slightly over 1400 posts & pages 2) My worldly blog - https://ravisiyermisc.blogspot.com/ - has slightly over 1000 posts & pages 3) My blog on my great-grandfather (TNS) - https://tnarayanasasthri.blogspot.com/ - has slightly over 20 posts & pages I also have a 4th blog on Blogger -  https://eklavyasai.blogspot.com/ - but I have not changed its data for some years now.  The blogs can be viewed by all (free of any charge) on the Internet. But the blog shows a list of a few posts at a time out of which one post can be viewed in full by clicking on it in

Search text in Blogger blog backup/export XML file entries and get matching entries data - In-progress test version

Last updated on  9 Sep. 2023   9 Sep. 2023 Update: I rarely use the software covered in this post now. To see the current software for creating Blogger blogbooks that I use, please visit:  Short User Guide to creating Blogger Blogbooks from Backup/Export File using ExportFileFilterAndGenBook and another VBA projects' macros/code (free and open source),  https://ravisiyermisc.blogspot.com/2023/09/short-user-guide-to-creating-blogger.html  . end-Update 9 Sep. 2023 I decided to put up and publish this post now on 1 Aug 2023 while this work is in progress, as I wanted to ensure that whatever work I have done till now is available for interested readers.  I think it will be useful to be able to get matching entries data from Blogger blog backup or export XML file, output as a new XML file. This matching entries only XML file can then be input to BlogExportFileToBook macro covered in a recent previous post, to generate an HTML blog book of it which can be conveniently viewed in a browser

Archive

Show more