search

CIAT-DAPA / subsets_genebank_accessions

Web tool which allows creating subsets of accessions based on indicators
0 stars 1 forks source link

Problems with passport data script #48

Closed stevensotelo closed 3 years ago

stevensotelo commented 3 years ago

Hi everyone. This issue were created because when I run the script to get the accessions data from a crop in some cases the script generates a issue (in the image attached). The cases generates the issue are those cases I put like input the crops are in the crop table in the issue #40 in the column "Stored in the database" with value "Processing"

image

Thanks so much

Regards.

khadijaAouzal commented 3 years ago

@juangarc I got the error just for Coconut and Coffee. The reason is that all their coordinates have NA values and therefore the geo columns (latitude and longitude) are not retrieved.

For the other crops, I extracted the passport data without any error. Could you show me the error you get when trying to extract their accessions?

juangarc commented 3 years ago

@juangarc I got the error just for Coconut and Coffee. The reason is that all their coordinates have NA values and therefore the geo columns (latitude and longitude) are not retrieved.

For the other crops, I extracted the passport data without any error. Could you show me the error you get when trying to extract their accessions?

@khadijaAouzal This is the issue with any crop has a "Processing" status in our table:

Faba bean

image

khadijaAouzal commented 3 years ago

@juangarc here the problem is due to the crop name. There shouldn't be a space.

To get accessions, you should use the short names of the crops:

name short name
African yam bean africanyambean
Amaranth amaranth
Andean root and tuber crops artc
Apple apple
Bambara groundnut bambara
Banana banana
Barley barley
Barnyard millet barnyardmillet
Beans beans
Breadfruit breadfruit
Carrot carrot
Cassava cassava
Chickpea chickpea
Coconut coconut
Coffee coffee
Cowage cowage
Cowpea cowpea
Eggplant eggplant
Faba bean fababean
Finger millet fingermillet
Forages forages
Foxtail millet foxtailmillet
Grasspea grasspea
Groundnut groundnuts
Kodo millet kodomillet
Lentil lentil
Lettuce lettuce
Little millet littlemillet
Maize maize
Oat oat
Pea pea
Pearl millet pearlmillet
Pigeonpea pigeonpea
Potato potato
Proso millet prosomillet
Rice rice
Rye rye
Sapota sapota
Sesame sesame
Sorghum sorghum
Soybean soybeans
Squashes squashes
Sunflower sunflower
Sweetpotato sweetpotato
Taro taro
Tea tea
Tomato tomato
Wheat wheat
Yam yam
juangarc commented 3 years ago

Thanks @khadijaAouzal I could fix the issue.