# List_Report_Filenames.txt # 25/02/24 # List of the report filename key phrases generated by the Fujitsu/iDox system. # The attempt here is to enforce file-naming consistency so as to properly identify the various Reports. # # For: Local Government Election 2022. # Comments begin at and include a # . # Example: (Aberdeen City) physical filenames: # 00QA_Dyce-Bucksburn-Danestone_Ward_PREFERENCES-BY-BALLOT-BOX_V2.pdf # CandidateVotesPerStageReport_V0002_Dyce-Bucksburn-Danestone-Ward_06052022_112506.pdf # DeclarationOfResultsReport_V0002_Dyce-Bucksburn-Danestone-Ward_06052022_112506.pdf # FirstPreference_V0001_Dyce-Bucksburn-Danestone-Ward_06052022_160452.pdf # PreferenceProfile_V0001_Dyce-Bucksburn-Danestone-Ward_06052022_160545.txt << .txt rather than .blt # PreferenceSummary_V0001_Dyce-Bucksburn-Danestone-Ward_06052022_160453.pdf # Transfers_V0001_Dyce-Bucksburn-Danestone-Ward_06052022_160455_0.pdf # # Typical filename conversion: # 00QA_Dyce-Bucksburn-Danestone_Ward_PREFERENCES-BY-BALLOT-BOX_V2.pdf # -> # C01_W01_PREFERENCESBYBALLOTBOX_00QA_Dyce-Bucksburn-Danestone_Ward_PREFERENCES-BY-BALLOT-BOX_V2.pdf # Prefix Original # # Key elements. After converting to UPPER-case. This order for display on websites? # # The Preference Profile file. # This file has a much-varied file extension: # PreferenceProfile - file extensions encountered: .BLT .CSV .PDF .XLSX. (Append .txt ?) # File Extension Correction/s # .TXT No action # .BLT Append .txt (leave original extension for lineage) # .CSV Append .txt (leave original extension for lineage) # .PDF Append .txt Read-and-convert to text # .XLSX Append .txt Read-and-convert to text # NOTE This file is an unstructured text file - it is in no way a .CSV or .XLSX style. # # NOT USED: F08,"Understand","How to understand the Preference Profile for each electoral ward" # This file is Council-wide - it is the same for all Wards for that Council. The Simple website uses # hyperlinks within the Ward to point to the Council-level physical file. # On the various Council websites, this file is very poorly delivered: # How and where it is displayed. # Its content. Some Councils use the EMB template with a "Contact" email address of XXXXXX. # This file is very often (always?) erroneously named as "HOW TO UNDERSTAND THE VOTING INFORMATION" - it # should be named something similar to "How to understand the Preference Profile file". # # # A few Council web sites also offer a bespoke report - usually the first listed (e.g. Edinburgh, Glasgow). # Maybe something like: # F00,"BespokeReport","Ward 1 Almond results 2022" # Before name-string comparison the following editing is performed: # All SPACEs, underscores and hyphens are removed. # The remaining characters are converted to UPPER-case. # So, "00QA_Dyce-Bucksburn-Danestone_Ward_PREFERENCES-BY-BALLOT-BOX_V2.pdf" # will match "PreferencesByBallotBox", and be classified as a "Preferences by Ballot Box Report". F01,"DeclarationOfResults","Declaration of Results" F02,"CandidateVotesPerStage","Candidate Votes per Stage Report" F03,"Transfers","Transfers Report" F04,"FirstPreference","First Preference Report" F05,"PreferenceSummary","Preference Summary Report" F06,"PreferencesByBallotBox","Preferences by Ballot Box Report" F07,"PreferenceProfile","Preference Profile" #EOF