Sequenchel has several command line options. This way you can run a report or import a file without user intervention. This can also determine how Sequenchel behaves.
If a command line argument contains spaces you can put double quotation marks around the entire command line option like this: “/ImportFile:D:Path with spaces\subfolder\*.xls”.
Sequenchel main program
/Control Run Sequenchel in Control Mode. This will enable you to edit the data in fields that have the checkmark “Control Mode” in the configuration enabled.
Sequenchel main program and SeqCmd.exe Command Line Interface
- /Debug Run Sequenchel in Debug mode. This will give messageboxes and other information to help find a problem in Sequenchel.
- /SecurityOverride:<password> Run Sequenchel in Security Override mode. This will enable all security options that have been disabled in the settings. You will need to provide the same password that was entered in the settings.
SeqCmd.exe Command Line Interface
- /? Display SeqCmd help
- /Report Run a preconfigured report.
- /Import Import a file into Sequenchel.
- /Connection:<connection name> Use this preconfigured Connection for Report or Import option.
- /TableSet:<TableSet name> Use this preconfigured TableSet for Report or Import option.
- /Table:<Table name> Use this table for Import option. This can be a precofigured table name or alias, an existing table or a new table. Include the schema name if you are not using a preconfigured alias.
- /ReportName:<Report name> Run this predefined Report (requires /Report option)
- /ExportFile:<File path and name> Export the Report or the Import file to this Exportfile. If Import and Report are both used this file will contain the report.
- /ImportFile:<File path and name> Import this file or these files into the database. (Requires /Import option) You can use a filemask for importing files like “*.xls” or “*.*”. All files matching your filemask will be imported. make sure all files (and sheets) have the same columns and data types.
- /ConvertToText:<True/False> ; Default=False ; Convert imported data to plain text. Excel files only. NULL values are converted to empty strings.
- /ConvertToNull:<True/False> ; Default=False Convert empty values/strings to NULL. Upload to database only.
- /HasHeaders:<True/False> ; Default=True ; The first row of the imported file has header/column names.
- /Delimiter:”<value>” ; Field seperator for import (txt, csv) file. Default is comma. -> /Delimiter:”,”
- /EmailRecipient:<Email@Address.com> ; Report Only. Requires SMTP to be configured in Sequenchel.
- /ClearTargetTable[:,0,1,2>] ; Delete all data from the database table before upload.
- 0: Do not clear the target table. This is the default value if omitting the switch.
- 1: Clear the target table once before importing one or multiple files. This is the default value when using the switch without parameter.
- 2: Clear the target table before every upload when importing and uploading files. The purpose of this switch is to process every upload before uploading the next file with the switch /SqlCommand
- /SqlCommand:<value> ; Execute this command on the SQL Connection after every upload. This enables you to process every file seperately (e.g. with SmartUpdate) when uploading multiple files.
- /ImportAsXml ; Convert plain text to basic XML. Leave XML Import as original.
Import into the database as Xml datatype.
CreateTargetTable creates a special table for this purpose.
- /CreateTargetTable ; Create the target database table if it does not exist.
Uses import file datastructure or creates a basic XML upload table.
- /QuotedValues:<True/False> ; Default=False
True on Import: Double quotes are regarded as text delimiters.
True on Export: All values will be enclosed in double quotes.
- /LargeFile[:BatchSize] ; The file to import will be parsed per batch instead of as a whole. The default value for BatchSize = 100.000 records. The switches CreateTargetTable and ExportFile do not work with LargeFile and will be ignored. You can use the gui to create the table from a large file.
- /CreateSmartView ; Requires /Connection, Create a local view to a remote table for SmartUpdate.
- /LinkedServer:<value> ; Requires /CreateSmartView, The remote table is on this linked server.
- /SourceDatabase:<value> ; Requires /CreateSmartView, The remote table is in this database.
- /SourceSchema:<value> ; Requires /CreateSmartView, The remote table is in this schema.
- /SourceTable:<value> ; Requires /CreateSmartView, The remote table name.
- /SourceSystem:<Value> ; Requires /CreateSmartView, The source database server system
- 0 = MS SQL Server
- 1 = Oracle
- 2 = Progress (SQL 92)
- 3 = MySQL
- Other systems may use a similar method to query the TOP n rows from a table. If you need to work with a diferent system, select the one that uses the same method.
- /TargetSchema:<value> ; Requires /CreateSmartView, The local schema name where the view is created.
- /TargetView:<value> ; Requires /CreateSmartView, The name of the local view to be created.