'output_subdirectory' - Output files in a timestamp labelled sub-directory.'reflow_large_blocks' - Reflow large blocks (target line length defined in $reflow_max_lines).'condense_slide_breaks' - Condense all slide breaks.'add_metadata_to_export_files' - Adds the metadata block to the top of the export files.'prevent_overwrites' - Prevent overwriting files - adds a '(1)' style suffix.'standardize_title_format' - Standardize the formatting of the name of the songs.'standardize_song_sections' - Standardize the names of the song sections to fit ProPresenter's default 'Groups'.'start_with_capital' - Begin all lines with capital letter.'remove_x2' - Remove 'x2' type references and empty parentheses.'straighten_curly_quotes' - Straighten curly quotes.'fix_mid_line_punctuation' - Fixes mid-line punctuation - replaces '.' with a line break, and makes sure ', ?!' is always followed by a space.'remove_end_punctuation' - Remove line-ending punctuation.'capitalize_names' - Capitalize some property names (defined in $words_to_capitalize variable).
Custom formatting functions (needs to be enabled in config file).Reflow song sections over 2 lines long (can be changed in config file).Attempts to handle inconsistencies with text encoding.Outputs to text files by default with experimental ProPresenter6 export (specify $file_export_type in config.php).Attempts to strip all formatting from song words to make for a clean import into target system.Exports all songs and lyrics from EasyWorship 6.1 database files into a date-labeled sub-directory in /output directory.I take no responsibility for any data loss that may occur directly or indirectly from using this script! Features To safeguard your existing data, make sure that you run this script on copies of your database files. Note: this script does not write anything to the EasyWorship database files, however accidents can happen. The exported files can be found in /output/.The progress of the conversion is displayed on the screen.Alternatively, if the repository in a directory served by a web server, you may run process.php in a web browser.
From the command line, change directory to the repository root and run:. If you want to use the experimental ProPresenter6 export feature, change $file_export_type = 'plain_text' to $file_export_type = 'propresenter6' in config.php. The default settings will export your songs in plain text files. Review the custom formatting options in config.php and set the values to true or false. Copy the following files from your EasyWorship data directory to /databases/:. On my installation, the installer for EasyWorship 6.1 had created a new subfolder for the 6.1 profile at C:\Users\Public\Softouch\EasyWorship\Default\6.1\. This is commonly in C:\Users\Public\Softouch\EasyWorship\Default\Databases\Data\ but may vary. Locate the EasyWorship database files in the EasyWorship data directory. Clone this repository to a location on your computer that PHP has write access to. Ensure that PHP has PDO SQLite support and MBString support (see for details - thanks jonathantjm!). It doesn't have a graphical user interface, however you can run this from the command line or from a web browser. To use this solution, you'll need to be comfortable with running PHP scripts. Previous versions of EasyWorship have had different 3rd party solutions that have sprung up.įor further information about these, the following links may be useful: This solution was conceived when faced with an EasyWorship 6.1 library of 800+ songs which no-one wanted to retype! It caused me to look closely at the database format and come to the conclusion that the best solution was to extract the data from the tables and clean up the contents programmatically. EasyWorship 6.1 now stores its databases in SQLite3 format, which meant that all other export utilities no longer worked (see below for Other Export Methods that work with previous versions). Previous versions of EasyWorship (including 6.0) used a different database storage engine. This PHP-based solution accesses the EasyWorship 6.1 database and exports all of the songs as plain text files suitable for importing into another lyric projection system (tested with ProPresenter 6.1). do whatever you want with it, but no warranty!)
0 kommentar(er)
