User:Alex Doll: Difference between revisions

From SAGMILLING.COM
Jump to navigation Jump to search
← Older edit
Content deleted Content added
 
(24 intermediate revisions by the same user not shown)
Line 3: Line 3:


===Setting up a new project===
===Setting up a new project===
# Click the Administration button
# Create a new database & dbuser.
# Create a new folder in circuitmodels/.
# Create a new Client
## Assign the new administrator
# Copy the base PHP files into the new folder.
⚫
## The database structure, including default data, will populate.
# Tweak the configuration file to point to the new database.
## Check that indexing of table index fields is active
⚫
# fill in the database structure, including default data.
# Switch to the new Client and check that the database is populated correctly
<div style='background-color: #F9F9F9; border: dashed thin blue; padding:0.5em;'>
# Email the new administrator with credentials and URL.
<syntaxhighlight lang="mysql">

CREATE TABLE `labs` SELECT * FROM `sagmilli_agd`.`labs`;
===Test suite before deploying new code===
CREATE TABLE `mills_classes` SELECT * FROM `sagmilli_agd`.`mills_classes`;
On the development server
CREATE TABLE `project` SELECT * FROM `sagmilli_agd`.`project` WHERE `id`=1;
# create a new project
CREATE TABLE `ai` SELECT * FROM `sagmilli_agd`.`ai` WHERE `ProjNum`=1;
## add a member to this new project
CREATE TABLE `dwt` SELECT * FROM `sagmilli_agd`.`dwt` WHERE `ProjNum`=1;
# create a new test result
CREATE TABLE `geotech` SELECT * FROM `sagmilli_agd`.`geotech` WHERE `ProjNum`=1;
## Add the 3 work index values
CREATE TABLE `litho` SELECT * FROM `sagmilli_agd`.`litho` WHERE `ProjNum`=1;
## check these appear in the Testwork Summary listing
CREATE TABLE `pli` SELECT * FROM `sagmilli_agd`.`pli` WHERE `ProjNum`=1;
## check these appear in the testwork comparison charts
CREATE TABLE `project__circuits` SELECT * FROM `sagmilli_agd`.`project__circuits` WHERE `ProjNum`=1;
# delete a test result. delete a whole sample.
CREATE TABLE `spi` SELECT * FROM `sagmilli_agd`.`spi` WHERE `ProjNum`=1;
# create a new optimized Bond SABC circuit
CREATE TABLE `ucs` SELECT * FROM `sagmilli_agd`.`ucs` WHERE `ProjNum`=1;
## create new mill for the new circuit from templates or from blanks
CREATE TABLE `wibm` SELECT * FROM `sagmilli_agd`.`wibm` WHERE `ProjNum`=1;
## check tent diagram
CREATE TABLE `wirm` SELECT * FROM `sagmilli_agd`.`wirm` WHERE `ProjNum`=1;
## change to raw Bond circuit
CREATE TABLE `wic` SELECT * FROM `sagmilli_agd`.`wic` WHERE `ProjNum`=1;
# create a new SSBM circuit
CREATE TABLE `mills` SELECT * FROM `sagmilli_agd`.`mills` WHERE `ProjNum`=0 OR `ProjNum`=1;
## create new mill for the new circuit from templates or from blanks
</syntaxhighlight>
# create a new SSSAG circuit
</div>
## create new mill for the new circuit from templates or from blanks
# create a new template mill for a SAG mill, a pebble crusher and a ball mill.


Compare the '''Example''' project on development server versus main server
# View model output table of a circuit
## Pull up some summary charts
## Check some SAG-limited samples
## Check some ball-limited samples
## Run the PDF report, confirm percentile samples against the HTML list.
# Check the result table totals are the same
# Edit a SAG mill; change the model on a SAG mill
## check a tent diagram
## change speed or filling on tent diagram
# Edit a ball mill; change the model on a ball mill
## check a tent diagram
## change speed or filling on tent diagram
# Manually override the test results and the F80, P80 sizes (use the data entry fields on the flowsheet page)
# Edit a crusher

Latest revision as of 13:19, 17 May 2026

Alex's to-do lists

Stuff that Alex needs to not forget.

Setting up a new project

  1. Click the Administration button
  2. Create a new Client
    1. Assign the new administrator
    2. The database structure, including default data, will populate.
    3. Check that indexing of table index fields is active
  3. Switch to the new Client and check that the database is populated correctly
  4. Email the new administrator with credentials and URL.

Test suite before deploying new code

On the development server

  1. create a new project
    1. add a member to this new project
  2. create a new test result
    1. Add the 3 work index values
    2. check these appear in the Testwork Summary listing
    3. check these appear in the testwork comparison charts
  3. delete a test result. delete a whole sample.
  4. create a new optimized Bond SABC circuit
    1. create new mill for the new circuit from templates or from blanks
    2. check tent diagram
    3. change to raw Bond circuit
  5. create a new SSBM circuit
    1. create new mill for the new circuit from templates or from blanks
  6. create a new SSSAG circuit
    1. create new mill for the new circuit from templates or from blanks
  7. create a new template mill for a SAG mill, a pebble crusher and a ball mill.


Compare the Example project on development server versus main server

  1. View model output table of a circuit
    1. Pull up some summary charts
    2. Check some SAG-limited samples
    3. Check some ball-limited samples
    4. Run the PDF report, confirm percentile samples against the HTML list.
  2. Check the result table totals are the same
  3. Edit a SAG mill; change the model on a SAG mill
    1. check a tent diagram
    2. change speed or filling on tent diagram
  4. Edit a ball mill; change the model on a ball mill
    1. check a tent diagram
    2. change speed or filling on tent diagram
  5. Manually override the test results and the F80, P80 sizes (use the data entry fields on the flowsheet page)
  6. Edit a crusher
Retrieved from "https://wiki.sagmilling.com/index.php?title=User:Alex_Doll&oldid=1540"