Physical Photos and film - inventory management

[Gilles Caulier]

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 <alcheechmail at gmail.com>:

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-devel/attachments/20180306/0482e129/attachment.html>