I'd like to manage database-like my hard drive full of various types of files connected to my filed of interest. Its ancient sources and modern works that analyse and cross reference them. So it is a lot of images of old manuscripts, retyped old text in Ancient languages, scholarly books and articles (scanned, in PDFs or from Web) and my own notes.
It is impossible for me with my unarguably limited knowledge, to have them all tagged, searchable, filterable and cross-referenced.
I have some folders of images tagged, but tagging doesn't work for GIF-s, PNG-s and PDFs in Windows10. Even with the Shell that allows me tagging PDFs (but not PNGs for some reason) the Windows search-box ignores the tags for these files.
I have some of the data, parts of the books and web articles made into Excel spreadsheet with images, and filtres, but
- converting all of my material (Optical Recognition, corrections, solving the footnotes issues, placing images as JPG instead of uncompressed bitmaps, and so on) seems like unrealistic endless nightmare. Not to mention Excel is not good at handling lot of formatted text and images data. And often times a file crashes or looses all the images "as attempt to cure a one image issue" and is not a safe way to keep my data, I assume.
But first of all it is not covering all of my files, only what I manually put in there.
I was thinking of Ms Access, but I am afraid it will still require me a lot of life taken just for making the data into Access, and still will not be able to dynamically filter and instantly view the relevant parts of my images/texts/etc.
Maybe it should be a File Manager-like database that would be able to tag and work with chunks of files.
You know this paragraph of this PDF file is about that Ancient writer and that other one too, and mentions this three scholars opinions from these three works. And this footnote from this Word file mentions these of them... And this image is an example of this mentioned astronomical technique. And this part that is the second paragraph on the Scanned IMAGE version of this page of that book (that has all the pages scanned in this folder) ...
Any thought and ideas how would one manage to work with such diverse files and "database" them? There are apps that allow me to do few things to few file formats but not all of them. And making all of that into database (especially images) seems stupid and endless job.
Ideally I would like the materials to be filtered and to see several images/pages on the go, without the need to double click each one to see it is not the one I wanted. I will be okay even with full pages from PDF and whole image files, I am willing to resign from having the non-relevant parts of images cropped and the paragraph of interest to be cropped out of the PDF's page. That would be nice, be realistically I assume that is too much to ask, and I will be happy even without it.
At the moment I have no practical knowledge of databases and programming, I just learned some stuff in Excel and some basic theory about Access.
It is impossible for me with my unarguably limited knowledge, to have them all tagged, searchable, filterable and cross-referenced.
I have some folders of images tagged, but tagging doesn't work for GIF-s, PNG-s and PDFs in Windows10. Even with the Shell that allows me tagging PDFs (but not PNGs for some reason) the Windows search-box ignores the tags for these files.
I have some of the data, parts of the books and web articles made into Excel spreadsheet with images, and filtres, but
- converting all of my material (Optical Recognition, corrections, solving the footnotes issues, placing images as JPG instead of uncompressed bitmaps, and so on) seems like unrealistic endless nightmare. Not to mention Excel is not good at handling lot of formatted text and images data. And often times a file crashes or looses all the images "as attempt to cure a one image issue" and is not a safe way to keep my data, I assume.
But first of all it is not covering all of my files, only what I manually put in there.
I was thinking of Ms Access, but I am afraid it will still require me a lot of life taken just for making the data into Access, and still will not be able to dynamically filter and instantly view the relevant parts of my images/texts/etc.
Maybe it should be a File Manager-like database that would be able to tag and work with chunks of files.
You know this paragraph of this PDF file is about that Ancient writer and that other one too, and mentions this three scholars opinions from these three works. And this footnote from this Word file mentions these of them... And this image is an example of this mentioned astronomical technique. And this part that is the second paragraph on the Scanned IMAGE version of this page of that book (that has all the pages scanned in this folder) ...
Any thought and ideas how would one manage to work with such diverse files and "database" them? There are apps that allow me to do few things to few file formats but not all of them. And making all of that into database (especially images) seems stupid and endless job.
Ideally I would like the materials to be filtered and to see several images/pages on the go, without the need to double click each one to see it is not the one I wanted. I will be okay even with full pages from PDF and whole image files, I am willing to resign from having the non-relevant parts of images cropped and the paragraph of interest to be cropped out of the PDF's page. That would be nice, be realistically I assume that is too much to ask, and I will be happy even without it.
At the moment I have no practical knowledge of databases and programming, I just learned some stuff in Excel and some basic theory about Access.