Export button data formatting

[terryd]

I have a little diary table with the fields in diarybrowse.png.
Problem 1. The Diary time is a long with a predetermined format of @t4
In diarytimeheader.png the date picture for the column is correctly set as '@t4', but in DiaryTimedataformatting.png the formatting seems to be ignored and the the value is displayed as a long
Problem2. The comment field is a string with length 2048. In commentformat.png I'm not sure about the first IF section but the ELSE sets the column width to the length of the clipped comment, unfortunately the information exported is truncated to the first 50 characters in the field
DiaryBrowse.png is the browse that the export is generated from.
ExcelExport.png is the generated xml file
What do I do to display the time correctly?
What do I do to display more of the comment (maybe not all of it but certainly more)?

[attachment deleted by admin]

[Bruce]

perhaps you can send me an example app Terry?

[terryd]

Hi Bruce
Attached is Web modified and the exported xml file

Steps to reproduce

Added xfiles to the application
Used Nettalk Browse wizard to create the browse and update procedures
On the browse form tab checked the close button and set export to Yes
On the UpdateSiteDiary Priming tab
Diary date was already set to today()
I added DiaryTime set to Clock()
I added CreatedBy set to Terry
Added a menu item Diary calling procedure SiteDiary
Compiled
Insert a diary record
Even though the dictionary has the DiaryTime field defined as Long format @T4 the wizard has created the field in the form as Number which allows no formatting and no value appears in the field. Entering a comment and saving displays a diary time of 0:00:00 in the diary time field of the browse so the formatting was accepted here.
I changed the field type to string with a picture of '@t4'
recompiled
The diary time displayed correctly
Added 2 records using Lorem ipsum
XML file Result attached
Time in wrong format
Comment truncated to 50 characters


[attachment deleted by admin]

[MyBrainIsFull]

Hi Terry, I have compiled your app and agree with you, looks like the ExportExcel Routine is a work in progress....

The routine only checks for a date, not a time, and the comments are cut at 50 chrs even if you hard code the column size at 500

I have attached your app with the export section commented out and replaced, it fixes the time, but not the comments.  That might be for Bruce in 8-32

If it were me, I would hijack the routine and make it generate a csv (ascii) file instead.
Let me know if you want more help with that.

Regards
Kevin


[attachment deleted by admin]

[terryd]

Hi Kevin. Thanks for that.
I will work around this issue using your time fix at the moment but I would obviously like this to be standard within the system. On the comment field for this particular application I am chopping the field into less than50 character bits and then displaying them as multiple fields. Not an elegant solution but when you are under the whip you do what you need to, not what you should ;-) .

[Bruce]

Hi Terry,

Sorry for the delay.
The comment length issue is fixed in xFiles - build 2.56 which is currently up.

The time issue is fixed in NetTalk 8.32 - which hopefully will be up in the next day or so.

cheers
Bruce

[terryd]

Thanks Bruce