Skip to content

Instantly share code, notes, and snippets.

@rnsrk
Created April 1, 2022 06:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rnsrk/1ff0071876328020803268c93375af46 to your computer and use it in GitHub Desktop.
Save rnsrk/1ff0071876328020803268c93375af46 to your computer and use it in GitHub Desktop.
Template for ODBC import script, used at Manage > Configure > WissKI ODBC Import (WissKI section). Please set url, database, port, user, password, table name, bundle id and field id to your needs. Check the delimiter as well!
<server>
<url>localhost</url>
<database>DATABASE_NAME</database>
<port>3306</port>
<user>DATABASE_USER</user>
<password>DATABASE_PASSWORD</password>
<table>
<select>*</select>
<name>TABLE_NAME_IN_DATABASE</name>
<append></append>
<delimiter>,</delimiter>
<id></id>
<trim>TRUE</trim>
<row>
<bundle id="BUNDLE_ID_IN_WISSKI_ENTITIES_AND_BUNDLES">
<field id="FIELD_ID_IN_WISSKI_ENTITIES_AND_BUNDLES"><fieldname>FIELD_NAME_IN_DATABASE</fieldname></field>
<field id="FIELD_ID_IN_WISSKI_ENTITIES_AND_BUNDLES"><fieldname>FIELD_NAME_IN_DATABASE</fieldname></field>
<field id="FIELD_ID_IN_WISSKI_ENTITIES_AND_BUNDLES"><fieldname>FIELD_NAME_IN_DATABASE</fieldname></field>
</bundle>
</row>
</table>
</server>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment