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
--
--
