Administration Data import export Import Definition source table - robinfeng/beashelp GitHub Wiki
定义来源表
Navigation: Administration > Data import/export > Import: help-zahnrad Definition source table No contents entries on this page Contents The source table can be specified in three different ways:
By specifying the table name By specifying a SELECT instructions preceded by 2 :: e.g. "::select * from oitm" By specifying a text file
help-beispiel Example: SELECT instruction
The source resides in an external SQL database in the table "olditems". The SQL database link information is now specified under "DETAILS" and the name "olditems" under "Table". This is followed by clicking on "Create and test DSN". The field names of this source table are now shown to the right.
Import from a text file If the source is a text file, then the link source "text file" must be selected, followed by clicking the orange arrow next to it.
The information for the text file definition can now be entered in the detail window
File Name File name of the text file Separator Symbols for field separators Quotation Marks Are the values enclosed by quotations marks? This switch must then be activated. In this case, the texts may also include line breaks. Asci->Ansi To convert DOS font types into Windows font types Column def. in row Specifying the cell containing the column definitions. The values found are shown under "Columns". If a "0" is entered here, the column definition is "frozen" and can be post-edited manually. Important: Each column name must be unique. Special characters, umlauts and blanks are automatically removed. Duplicate column names may need to be renamed and "empty columns" at the end removed. Values in rows Specifying the row from which the values read should be displayed. Conversion Conversion conditions: Individual letters can be replaced by other letters or ASCII characters. The statement "A=B" would convert all As into Bs. Alternatively, the ASCII value can also be specified as ":65=:66" which is identical to "A=:66" as "A=B". Any number of conversion conditions can be specified - separated by a linefeed Columns The columns determined (see column def. in row) Values The values determined
返回 主页