Differences

This shows you the differences between two versions of the page.

--- en:user_advanced:greenstonesqlplugs [2019/09/05 07:16] – [The short version: Usage instructions] anupama
+++ en:user_advanced:greenstonesqlplugs [2023/03/13 01:46] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== Editing archives metadata and/or fulltext using a MySQL database ======
 Like the GreenstoneMETSPlugin, the GreenstoneSQLPlugin is another alternative to using the GreenstoneXMLPlugin.
@@ Line 67: / Line 70: @@
   * Once the collectionConfiguration.xml file has been correctly setup, you can run GLI, open the hand configured collection in there, and then run build in there.\\ Alternatively, you can use the commandline and run (incremental-)import and (incremental-)build normally:\\ <code>import.pl -site <SITENAME> <COLNAME>
-buildcol.pl -activate -site <SITENAME> <COLNAME></code>Or if building incrementally:<code>incremental-import.pl -incremental -site <SITENAME> <COLNAME>
+buildcol.pl -activate -site <SITENAME> <COLNAME></code>where COLNAME is the collection name.\\ Or if building incrementally:<code>incremental-import.pl -incremental -site <SITENAME> <COLNAME>
 incremental-buildcol.pl -activate -site <SITENAME> <COLNAME></code>Alternatively, you can run both import and buildcol steps in one go:<code>full-rebuild.pl -site <SITENAME> <COLNAME></code>And if incrementally building in one go:<code>incremental-rebuild.pl -site <SITENAME> <COLNAME></code>\\ **IMPORTANT: On Windows**, precede the import and buildcol or rebuild commands with ''perl -S''.\\ The default sitename is ''localsite''. Leave out the ''-site <SITENAME>'' for Greenstone 2.
   * Start your GS3 server if you haven't already and preview your collection.
@@ Line 73: / Line 76: @@
      * 	But **once you log into MySQL client, always first set the connection to use the ''utf8mb4'' character set** before creating or loading databases and tables:\\ <code>mysql> set names utf8mb4;</code>
      * The GreenstoneSQLPlugs create a **database** called ''<SITENAME>'' for GS3 (which defaults to ''localsite'') and called ''greenstone2'' for GS2.
-     * Up to 2 **tables** are created for each collection: ''<COLNAME>_metadata'' and ''<COLNAME>_fulltxt'' (note spelling), where COLNAME is the collection name and where hyphens '-' in <COLNAME> are replaced by underscores '_'.
+     * Up to 2 **tables** are created for each collection: ''<COLNAME>_metadata'' and ''<COLNAME>_fulltxt'' (note spelling), where hyphens '-' in <COLNAME> are replaced by underscores '_'.
 **Notes on GreenstoneSQLPlugin/out configuration options:**