Menu ▾ ▴

#823 File read tab delimited read not working in wizard

5.4
open
nobody
Designer (557)
5
2009-08-25
2009-08-25
prichards
No

Build 5.4.0.356

The File BizComp Read Delimited does not allow tab as a record separator in the wizard. I have found two ways for the Engine to work with tab delimited - one is to set xa:field_separator to the tab character (can do this using Auto Detect, which sets xa:field_separator="	") and the other is to edit and set xa:field_separator="\t".

First, it should be decided what character or special case(s) will be used to represent "tab" in the Designer and in the Engine (resulting BizComp).

Second, here is a list of current issues with the wizard:
- you cannot enter the tab character in the Field Separator entry; hitting the tab key
takes you to the next field in the GUI, nor can you enter more than one character (e.g. "\t")

- using Auto Detect to Browse a file with tab separators will detect the tab character and
set xa:field_separator="	". However, Auto Detect does not correctly identify the
number of fields and treats all of the fields as a single field when trying to map. User
must then manually edit the number of fields and add them to the Source and to Target mappings.

- When xa:field_separator="	", the Designer does not display any character in the tree view
(and appears to be no field separator to the viewer)

- documentation does not include any notes or instructions for tab delimited (i.e. how to
enter the tab character or what representation to use)

I have not tested File BizComponent Write (for tab delimited), which may have similar issues.

Discussion


Log in to post a comment.