...
Call stored procedure tman.insert_asset (https://git.yale.edu/cultural-heritage-dam/tman-database/blob/main/procedures/insert_asset.sql) to upload metadata of the asset to be ingested.
Schema name: tman
Procedure name: insert_asset
Parameters:
login,
unitcode,
filename,
hotfolderpath,
cmstype,
cmsid::bigint,
ingestrequested::smallint,
netx_folderid::bigint,
preservica_securitytag,
preservica_colref,
uploadchecksum,
cdsprimary::smallint,
mimetype,
uuid,
nativeid::integer,
cdsrank::integer,
imagecredit,
imagecaption,
imagecopyright,
copyrightinfourl,
copyrightstatus,
usageterms,
imagesource,
headline,
imagekeywords,
jobidentifier,
creator,
creatorrole,
imagetitle,
instructions,
bitdepth,
colorprofile,
imagesupplier,
lens,
lensmake,
lensmodel,
serialnumber,
imageheight::integer,
imagewidth::integer,
date_photo_taken::date,
date_of_source::date,
tombstone,
use_stub::smallint,
cds_access_master,
cds_access_tiff,
cds_access_jpeg,
cds_maxsize_tiff::integer,
cds_maxsize_jpeg::integer,
Unit_rank::integer
*Data type not explicitly casted are all of type text
example:
call tman.insert_asset(
'login',
...