Posts

Showing posts from July, 2023

SplitBlogBook: VBA code to Generate Contents Internal Links List for HTML blog book and/or Split it into smaller HTML files

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 Note: At a convenient time, I intend to rename the SplitBlogBook program/macro to something like GenContentLinksListAndOrSplitBlogBook as that will better describe its current functionality. The VBA program BlogExportFileToBook described in my post: BlogExportFileToBook: VBA code to produce HTML blog book from Blogger blog backup/export XML file, https://ravisiyermisc.blogspot.com/2023/07/BlogExportFileToBook-vba-code.html , produces a single HTML blog book for a blog having all its posts, pages and com...

Getting pages and comments from Blogger blog using RSS feeds and related issues in blog books context

I was not able to get this information easily when I searched for it. So I thought I should put up a short post on it for my own needs which perhaps may be useful for others too. Explored RSS feed for pages and comments and found that for blogger, the following works: https://ravisiyermisc.blogspot.com/feeds/pages/default https://ravisiyermisc.blogspot.com/feeds/comments/default That solves the issue about adding pages content to Google Apps Script (GAS) projects covered in recent posts as one can use roughly the same procedure used to get posts content with only the fetch request url being changed to get pages. But for comments, the issue is that, in RSS as in XML backup/export file, the comments are listed separately and while they mention the associated post link (url), the post data itself is not provided. A blog book should have comments appearing after the content of the post in which the comments are made, which is how they appear on the blog itself. So in my recent posts about ...

BlogExportFileToBook: VBA code to produce HTML blog book from Blogger blog backup/export XML 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 25 Jul 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.  This post follows up on my previous post: VBA code to read XML structure of blogger blog entries in export file - Test version, https://ravisiyermisc.blogspot.com/2023/07/vba-code-to-read-xml-structure-of.html . I was able to take it further by writing a VBA macro BlogExportFileToBook (and related macros) whi...

Make Blogger Single Posts Book by (Feed) Index Range - GAS program - 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 22 Jul 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.  This work follows up on work covered in my previous post: Make Blogger Posts Book(s) by (Feed) Index Range or Index List; List Posts By Index - GAS programs - Test versions, https://ravisiyermisc.blogspot.com/2023/07/make-blogger-posts-books-by-index-range.html . The makePostsBookByIndexRange covered in above...

VBA code to read XML structure of blogger blog entries in export file - 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 22 Jul 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 am learning about XML structure of Blogger blog export files and how to read it programatically using Visual Basic for Applications (VBA). In the course of that, I wrote a macro BlogExportFileEntriesXMLStructureToLog() and related macros which goes through a Blogger blog export file and produces a log f...

Make Blogger Posts Book(s) by (Feed) Index Range or Index List; List Posts By Index - GAS programs - Test versions

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 19 Jul 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 wanted to have the facility to make blog post books of my blogs based on range of indexes, with index being the index number of the post in the blog feed. This would give better control over the way the books are partitioned rather than a number like 100 posts or 150 posts. But for that we also need to be ab...

Overcoming execution time limits issue for BlogBooksMaker GAS program by creating linked (not embedded) pictures output doc, Test Version

This post provides some info. about an interesting possibility of using MimeType.HTML instead of MimeType.GOOGLE_DOCS to get linked pictures output document in BlogBooksMaker GAS program which does not trip up on GAS (Google Apps Script) execution time limits. MimeType.GOOGLE_DOCS creates a Google Document with embedded pictures. This makes the output document a large one and it also takes a long time for the document to get written. I think that's when, at times, GAS gives an error which perhaps is due to some execution time limit(s) being reached. In contrast, MimeType.HTML does not embed pictures in the output file but has only links to the pictures. That makes the output document size small and it gets written quickly which, so far in my tests, has successfully completed in GAS without reporting any error. I think these programs complete within GAS execution time limits (for free usage users like me). For more about BlogBooksMaker program, please visit: BlogBooksMaker Google Ap...

Word VBA to make Blog Feed into Word document or Book, 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 14 Jul 2023 while this (Microsoft) Visual Basic for Applications (VBA) work is in progress, as I wanted to ensure that whatever work I have done till now is available for interested readers.  The following VBA code takes in a blog feed request (hardcoded as of now) and generates an output html file which can be inserted into Word as Web Page text thereby having a blog feed book as a Word document. To this Word document you can add page numbers, TOC, T...

Archive

Show more