Database Checker/Updater

[et_pb_section fb_built=”1″ admin_label=”Header” module_id=”biblio-page-heading” _builder_version=”4.16″ _module_preset=”default” background_color=”#e0d7c7″ custom_margin=”||40px||false|false” custom_padding=”20px||20px||true|false” locked=”off” collapsed=”on” global_colors_info=”{}”][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.17.6″ _module_preset=”default” text_font=”|300|||||||” text_font_size=”50px” text_line_height=”1.2em” text_orientation=”center” custom_margin=”||||false” global_colors_info=”{}”]Bibliography Database Checker/Updater[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Buttons” _builder_version=”4.16″ background_color=”#ffffff” custom_padding=”0px||0px|” locked=”off” collapsed=”off” global_colors_info=”{}”][et_pb_row _builder_version=”4.16″ _module_preset=”default” custom_margin=”||||false|false” collapsed=”off” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_blurb content_max_width=”1100px” _builder_version=”4.24.2″ _module_preset=”default” header_level=”h1″ header_text_align=”center” header_font_size=”36px” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]

Edit/Add
Citation EntriesCompare/Merge
Citation EntriesEdit/Add
AuthorsCompare/Merge
Authors

Edit/Add TopicsCheck/Update DatabaseCitations Missing InformationBroken Link Checker

Site ScrapersSearch LogAdmin Main Menu

[/et_pb_blurb][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Checker” _builder_version=”4.16″ collapsed=”off” global_colors_info=”{}”][et_pb_row _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.21.0″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]

Accessed: April 25, 2024 MDT

Citation Table:

Citation Range*:

through

Update Citation Authors, Citation Collections, and Citation Display Strings, as explained for the respective Update buttons below.

Update all citations that have the update_flag set to "auth", "coll", "display", or "all," as described for the corresponding Update buttons.

If the update_flag is set, use the inverted_authors field to update the author_citation table; otherwise if the author_citation table has entries, use them to update the inverted_authors field; otherwise, if the inverted_authors field is set, use it to update the author_citation table; otherwise error. ~10K entries maximum.

If the update_flag is set, use the collection field to update the collection_citation table; otherwise if the collection_citation table has entries, use them to update the collection field; otherwise, if the collection field is set, use it to update the collection_citation table; otherwise error. ~10K entries maximum.

Use the current table values to update the citation to be displayed for each citation entry. ~4K entries maximum

Look for any parent entries that don’t exist. Make sure all entries with children have their child_count set.

Copies links from a parent to any child entries that don’t have any links.

Check a range of citations for identical title and author(s). ~10K entries maximum

If the update_flag is set, use the inverted_authors field to check the author_citation table; otherwise if the author_citation table has entries, use them to check the inverted_authors field; otherwise, if the inverted_authors field is set, use it to check the author_citation table; otherwise error. ~10K entries maximum.

Content Table:

Any contents for non-existent citations are flagged/deleted.

Author Tables:

Author Range**:

through

Check and normalize the Name & Inverted Name fields. Update the Alternate Names field to add any needed names and flag any extra names.

Add the new author names in the Author file. One name in inverted format per line. Names already in the database are flagged and not added.

Author File:

Find/delete any author-citation entries that do not refer to an entry in the citation table. Find/delete duplicate entries referencing the same article and author.

Collection Tables:

Update the sequence numbers of collections in increments of 10. Used to set the order of collection lists. Spaced to allow adding intermediate collections.

Check/update the collection-citations table for flagged citations using the collection field to select collections. Check/delete any extra entries that do not refer to existing citations or collections. Check/delete any duplicate collection/citation entries.

Link Tables:

Link Range***:

through

List/delete entries that are not used in the link-citation table. List/delete duplicate entries.

List/delete entries pointing to non-existent link table entries. List/delete entries pointing to non-existent citations. List/delete duplicate entries (same link, citation and type, possibly different link_no’s). List/correct link numbers for citations. List invalid link types.

Topic Tables:

List any topics that are not in a valid tree. List any topics that do not have a valid parent or who are in a different tree from their parent. List/change any topic breadcrumbs (tree > parent > ... > topic) that have changed.

Updates the seq_num’s for the selected tree so that they increment by 10.

Select Tree:

Book of Moses Topics

Hugh W. Nibley Topics

RSC Topics

Old Testament Topics

Old Testament Scriptures

Book of Mormon Topics

Book of Mormon Scriptures

New Testament Topics

New Testament Scriptures

Doctrine and Covenants Topics

Doctrine and Covenants Sections

Book of Abraham Topics

testTopic

List/delete any topic-citation entries that do not refer to an entry in the citation table. List/delete any topic-citation entries that do not refer to an entry in the topics table. List/delete duplicate entries referencing the same citation and topic.

Add entries to the topic_citations table from the Topic file. Each line in the file modifies a topic to add citations and has a topic_id, tab, and a comma- or tab-separated list of cit_ids. All sequence numbers are set to 0, i.e., the order of the citations within the topic is not forced.

Add entries to the topic_citations table from the Topic file. Each line in the file adds a citation to multiple topics and has a citation_id, tab, and a comma- or tab-separated list of topic_ids.

Topic File:

Data Input Files:

Data File:

Check Data Files:

Check File:

Special Editing:

Editing File:

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]

Contents