TapeTrack Documentation

Because there is more to tape management than you ever realized

User Tools

Site Tools


engine:import:addtranslationfromsql

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
engine:import:addtranslationfromsql [2020/02/24 01:49] Scott Cunliffeengine:import:addtranslationfromsql [2025/01/21 22:07] (current) – external edit 127.0.0.1
Line 8: Line 8:
 ''AddTranslationFromSQL(field, sql);'' ''AddTranslationFromSQL(field, sql);''
  
-//string field;//\\ +^ Variable ^ Type ^ Description ^ Min Length ^ Max Length ^ 
-//string sql;//\\ +|field| String | The field to be translated.|1|128
- +|sql| String | An SQL query to run to extract translation pairs.|1|256|
-|field| The field to be translated.| +
-|sql| An SQL query to run to extract translation pairs.|+
  
 ==== Example ==== ==== Example ====
-**AddTranslationFromSQL: Translate based on the values in a table.** +AddTranslationFromSQL: Translate based on the values in a table. 
-|AddTranslationFromSQL(VOLUME, "SELECT volume,barcode FROM barcodetable");|+ 
 +<code> 
 +AddTranslationFromSQL(VOLUME, "SELECT volume,barcode FROM barcodetable"); 
 +</code> 
 + 
 +===== See Also ===== 
 + 
 +[[engine:import|Import Engine Functions]] \\ 
 +[[cli:sync_fields|Sync Engine Fields]] \\ 
 +[[cli:tmss10sync|TMSS10Sync]]
  
 {{tag> import_engine sync_engine}} {{tag> import_engine sync_engine}}
engine/import/addtranslationfromsql.1582508990.txt.gz · Last modified: 2025/01/21 22:07 (external edit)