How import document in FMP Business Adapter Studion?

[Yakutskenergo]

Hello,

Can somebody tell how import document.

I have .xls files, where some devices PC, Laptops and i want attach document for them.

[mfranz]

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

[ChrisG · Accepted solution]

@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