Hi Lee,
You could create two calcs:
Case(
Get(RecordNumber) = 1 ; "\"H\"," & clientID & "\",20090708,\"From " &
startdate & " to " & enddate & "\"")
for the header
and
Case(
Get(RecordNumber) = Get(FoundCount) ; "\"T\"," & invnumbertotal & ", "
& invoiceamounttotal
for the footer
that would only return results for the first and last records.
Not sure exactly what results you're after, but the Get(RecordNumber)
idea should get you started.
--
Steve Moore
Cumberland, Maine
On Jul 8, 2009, at 5:45 AM, Lee wrote:
Beverly,
The situation is that a client of mine has joined a 'buying' group
where many of his customers are members. This group has requested
that all his clients that belong to the group have their invoices
charged directly to the group who will then pay the accounts. The
group has requested that he complete a csv 'Report' to be uploaded
via the web to their website. They have furnished an example of the
report which shows each invoice/line like this "D",
20090710(inv.date),"RST1011"(their client ID),1(denotes invoice or
credit note),"Parts",354.69(inv amount),30(days to pay)
I can easily create this part of the report simply by exporting the
relavant data from the day's invoices out of Filemaker, however, the
group has a 'Header' line consisting of
"H","myClient ID",20090708,"From 2/7/2009 to 8/7/2009".
Obviously the day and date first being in Australia
There is also a 'Footer' line
"T",28(inv number total),15604.34(invoice amount total)
Its these Header and Footer lines that have me perplexed.
If you take the 'report' into Excel then it will have to be
converted back to standard csv as they require the "" surrounding
the text.
Lee Mills
Beverly Voth wrote:
Lee, as CSV, is this to be opened in Excel? And if so, in what
version of Excel? FMP & SQL require the same number of columns in
each row to open a csv file. Excel, just reads the data until a
return/new line is encountered, AFAIK.
Excel will also read XML in a format that places data in particular
cells, if that's what you need. Export from FMP as XML and apply an
XSLT to make an .xlsx file.
--
Beverly Voth
mailto:[email protected]
tel:(606) 258-7399
--
On Jul 8, 2009, at 1:34 AM, Lee <[email protected]>
wrote:
Hi,
I can export data to csv, no problem however can you create a
header and a footer with other data as a csv file.
For example you can have 20 lines of data with the top line
displaying information from 3 other fields and a Footer with
totals etc.
Lee Mills
--
--
