System Administration

Updating large lists eg for AVETMISS or Postcodes

Friday, Feb 8, 2019 by Scott Spence System Administration

Note that this is performed by CourseSales.com administration staff NOT by clients Also created a way to load new records from the browser for lists that are maintained in the database: Log in using the super user Go to /referencelist/upload Choose the type from the list - only certain lists with large numbers of records are maintained in the database File must be CSV with two columns - KEY, VALUE - and no heading Batch size can be 100 - 200, but don’t choose a larger batch size Choose how many batches - ie a batch size of 100 and a number of batches of 2 means 200 records will be processed (this is all to manage large file sizes) Start offset - eg start from batch 3 Process changes is whether to download a CSV of what new records would be imported, or to process the new records directly into the database.

Testing using Selenium IDE, tips and hints

Saturday, Apr 18, 2015 by Scott Spence System Administration, Testing

The following are things that we have found useful when creating Selenium IDE scripts in testing CourseSales.com or automating data transfer/interactions with other third party web-based software applications. If you wish to do some online tutorials for Selenium visit www.guru99.com/selenium-tutorial.html, the tutorials are created by an IBM veteran. The course covers: Selenium Introduction Selenium IDE Tutorial Selenium WebDriver Tutorial Xpath - Advanced Locators Accessing Web Elements TestNG and Maven Advanced Concepts on Selenium WebDriver Selenium Grid Interview Questions & Answers LIVE PROJECTS for Real Time Exercises Useful Selenium IDE commands Increment variable ‘Count’ when using ‘goto’ commands and loops to keep track of numbers of iterations.