User:Alex Doll: Difference between revisions

From SAGMILLING.COM
Jump to navigation Jump to search
Content deleted Content added
Created page with "==Alex's to-do lists== Stuff that Alex needs to no forget. ===Setting up a new project=== # Create a new database & dbuser. # Create a new folder in circuitmodels/. # Copy th..."
 
 
(27 intermediate revisions by the same user not shown)
Line 1: Line 1:
==Alex's to-do lists==
==Alex's to-do lists==
Stuff that Alex needs to no forget.
Stuff that Alex needs to not forget.


===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
<pre>
# Email the new administrator with credentials and URL.
PREPARE populate FROM 'CREATE TABLE `sagmilli_?`.`?` SELECT * FROM `sagmilli_agd`.`?` ?;'
SET @db = 'Example';
SET @where='';
SET @table= 'labs';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'mills_classes';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'project';
SET @where=' WHERE `id`=1';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'ai';
SET @where=' WHERE `ProjNum`=1';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'dwt';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'geotech';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'litho';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'pli';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'project__circuits';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'spi';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'ucs';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'wibm';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'wirm';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'wic';
EXECUTE populate USING @db, @table, @table, @where;
SET @table= 'mills';
SET @where= 'WHERE `ProjNum`=0 OR `ProjNum`=1';
EXECUTE populate USING @db, @table, @table, @where;


===Test suite before deploying new code===
DEALLOCATE PREPARE populate;
On the development server
</pre>
# create a new project
## add a member to this new project
# create a new test result
## Add the 3 work index values
## check these appear in the Testwork Summary listing
## check these appear in the testwork comparison charts
# delete a test result. delete a whole sample.
# create a new optimized Bond SABC circuit
## create new mill for the new circuit from templates or from blanks
## check tent diagram
## change to raw Bond circuit
# create a new SSBM circuit
## create new mill for the new circuit from templates or from blanks
# create a new SSSAG circuit
## 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"