EPM Data Manager Download Data vba

[back4more70]

Hi all, I am trying to understand the vba for FMPXLClient.EPMAddInDMAutomation.Download (i.e. the "Download Data" button on in the Data Manager Group tab in Excel). Has anyone written vba with this and had success?

For background, I am trying to download text files that were saved on the server using the Export MD (export master data) Data Manager package. I would like my vba to download the file from the server to the user's local drive so it can be manipulated. Ideas? Thank you.

[former_member186338 · Accepted solution]

Just tested on the real system:

Option Explicit
Dim epmdma As New FPMXLClient.EPMAddInDMAutomation
Public Sub ttt()
Dim bytFile() As Byte
bytFile = epmdma.Download("DATAMANAGER", "DATAFILES", "\", "Export_CoA.txt", "")
End Sub

Working fine!

Arguments:

Module: DATAMANAGER

SubModule: DATAFILES

SubFolder: \ (or some subfolder)

File: Export_CoA.txt

Team: empty - for Company team

[back4more70 · Accepted solution]

cool! thank you

[adzb1 · Accepted solution]

Works great thanks!

Unfortunately for larger files, it corrupts the .txt file. Any recommendations?

edit: While using the download data button seems to not corrupt the file.

[former_member186338 · Accepted solution]

adzb1

Sorry, it's better to use your real name - hard to select in "mention"

Please show your code and provide info about file sizes.

[former_member186338]

As far as I remember I was able to do it. But now I don't have connection to the working system - I can't test.

Another option is to export data to aplication server folder mapped to some network folder. Then you can have immediate access to the export file.

[back4more70]

"Another option is to export data to aplication server folder mapped to some network folder. Then you can have immediate access to the export file."

I never thought of that, thank you Vadim!