Page Header when Export
Hi Todd, Andy…
My way to solve this is very simple, and avoids the issues Andy spots :
Set print or export file name {[Path]}
Calculate TitleRow as row(‘Name’,’First Name’,’Date’,”Time’,’Type’)
Prepare for export to file {Delimited (tabs)}
Export data TitlesRow
Prepare for export to file {Delimited (tabs)} <———
Export data MyList
End export
Close print or export file
The second Prepare to export should not be necessary, but a bug in Omnis makes it needed (at least version 5 and before)
Hope it helps
> Le 3 juin 2017 à 14:59, Andy Hilton <andyh@totallybrilliant.com> a écrit :
>
> Todd
>
> I do this by adding code to read my column names and create a line with the titles to export prior to exporting the data – the thing to be aware of is that you then have to have the columns as text columns as a column that is say set for a number will not output something like ‘total’ it just spits it out as 0.00 !!! But otherwise it’s all good to do it that way…….I have not found any way of automating this within Omnis……
>
> Andy
>
>> On Jun 3, 2017, at 1:42 AM, Todd <mimm@montana.com> wrote:
>>
>> Yes, it is just a tab delimited file for use in excel or others. It works great except that the page header which should provide column heads (as it does when sent to printer) is suppressed. Checking with a text editor reveals no first line of page header.
>>
>> Sent from my iPad
>>
>>> On Jun 2, 2017, at 11:23 PM, Chris hughes <ataddata@bigpond.net.au> wrote:
>>>
>>> Hi Todd is that just a tab delimited export file your trying to create.
>>>
>>>
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com