Skip to content

XAware Community

Get the Flash Player to see this player.
Flash Image Rotator Module by Joomlashack.
XAware 5.6
Need Help
Webinars and Events
Advanced Tutorials
Webinars and Events

You are here: Home arrow Forums
XAware Community Forums
Welcome, Guest
Please Login or Register.    Lost Password?
S1311: Update FileBizComp to read header line (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: S1311: Update FileBizComp to read header line
#1507
Vasu Thadaka (User)
XAware guru
Posts: 793
User Offline Click here to see the profile of this user
S1311: Update FileBizComp to read header line 11 Years, 11 Months ago Karma: 4  
S1311: Update FileBizComp to read header line, detect separator

For delimited records, provide a check-box to designate that the file contains a header line. When checked, provide a browse button to browse for a sample file. Read the file's first line. Parse the line into fields. Use the fields as names to construct the template structure. In this way, the user can quickly create a readable XML structure from a text file with a header. (Murat request, also a prominent feature in Talend and Pentaho/Kettle).

Also, attempt to auto-detect the separator character. Use a simple algorithm: find the first non-alpha-numeric non-space character, use that as the "suggested separator".

At run-time, the first line of the file must be discarded.

Acceptance Criteria:
1. When creating a file bc during the wizard process the user can specify that the first line is a header
2. The user can supply a sample file and a sample xml structure is produced from that along with a guess at the suggested separator is used to fill in separator.
3. When the bizcomp is executed the header line is skipped/ignored.


-------------------------------------------------------------
S1321
FileBizComp header line enhancements
Based on feedback from Murat:

For reading a delimited file:
Specify a line number for the header line, if it exists
Specify a line number for the first data line

These allow skipping comment lines.

Writing delimited file:
Also, while writing delimited files, lets introduce the concept of a header line. The header line will be derived from the name of the element in the template.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
      Topics Author Date
    thread link
S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/15 12:34
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/15 12:38
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
kvandersluis 2008/05/15 18:21
    thread link
thread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/16 06:33
    thread link
thread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
kvandersluis 2008/05/16 08:39
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/16 09:01
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/05/16 15:35
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/19 06:10
    thread link
thread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/05/19 10:57
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/05/16 15:53
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/19 06:12
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/05/16 16:23
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/19 06:13
    thread link
thread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/20 09:29
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/05/19 11:03
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/19 11:29
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/05/19 15:53
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/20 03:10
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
molmez 2008/05/20 10:12
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/20 11:26
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/05/20 15:47
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
dblack 2008/05/20 17:18
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
molmez 2008/05/21 03:25
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/21 04:16
    thread link
thread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
kvandersluis 2008/05/21 11:57
    thread link
thread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/22 05:54
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/05/21 11:53
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/05/23 17:21
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
molmez 2008/05/25 12:04
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/26 06:02
    thread link
thread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
kvandersluis 2008/05/26 23:25
    thread link
thread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/27 07:09
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
kvandersluis 2008/05/28 01:08
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/28 07:13
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
kvandersluis 2008/05/28 17:52
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/29 04:16
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
kvandersluis 2008/05/29 11:04
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/05/29 12:02
    thread link
thread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
satish.kuncha 2008/05/29 12:14
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
molmez 2008/05/28 06:00
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/05/29 11:09
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
satish.kuncha 2008/05/29 11:58
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/05/29 13:35
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
satish.kuncha 2008/05/30 09:21
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/05/30 10:53
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/06/03 09:15
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
kvandersluis 2008/06/03 09:32
    thread link
thread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/06/03 12:29
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/06/03 13:22
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/06/04 07:25
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/06/03 14:46
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/06/04 07:02
    thread link
thread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/06/04 11:50
    thread link
thread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/06/05 06:58
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/06/05 11:42
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/06/04 10:32
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/06/05 09:11
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/06/04 10:48
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
jpeters 2008/06/04 14:25
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/06/05 07:10
    thread link
thread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
kvandersluis 2008/06/05 09:12
    thread link
thread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
kvandersluis 2008/06/05 09:16
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/06/05 09:38
    thread link
thread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/06/05 09:47
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/06/05 11:59
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/06/05 13:28
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/06/05 13:38
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
kvandersluis 2008/06/06 09:46
    thread link
thread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/06/06 11:06
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/06/06 13:34
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/06/09 05:14
    thread link
thread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
kvandersluis 2008/06/11 12:01
    thread link
thread linkthread linkthread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
kvandersluis 2008/06/11 13:05
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/06/06 13:57
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
molmez 2008/06/12 03:22
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
Vasu Thadaka 2008/06/12 06:00
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
voconnor 2008/06/12 10:27
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
jpeters 2008/06/12 10:27
    thread link
thread linkthread linkthread link Re:S1311: Update FileBizComp to read header line
ravindrach 2008/06/12 10:46
    thread link
thread linkthread link Re:S1311: Update FileBizComp to read header line
jpeters 2008/06/12 10:51
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop

Community Login

Get the Flash Player to see this player.
Flash Image Rotator Module by Joomlashack.
Commercial
Free Training
QuickStart Packages
Image 4 Title
Image 5 Title

Visit XAware.com