1 Reply by Darwyn Sumner (LERC) (edited by Darwyn Sumner (LERC) 28-11-2007 15:16:33)

  • Darwyn Sumner (LERC)
  • Veteran
  • Offline
  • Registered: 07-06-2006
  • Posts: 176

Re: Date validation and future dates

"You cannot specify that ... a site was designated at a date in the future!" Says the Help Menu
Nonsense!
I wish to designate sites scheduled for Resurvey in 5 year's time so that I can easily produce field schedules for our surveyors.
So does everyone else who uses Recorder to manage Local Sites surveying.

2 Reply by Darwyn Sumner (LERC)

  • Darwyn Sumner (LERC)
  • Veteran
  • Offline
  • Registered: 07-06-2006
  • Posts: 176

Re: Date validation and future dates

Here's our "Wenceslas" fix:

1. Add a term "Resurvey" to Site_status
2. Assign this to the appropriate Location's list of Designations
3. Subtract 100 years from the date you wish to send your surveyors out resurveying (or your Page out searching for peasants in the snow)
4. Use this XML which replaces the lost 100 years (actually 1200 months as

"y", 100

doesn't appear to work - perhaps even Microsoft cannot imagine anyone needing to subtract or add years):

<?xml version="1.0" ?> 
<CustomReport menupath="Surveying" title="Resurvey - The Wenceslas Fix" description="Generates a list of sites to be resurveyed. The dates in the dialog box MUST be 100 years ago and close to the Feast of St. Stephen. if it's not on the list you haven't added the Land Parcel yet and what's the point of you going out in the snow without the peasant's parcel.">     
<SQL>
--Darwyn Sumner 2007"" 
SELECT DISTINCT 
                LOCATION.LOCATION_KEY as LOCATION_KEY,
        LOCATION_NAME.ITEM_NAME as Location,
        LOCATION.FILE_CODE as Object,
        LOCATION.SPATIAL_REF as [Grid ref], 
        --dbo.LCReturnEastings(LOCATION.SPATIAL_REF, LOCATION.SPATIAL_REF_SYSTEM) AS Easting, 
                --dbo.LCReturnNorthings(LOCATION.SPATIAL_REF, LOCATION.SPATIAL_REF_SYSTEM) AS Northing,
        LOCATION_DESIGNATION.REF_CODE as [Reference], 
        DateAdd("m",1200,LOCATION_DESIGNATION.DATE_FROM) as [From], 
        LOCATION_DESIGNATION.DATE_TO as [to], 
        LAND_PARCEL.LAND_PARCEL_NUMBER as Parcel,
        LAND_PARCEL.LAND_PARCEL_MAP_SHEET as Sheet

FROM          
           LOCATION INNER JOIN
         LOCATION_NAME ON LOCATION.LOCATION_KEY = LOCATION_NAME.LOCATION_KEY INNER JOIN
         LOCATION_DESIGNATION ON LOCATION.LOCATION_KEY = LOCATION_DESIGNATION.LOCATION_KEY INNER JOIN
         SITE_STATUS ON LOCATION_DESIGNATION.SITE_STATUS_KEY = SITE_STATUS.SITE_STATUS_KEY INNER JOIN
         LAND_PARCEL ON LOCATION.LOCATION_KEY = LAND_PARCEL.LOCATION_KEY
         
<Where keytype="Default">
WHERE     
        ((LOCATION_DESIGNATION.SITE_STATUS_KEY)='LERC00010000001B') 
        AND (LOCATION.FILE_CODE != 'none') 
        AND LOCATION_NAME.PREFERRED = 1
ORDER BY 
        [From]

</Where>
      
    </SQL>
    
<Columns>
   <Column name="LOCATION_KEY" position ="1" caption="LOCATION_KEY" visible = "true" width="110"/>
   <Column name="Object" position="3" caption="Object" width="45"/>
   <Column name="Location" position ="4" caption="Locations" visible = "true" width="220"/>
   <Column name="Grid ref" position ="5" caption="Grid" visible = "true" width="80"/>
   <Column name="From" position ="6" caption="From" visible = "true" width="60"/>
   <Column name="to" position ="7" caption="to" visible = "true" width="60"/>
   <Column name="Sheet" position ="8" caption="Sheet" visible = "true" width="60"/>
   <Column name="Parcel" position ="9" caption="Parcel" visible = "true" width="45"/>  

</Columns>
</CustomReport>

5. Note that this doesn't return a value unless you've also added "Land Parcel" details