Export data as a csv file to the Mid Server

[matthew_strecke]

I'm trying to export data that is stored in a table to the Mid Server. I hoping to push a csv file to the Mid Server. Has anyone done this before?

[Teja31]

Hi Matthew,

Did you figure out any solution for the above task !!

Thanks,

Teja

[stevemac]

Look at export set functionality.  It should have all the controls required

[Teja31]

Hi Steve,

I'm using the export set. But the file is not generating in the directory that we created in Mid Server. Could you please let me know how you dealt with export target and file path in it.

Thanks in Advance!!

[stevemac]

Hi,

Is the MID Server agent running on Windows or *nix?

I have only ever used this with Windows.  The export path you specify in the Export Target's file path becomes a subdirectory of the MID Server "agent" folder

As a test I performed the following

 - created a new Export Target.  It was named "et test" had has a file path of "\SSHWC"

 - created a simple Export Definition (some incident records created recently).  Previewed the definition to ensure there was data returned

 - created an Export set that used the Export Definition and Export Target above & used the related link to export the data.  The instance indicated it was transferring the data to the MID Server

Looking at the MID Server -  it created the subdirectory "export" in the "agent" directory and the subdirectory "SSHWC" in the "export" directory and the file was transferred OK

Mapping a drive to our MID Server from my local machine

 - Prior to export W:\LocalApp\MSAgentCMDBMultiCIs\agent\

 - After export W:\LocalApp\MSAgentCMDBMultiCIs\agent\export\SSHWC