Help us understand your request (check below):
Describe what you're trying to do
Always possible that I have done something crazy, but I performed a search with a long list of comma separated catalog numbers and got results, then selected Download for Citation Bulkloader and immediately received this error:
ERROR_ID D5882672-89A9-46C8-A2A201A8AC3EE6C9
ERROR_TYPE SQL
ERROR_MESSAGE ERROR: column "scientific_name" does not exist Position: 203
ERROR_DETAIL
ERROR_SQL select guid, '' publicationID, '' doi, '' type_status, '' occurs_page_number, concatAcceptedIdentificationIDs(collection_object_id) as use_identificationID, '' citation_remarks, scientific_name, '' identification_order, '' made_date, '' identification_remarks, '' use_pub_authors, '' identifier_1, '' identifier_2, '' identifier_3, '' identifier_4, '' identifier_5, '' identifier_6, '' attribute_type_1, '' attribute_value_1, '' attribute_units_1, '' attribute_remark_1, '' attribute_method_1, '' attribute_determiner_1, '' attribute_date_1, '' attribute_type_2, '' attribute_value_2, '' attribute_units_2, '' attribute_remark_2, '' attribute_method_2, '' attribute_determiner_2, '' attribute_date_2, '' attribute_type_3, '' attribute_value_3, '' attribute_units_3, '' attribute_remark_3, '' attribute_method_3, '' attribute_determiner_3, '' attribute_date_3, '' attribute_type_4, '' attribute_value_4, '' attribute_units_4, '' attribute_remark_4, '' attribute_method_4, '' attribute_determiner_4, '' attribute_date_4 from api_jegelewicz_20260420040427265_893
If the long list of catalog numbers matters, here it is all in UCM:Inv
32813,275,730,3046,3153,3221,3958,4491,4493,4496,5417,6238,6239,6240,6244,6246,6252,6258,6497,6714,6974,6978,6979,6987,6989,6990,7002,7020,7662,8155,9372,9383,9405,12775,13641,13772,13775,13776,13835,14694,14695,14719,14737,14810,14841,14884,14889,14891,14905,14906,14928,15008,15014,15040,15054,15081,15107,15538,17780,18332,18391,18395,18396,18399,18401,18402,18406,18407,18409,18412,18413,18430,18435,18436,18443,18444,18445,18446,18449,18450,18451,18459,18463,18464,18468,18470,18473,18480,18484,18488,18490,18493,18494,18495,19855,19859,19865,19902,19903,19904,19905,19906,19941,19944,21434,22172,22449,23410,23958,23973,24184,24186,24194,24705,312,621,6287,6289,6355,7281,8597,10114,10695,11660,12757,15940,16016,16042,17001,17475,17486,17710,17724,17735,18058,21167,21168,22519,26373,30966,30969,30972,32812,37079,7664,13023,17737,626,2691,6255,6264,6715,6968,6969,6986,6993,6996,8578,8579,8588,8592,8595,8596,8598,8812,9301,9302,9306,9307,9309,15786,16172,16201,16202,17269,17788,17803,17804,17805,17806,17808,17809,17811,17812,17814,17817,17836,17837,18264,18305,18306,18307,18309,18310,18311,18312,18313,18314,18315,18316,18317,18318,18319,18320,18321,18322,18323,18324,18325,18326,18327,18330,18331,18333,18335,18336,18339,18340,18341,18342,19311,19312,19852,19866,19872,19882,19958,20070,20178,20179,20238,20652,20654,20656,20668,20669,20671,20674,20676,20678,20679,20681,20685,20686,20746,20770,20791,20878,21209,21214,21225,21231,21273,21286,21666,21826,21965,22445,22479,22484,22545,23094,23221,23545,23659,23682,24112,24165,24812,24820,24904,24931,24966,26245,26246,26374,26375,26376,26377,26378,26379,29729,30260,31840,32781,32814,32815,32816,32817,32931,50640,50641,50642,50643,50644,50645,50646,50647,50648,50649,50650,50651,50652,50653,50654,50655,50656,50657,50658,50659,50660,50661,50662,50663,50665,50666,50668,50669,50670,50675,50676,50677,50678,50679,50680,60476,28591,52298,559,575,2393,2730,2738,3263,3476,3482,4891,4892,4893,6245,6250,6251,6265,6960,6973,6995,6998,6999,7000,7059,7060,7517,8832,9305,9366,9381,9552,10527,10535,11157,11431,11433,12349,12365,13120,13719,14270,14271,15136,15137,15138,15592,15781,15782,16046,16087,16169,16170,16216,16217,16264,16265,16396,16558,16867,17111,17703,17754,17759,17789,17874,17911,18254,18255,18262,18269,18278,18280,18290,18295,18303,18308,18328,18329,18334,18337,18338,18356,19113,19134,19320,19321,19356,19357,19358,19359,19360,19361,19362,19363,19364,19365,19366,19367,19368,19369,19370,19371,19372,19373,19374,19375,19479,19480,19675,19677,19685,19690,19959,20210,20212,20234,20235,20241,20243,20244,20259,20260,20261,20262,20264,20266,20268,20269,20577,20659,20662,20665,20771,20775,20777,20787,20790,20970,21027,21078,21079,21080,21081,21082,21083,21084,21085,21131,21158,21193,21208,21215,21220,21228,21238,21239,21248,21256,21260,21274,21279,21290,21291,21292,21379,21382,21385,21392,21421,21422,21485,21486,21487,21488,21506,21508,21510,21537,21603,21626,21657,21662,21669,21821,21823,21827,21830,21831,21914,21915,21927,22018,22056,22339,22446,22520,22573,22599,22627,22629,22644,22674,22697,22703,22707,22722,22756,22794,22813,22828,22830,22844,23153,23172,23214,23215,23447,23654,23761,23762,23763,23764,23765,23766,23767,23768,23814,23838,23840,23847,23891,24172,24651,24655,24686,24687,25861,25902,25903,25904,25905,25906,25907,25908,28552,30906,52964,206,1707,2861,2862,2934,3480,4000,4495,6232,6236,6241,6262,6965,6966,6980,6994,7009,7063,7151,7152,7598,7600,7602,7603,7607,7612,7677,7679,7980,8860,9388,9778,10113,10155,11865,12080,12353,12358,12360,13011,13040,13121,13123,13127,13131,13132,13134,13135,13137,13138,13139,13240,13263,13445,13712,13714,13726,13728,13731,13773,14718,14721,14760,14766,14802,14812,14912,14961,15055,15079,15272,16173,16199,16626,16628,17779,17787,17899,19174,19676,19820,19821,20214,21170,21178,21186,21492,22540,23213,31839,54378,54379
How-To
Please review the Arctos Code of Conduct to ensure respectful communication, and see https://handbook.arctosdb.org/how_to/How-to-Use-Issues-in-Arctos.html for more information about submitting and managing Issues.
Help us understand your request (check below):
Describe what you're trying to do
Always possible that I have done something crazy, but I performed a search with a long list of comma separated catalog numbers and got results, then selected Download for Citation Bulkloader and immediately received this error:
ERROR_ID D5882672-89A9-46C8-A2A201A8AC3EE6C9
ERROR_TYPE SQL
ERROR_MESSAGE ERROR: column "scientific_name" does not exist Position: 203
ERROR_DETAIL
ERROR_SQL select guid, '' publicationID, '' doi, '' type_status, '' occurs_page_number, concatAcceptedIdentificationIDs(collection_object_id) as use_identificationID, '' citation_remarks, scientific_name, '' identification_order, '' made_date, '' identification_remarks, '' use_pub_authors, '' identifier_1, '' identifier_2, '' identifier_3, '' identifier_4, '' identifier_5, '' identifier_6, '' attribute_type_1, '' attribute_value_1, '' attribute_units_1, '' attribute_remark_1, '' attribute_method_1, '' attribute_determiner_1, '' attribute_date_1, '' attribute_type_2, '' attribute_value_2, '' attribute_units_2, '' attribute_remark_2, '' attribute_method_2, '' attribute_determiner_2, '' attribute_date_2, '' attribute_type_3, '' attribute_value_3, '' attribute_units_3, '' attribute_remark_3, '' attribute_method_3, '' attribute_determiner_3, '' attribute_date_3, '' attribute_type_4, '' attribute_value_4, '' attribute_units_4, '' attribute_remark_4, '' attribute_method_4, '' attribute_determiner_4, '' attribute_date_4 from api_jegelewicz_20260420040427265_893
If the long list of catalog numbers matters, here it is all in UCM:Inv
32813,275,730,3046,3153,3221,3958,4491,4493,4496,5417,6238,6239,6240,6244,6246,6252,6258,6497,6714,6974,6978,6979,6987,6989,6990,7002,7020,7662,8155,9372,9383,9405,12775,13641,13772,13775,13776,13835,14694,14695,14719,14737,14810,14841,14884,14889,14891,14905,14906,14928,15008,15014,15040,15054,15081,15107,15538,17780,18332,18391,18395,18396,18399,18401,18402,18406,18407,18409,18412,18413,18430,18435,18436,18443,18444,18445,18446,18449,18450,18451,18459,18463,18464,18468,18470,18473,18480,18484,18488,18490,18493,18494,18495,19855,19859,19865,19902,19903,19904,19905,19906,19941,19944,21434,22172,22449,23410,23958,23973,24184,24186,24194,24705,312,621,6287,6289,6355,7281,8597,10114,10695,11660,12757,15940,16016,16042,17001,17475,17486,17710,17724,17735,18058,21167,21168,22519,26373,30966,30969,30972,32812,37079,7664,13023,17737,626,2691,6255,6264,6715,6968,6969,6986,6993,6996,8578,8579,8588,8592,8595,8596,8598,8812,9301,9302,9306,9307,9309,15786,16172,16201,16202,17269,17788,17803,17804,17805,17806,17808,17809,17811,17812,17814,17817,17836,17837,18264,18305,18306,18307,18309,18310,18311,18312,18313,18314,18315,18316,18317,18318,18319,18320,18321,18322,18323,18324,18325,18326,18327,18330,18331,18333,18335,18336,18339,18340,18341,18342,19311,19312,19852,19866,19872,19882,19958,20070,20178,20179,20238,20652,20654,20656,20668,20669,20671,20674,20676,20678,20679,20681,20685,20686,20746,20770,20791,20878,21209,21214,21225,21231,21273,21286,21666,21826,21965,22445,22479,22484,22545,23094,23221,23545,23659,23682,24112,24165,24812,24820,24904,24931,24966,26245,26246,26374,26375,26376,26377,26378,26379,29729,30260,31840,32781,32814,32815,32816,32817,32931,50640,50641,50642,50643,50644,50645,50646,50647,50648,50649,50650,50651,50652,50653,50654,50655,50656,50657,50658,50659,50660,50661,50662,50663,50665,50666,50668,50669,50670,50675,50676,50677,50678,50679,50680,60476,28591,52298,559,575,2393,2730,2738,3263,3476,3482,4891,4892,4893,6245,6250,6251,6265,6960,6973,6995,6998,6999,7000,7059,7060,7517,8832,9305,9366,9381,9552,10527,10535,11157,11431,11433,12349,12365,13120,13719,14270,14271,15136,15137,15138,15592,15781,15782,16046,16087,16169,16170,16216,16217,16264,16265,16396,16558,16867,17111,17703,17754,17759,17789,17874,17911,18254,18255,18262,18269,18278,18280,18290,18295,18303,18308,18328,18329,18334,18337,18338,18356,19113,19134,19320,19321,19356,19357,19358,19359,19360,19361,19362,19363,19364,19365,19366,19367,19368,19369,19370,19371,19372,19373,19374,19375,19479,19480,19675,19677,19685,19690,19959,20210,20212,20234,20235,20241,20243,20244,20259,20260,20261,20262,20264,20266,20268,20269,20577,20659,20662,20665,20771,20775,20777,20787,20790,20970,21027,21078,21079,21080,21081,21082,21083,21084,21085,21131,21158,21193,21208,21215,21220,21228,21238,21239,21248,21256,21260,21274,21279,21290,21291,21292,21379,21382,21385,21392,21421,21422,21485,21486,21487,21488,21506,21508,21510,21537,21603,21626,21657,21662,21669,21821,21823,21827,21830,21831,21914,21915,21927,22018,22056,22339,22446,22520,22573,22599,22627,22629,22644,22674,22697,22703,22707,22722,22756,22794,22813,22828,22830,22844,23153,23172,23214,23215,23447,23654,23761,23762,23763,23764,23765,23766,23767,23768,23814,23838,23840,23847,23891,24172,24651,24655,24686,24687,25861,25902,25903,25904,25905,25906,25907,25908,28552,30906,52964,206,1707,2861,2862,2934,3480,4000,4495,6232,6236,6241,6262,6965,6966,6980,6994,7009,7063,7151,7152,7598,7600,7602,7603,7607,7612,7677,7679,7980,8860,9388,9778,10113,10155,11865,12080,12353,12358,12360,13011,13040,13121,13123,13127,13131,13132,13134,13135,13137,13138,13139,13240,13263,13445,13712,13714,13726,13728,13731,13773,14718,14721,14760,14766,14802,14812,14912,14961,15055,15079,15272,16173,16199,16626,16628,17779,17787,17899,19174,19676,19820,19821,20214,21170,21178,21186,21492,22540,23213,31839,54378,54379
How-To
Please review the Arctos Code of Conduct to ensure respectful communication, and see https://handbook.arctosdb.org/how_to/How-to-Use-Issues-in-Arctos.html for more information about submitting and managing Issues.