Passport indicators process

[stevensotelo]

• [x] Processing passport data (@juangarc )

Crop	Available in Genesys	Stored in database	Amount of accessions Genesys	Amount of accessions IndicatorDB
African yam bean	:heavy_check_mark:	:heavy_check_mark:	315	315
Amaranth	:heavy_check_mark:	:heavy_check_mark:	1301	1301
Andean root and tuber crops	:heavy_check_mark:	:heavy_check_mark:	2526	2526
Apple	:heavy_check_mark:	:heavy_check_mark:	21337	21337
Bambara groundnut	:heavy_check_mark:	:heavy_check_mark:	2186	2186
Banana	:heavy_check_mark:	:heavy_check_mark:	3219	3219
Barley	:heavy_check_mark:	:heavy_check_mark:	220410	220410
Barnyard millet	:heavy_check_mark:	:heavy_check_mark:	750	750
Beans	:heavy_check_mark:	:heavy_check_mark:	62898	62898
Breadfruit	:heavy_check_mark:	:heavy_check_mark:	282	282
Carrot	:heavy_check_mark:	:heavy_check_mark:	1966	1966
Cassava	:heavy_check_mark:	:heavy_check_mark:	13113	13113
Chickpea	:heavy_check_mark:	:heavy_check_mark:	63802	63802
Coconut	:heavy_check_mark:	:heavy_check_mark:	194	194
Coffee	:heavy_check_mark:	:heavy_check_mark:	1890	0
Cowage	:heavy_check_mark:	:heavy_check_mark:	64	64
Cowpea	:heavy_check_mark:	:heavy_check_mark:	34623	34623
Eggplant	:heavy_check_mark:	:heavy_check_mark:	5204	5204
Faba bean	:heavy_check_mark:	:heavy_check_mark:	16317	16317
Finger millet	:heavy_check_mark:	:heavy_check_mark:	12608	12608
Forages	:heavy_check_mark:	:heavy_check_mark:	175924	175924
Foxtail millet	:heavy_check_mark:	:heavy_check_mark:	1598	1598
Grasspea	:heavy_check_mark:	:heavy_check_mark:	6556	6556
Groundnut	:heavy_check_mark:	:heavy_check_mark:	20852	20852
Kodo millet	:heavy_check_mark:	:heavy_check_mark:	665	665
Lentil	:heavy_check_mark:	:heavy_check_mark:	30846	30846
Lettuce	:heavy_check_mark:	:heavy_check_mark:	11010	11010
Little millet	:heavy_check_mark:	:heavy_check_mark:	473	473
Maize	:heavy_check_mark:	:heavy_check_mark:	104169	104169
Oat	:heavy_check_mark:	:heavy_check_mark:	38976	38976
Pea	:heavy_check_mark:	:heavy_check_mark:	21693	21693
Pearl millet	:heavy_check_mark:	:heavy_check_mark:	32219	32219
Pigeonpea	:heavy_check_mark:	:heavy_check_mark:	15570	15570
Potato	:heavy_check_mark:	:heavy_check_mark:	22597	22597
Proso millet	:heavy_check_mark:	:heavy_check_mark:	890	890
Rice	:heavy_check_mark:	:heavy_check_mark:	263105	250000
Rye	:heavy_check_mark:	:heavy_check_mark:	11373	11373
Sapota	:heavy_check_mark:	:heavy_check_mark:	110	110
Sesame	:heavy_check_mark:	:heavy_check_mark:	906	906
Sorghum	:heavy_check_mark:	:heavy_check_mark:	101611	101611
Soybean	:heavy_check_mark:	:heavy_check_mark:	47567	47567
Squashes	:heavy_check_mark:	:heavy_check_mark:	1797	1797
Sunflower	:heavy_check_mark:	:heavy_check_mark:	10121	10121
Sweetpotato	:heavy_check_mark:	:heavy_check_mark:	8845	8845
Taro	:heavy_check_mark:	:heavy_check_mark:	1194	1194
Tea	:heavy_check_mark:	:heavy_check_mark:	1	1
Tomato	:heavy_check_mark:	:heavy_check_mark:	34669	34669
Wheat	:heavy_check_mark:	:heavy_check_mark:	460456	250000
Yam	:heavy_check_mark:	:heavy_check_mark:	6284	6284

[stevensotelo]

@khadijaAouzal

• [x] Get the list of the crops names in order to start process and sent to @juangarc

[stevensotelo]

@juangarc

• [x] Add a new column to set which crops have accessions in genesys
• [x] Fix the table crops. It should check just the crops which are ready into the database

[stevensotelo]

@juangarc

• [x] He has problem when he is importing. He is checking with @khadijaAouzal.

@khadijaAouzal

• [x] She should check the try catch function in the execution. She said that is better remove the try-catch in the function
• [x] Check what is happening with the log

[stevensotelo]

[stevensotelo]

@juangarc and @khadijaAouzal

• They solved the issue with the importing process. @juangarc remove the try-catch in the function

[stevensotelo]

[stevensotelo]

[stevensotelo]

@juangarc

• [x] Add new column with amount of total accessions for both databases: our database / genesys: (500/1500)

[stevensotelo]

[stevensotelo]

[stevensotelo]

@juangarc

• [x] Document issue with coconut and coffe
• [x] He should send a copy of the new database to brayan

@khadijaAouzal

• [x] Check the issue of @juangarc

[stevensotelo]

[stevensotelo]

@juangarc

• He sent information about issue to @khadijaAouzal
• He sent the database to @bmora-0110
• [x] He should fix the file format, which he sent before to @bmora-0110 in order to adjust with the code

@khadijaAouzal

• She solved the issue with coconut and coffe

[stevensotelo]

@juangarc

• He is running again the import process, it was because we had to fix the coordinates of accessions
• [x] The crops which are pending to finalize are: Sorghum and Wheat

[stevensotelo]

The data is processed and saved into the database