{"id":739,"date":"2026-08-19T16:25:10","date_gmt":"2026-08-19T16:25:10","guid":{"rendered":"https:\/\/anchurus.co.uk\/?page_id=739"},"modified":"2026-08-19T16:25:11","modified_gmt":"2026-08-19T16:25:11","slug":"using-the-anchurus-ii-web-application-a-site-leaders-view","status":"publish","type":"page","link":"https:\/\/anchurus.co.uk\/?page_id=739","title":{"rendered":"Using the Anchurus II web application: a site leaders\u2019 view"},"content":{"rendered":"<div class=\"root-eb-toc-4on3z wp-block-essential-blocks-table-of-contents\"><div class=\"eb-parent-wrapper eb-parent-eb-toc-4on3z \"><div class=\"eb-toc-container eb-toc-4on3z eb-toc-sticky-left eb-toc-is-sticky eb-toc-collapsible eb-toc-initially-not-collapsed eb-toc-scrollToTop style-2 list-style-none\" data-scroll-top=\"false\" data-scroll-top-icon=\"fas fa-angle-up\" data-collapsible=\"true\" data-sticky-hide-mobile=\"false\" data-sticky=\"true\" data-scroll-target=\"scroll_to_toc\" data-copy-link=\"false\" data-editor-type=\"\" data-hide-desktop=\"false\" data-hide-tab=\"false\" data-hide-mobile=\"false\" data-itemcollapsed=\"false\" data-highlight-scroll=\"false\"><div class=\"eb-toc-header\"><span class=\"eb-toc-close eb-toc-sticky-left\"><\/span><h2 class=\"eb-toc-title\">Table of Contents<\/h2><\/div><div class=\"eb-toc-wrapper \" data-headers=\"[{&quot;level&quot;:2,&quot;content&quot;:&quot;Summary&quot;,&quot;text&quot;:&quot;Summary&quot;,&quot;link&quot;:&quot;summary&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Getting started and the control screen&quot;,&quot;text&quot;:&quot;Getting started and the control screen&quot;,&quot;link&quot;:&quot;getting-started-and-the-control-screen&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Listing a table&quot;,&quot;text&quot;:&quot;Listing a table&quot;,&quot;link&quot;:&quot;listing-a-table&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Deleting rows in a table&quot;,&quot;text&quot;:&quot;Deleting rows in a table&quot;,&quot;link&quot;:&quot;deleting-rows-in-a-table&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Exporting table data&quot;,&quot;text&quot;:&quot;Exporting table data&quot;,&quot;link&quot;:&quot;exporting-table-data&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Importing table data&quot;,&quot;text&quot;:&quot;Importing table data&quot;,&quot;link&quot;:&quot;importing-table-data&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Writing queries&quot;,&quot;text&quot;:&quot;Writing queries&quot;,&quot;link&quot;:&quot;writing-queries&quot;}]\" data-visible=\"[true,true,true,true,true,true]\" data-delete-headers=\"[{&quot;label&quot;:&quot;Summary&quot;,&quot;value&quot;:&quot;summary&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Getting started and the control screen&quot;,&quot;value&quot;:&quot;getting-started-and-the-control-screen&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Listing a table&quot;,&quot;value&quot;:&quot;listing-a-table&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Deleting rows in a table&quot;,&quot;value&quot;:&quot;deleting-rows-in-a-table&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Exporting table data&quot;,&quot;value&quot;:&quot;exporting-table-data&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Importing table data&quot;,&quot;value&quot;:&quot;importing-table-data&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Writing queries&quot;,&quot;value&quot;:&quot;writing-queries&quot;,&quot;isDelete&quot;:false}]\" data-smooth=\"true\" data-top-offset=\"50\"><div class=\"eb-toc__list-wrap\"><ul class=\"eb-toc__list\"><li><a href=\"#summary\">Summary<\/a><li><a href=\"#getting-started-and-the-control-screen\">Getting started and the control screen<\/a><li><a href=\"#listing-a-table\">Listing a table<\/a><li><a href=\"#deleting-rows-in-a-table\">Deleting rows in a table<\/a><li><a href=\"#exporting-table-data\">Exporting table data<\/a><li><a href=\"#importing-table-data\">Importing table data<\/a><li><a href=\"#writing-queries\">Writing queries<\/a><\/ul><\/div><\/div><button class=\"eb-toc-button  eb-toc-button-left\"><div>Table of Contents<\/div><\/button><\/div><\/div><\/div>\n\n\n<h2 class=\"wp-block-heading\">Summary<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This page explains how, as a site leader, you will be able to manage all the tables in the database by:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Making changes to them by inserting new rows and updating and deleting existing rows<\/li>\n\n\n\n<li>Importing files of data into tables and exporting files of data from tables<\/li>\n\n\n\n<li>Importing, Inserting and editing queries recorded in the query table<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">This page assumes that you have read the pages:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em>Getting started with Anchurus II<\/em><\/li>\n\n\n\n<li><em>Using the Anchurus II web application: the basics a site viewer\u2019s view<\/em><\/li>\n\n\n\n<li><em>Using the Anchurus II web application: site editors\u2019 view<\/em><\/li>\n\n\n\n<li><em>The Anchurus II release 2 database<\/em><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Getting started and the control screen<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To get started, you login and then select a site. For details of how to do this see the manual page: <em>Using the Anchurus II web application: the basics: a site viewer\u2019s view.<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once you have done this you are presented with the control screen ( Figure 10.1). In the control screen header (the green box), you are presented with:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A \u201cSelect site\u201d dropdown which will give you a list of sites you can access<\/li>\n\n\n\n<li>Site summary: with a list of tables each with their number of rows<\/li>\n\n\n\n<li>Your email address<\/li>\n\n\n\n<li>Your status as a user in this case <em>Site Leader<\/em><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">On the next line, there are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Help dropdown that takes you to the Anchurus web site<\/li>\n\n\n\n<li>List dropdown: listing the names of tables that you can list<\/li>\n\n\n\n<li>An Insert dropdown: listing the of names of those table where you can insert rows<\/li>\n\n\n\n<li><strong>An import drop down: <\/strong>which lets you import data into the data tables<\/li>\n\n\n\n<li><strong>A query drop down: <\/strong>which lets you list, insert and import queries<\/li>\n\n\n\n<li><strong>An admin drop down<\/strong> \u2013 which gives you access to control the user access to your site (for more details see <em>The Administration Manual. <\/em>To get a copy contact the Anchurus web site contact form)<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The bullets in bold highlight the new features you can access as a site leader.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"771\" height=\"507\" src=\"https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-22.png\" alt=\"\" class=\"wp-image-759\" srcset=\"https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-22.png 771w, https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-22-300x197.png 300w, https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-22-768x505.png 768w\" sizes=\"auto, (max-width: 771px) 100vw, 771px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Figure10.1. The Anchurus II site leader\u2019s control screen<br>you see after you have logged in and selected a site<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Listing a table<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When you select a table from the List dropdown, you create a new work area, with a work area header and a list of up to the first 10 rows of the table. Once you have selected a row, what you see is shown in figure 10.2 which highlights the new controls you have access to as a site leader. The following sections describe these controls in more detail.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"771\" height=\"574\" src=\"https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-14.png\" alt=\"\" class=\"wp-image-744\" srcset=\"https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-14.png 771w, https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-14-300x223.png 300w, https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-14-768x572.png 768w\" sizes=\"auto, (max-width: 771px) 100vw, 771px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Figure 10.2. A table list seen by a site editor from the find table showing your additional controls as site leader<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Deleting rows in a table<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Once you have selected one or more rows in a table and you click on delete, you are presented with a popup which asks you to confirm that you wish to delete the row or rows (figure 10.3). When you click on OK, the system makes referential integrity checks (s<em>ee<\/em> The Anchurus II release 2 database) and if the checks are satisfied, the rows are deleted.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"771\" height=\"461\" src=\"https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-21.png\" alt=\"\" class=\"wp-image-758\" srcset=\"https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-21.png 771w, https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-21-300x179.png 300w, https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-21-768x459.png 768w\" sizes=\"auto, (max-width: 771px) 100vw, 771px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Figure 10.3 The delete row popup<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Exporting table data<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Once you have listed a table, you can click the export icon where upon a file of data will be downloaded to your downloads folder as a CSV (comma separated variables) file.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This works for the contents of the workspace, so if you are displaying a complete table, a table with filtered columns or the results of a query, export always works.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Importing table data<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Clicking on the Import icon takes you to a new work area (figure 10.4) which leads you through the following dialogue.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"752\" height=\"457\" src=\"https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-16.png\" alt=\"\" class=\"wp-image-748\" srcset=\"https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-16.png 752w, https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-16-300x182.png 300w\" sizes=\"auto, (max-width: 752px) 100vw, 752px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Figure 10.4 The import data work area<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Firstly, you are offered the option of downloading an empty CSV (common separated variables) file to record the data you want to import. This file is downloaded into your downloads folder. You can open it with your spreadsheet application where upon you will be presented with a spreadsheet with the top row with the column headings for the table to which you wish to import data (Figure 10.5).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"771\" height=\"91\" src=\"https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-17.png\" alt=\"\" class=\"wp-image-749\" srcset=\"https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-17.png 771w, https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-17-300x35.png 300w, https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-17-768x91.png 768w\" sizes=\"auto, (max-width: 771px) 100vw, 771px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Figure 10.5. The import find table input spreadsheet<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Fill the spreadsheet with the data you want to import. Please note, that you should not change the column headings in row 1 of the spreadsheet; if you do, the Anchurus Web application will not be able to import it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once you have a complete spreadsheet save it in your filestore either in the site shared drive or in your local computer filestore. Make sure you save it as a .csv format file.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Return to the work area page, and click upload where upon you will be presented with a view of your filestore (Figure 10.6) and select your file.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"771\" height=\"428\" src=\"https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-18.png\" alt=\"\" class=\"wp-image-751\" srcset=\"https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-18.png 771w, https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-18-300x167.png 300w, https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-18-768x426.png 768w\" sizes=\"auto, (max-width: 771px) 100vw, 771px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Figure 10.6. Identifying your file in a filestore<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The system will upload the data and record the results in the Import processing log (Figure 10.7) This shows for each row of your import spreadsheet (numbered 2 onwards) that it was either loaded successfully or was in error together with details of how you should correct it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once all the data has been processed, you are given the option of either abandoning the whole import operation or loading the valid rows. Your choice depends on the level of errors and the difficulty of finding and isolating the rows with errors, correcting them and then reimporting them. In most cases it is best to abandon the import and use the import processing log to correct your data and try again.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"579\" height=\"473\" src=\"https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-19.png\" alt=\"\" class=\"wp-image-753\" srcset=\"https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-19.png 579w, https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-19-300x245.png 300w\" sizes=\"auto, (max-width: 579px) 100vw, 579px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Figure 10.7: The Import processing log when importing 29 rows into the find table<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Writing queries<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The query table contains a list of all the reusable queries available for your site. You use this table in the same way as all the other tables. You can list the table, view, update and delete table rows and import and export tables rows (see figure 10.8).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"771\" height=\"428\" src=\"https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-20.png\" alt=\"\" class=\"wp-image-755\" srcset=\"https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-20.png 771w, https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-20-300x167.png 300w, https:\/\/anchurus.co.uk\/wp-content\/uploads\/2026\/08\/image-20-768x426.png 768w\" sizes=\"auto, (max-width: 771px) 100vw, 771px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Figure 10.8. A query table list<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Your main challenge as a site leader is to write queries using SQL (the Structured Query Language). These are SQL select statements. They have the following parts:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>SELECT keyword followed by<\/li>\n\n\n\n<li>A list of table column names from one or more tables separated by a new line<\/li>\n\n\n\n<li>FROM key word followed by either a single table name or a series of Join statements linking the different tables list in 2 above<\/li>\n\n\n\n<li>If you want a selection of the rows from a table; use a WHERE key word followed by selection statements<\/li>\n\n\n\n<li>If you want to control the order which the rows are presented in your output, use an<br>ORDER BY key word followed by ordering clauses<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Typical examples of such Selelct statements are:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example 1 \u2013 a simple query<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This will select the named columns from rows in the context table for the Site \u201cBC\u201d { Blounts Court}, excavation area \u201cTrench01\u201d.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SELECT<br>context. SiteId,<br>context.Contextid,<br>context.Name1,<br>context.AreaId<br>FROM context<br>WHERE (context SiteId LIKE \u201cBC\u201d) AND (context.AreaId LIKE \u201cTrench01\u201d)<br>ORDER BY context.ContextId ASC;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Note: the use of newlines and spaces to make the SQL Select statement easier to read.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example 2 \u2013 a complicated multi-table SQL statement<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This query compares the dates assigned to a context with the production dates of the finds as recorded in the findgrouup table.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It does this by recording production details from the findgroup table, the find table and the context table.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SELECT<br>findgroup.SiteId,<br>findgroup.FindGroupId,<br>findgroup.Material,<br>findgroup.FindGroupName,<br>&#8212; comment note the use of AS keyword to rename columns<br>findgroup.Count,<br>findgroup.YearStart AS FindGroup_YearStart,<br>findgroup.YearEnd AS FindGroup_YearEnd,<br>find.FindId,<br>find.FindName1,<br>find.YearStart AS Find_YearStart,<br>find.YearEnd AS Find_YearEnd,<br>context.ContextId,<br>context.YearStart AS Context_YearStart,<br>context.YearEnd AS Context_YearEnd<br>FROM ((findgroup<br>INNER JOIN find ON findgroup.FindGroupId = find.FindGroupId)<br>INNER JOIN context ON find.ContextId = context.Contextid)<br>ORDER BY context.ContextId ASC;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Learning SQL<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The simplest way of learning SQL is to click on <a href=\"https:\/\/www.w3schools.com\/SQL\/\">https:\/\/www.w3schools.com\/SQL\/<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There are any sites that will validate your SQL statements. Try: <a href=\"https:\/\/runsql.com\/sql-validator\/\">Online SQL Validator &amp; SQL Syntax Checker | Free SQL Query Validator<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can use comments in an SQL statement to clarify your query or to comment out lines while you are testing it (see <a href=\"https:\/\/www.w3schools.com\/sql\/sql_comments.asp\">SQL Comments<\/a>).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Andrew Hutt and Tony Bakker<br>Version v02<br>19\/8\/2026<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Summary This page explains how, as a site leader, you will be able to manage all the tables in the database by: This page assumes that you have read the pages: Getting started and the control screen To get started, you login and then select a site. For details of how to do this see [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_eb_attr":"","footnotes":""},"class_list":["post-739","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/anchurus.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/739","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anchurus.co.uk\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/anchurus.co.uk\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/anchurus.co.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anchurus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=739"}],"version-history":[{"count":15,"href":"https:\/\/anchurus.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/739\/revisions"}],"predecessor-version":[{"id":764,"href":"https:\/\/anchurus.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/739\/revisions\/764"}],"wp:attachment":[{"href":"https:\/\/anchurus.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=739"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}