Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

TMAN ingest

Initial ingest

Call stored procedure dbo.insertAsset (https://git.yale.edu/cultural-heritage-dam/TMAN/blob/master/TMAN/sql/procs/insertAsset.sql) to upload metadata of the asset to be ingested.

example:

call tman.insert_asset(

'login',

'YPM',

'filename.jpg',

'YPM/TEST',

'obj',

1,

0::smallint,

44,

'YPM_OPEN',

'bba8073f-6b9c-4f26-82c4-d13370b15544',

'99e901910347465d481994622de236df',

1::smallint,

'image/jpeg',

'017bfa8f-536b-4598-91b3-2ea2f858536b',

655811,

1,

'imagecredit',

'imagecaption',

'imagecopyright',

'copyrightinfourl',

'copyrightstatatus',

'usageterm',

'imagesource',

'headline',

'imagekeywords',

'jobidentifier',

'creator',

'creatorrole',

'imagetitle',

'instruction',

'bitdepth',

'colorprofile',

'imagesupplier',

'lens',

'lensmaker',

'lesmodel',

'seralnumber',

393,

383,

NULL::date,

NULL::date,

'tombstone',

0::smallint,

'N',

'P',

'N',

4096,

0,

0

)

Using stub files in NetX

Google doc

...