Uploading mechanism and Lesson(s) learnt
Download
1 / 11

here - PowerPoint PPT Presentation


  • 339 Views
  • Updated 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 'here' - 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 l.jpg

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 l.jpg

Uploading mechanism and Lesson(s) learnt

CZE

EST

FRA

LTU

NGB

LVA

WP-B2 Creation database (IPGRI)

NLD


Slide3 l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

Uploading mechanism and Lesson(s) learnt

WP-B2 Creation database (IPGRI)


Slide7 l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

  • 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)


ad