20221103-1129. While waiting for my baked chicken 375 F, 20 minutes, and while drinking coconut coffee, I’m indecisive if I should match the post_name (or Slug) and the post_title to my KJV biblical project.
My naming convention was to “keep it simple”: three digits for books, three digits for chapters, and three digits for verses. (Note: I use a single dash in place of spaces. I do this also for my archive files.) I only added the proper names of the books after finalizing my KJV biblical project.
Plus, I had 31,103 of verses containing Page Jumps to the 66 books. I wanted to import 1,188 chapters but like I said, the dataset is arranged “horizontally” and that would take too much time transposing the verses “vertically” to line up with the CSV title headers.
The post_name is shortened to make importing and Page Jumping easier. Had I included/inserted the proper names of the 66 books then I would have to re-do the HTML anchors for both the verses (31,103) and the books (66)!
For the verses, I imported the CSV files to match with the available WordPress headers or key fields, such as post_id, post_date, post_author, post_type, post_status, post_parent, post_title, post_name, post_excerpt, menu_order and most importantly post_content.
I imported the smaller files together. But for the most part I processed the CSV files starting with the smallest KJV bible book, 2-John and ended with the larges KJV book, Psalms.
For the books, I imported the same essential fields/headers/keys. HOWEVER, since the verses for larger books are too HUGE for one spreadsheet cell for importing; I’ve opted to hand-crafted each 66 each books by a simple, tried-and-true method: copy and paste! That’s why there are lots of revisions/versions for each static “page”.
For the verses, the longer Slug or post_name does NOT match the shorter post_title. I may work on this project further and should only take a few minutes.
For the books, the longer post_title does NOT match the shorter post_name. This is the complete opposite for the verses and I may work on this project further too.
That’s all. FlynnsPaws.