0_PE951180 asked a question.
How import document in FMP Business Adapter Studion?
Hello,
Can somebody tell how import document.
I have .xls files, where some devices PC, Laptops and i want attach document for them.
Hi,
I think the Business Adapter (Studio) will not allow to attach actual documents. I see 3 options:
- store these documents somewhere else, like on a file share/SharePoint and just set a reference (see 2nd attribute)
- upload the documents manually from the WebUI
- do some SQL trickery to upload the files (FNMS on-premises only)
Best regards,
Markward
Expand Post- ChrisG (Flexera Software)
@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.DocumentSET DocumentFile = CAST(BulkColumn AS IMAGE), DocumentSize = DATALENGTH(BulkColumn)FROM OPENROWSET(BULK 'C:\Data\MyFile.xlsx', SINGLE_BLOB) AS DATAWHERE DocumentID = 1234
Expand Post
@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: