Skip to Content

Data Manager - Is it possible to set up default Export to Excels?

Hi there~

Currently in MDM Data Manager, when you select Export to Excel, you have to choose which fields you would like to export and set it up in an order you desire every time (pictured below).  There is a specific template I need to populate, which requires specific fields in a specific order every time.  I have been setting this up manually, and it gets time consuming for having to do it constantly.  I have heard there may be a way to set up Export to Excel to be in a order you pre-define, however after reading the Reference Guides and searching previous conversations, I have not found an answer?  Is there a way to do this? And if so, how?

Current version I am using - 7.1 SP11

Thank you!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 23, 2014 at 08:15 AM

    Hi Rachel,

    It is simple to achieve this using syndicator.Also,for a future requirement applying filters and saving configurations can be useful.These make a map handy.

    A flat file so obtained can be imported to excel or other databases.

    Thanks,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 23, 2014 at 03:58 AM

    Hi,

    You might probably like to use MDM Syndicator to achieve this.

    But its not posible through Data Manager.

    Regards,

    Ali

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 23, 2014 at 11:16 AM

    just in addition to what Ravi said, a flat tab separated file can be readily opened in excel. So should solve your purpose.

    -Abhijeet

    Add comment
    10|10000 characters needed characters exceeded