asked on

CSV file Insert Header

I have a csv file which does not have a header, but some time I would like a header for the file. I create this csv file on the fly use xslt file as my stly sheet is there a way I can add a header using the stly sheet or will I have to use vb.net code. example of csv file below. The xslt currently work fine but it does not add header to the file. I have attached the xslt for your review.

12408      333333333      0      666      666      1      FALSE                  1015            36      25      0
12508      336666666      0      88      885      1      FALSE      3.5                                    0
12508      222222222      0      88      523      1      FALSE      58                                    0

<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="text"/>
 
  <xsl:template match="Employees">
    <xsl:for-each select="Time">
      <xsl:apply-templates select="*"/>
      <xsl:text><!--new line at the end of the information-->   </xsl:text>
    </xsl:for-each>
  </xsl:template>
 
  <xsl:template match="*"><!--put out elements content in qutes-->
    <xsl:if test="position()>1">,</xsl:if>
    <!--more than one being processed-->
    <xsl:text/>"<xsl:apply-templates/>"<xsl:text/>
  </xsl:template>
</xsl:stylesheet

Open in new window

Gertone (Geert Bormans)

<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>

<xsl:template match="Employees">
<xsl:for-each select="Time/*">
<xsl:value-of select="name()"/>
<xsl:if test="not(last())">,</xsl:if>
</xsl:for-each>
<xsl:text></xsl:text>
<xsl:apply-templates select="Time"/>
</xsl:template>

<xsl:template match="Time">
<xsl:apply-templates select="*"/>
<xsl:text></xsl:text>
</xsl:template>

<xsl:template match="*">
<xsl:if test="position()>1">,</xsl:if>

<xsl:text>"</xsl:text><xsl:apply-templates/>"<xsl:text>"</xsl:text>
</xsl:template>
</xsl:stylesheet

Gertone (Geert Bormans)

note that I got rid of the for-each Time,
it is better to use apply-templates there
(let XSLT do the work instead of yourself :-)

this construct is wrong
<xsl:text/>"
the " should be inside the xsl:text element as in my code

daruffin

ASKER

This code does not move the data or give a header for the file. It changes the sheet name but it did not work

Gertone (Geert Bormans)

> It changes the sheet name

are you looking at this in Excel?
I allready found it weird that you had ',' in the code and none in your so called output

can you post a bit of the XML please, so I can test this
It worked with the XML I created myself, but it could be different from yours

daruffin

ASKER

Here is the xml code below, my old code will convert it to a csv, but it does not add the header to the file

<?xml version="1.0" ?>
- <Employees>
- <Time>
<TransferDate>012508</TransferDate>
<EmployeeNumber>333333333</EmployeeNumber>
<SalesOrderNum>0000000</SalesOrderNum>
<WorkeTicketSeq>888</WorkeTicketSeq>
<WorkeTicketStep>888</WorkeTicketStep>
<SequenceNum>1</SequenceNum>
<OverTime>false</OverTime>
<HoursWorked />
<RecordType />
<StartTime>0915</StartTime>
<EndTime />
<ActivityCode />
<Department />
<Flag>0</Flag>
</Time>
</Employees>

daruffin

ASKER

by the way I'm looking at the file in excel, but my customer will use excel to changes some of the data

ASKER CERTIFIED SOLUTION

Gertone (Geert Bormans)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

daruffin

ASKER

I will test it when I come back from lunch and let you know thanks so much for your help. I will let you
know after lunch if it worked

daruffin

ASKER

Hello Geert

This works fine. Just need for the user to know what the fields our with-out typing them in each time.It add the header twice on the same line but I guess they can just remove the other section of header which has no data.
If you have any more suggestion out to have it stop after the first section of header it would be apperecited, if not then I can live with this out come

daruffin

ASKER

Thanks alot Geert for your help.

Gertone (Geert Bormans)

I see, I forgot to add a restriction on the header
(it works correctly if I only have one Time element)
You need to add a [1] in the for-each, to only access the first Time element, not all

<xsl:template match="Employees">
<xsl:for-each select="Time[1]/*">
<xsl:text>"</xsl:text>
...

daruffin

ASKER

Thanks so much Geert everythings works fine. I will stay in touch if I need anything else

Gertone (Geert Bormans)

welcome