Jump to: navigation, search

Jdruker/ForAndrey

Downloading config option data -- Dummying up SQL

View CSV

The above yields the following output, except that in the CSV file the internal quotes are """.

  • "INSERT INTO tableXYZ (Component,Section,Parameter,Valid,DefaultValue,ShortDescription) values("UniversalContactServer","authentication","enabled","Either true or false","false","\"Enable or disable the authentication mechanism.\"");"
  • "INSERT INTO tableXYZ (Component,Section,Parameter,Valid,DefaultValue,ShortDescription) values("UniversalContactServer","authentication","mode","Either single-user or multi-users","multi-users","\"Select working mode for authentication, either 'single-user' to use username and password stored in UCS options or 'multi-users' to authenticate using 'Persons' in CME.\"");"
  • "INSERT INTO tableXYZ (Component,Section,Parameter,Valid,DefaultValue,ShortDescription) values("UniversalContactServer","authentication","password","See Description","","\"Value is a password corresponding to the defined username option\"");"
  • "INSERT INTO tableXYZ (Component,Section,Parameter,Valid,DefaultValue,ShortDescription) values("UniversalContactServer","authentication","use-role","Either true or false","false","\"Enable or disable role verification. Role can be defined with Genesys Administrator\"");"
  • "INSERT INTO tableXYZ (Component,Section,Parameter,Valid,DefaultValue,ShortDescription) values("UniversalContactServer","authentication","username","See Description","","\"Value is a name of a user\"");"

...

More...

Before trying to escape quotes

View CSV

This page was last edited on July 23, 2018, at 16:05.
Comments or questions about this documentation? Contact us for support!