Creating Blogger Blogbooklets based on search criteria and excluding some pages/posts from it

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. This approach could be superior to removing these pages again and again from output files created in different runs of ExportFileFilterAndGenBook macros.

The procedure to do this:

1) Run ExportFileFilterAndGenBook - Generate HTML blog book function, providing original Blogger XML backup file (for example: 20230801-ravisiyer-blog.xml) as the input file, generate only log files and provide blank search criteria. It should create a main log file (for our example: 20230801-ravisiyer-blog-BlogBookLog.txt) log file

2) Make a copy of the main log file (for our example: 20230801-ravisiyer-blog-BlogBookLog.txt renaming it suitably as an Index List file (for our example: as 20230801-ravisiyer-blog-ExclLstPgs-Index.txt). In the latter (Index List) file, delete the pages and posts that should be excluded from blogbooks that we plan to create (and some header and footer stuff).

3) Then run ExportFileFilterByIndexList providing original Blogger XML backup file (for our example: 20230801-ravisiyer-blog.xml) and the Index List file we created in above step (for our example: 20230801-ravisiyer-blog-ExclLstPgs-Index.txt) as the input files. It should create a filtered XML output file (for our example: 20230801-ravisiyer-blogixfilt.xml) which will have all needed entries and not have the excluded pages and posts entries.

4) Now the filtered XML output file created in above step (for our example: 20230801-ravisiyer-blogixfilt.xml) becomes the main XML backup input file for Generate HTML blog book function of ExportFileFilterAndGenBook to create blog books based on some search criteria. The excluded pages and posts will not be part of the blog books as they are simply not present in the input file.

For an example run, see ExportFileFilterByIndexList project's v2/RunFilterPages sub-folder:  https://drive.google.com/drive/folders/1pktyfO0D4YDjtHD0QDA8MY2lPJOLew6V?usp=drive_link

and the associated Runinfo.txt file: https://drive.google.com/file/d/18P5zWMUF2mO70qGNqqYFUyufayRgaAAR/view?usp=drive_link .

[References: 1) 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

2) 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 ]

Note that Date range filter of ExportFileFilterAndGenBook can be used to produce XML output file having only pages and posts that match the Date ranges specified. For an example run of this, see ExportFileFilterAndGenBook project's v4/Run3 sub-folder: https://drive.google.com/drive/folders/1dA1Tiomk2mL4ix_vNgBA6cAr-QdEnh5T?usp=drive_link

and the associated Runinfo.txt file: https://drive.google.com/file/d/17dyg3YaF7wol9tIqXu0jEIJAciH4sMGR/view?usp=drive_link .

However, in the procedure specified in this page, I have not used Date Range filter. I presume that if Date range filter is additionally used in this procedure, it will work as expected.

Comments

Archive

Show more