Re: Physical Photos and film - inventory management

Posted by Gilles Caulier-4 on Mar 06, 2018; 9:28pm
URL: http://digikam.185.s1.nabble.com/Physical-Photos-and-film-inventory-management-tp4705309p4705326.html

Hi,

If i try to resume, you have a separated 'database' to merge somewhere in digiKam database table to achieve the inventory.

I don't recommend to touch directly the DK database table directly, but to patch files metadata (or sidecar) with new XMP metadata which will be imported in database automatically. The XMP as plenty of tags dedicated for your use case, and digiKam is able to backport these tags a new properties in database.

Look in setup/template. All these field are saved in database while file scanning, and each one as an XMP entry.

In you want to know the XMP tags relevant of each entry, go to Item/Edit metadata/XMP and adjust a vulue somewhere and save. Now look where in XMP the data have been patched with Exiftool or Exiv2 CLI tool.

Now to automatize the xmp values in files (or sidecar), you will need to write a script to extract each fields from CSV and write value in XMP. Again here, exiftool and exiv2 can help.

Best

Gilles Caulier

2018-03-05 17:32 GMT+01:00 alcheech <[hidden email]>:

Hello everyone,

I am brand new to Digikam (first post) and looking to organize up to a
million original pieces of film.  I currently have scanned around 100,000
images and they are stored in different digital and physical locations.
What I need is both a digital media database (for the scanned images
including the scanner etc, type of scan - which I believe I can use tags and
such but would like to use tables for the genres) as well as an inventory
management system for the physical product

I sell these photos on different platforms and make CSV files (including
image location, title, price, description, etc) depending on the site and
how the CSV is created.  And get CSV sales records from those platforms
(where I manage sales to collectors)

I don't think Digikam by itself can handle what I am requiring where I would
have to tie in another database with sales records, customer data, pricing
mechanisms of individual original film and photos, etc).

Would I use Digikam to import my records and use another database for
inventory and customer management including physical locations, pricing,
sales records, customer data.  Then create a front end merging the two where
I can do queries such as sales data for set xyz (so I can see prices).  I
would love it to have the look and feel as Digikam.  I think this most
likely is the direction I have to take

I doupt I can simply add tables and modify query reports in Digikam itself
and have it be both digital asset management and inventory / sales
management.

Can anyone give me advise on how to tackle this project?

Thank you,

Al Cheech



--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-devel-f1695701.html