Talk:MySQL as central database
From ICISWiki
Contents |
SETUP
The following are results of ICIS application tests using MySQL as Central database and MS Access as local databases.
DIAGNOSTIC
version: v5.5.1.2
Test1: Settings: ticked Fix - Automatic Modification
Result... ?
GMS SEARCH
version: 5.5.1.0
Test1: Searched for name "APO"
Test2: Result: Found Apo, OK
SETGEN
version: 5.5.1.3 (Sept. 2008)
Test1: Created Folder, OK
Test2: Created List and moved to Folder, OK
Test3: Used "+" button, entered item "AAA", clicked "OK" in Name Information for New Entry window, clicked "OK" to Add a GMS Germplasm Record window, OK
Test4: Select "MYSQL_TEST1" list - "X". Select "MYSQL_TEST", Tag "AAA" as "Female" and "BBB" as "Male". OK
Test5: Create "MYSQL_TEST2" list. Open "MYSQL_TEST1" in "Browse window".
Test6: Tag "AAA/BBB" and select "-", "Advance a Line One Generation for UNKNOWN" window displays.
Test7: Type "AB" in the "Prefix" box and type "3" in the "Plants Selected" box of the "Naming Convention...", "OK to All", OK
Test8: Testing "B-"...OK
Create "MYSQL_TEST3" list. Click "B-".
from "Generate Derivative in Batch Mode for UNKNOWN" window,
select "U08DSF1" in the "Source Study",
select "Unknown Derivative Method" and "Alternative Cultivar Name" from the "Constant Selection Parameter".
select "Designation" from the "Designation" box of the "Naming Convention Designation" section
set "Start No" to "1" of the "Naming Convention of Designation"
type "AB" in the "Prefix" box of the "Naming Convention of Entry Code"
select "STUDY" in the "Prefix" of the "Naming Convention of Source"
click "Start"
Result: Failed.
WORKBOOK
Test1: Select Study - Retrieve - Dataset "UDS03F4", OK
Test2: Select Study Settings - Create testmysql filename and folder, OK
Test3: Select Study - Retrieve - Variate, clicked OK.. Failed.
Test4: Select Add-ins - Import Setgen List(select Cancel). Select "Checks" from Retrieve List Window, OK
Test5: Select Study "U08DSF1", Load, OK
INTRACK
Test1: Select "Checks", tag all, Retrieve All Lots, OK
Test2: Tag all items in Inventory Details - Reserve (10 g in Al foil). OK
Test3: Tag all items in Inventory Details - Deposit (10 g in Al foil). OK
Test4: LogOn as Administrator - Select "Checks" (tag all) then Retrieve Inventory, OK
