11-07-2019 01:04 PM
Hello,
I am trying to identify the database table that stores the document types associated with a parse format (COLD import process).
The table should be closely related to the ‘parsefiledesc’ table, but it doesn't appear that the document type assignments are in that table.
As an example, I'm trying to return all of the document types associated with import process #205 – any ideas on what table that could be?
The image below is from Configuration | Import | COLD/ERM Processor.
11-08-2019 06:58 AM
You can use the join table 'hsi.parsefilexitmtyp', like this:
select rtrim(dt.itemtypename) as doctype, pf.parsefilename as ImportJobNamefrom hsi.parsefiledesc pfjoin hsi.parsefilexitmtyp pfx on pfx.parsefilenum = pf.parsefilenumjoin hsi.doctype dt on dt.itemtypenum = pfx.itemtypenum
If you want just COLD jobs, add a constraint to the parsefiledesc table to get only 'parsingmethod = 1'
11-08-2019 06:58 AM
You can use the join table 'hsi.parsefilexitmtyp', like this:
select rtrim(dt.itemtypename) as doctype, pf.parsefilename as ImportJobNamefrom hsi.parsefiledesc pfjoin hsi.parsefilexitmtyp pfx on pfx.parsefilenum = pf.parsefilenumjoin hsi.doctype dt on dt.itemtypenum = pfx.itemtypenum
If you want just COLD jobs, add a constraint to the parsefiledesc table to get only 'parsingmethod = 1'
11-08-2019 07:35 AM
Hey Kevin,
This is exactly what I was looking for -- it looks like the table I needed was parsefilexitmtyp.
I was looking for just a particular COLD process, so I was able to set the 'parsefilenum' to that import process and return those document types.
Thank you very much Kevin.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.