Skip to main content

Uniface 8: Text Connector

  • November 19, 2018
  • 3 replies
  • 1 view
Jan Cees Boogaard

Text Connector

Author: cdouglass@siriussoftware.com.au (Colin)

Hi,

I am trying to use the text connector to create a text file. I have not used it before so I am not sure if I am setting it up right.

I have defined an entity with a DBMS path of "Text Files (TXT)".

I have added the following line the into the assignment file

[ENTITIES]
in_warehouse_product_seq.sirius $text:in_warehouse_product_seq.fdd/append

Then when I store the table "in_warehouse_product_seq" I get the following error in the msg frame
I/O function: 0, mode: 1, on file/table: $text:in_warehouse_product_seq.fdd/append
42000 [Microsoft][ODBC SQL Server Drive][SQL Server]Line 2: Incorrect syntax near ']'

Am I missing a step? I expected a text file with the extension of fdd to be created.

Do I need to have a $TXT path?

 Thanks Renee

3 replies

Jan Cees Boogaard

Text Connector

Author: cdouglass@siriussoftware.com.au (Colin)

Hi,

I am trying to use the text connector to create a text file. I have not used it before so I am not sure if I am setting it up right.

I have defined an entity with a DBMS path of "Text Files (TXT)".

I have added the following line the into the assignment file

[ENTITIES]
in_warehouse_product_seq.sirius $text:in_warehouse_product_seq.fdd/append

Then when I store the table "in_warehouse_product_seq" I get the following error in the msg frame
I/O function: 0, mode: 1, on file/table: $text:in_warehouse_product_seq.fdd/append
42000 [Microsoft][ODBC SQL Server Drive][SQL Server]Line 2: Incorrect syntax near ']'

Am I missing a step? I expected a text file with the extension of fdd to be created.

Do I need to have a $TXT path?

 Thanks Renee

Hello,

I suggest you to use $txt instead of $text  (because $TXT is the official mnemonic for TXT connector) :

[ENTITIES]
in_warehouse_product_seq.sirius $txt:in_warehouse_product_seq.fdd/append

 

And then don't forget to define TXT in paths and driver_settings sections, see an example below  :

[DRIVER_SETTINGS]
SOL     U3.4
SEQ     U1.0

MSS   Ux.x

TXT U1.0


[PATHS]
$TXT    TXT:
$MSS   MSS:xxx:|yyy|zzz

$SYS    $MSS
$UUU    $SYS
$IDF    $SYS
$DEF    $SYS


If it doesn't  work, please send use the full content of your asn file.

Regards,

Ben.


Author: BenHen (benoit.henry@hotmail.com)
Jan Cees Boogaard

Text Connector

Author: cdouglass@siriussoftware.com.au (Colin)

Hi,

I am trying to use the text connector to create a text file. I have not used it before so I am not sure if I am setting it up right.

I have defined an entity with a DBMS path of "Text Files (TXT)".

I have added the following line the into the assignment file

[ENTITIES]
in_warehouse_product_seq.sirius $text:in_warehouse_product_seq.fdd/append

Then when I store the table "in_warehouse_product_seq" I get the following error in the msg frame
I/O function: 0, mode: 1, on file/table: $text:in_warehouse_product_seq.fdd/append
42000 [Microsoft][ODBC SQL Server Drive][SQL Server]Line 2: Incorrect syntax near ']'

Am I missing a step? I expected a text file with the extension of fdd to be created.

Do I need to have a $TXT path?

 Thanks Renee

Thanks that did the job..


Author: Colin (cdouglass@siriussoftware.com.au)
Jan Cees Boogaard

Text Connector

Author: cdouglass@siriussoftware.com.au (Colin)

Hi,

I am trying to use the text connector to create a text file. I have not used it before so I am not sure if I am setting it up right.

I have defined an entity with a DBMS path of "Text Files (TXT)".

I have added the following line the into the assignment file

[ENTITIES]
in_warehouse_product_seq.sirius $text:in_warehouse_product_seq.fdd/append

Then when I store the table "in_warehouse_product_seq" I get the following error in the msg frame
I/O function: 0, mode: 1, on file/table: $text:in_warehouse_product_seq.fdd/append
42000 [Microsoft][ODBC SQL Server Drive][SQL Server]Line 2: Incorrect syntax near ']'

Am I missing a step? I expected a text file with the extension of fdd to be created.

Do I need to have a $TXT path?

 Thanks Renee

Hi Renee,

you have to use $TXT as the path or define your own $TEXT path which maps to $TXT.
Make sure the TXTxxxx.dll is specified (if you get a 3GL error).

Sucecss, Uli

if all you want to do is to CREATE a TXT-file, you can set the TXT for the entity in your data model; you do not need to use this /append routine:
To read data from a text file, add the /append command line switch to each file name in an assignment file, using the following construction:

Entity.ConceptualSchema = $txt:Entity.ffd/append
For example:
my_file.my_cs = $txt:my_file.ffd/append

The use of wildcards is not supported. Without the /append command line switch, the TXT connector implicitly creates the file or overwrites it.


Author: ulrich-merkel (ulrichmerkel@web.de)

Recent badge winners

Explore all badges
Terms & ConditionsAccessibility statement