slide1 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Uploading mechanism and Lesson(s) learnt PowerPoint Presentation
Download Presentation
Uploading mechanism and Lesson(s) learnt

Loading in 2 Seconds...

play fullscreen
1 / 11

Uploading mechanism and Lesson(s) learnt - PowerPoint PPT Presentation


  • 347 Views
  • Uploaded on

Uploading mechanism and Lesson(s) learnt Basic errors: Forgot NICODE !!! (rare=INSTCODE, GENUS, ACCENUMB) Wrong descriptor names (ORICTY instead of ORIGCTY) Wrong code for descriptors (1-2-3-4-5 for SAMPSTAT) More or less columns than declared !!! (Excel !?)

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Uploading mechanism and Lesson(s) learnt' - bernad


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

Uploading mechanism and Lesson(s) learnt

Basic errors:

  • Forgot NICODE !!! (rare=INSTCODE, GENUS, ACCENUMB)
  • Wrong descriptor names (ORICTY instead of ORIGCTY)
  • Wrong code for descriptors (1-2-3-4-5 for SAMPSTAT)
  • More or less columns than declared !!! (Excel !?)
  • Wrong tags: tab, line feed and carriage return codes !!!

WP-B2 Creation database (IPGRI)

slide2

Uploading mechanism and Lesson(s) learnt

CZE

EST

FRA

LTU

NGB

LVA

WP-B2 Creation database (IPGRI)

NLD

slide3

Uploading mechanism and Lesson(s) learnt

  • INSTCODE (COLLCODE, BREDCODE, DONORCODE, DUPLSITE)=> validation against FAO codes ? => FATAL ERROR
  • ACCENUMB => has to be unique within NICODE/INSTCODE=> FATAL ERROR
  • GENUS/SPECIES/SPAUTHOR/SUBTAXA/SUBTAUTHOR=> static add to cod_tax table
  • ACQDATE/COLLDATE=> valid dates required=> FATAL ERROR

WP-B2 Creation database (IPGRI)

slide4

Uploading mechanism and Lesson(s) learnt

  • ORIGCTY/SAMPSTAT/COLLSRC/STORAGE=> validation against MCPD ? => FATAL ERROR
  • LATITUDE/LONGITUDE=> has to be valid values based on MCPD=> what about GIS checking ?=> FATAL ERROR
  • Others…

WP-B2 Creation database (IPGRI)

slide5

Uploading mechanism and Lesson(s) learnt

Missing Data

  • ORIGCTY = 40%
  • SAMPSTAT = 18 %
  • COLLSRC = 74 %
  • LAT/LON = 93 %
  • ACQDATE = 60 %
  • COLLDATE = 91 %

WP-B2 Creation database (IPGRI)

slide6

Uploading mechanism and Lesson(s) learnt

WP-B2 Creation database (IPGRI)

slide7

Uploading mechanism and Lesson(s) learnt

Primary Issues:

  • What about the level of restrictions in the uploadingmechanism as set now ?
  • Should we recommend “priority fields” ?
  • What can we do to improve the data quality and accuracy in EURISCO ?
  • What are the short and medium term“priority research targets” ?
  • When can we expect 25%, 50%, 75% of the totalexpected datasets ?
  • How central crop databases will fit in the system ?
  • How can we link to other systems ?

WP-B2 Creation database (IPGRI)

slide8

Uploading mechanism and Lesson(s) learnt

Secondary Issues:

  • What about the other import mechanisms suchas ODBC, XML ?
  • Should we also consider capacity building effortsto EURISCO partners (I.e. training, tools, etc…) ?
  • How far can we expect partners to commit to datauploading as well as data quality activities ?

WP-B2 Creation database (IPGRI)

slide9

Other issues…

Strategic choices beyond EURISCO:

  • SINGER database in MCPD v2 format
  • SINGER crop networks in MCPD v2 formatWheat / Barley / Sweet Potato… + others
  • AVRDC (Taiwan) in MCPD v2 format ….

WP-B2 Creation database (IPGRI)

Regional/Int’l Networks

Wheat

Barley

EURISCO

SINGER

Crop Networks

Vegetables

slide10

Other issues…

Tools and CD-ROM Web enabling

  • Old Tool Kit development stopped.
  • New Tool Kit (PHP based) in developmentwith GIS, Statistical and Graphical interfaceReady by end September (?)
  • EURISCO will be deployed with the new Tool Kitand call for shared development in PHP will bemade.
  • CD-ROM pilot version visible for end 2002…

WP-B2 Creation database (IPGRI)

slide11

Finalize the EURISCO MCPD

  • Endorse the EURISCO data import format
  • Endorse the EURISCO data structure
  • Endorse the EURISCO data import rules

URGENT

  • End June: Import modules finishedDatabase structure finishedTest on 10 NI (at least) ~ 200,000 accessions
  • Mid July:Final Web site v0.9 on new Tool Kit

PLANNING

Conclusions

WP-B2 Creation database (IPGRI)