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)

By -

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

End Quick Info

2 & 3 Sep. 2023 Update

At times, we may want to remove some pages/posts from the Blogger XML Backup/Export file, and use the modified file as input to Generate HTML blog book function of ExportFileFilterAndGenBook to create blog books optionally matching some search strings but none of the blogbooks created this way, having the pages/posts excluded from the Blogger XML Backup/Export file. 

In particular, some of my blogs have a few pages with very long lists of posts. I would prefer to not have these pages with very long lists of posts to be part of some blogbooks I create.

How to achieve this using a combination of ExportFileFilterAndGenBook and ExportFileFilterByIndexList projects is covered in the Runinfo file here:  https://drive.google.com/file/d/18P5zWMUF2mO70qGNqqYFUyufayRgaAAR/view?usp=drive_link, which describes the run that created the data files in the associated v2/RunFilterPages sub-folder of the ExportFileFilterByIndexList project, https://drive.google.com/drive/folders/1pktyfO0D4YDjtHD0QDA8MY2lPJOLew6V?usp=drive_link .[Ref: ExportFileFilterByIndexList: VBA code to filter Blogger XML Backup/Export file based on Entry Index List text file,  https://ravisiyermisc.blogspot.com/2023/08/exportfilefilterbyindexlist-vba-code-to.html .]

End-Update 2 & 3 Sep. 2023

1 Sep. 2023 Update

Version v6 adds feature of combining search strings using AND instead of default OR. See below screenshot:
[On PC desktop/laptop, to open pic in larger resolution (if available), right-click on pic followed by open link (NOT image) in new tab/window. In new tab/window you may have to click on pic to zoom in.]


End-Update 1 Sep. 2023

30 Aug. 2023 Update

Version 4 brings in SplitBlogBookAndGenContentsLinks code into ExportFileFilterAndGenBook project. The Top Level Run Options has been modified to add Gen. Contents Links and Split blog book option to it.

So now ExportFileFilterAndGenBook has the following three main macros functionality:

  1. Filter Blog XML Backup/Export File based on Date Range
  2. Generate HTML Blogbook from XML entries input file optionally filtered by content matching string(s)
  3. Generate Contents Links List and/or Split Blogbook
Given below are screenshots of the program.





End-Update 30 Aug. 2023

This ExportFileFilterAndGenBook project takes BlogExportFileSearchToBook project with its two modules: MainBlogExportFileToBook and ModCreateCommentsDictionary, and incorporates FilterXMLExportFile project's single module: MainModule, making this new project (ExportFileFilterAndGenBook). [Refs: 1) BlogExportFileSearchToBook: VBA code to produce HTML blog book from Blogger blog backup/export XML file optionally limited to content matching search string, https://ravisiyermisc.blogspot.com/2023/08/blogexportfilesearchtobook-vba-code-to.html , 2) 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,  https://ravisiyermisc.blogspot.com/2023/08/filterxmlexportfile-vba-code-to-create.html .]

Now users can invoke drivers of both FilterXMLExportFile() main function and BlogExportFileSearchToBook() main function from within the same VBA project. That is convenient as sometimes it is a two-step procedure to create a blogbook - first run FilterXMLExportFile to create a filtered XML entries file and then run BlogExportFileSearchToBook on this filtered XML entries file. 

Now there is also more consistency between output files and log files generated by FilterXMLExportFile and BlogExportFileSearchToBook .

Comments

Post a Comment

Archive

Show more