Examples of using the texexport command line tool

[rondlg]

From Pete Herbst: 23 Nov 2020, 23:02

Does anyone have any examples on GitHub or elsewhere that they can share on how they use texexport properly?

I've tried experimenting with it on our server but the help doesn't provide enough detail for me to figure this out on my own and there's no man pages for it. I've also searched through the old Texpress documentation and didn't find any references to it.

If you're logged in as the emu user on your server and you just run: texexport
.. this what you get.

texexport
Usage: texexport [-R] [-V] [-ccollist] [-fstyle] [-ssortlist]
[-ttype] [-mmodifiers] [-nr] -a|-kfile|-lkeylist|-ofile dbname
where
-ccollist is list of columns to export (col[:n],col[:n]...)
-fstyle is style of output (see below)
-ssortlist is list of columns for sorting (col[:a|d],col[:a|d]...)
-ttype is type of exporting (forms or schema)
-mmodifiers defines modifier options for selected style
-n means notify upon completion
-r means remove file at completion
You must specify one of:
-a export all records from dbname table
-kfile file of keys of rows in dbname table
-lkeylist comma-separated list of keys of rows in dbname table
-ofile file of offsets of rows in dbname table
Formats include:
ids lines of the format colid:fieldno=data
idsbrief as for ids but with empty lines omitted
options -ml print Library items as single value
-mwn print col name in exactly n characters
texpressdata KE Texpress internal data file format
texql KE Texql insert statements
delimited character-separated columns
options -mdch use ch as text delimiter (dflt ")
-msch use ch as column separator (dflt tab)
-mc include column names on first line
-ml print Library items as single value
fixedwidth fixed width (blank-padded) output
format column output defined by format string
formatbrief as for format but with empty lines omitted
options -mfstr use str as the format string
-ml print Library items as single value

[rondlg]

From Larry Gall: 24 Nov 2020, 00:40

Pete et al., here is a quick annotated file showing basic texexport operation, best, Larry

texexport-blurb.pdf

[rondlg]

From Bill Mertz: 8 Dec 2020, 00:45
 

I don't know if anyone mentioned this, but we found that a useful little admin task is:
texexport -fidsbrief -l[Text:IRN] eparties (or whichever table you'd like -- or make it a variable).
This allows you to see all of the entered data for the record. You don't have to search through the tabs verifying you accounted for everything.
-Bill
P.S. Yes, you can enter multiple IRNs separated by commas.