Emerson Exchange 365

• Not Answered

AMS Data Export

Hi all,

Does anyone know of a way to pull specific product information (i.e. serial numbers) from the AMS database? Looking at an AMS backup file and it does really have any meaning to it. It would be advantageous if a person was able to pull bulk data from your devices when looking at site critical sparing or just getting a handle of what the site installation looks like. I've just never come across a way to pull that information out of AMS other than a manual one by one process. 

Even if I could get the information in a certain format then we could write some script to pull specific data out.

Let me know you thoughts, thanks!

• AMS

Eric_Brousseau

• 25 May 2023 1:38 PM
• Cancel

7 Replies

• Tinh Phan

  

  • 25 May 2023 3:18 PM

  Open the device dashboard in AMS Device Manager and go to "File" drop down and chose "Export All". Use excel and open the file. All device data are there.

  • Cancel
• MPHymel

  

  • 25 May 2023 3:22 PM

  In reply to Tinh Phan:

  There is also an external tool that can be used if you have thousands of devices on your system, the tool gates exports to smaller chunks of data and spreads it out over time.

  • Cancel
• Marlen Osmanov

  

  • 25 May 2023 6:08 PM

  4f4f4f4

  
  

  Marlen.

  Tel:+79855203476

  
  

  
  

  • Cancel
• Tushar Gohad

  

  • 26 May 2023 6:10 AM

  Hi,
  Device Information can be extracted from Generic Export File for multiple devices at time.
  to extract information follow these steps - Launch AMS Device Manager --> in Device Explorer View Click on AMS Device Manager --> Export --> Select Generic Export File --> Select device/s for which information extraction --> Select Date & Time Range --> file will save on default path.
  
  Once export done, open excel file & drag/drop exported .xml file & follow prompt. Search parameter/s looking for.

  • Cancel
• Adam Bickerstaff

  

  • 14 Mar 2024 4:53 PM

  In reply to MPHymel:

  Marlen Osmanov What Tool are you referring to? I am exporting a few thousand tags of various Manufacturers using AMS Bulk export and seem to be limited to 50 tags per export.

  • Cancel
• Tushar Gohad

  

  • 14 Mar 2024 5:17 PM

  In reply to MPHymel:

  Hi MPHymel,
  I am also interested in external tool for device parameter export.
  Kindly advise

  • Cancel
• MPHymel

  

  • 15 Mar 2024 1:05 PM

  In reply to Tushar Gohad:

  in your c:\AMS\BIN folder you should find a GenExDeviceParams.exe file.
  
  This can be run, and be patient it will appear to lock but it takes time to populate.
  
  The may not be a supported tool, meaning BOL may not cover it's use, and it may one day no longer work, but it has worked for us, we are version 14.1.1
  
  The utility runs in the background and will take some to to progress through all your instruments.
  
  Hope this helps.

  • Cancel