Hello,
Can somebody tell how import document.
I have .xls files, where some devices PC, Laptops and i want attach document for them.
Jan 12, 2022 06:51 PM
@mfranz is right that the data model available for use in business adapters does not cover importing document content.
You might consider doing this by directly manipulating relevant data in the compliance database of a FlexNet Manager Suite On-premises system. Document data is stored in the Document.DocumentFile and DocumentSize columns in the compliance database.
Something like the following (untested) SQL statement would store the contents of the file C:\Data\MyFile.xlsx (on the database server's filesystem) on the document record that has ID 1234:
UPDATE dbo.Document
SET
DocumentFile = CAST(BulkColumn AS IMAGE),
DocumentSize = DATALENGTH(BulkColumn)
FROM
OPENROWSET(BULK 'C:\Data\MyFile.xlsx', SINGLE_BLOB) AS DATA
WHERE
DocumentID = 1234
Jan 24, 2022 12:57 AM
Hi,
I think the Business Adapter (Studio) will not allow to attach actual documents. I see 3 options:
Best regards,
Markward
Jan 13, 2022 01:20 AM
@mfranz is right that the data model available for use in business adapters does not cover importing document content.
You might consider doing this by directly manipulating relevant data in the compliance database of a FlexNet Manager Suite On-premises system. Document data is stored in the Document.DocumentFile and DocumentSize columns in the compliance database.
Something like the following (untested) SQL statement would store the contents of the file C:\Data\MyFile.xlsx (on the database server's filesystem) on the document record that has ID 1234:
UPDATE dbo.Document
SET
DocumentFile = CAST(BulkColumn AS IMAGE),
DocumentSize = DATALENGTH(BulkColumn)
FROM
OPENROWSET(BULK 'C:\Data\MyFile.xlsx', SINGLE_BLOB) AS DATA
WHERE
DocumentID = 1234
Jan 24, 2022 12:57 AM