Tenup
Execute TenUp commands using the tenup executable via JavaScript. Also see https://www2.1010data.com/documentationcenter/beta/TenupUsersGuide/index_frames.html
Usage
Install with npm
npm install tenup --save-dev
var tenup = require("tenup")
var options = {
executable: tenup.getPathToTenup(), // the path to tenup executable (can be overridden)
login: {}, // login credentials: TENTENGW, TENTENUID, TENTENPW or any other args supported via env variables
table: '', // the path to the new table
table_tree_file: '', // XML file with information about the columns of the uploaded table
flat_file: '', // the name of the flat file to upload
query_file: '', // a query file containing sql to run against the source table
sql: '', // inline sql to run against the source table (used instead a query file)
connection_string: '', // odbc connection to use
title: '', // optional title for the new table
args: '', // additional tenup cmd line args such as -K -y etc.
logTenUpCmd: false // log the full tenup command to the console
}
tenup.execute(options, function (status, results) {
// options see above
// callback function(status, results) {
// status = true:false the operation succeeded
// success results or if status is false - an error message
//}
});
##Loading from ODBC-compliant databases with a query file
var options = {
connection_string: 'DSN=sql1010odbc',
table: 'path.to.my.new.table',
query_file: 'queries/my_query.xml'
}
##Loading from ODBC-compliant databases with a sql command
var options = {
connection_string: 'DSN=sql1010odbc',
table: 'path.to.my.new.table',
sql: 'SELECT * FROM my_src_table'
}
##Loading with a Flat File
var options = {
table_tree_file: 'my_schema.xml',
flat_file: 'my_data_file'
}