E-mail: Password: Create an Account Recover password

About Authors Contacts Get involved Русская версия

show

Programs for managing collections

Community and Forum → Entomological collections → Programs for managing collections

Pages: 1 2

06.03.2015 10:33, antlook

According to point A), you can use a blank template for this, as I already mentioned.
D) It is not entirely clear what to do with the taxa of the genus and higher rank, which change depending on the views on taxonomy. E) How to provide for the possibility to make a selection for compiling defining tables, which would be nice (in the manner of http://www.lucidcentral.org/). Program Overview https://vk.com/topic-2418619_3601223 Other overview-List http://www.ent.iastate.edu/list/directory/104/vid/4

10.03.2015 14:54, Grimm

Dear colleagues!
I've been working with cataloging for a long time!
Here is my suggestion (small snippet)
There are 65,000 lines on a single sheet.

File/s:



download file ____.xls

size: 32k
number of downloads: 387






10.03.2015 15:17, Peter Khramov

Grimm, is this an export from somewhere, or do you store it directly in this form?

10.03.2015 16:11, kovyl

Dear Grimm,
The fact that Excel has data grouping is clear.
About 65,000 lines - in the sense that you can put data on the corresponding number of taxa on the sheet?
What exactly is your offer?

10.03.2015 16:30, Peter Khramov

Probably, in what columns to split the information. For example, there is an original solution to the question with brackets for the author/year. Although not completely.

10.03.2015 18:36, kovyl

Well, if we are talking about taxa, then you don't need to split anything into any columns. Name of the taxon and its status. Do you have a base based on Excel?

11.03.2015 8:58, Grimm

Database in Excel!
The brackets are placed separately, so that it would be more convenient to sort by authors, and in this case it is much easier to change or insert them! However, there is a problem with transferring data for printing to labels. To do this, there is (secret column in column V)! The second sheet shows the authorship of higher taxa.

11.03.2015 9:01, Grimm

About 65,000 lines - this is the limit of Excel 2003.
I keep it in this form for the convenience of mailing lists, if people work in the old version.

11.03.2015 19:44, kovyl

Database in Excel!
If in the sense of classical databases, then this is not exactly a database, but rather a table. If in the sense of a data set, then it can also be considered a database.

Pages: 1 2

New comment

Note: you should have a Insecta.pro account to upload new topics and comments. Please, create an account or log in to add comments.

* Our website is multilingual. Some comments have been translated from other languages.

Random species of the website catalog

Insecta.pro: international entomological community. Terms of use and publishing policy.

Project editor in chief and administrator: Peter Khramov.

Curators: Konstantin Efetov, Vasiliy Feoktistov, Svyatoslav Knyazev, Evgeny Komarov, Stan Korb, Alexander Zhakov.

Moderators: Vasiliy Feoktistov, Evgeny Komarov, Dmitriy Pozhogin, Alexandr Zhakov.

Thanks to all authors, who publish materials on the website.

© Insects catalog Insecta.pro, 2007—2024.

Species catalog enables to sort by characteristics such as expansion, flight time, etc..

Photos of representatives Insecta.

Detailed insects classification with references list.

Few themed publications and a living blog.