User:WorkExp2017

Monday

Wiki Reference Card: Wiki PDF

My assigned project for Monday was to name and categorize image files of embryo's onto an excel spreadsheet while listing any duplication of the files and images. These images include highly detailed photographs of the original embryo slides. The slides where taken from a donated embryo which was then preserved and sectioned a few microns each, which was then placed on slides. The digitized version of these slides are numerous and are quite sought after and posses a substantial amount of scientific value.

1. In order to copy image file names onto an Excel spread sheet you must first open the command prompt then edit the selected drive to match the current drive the hard drive is located.
2. This done by adding; d: to C:/Users/Unsw.Unsw-23098 then pressing the enter key. This will for example change the drive location to drive d.
3. Then proceed to type dir which will give you the directory view.
4. You then must find the folder that contains the file names you wish to copy then type cd (change directory) then the file name.
5. Press the enter key and then type once again dir which will bring up the list of all the file names in the selected folder.
6. Type dir then space > then create a name for the new filenew file.txtwhich will transfer all the names into a text file.
7. Finally open up the folder location and open the text file then select delimited, tab, space options then enter. after auto fitting the excel spreadsheet should have the entire list of names. For small amounts of folders just right click, rename then copy and paste.

This link depicts each step taken. [1]

The majority of hard drives where categorized on an excel spreadsheet and i began to identify duplicate folders on a separate spreadsheet. Folders from the hard drives containing the images have had some files and even hard drives completely duplicated and it is imperative they are located.

Tuesday

On Tuesday i had identified all the duplicates and had listed them on the Excel spreadsheet. I then was tasked with uploading the images to the OMERO database. Dr Mark Hill (my employer and supervisor) taught me how to up load these slides as well as how to identify compressed files and non compressed files to upload. After realizing the extent of non uploaded slide i began immediately. After being given temporarily administrative privileges i began to upload the files and fill the many blanks that where missing in the database. I was also warned that there are some slides that refuse to upload and i was instructed to list those that where failed or avoided on the Spreadsheet. This procees due to the sheer size and amount of the images will take up a large portion of my work experience time and it is vital that the task is complete before Dr Hill travels to Berlin to discuss the issues and overall concepts of the extensive collection.

DEC Uploaded

• Blechschmidt
  • 1950 04 20 Slide 2 - 32