Hi,
I have to export data with a particular format : fixed length, Tilda delimited, no headers. Thus, I decided to use a text template document and the LIST function specifying the query name, '~' as separator and the names of the attributes I wanted in the export :
<<LIST('Unrecorded Interface','~','SourceIndicator','ExpInd','ExportDate','TownshipCode','TownshipDescription','StandNumber','StStandNumber','OldStandNumber','OSSN','StandSize','OldStandSize','ZoneCode','ZoneDescription','LandUsageCode','LandUsageDescription','StreetNumber','StreetCode','StreetDescription','StreetType','Region','Ward','GisStandStatus','OwnerSurname','OwnerInitials','OwnerFirstNames','OwnerIdNumber','PreviousOwnerSurname','PreviousOwnerInitials','PreviousOwnerFirstNames','PreviousOwnerIdNumber','TitleDeedNumber','PurchaseDate','PurchasePrice','RegistrationDate','SiteValuation','ExemptSiteValuation','ImprovementValuation','ExemptImprovementValuation','ImprovedValue','OwnerType','ConsentUse','BettermentFee','EndowentFee','OwnerTypeDate','EffectDate','ValuationDate','VenusGenerationNumber','SwimmingPoolIndicator','SubdivisionConsolidationInd','ConsentUsageDate','SectionalTitleInd','ServitudeInd','EmptyStandInd','PropertyCategoryCode','ServitudeCode','EstateCode','UpperLevelIndicator')>>
As it is fixed length I add spaces in each attributes to be fill the full length so I am sure the there are all defined. This is the result of the template for one instance of the object when DISPLAY DOCUMENT :
~20080717~ ~ ~ ~ ~ ~0000000000~0000000000~ ~ ~ ~ ~ ~ ~ ~ ~ ~000~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~19021130~0000000000000~19021130~0000000000000~0000000000000~0000000000000~0000000000000~0000000000000~ ~ ~0000000000000~0000000000000~19021130~19021130~19021130~0000000000~ ~ ~19021130~ ~ ~ ~ ~ ~ ~
The problem is that, the attributes 'ExpInd' and 'OSSN' are missing even if the are DEFINED. Do you know what could be the cause ?
Another question concerns the fixed length, I had to create rules because I did not find any way to format the text attributes with a fixed length. Is there a more simple way to do it ?
Best Regards,
Christophe
