Dave Carmean, Computing, SFU Biological Sciences

Dave Carmean, Computer Systems Consultant

Ph.D., University of California, Davis

Phone:   778-782-2030   Room B8230

email:     carmean@sfu.ca  

  Submit a Support request  

Want to know what software and other computer resources are available to you? Check out the Faculty of Science IT Support and Biology's Computing Facilities and Help.

I concentrate on using databases and the web to automate workflow and information sharing. I want to identify inefficient workflows and help make them easier for all involved.

I welcome questions and suggestions, and am here to help you. Feel free to email or call (2-2030) me anytime. For the fastest computer support, submit a trouble ticket with a concise explanation of the support needed or the problem and what actions you have taken.

Like you I am interested in ways of improving the lives of people around the world. One way people at SFU are involved is micro-lending- you can join the SFU Kiva team.

Our paper "Online access to the Kalgutkar and Jansonius database of fossil fungi" is in the journal Palynology. You may access the database at Kalgutkar Fossil Fungi. Access the Ben Woo Russula database.

Current and Ongoing Projects:

Online Publications Database. This provides an updated lists of publications for members of the department. The public can view complete lists of publications (Switch tdwillia in the URL to any other Biology Faculty computing ID) as well as Selected Publications of any faculty member. Individual faculty and researchers can add and edit their publications as well as authorize other individuals to update their publication lists. The current version uses Filemaker as the database and Apache/PHP for the web interface, while we have working version using a MySQL database based on Bibliograph.

Teaching Assistantships System. Online Applications, Offers, Acceptance, TUG forms, Workload Review, and Evaluations.  Uses PHP, Filemaker and SFU's Central Authentication Service (CAS). 

Booking of Rooms, Equipment, and Undergraduate Advisors.  I modified the open source MRBS for our needs.  It uses PHP, mySQL as well as CAS authentication.  Students' booking are confidential and they are reminded of their appointments by email through a nightly cron task.  

Updating Filemaker.  All online and departmental databases are now in Filemaker 16/17, and use PHP/ Apache to serve web forms and data. The webserver is a Redhat VM and the database server is a Windows VM. Previously everything was served by a Mac mini (regular hardware/ OS, not the server version), Filemaker server version 11, and we first transitioned just the Apache web server from the mac mini to the Redhat VM, then later on upgraded the databases to Filemaker version 16 with no problems.

CodeWeaversComputer Support:
My philosophy is to provide people the help they want to prevent and solve problems in a way that meets their needs. I am not an advocate for the most recent (and most expensive) technology.

Much of my work integrates the web and databases. This minimizes duplication of data entry as it allows the information appear in different forms in different contexts.

Web Sites:
My goal is to provide relevant information quickly to users. I believe that web pages should be fast and simple to navigate for all users, regardless of their browser or connection. I have set up our system so faculty and staff can update their own pages (if they wish) rather than relying on others. The new SFU AEM webserver does not allow this, but we maintain several self-serve options.



Systems Consultant, Simon Fraser University, 1996-Present.
Computing Advisor for the Biological Sciences Department and the Dean of Science. Responsible for database development, networking, and web design.

Courtesy Faculty, Oregon State University, Corvallis. 2011-12. (Disclaimer: Totally courtesy of OSU- I continued to concentrate on my work for SFU)

Visiting Scientist? /Associated Person, Duke University, Durham, North Carolina. 2003-4.

Visiting Scientist, Umeå University, Sweden. 1997-1998.

Post-Doctoral Fellow, Simon Fraser University, 1994-1995.
Sequencing DNA and phylogenetic analysis
Training personnel in PCR and sequencing techniques
Manager of Molecular Laboratory for Dr. Bernard J. Crespi

Research Assistant, University of California, Davis, 1989-1993.
Sequencing DNA of Holometabola for phylogenetic analysis (UC Berkeley)
Systematic study of the Trigonalidae (Hymenoptera)
Responsible for computer accessibility and databases of Bohart Museum

Teaching Assistant, University of California, Davis. Insect taxonomy/field ecology (1992), Biogeography (1991, 1992), Parasitology (1989).

Research Assistant, Oregon State University, 1985-1988.
Studied yellowjackets and their associates. Created and organized computer databases of Trigonalidae and Symphyta literature, and Lepidoptera host plants.

Research Assistant, Washington State University Cooperative Extension, Seattle.
Part time, Oct. 1984-May 1985. Root weevils, with Sharon Collman.

Entomologist, Basseterre, St. Kitts (West Indies) Integrated Pest Control Unit, 1982-1984. Biological Control, with Everton Dolphin, Trevor Blanchette, and Conrad Kelly.

Science and Agriculture Teacher, Bumbuna, Sierra Leone, West Africa, 1980-1982.
(Peace Corps Volunteer, 1980-1984.)

Research Assistant, Washington State University, Pullman, 1978-1980. Laboratory and field research of yellowjacket behavior and life history.

1993. Ph. D. Entomology, University of California, Davis.
A generic revision of the trigonalid wasps (Hymenoptera) and a molecular
study of 18S rDNA and the holometabolous insects.

1989. M.S. Entomology, Oregon State University. Corvallis, Oregon.
Biology of the yellowjacket parasitoid Bareogonalos canadensis (Harrington)
(Hymenoptera: Trigonalidae).

1980. B.S. Entomology and B.S. Biology. Washington State University, Pullman, Washington.

1975. Argenta Friends School, Argenta, British Columbia.
(All 8 of our graduating class were in the top 10!)

18S rDNA workshop. Umeå University, Sweden (1997).
Molecular Evolution Workshop, Marine Biological Laboratory, Woods Hole, Massachusetts (1992).
Parasitic Hymenoptera Training Session, Maryland Center for Systematic Entomology, College Park, Maryland (1988).

PAUP*: computer program for phylogenetic analyses. 18S rDNA workshop, Umeå University, Sweden (May, 1997).

Phylogeny versus Homoplasy in the Trigonalidae. International Society of Hymenopterists. Davis, California. 1995.

How to get into a yellowjacket nest. British Columbia Parasitologists' Meeting. Burnaby, British Columbia. 1994.

18S rDNA and phylogeny of Holometabola: why Diptera are not (representative) insects. Society for the Study of Evolution Annual Meeting. Athens, Georgia. 1994.

Yellowjackets. University of California/ Pest Control Operator's of California Education Conference. Walnut Creek, California. 1990.

Wasps, Yellowjackets, Hornets, and Bees. Oregon State University Extension Service, Medford, Oregon. February, 1988.

The yellowjacket parasitoid Bareogonalos canadensis in Oregon. Entomological Society of America Western Regional Meeting, Portland. 1987.


Click here for publications in our database

1991 Alfa Romeo 164 manual (air conditioning, sound system, radio, clock, index)