Ross & Steve,
Yes I had already tried both of those options but two things go wrong.
When the first line is created it has " ", between the unfilled fields
that are in the data records below and the Text does not come up with "
at the start and finish of each text. For example I did get the correct
header wording/numbers but because it is in one field the " only is
shown at the start and finish of the field not each item within it so
the uploaded file can distinguish between fields for its uptake.
At this point I've created a csv export of the invoice data to text,
with my solution then displaying a text field for both the Header and
Footer exactly as required for uploading. All the operator has to do is
to update the 'from and to' dates then click a button to copy it and
paste it into the first line of the csv text file. Similarly on the same
page it shows the exact footer line where they have to update the number
of records and total invoiced, both of which are displayed on my
solution screen.
A bit messy but I can't think of any other way of doing it. In reality I
think they'll only be doing it each week so the extra manual time, about
10 secs, shouldn't be an issue. I know we have to rely on the operator
typing in the correct dates and totals, but hey, someone has to be
responsible for some things in this world don't they ?
Lee
Ross Dickson wrote:
Lee
One way I've dealt with these problems is to create a new text field
and then with a script:
- enter the data and required formatting into the text field
- create two new records
- enter the header and footer information into the same text field.
- sort the records to get the header record first and the footer last
- export the text filed in all records
- delete the two new records
Another approach is to assemble all of the data with its formatting
requirements in a global text field. Add the header and footer
information, and export the global text field from one record. Convert
the vertical tabs in the exported text file into returns with a file
management plug in.
Ross
Lee 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
--
