search

Rothamsted-Ecoinformatics / eRA

e-RA website code
3 stars 0 forks source link

Bibliography workflow #55

Closed nathcast closed 3 years ago

nathcast commented 3 years ago

We have a problem with importing references in the database. this will affect the new site but also affect the old site. The new version of mysql, or XL are chocking on the standart used. I have managed to import a full complement of the references on 16th sept, but have not manages to reproduce that. .

nathcast commented 3 years ago

Open bibliography in endnote. If not woking properly, check stettings Use eRA Tab Delimited export filter Import the text file in exel Check the records - Especally ensure that there are no rogue lines that denote a carriage return in any of the records

save as csv (comma delimited)

in dbeaver, import csv, using windows-1252

For the next few times I will do it until I have clear documentation

richardostler commented 3 years ago

Hi @nathcast, I'm not clear if this is ready to be closed. Has this been tested further and the documentation available?

nathcast commented 3 years ago

It works> I have also made a CheatSheet documentation file that resides in the bibliography folder. I