ERROR: LoadError: (2): File not found
Hey I am trying to run the following the save.efetch function in Julia v1.4.0. On Windows 10.
When I attempt to run this code:
BioMedQuery.PubMed.save_efetch!(conn, efetch_doc, true, true)
I get the following error:
Saving 15 articles to database ┌ Warning:
getindex(df::DataFrame, col_ind::ColumnIndex)is deprecated, usedf[!, col_ind]instead. │ caller = select_columns(::MySQL.Connection, ::String) at mysql_db_utils.jl:62 └ @ BioMedQuery.DBUtils C:\Users\antho.julia\packages\BioMedQuery\K4kwC\src\DBUtils\mysql_db_utils.jl:62 ERROR: LoadError: (2): File 'C:UsersanthoDocumentsMachine_LearningWork2020-04-17_PubMed_basic.csv' not found (Errcode: 2) Stacktrace: [1] execute!(::MySQL.Connection, ::String) at C:\Users\antho.julia\packages\MySQL\R2gKS\src\MySQL.jl:84 [2] db_insert!(::MySQL.Connection, ::Dict{String,DataFrame}, ::String, ::String; verbose::Bool, drop_csv::Bool) at C:\Users\antho.julia\packages\BioMedQuery\K4kwC\src\PubMed\pubmed_sql_utils.jl:482 [3] save_efetch!(::MySQL.Connection, ::XMLElement, ::Bool, ::Bool) at C:\Users\antho.julia\packages\BioMedQuery\K4kwC\src\PubMed\eutils_sql_save.jl:25 [4] create_mysql_pubmed_db(::String, ::String, ::XMLElement) at C:\Users\antho\Documents\Machine_Learning\Work\collect_data.jl:132 [5] main() at C:\Users\antho\Documents\Machine_Learning\Work\collect_data.jl:604 [6] top-level scope at C:\Users\antho\Documents\Machine_Learning\Work\collect_data.jl:627 [7] include(::Module, ::String) at .\Base.jl:377 [8] exec_options(::Base.JLOptions) at .\client.jl:288 [9] _start() at .\client.jl:484 in expression starting at C:\Users\antho\Documents\Machine_Learning\Work\collect_data.jl:627
This code seems to work on MacOS however I have not been able to get this running on Windows.
Just FYI, this package is unmaintained/deprecated.
Is there another package that performs similarly?
I'm not sure, sorry.