Mike

There doesn't  seem to be a way of setting up your own admin areas ? 

Dave

I like the admin area idea, but given the difficulties associated with this at the moment, then I think that the sample measurement option seems to be the best one. I see the sense in associating the 'measurement' with the sample rather than the observation too.

It's probably about time that I looked at the R6 XML reports/batch update documentation to try to learn how to write a batch update myself to do this. But it would sure save me a lot of time Mike if you could point me at any existing script that does something similar. I've tinkered before with XML reports that select records by polygon so I'm assuming that an XML batch update can select records in a similar way. What I'm more unsure about is creating new measurement records and associating them with samples of the selected records. Any snippets of SQL or pseudo-code that would help point me in the right direction would be very much appreciated.

Rich

Rich

Hopefully not spoiling your fun, the following untested code is someting along the lines of what you need.

Mike

<?xml version="1.0" ?>
<batchupdate menupath="Whatever" description="As you think "
title="As required
">
<SQL>

<Where keytype="Default">
Declare @SampleKey char(16)
Declare @SDKey char(16)
Declare @MUKey char(16)
Declare @MQKey char(16)
Declare @userId char(16)
Declare @Entrydate char(16)
Declare @Custodian char(8)
Declare @SampleData varchar(3)

SET    @EntryDate    =    GETDATE()
SET @UserID = (SELECT NAME_KEY FROM NAME WHERE
   <Condition field="Name.Name_Key" type="CurrentUserID" name="Current User ID"     operator="equal" /> )
SET @MUKey = 'Your MU Key'
SET @MQkey = 'Your MQ Key'
SET @sampleData = 'Y'

CREATE TABLE #TempSample (sample_Key char(16)  COLLATE SQL_Latin1_General_CP1_CI_AS
                   
           )

INSERT INTO #TempSample (Sample_Key) 
SELECT DISTINCT Sample_Key
FROM Sample S
WHERE
<Condition field= "S.Sample_key" operator="equal"  type="SamplesinPolygon"  name="Select Polygon"  includepartialoverlap="no"/>
AND
NOT EXISTS(SELECT * FROM SAMPLE_DATA SD WHERE SD.Measurement_Unit_Key  = 'Put your key in here')

DECLARE    SD_Cursor CURSOR FOR
        (   
            SELECT    sample
            FROM    #TempSample
        )
        OPEN    SD_Cursor
       
        FETCH NEXT FROM SD_Cursor
        INTO    @sampleKey
       
        -- Loops through the list of taxon designation type and adds entries to Taxon_designation_Set item
        WHILE @@FETCH_STATUS = 0
        BEGIN
            EXECUTE spNextKey 'Sample_datam', @SDKey  OUTPUT
                SET @Custodian = LEFT(@SDKey,8)       
                       
                INSERT INTO Sample_data (
                        Sample_data_key ,
                        sample_Key,
                                                Measurement_Unit_Key,
                        Mesaurement_Qualifier_Key,
                           Data,
                        Entered_By,
                        Entry_Date,
                        Custodian    )
                VALUES (@SDKey,
                                            @sampleKey,
                        @MUKey,
                        @MQkey,
                                            @sampleData,
                        @UserID,
                        
                                            @EntryDate,
                            
                        @Custodian    )
                       
            FETCH NEXT FROM SD_Cursor
            INTO    @Sample_Key
        END
       
        CLOSE        SD_Cursor
        DEALLOCATE    SD_Cursor
   
             

Drop table #TempSample

</Where>
</SQL>
</batchupdate>

Read-only system supplied admin area sounds ideal for LRCs as they use Vice County boundaries that in theory will never change, but can I put in a vote on behalf of organisations wanting to report upon reserves?  The boundaries of these will change over time and so it might be more appropriate to allow admin areas to be user controlled?  Maybe even directly linked to a GIS package to enable seamless operation?