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
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=drive_link
- Version v1 sub-folder: https://drive.google.com/drive/folders/13yj4yRq7V8kBxD1DqIimSiXDBMFbBzWu?usp=drive_link
- Info.txt, https://drive.google.com/file/d/1qcphY-m64Tilk4BHjljjlrJ7QQGKDa6n/view?usp=drive_link
End Quick Info
The Microsoft Visual Basic for Applications (VBA) sub./macro FilterBlogExportFile reads specified Blogger backup/export XML file and specified date range arguments from lines in associated Microsoft Word document, and then creates an output XML file having XML entries for posts and pages that match the specified date range.
In the first version - v1 version, only published date range is supported.
An example of published date range arguments specified in associated Word document is given below:
start_published_date:2023-04-15
end_published_date:2023-12-31
---------
The format for specifying above published date range arguments is based on (same as, as far as I know) that used by Blogger in search feature in its author 'dashboard?' listing post/pages of blog. See https://support.google.com/blogger/answer/9675453 for details.
This output file can be used as input file to BlogExportFileSearchToBook VBA program to produce HTML blogbook of posts and pages in input file. [Ref: 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 .]
To make the output file more easily readable and modifiable (say by deleting some post/page entries), and also reduce the size of the output file, I have not included template and settings entries in the output file. So the output file will not be a regular Blogger backup/export file which can be restored/imported into Blogger but the output file will have all the data needed by BlogExportFileSearchToBook to produce a blogbook of pages and posts and associated comments contained in the output file.
Test run folders within v1 folder have output data files for the test runs and sometimes have RunInfo.txt files too.
Some additional links of files within top-level folder which I think are appropriate to share here:
- FilterXMLExportFile source code (VBA): v1-MainModule.vb.txt, https://drive.google.com/file/d/1v7jeDEFAq4Ftdp9bt9Rt2ypwLtUnbJ_t/view?usp=drive_link
- Run1: Top-Level sub-folder, https://drive.google.com/drive/folders/1uwSl3oEWkfdr_EtxyjeCJUTx20MwJD7d?usp=drive_link
- FilterXMLExportFile Run1 Run information file: RunInfo.txt, https://drive.google.com/file/d/1FYveeCI7_uvDJNly302JLmiguQgRjvVD/view?usp=drive_link
- FilterXMLExportFile Run1 filter log: https://drive.google.com/file/d/1mJnCMGLM4JRax1sh3h96pJfqZXmU3vNY/view?usp=drive_link
- FilterXMLExportFile Run1 input file: 20230801-tns-blog.xml (782 KB), https://drive.google.com/file/d/1y96G1HvlIXVVBihNjv1nugjZwLZITnzf/view?usp=drive_link
- FilterXMLExportFile Run1 output file: 20230801-tns-blogfilt.xml (264 KB), https://drive.google.com/file/d/1ySm1_R8aCQvwCWpKBAMAXcWS5igIqudd/view?usp=drive_link
- BlogExportFileSearchToBook Run1 main log file: https://drive.google.com/file/d/1viv2bQNMLwd9b_06zgLAl1i-C9T4lzBs/view?usp=drive_link
- BlogExportFileSearchToBook Run1 output blogbook HTML file: 20230801-tns-blogfilt-BlogBook.html (222 KB), https://drive.google.com/file/d/1I_2C6LAQMfa1Vbukl31XJNidZGEvq0fe/view?usp=drive_link
- Run5: Top-Level sub-folder, https://drive.google.com/drive/folders/1WO_JUYjt7nc91hiV8DYnQQXzbZAwvoKn?usp=drive_link
- FilterXMLExportFile Run5 Run information file: RunInfo.txt, https://drive.google.com/file/d/1kZmS9FderAMl_o_mhDZvwLyWI4XWgF76/view?usp=drive_link
- FilterXMLExportFile Run5 filter log: https://drive.google.com/file/d/1v66SwZV0R6vJ5MxXLlvw9KzgpQvKA6K6/view?usp=drive_link
- FilterXMLExportFile Run5 input file: [Not put on Google Drive as file size is slightly big.]
- FilterXMLExportFile Run5 output file: https://drive.google.com/file/d/1AR3P4YTm51_-Vk57FimhSCpk36UqzQDl/view?usp=drive_link
- BlogExportFileSearchToBook Run5 main log file: https://drive.google.com/file/d/1TO3KPbGbD6IlOldU8M7eVNnHyJ0jM4dB/view?usp=drive_link
- BlogExportFileSearchToBook Run5 output blogbook HTML file: https://drive.google.com/file/d/1twMdamyIwu9EMoDS_w6wP6V7fXI06qJU/view?usp=drive_link
- FilterXMLExportFile source code (VBA): v2-MainModule.vb.txt, https://drive.google.com/file/d/1b5a2SXE34UZvIfytFfAKLYmMaN9LcU1W/view?usp=drive_link
- Run1: Top-level sub-folder, https://drive.google.com/drive/folders/1tB_eMWZASK2oXg1nu9MqBhEmHbJYmhvD?usp=drive_link
- Run 7: Top-level sub-folder, https://drive.google.com/drive/folders/1FoloVhok1GDJoiSr7holCmyRhja5jZui?usp=drive_link
Comments
Post a Comment