Land Access
active
Total logged
62h 0m
Uninvoiced
0h 0m
Entries
24
Invoices
0
Time by team member
| Team member | Entries | Hours |
|---|---|---|
| Caleb Harvey | 24 | 62h 0m |
Recent time entries
Last 24
| Date | Description | Who | Duration | Status |
|---|---|---|---|---|
| 24 Feb 2025 | Land Access Export - Add fields to export for contact; address, email, phone number | Caleb Harvey | 1h 30m | invoiced |
| 4 Dec 2024 | Land Access Import - Add two fields and relationships to show both the duplicates within the import and the duplicates from the import to the system - Use these fields to add a conditional format on the import lines to show red or orange respectively - If clicking on an import duplication, open the import table and go to related records to show the duplicates - Add a conditional format on the fields to show which fields are matching - Add a delete button to remove these records from the import list - For the system duplicates, open a different window showing the system duplicates against the clicked record - Add a button on each field in the list to override the existing system field with the new record data - Add a delete button up the top right to delete the import record when finished merging - Change the attach file button to process the document straight away into the import list - Change the process button to process this list into the system for land access records - Add in the import reference number and the selected state ID to the new records as well as looping through the import records to add in - Show a custom dialogue stating there are still duplicates do you wish to proceed - Show a custom dialogue if there is no state selected to say a state must be selected - Test importing the data with success - Change the delete button to grab the records related to the import selected from the land access table and delete - Test this with success - Complete | Caleb Harvey | 6h 30m | invoiced |
| 8 Nov 2024 | Export Selected Records from Land Access List - Create a script step in the list html file to grab the ID of all land access records selected and send through to a filemaker script step - Using these ID's, create a server record then go to the related land access records after setting the relationship field with the ID's - Loop through and perform a find on each record for associated agreement data - Add in missing required relationships from the back end - Loop through list adding the land access data to the first half of the spreadsheet and listing the agreement data down the second half - Duplicate the land access data for multiple agreement data associated - Test the export with success | Caleb Harvey | 4h 0m | invoiced |
| 7 Nov 2024 | Exporting Individual Records - Create a script step to export the selected land access data along with any associated agreements - Add a button to the card that opens when land access has been clicked on - First create the header data then add the land access data below - Loop through the associated agreement data and add in under the required heading - Success | Caleb Harvey | 3h 0m | invoiced |
| 6 Nov 2024 | Land Access Table - Adding in new columns to the land access data in accordance with the new import spreadsheet from Kate | Caleb Harvey | 1h 0m | invoiced |
| 4 Nov 2024 | Importing Land Access Data - Handling the uploaded data file from the user to create records inside the import table - Showing this data to the user and being able to process from here - Start work on a table to display all found clients and be able to sort through them and link them up inside the system - Importing the import table through to the land access table when the user has processed the data - Success | Caleb Harvey | 5h 30m | invoiced |
| 30 Oct 2024 | Import function - Starting Import function for land access records - Create further import tables to house the import files - Duplicate the tenement import table - Show the new tables portal nav and select on this page - Allow user upload for an excel file | Caleb Harvey | 1h 15m | invoiced |
| 27 Sept 2024 | Land Access - Creating a new relationship from agreement to land access record with the new field land access ID - Adding a portal on the agreement tab to show the link and a button to link them - When the button is pressed, open a land access list filtered by the land access relationship to the tenement - Create a link between land access table and tenement table to display on relationships section on tenement details page - Add a button over the land access record on this list and get it to bring up a card - On the card, display the land access record and a portal of all associated agreements linked to the selected record - Success | Caleb Harvey | 5h 30m | invoiced |
| 13 Sept 2024 | Land Access Linking for PDF - Establishing a link between agreement and land access records in the back end - Creating a fake join on some test data - Using this relationship to build out a pdf display of the land access data along with listing down the related agreement data - Back and forth with Kate to determine how relationship will be built and type of data required - Still work to be done on relationships | Caleb Harvey | 5h 0m | invoiced |
| 13 Sept 2024 | Land Access Meeting - Teams to go over work done so far - Further clarification on linking land access to agreements and display | Caleb Harvey | 1h 30m | invoiced |
| 9 Sept 2024 | Archiving Agreements - Add a button toggle to the agreements tab to turn the search bar off and on to allow view of archived or active only - Link this button up to the relationship between the portal and the active status of the records - Add an archive button on to the portal records that sets the line as active/inactive depending on its current status - Add a hide to the select fields and place non-editable fields underneath them that display if the record is archived - Change the conditional format on the line of the portal to make the text grey and italic if the record is archived - Test with success | Caleb Harvey | 1h 45m | invoiced |
| 9 Sept 2024 | Agreement Type Filter/Export - Add a new search object above the agreement portal - Add a pop-over button on top which contains a unique list of all agreement types in this list - When selected, it will set the search field with the type - Updated the filter on the portal to allow for action type of 4 (Agreements) and to filter down types to the type selected in the search if relevant - Tested the export which doesn't take into account the filter - Created a new while loop to loop through the portal and and match the filter against every item in the sub list - Ran this loop through the script parameter to send the exportable ID's to excel - Added the new fee field in the export script for agreements - Tested with different filters with success | Caleb Harvey | 2h 30m | invoiced |
| 9 Sept 2024 | Land Access Fees - Add Fees field into the agreements table - Show this field on the native title tab in the directory details screen - Ensure the field is clear to type into - Success | Caleb Harvey | 0h 30m | invoiced |
| 9 Sept 2024 | Land Access Teams - Anita and Kate - Adding ‘fees’ field in the agreements tab for Native title fees/comp fees etc. - Ability to export by agreement type - Archive button on the agreement tab - In the land access view we need to be able to indicate whether there are existing agreements i.e Notice of Entry, Compensation or Native Title - Once all of the data for agreements are in we can start to look at generating a summary by Lot/Plan or Tenement. - Add in the date the title search was conducted. | Caleb Harvey | 1h 15m | invoiced |
| 6 Sept 2024 | Phone call to Kate - Land Access Discussion - Data to be pulled from system and to be added - PDF and excel or in system display | Caleb Harvey | 1h 0m | invoiced |
| 5 Sept 2024 | Build Land Access Report - Create a new layout and start building the boxes to layout all the information - Build the headers for the report and map out field placements and what data is going where - Start entering as much data as accessible through current means and understanding - Call to Kate to clarify where data is pulling from and how it will look | Caleb Harvey | 2h 30m | invoiced |
| 5 Sept 2024 | Add onClick function to go to the tenement linked to the land access record - Add new function for onCellClicked in javascript - Add the ID of the tenement into the backend JSON data in FileMaker - Create a new function to run a FileMaker script in JS and direct the user to the selected tenement - Test until working correctly - Success | Caleb Harvey | 2h 0m | invoiced |
| 5 Sept 2024 | Discussion with Anita and Kate about land access screen | Caleb Harvey | 1h 30m | invoiced |
| 5 Sept 2024 | Update Ag-grid to the latest version in the web viewer - Fix any depricated functions - Retest data with success | Caleb Harvey | 2h 15m | invoiced |
| 4 Sept 2024 | Land Access - Add more options to the aggrid view - Bring through all the columns from the import table and test out the sorting and filtering - Add a save report option and link to a javascript function - In the function, save the column and filter state as base64 and send it back to FileMaker - Data coming through correctly | Caleb Harvey | 2h 30m | invoiced |
| 3 Sept 2024 | Create Nav UI - Create a UI similar to the task list page - Embed the url to the html file on the server to test accessing the data through oData API - Add a json field to the import table and a 1 to 1 relationship on the new Land Access table to list all json data - Add some test fields into the json data and send through the url to access the calc field on the land access record from oData - Change html file to allow for this method as original method only accounted for less than 10000 records | Caleb Harvey | 2h 30m | invoiced |
| 3 Sept 2024 | Import Table Creation - Create a Land Access Import Table with all fields required - Import the spreadsheet into the system - Create ID fields behind all the contact fields and match them to respective relationships on the contact table - Run the update to bring through ID's - Convert date field in spreadsheet to date format before importing - Enquire about matching names and importance of tracking contacts for Land Access in system - Add in tenement name match with ID Tracking | Caleb Harvey | 2h 30m | invoiced |
| 3 Sept 2024 | Land Access Meeting - Going through spreadsheet and requirements | Caleb Harvey | 2h 0m | invoiced |
| 8 Jan 2024 | Land Access Missing Data - Searching through backups to find an instance of data being in the system where it is currently blank - Found the contact dja dja wurrung had been deleted and a new one had taken its place - ID linked to deleted contact still linked to all land access land owner fields - updated the old ID to the new ID of the land owner and this fixed missing land owner data for this contact - Pulled an extraction from the system of all Vic land access records to see what happened to send to AMETS team to find missing data | Caleb Harvey | 2h 30m | invoiced |
Edit