Topic
10 replies Latest Post - ‏2014-06-20T15:30:49Z by R026_Viplav_Kumar
SystemAdmin
SystemAdmin
1283 Posts
ACCEPTED ANSWER

Pinned topic exporting events from AEL to CSV or Excel

‏2013-01-20T13:52:46Z |
Hi All,
i want to add a tool under AEL right click Menu , on clicking which will export the selected events to csv or excel file on the user local hard drive. Manual copy/paste option is available, but need this option also.
Updated on 2013-02-07T13:11:59Z at 2013-02-07T13:11:59Z by SystemAdmin
  • Venkat_GulfSoft
    Venkat_GulfSoft
    5 Posts
    ACCEPTED ANSWER

    Re: exporting events from AEL to CSV or Excel

    ‏2013-01-21T15:12:45Z  in response to SystemAdmin
    Sometime back, I wrote a utility called GbsNcoSQL that will let you run any SELECT statement on Object Server. Using this utility, you can run a "SELECT * from alerts_status" and export the results as CSV.
    Here is more information about this utility.

    http://blog.gulfsoft.com/2010/01/now-you-have-alternative-to-freetds.html

    Let me know if you are interested and I will send a copy of this utility.

    with warm regards,
    Venkat Saranathan.
    Gulf Breeze Software.
    • SystemAdmin
      SystemAdmin
      1283 Posts
      ACCEPTED ANSWER

      Re: exporting events from AEL to CSV or Excel

      ‏2013-01-22T06:52:33Z  in response to Venkat_GulfSoft
      Hi Venkat,
      thanks for the reply, How can i use this utility GbsNcoSQL , for exporting selected events from AEL to csv or excel format.
      • Venkat_GulfSoft
        Venkat_GulfSoft
        5 Posts
        ACCEPTED ANSWER

        Re: exporting events from AEL to CSV or Excel

        ‏2013-01-22T22:04:35Z  in response to SystemAdmin
        John,

        Now that I re-read your question, you can GbsNCOSQL to export ALL your AEL events into CSV by creating a new tool to run GbsNcoSqL command line.

        The user guide/syntax is available below.

        http://blog.gulfsoft.com/2010/01/gbsncosql-user-guide.html

        However if you are thinking about exporting only selected events, I can't think of a way to do this using GbsNcoSQL.

        Make sense?
        Thanks,
        with warm regards,
        Venkat Saranathan.
        Gulf Breeze Software.
        • SystemAdmin
          SystemAdmin
          1283 Posts
          ACCEPTED ANSWER

          Re: exporting events from AEL to CSV or Excel

          ‏2013-01-23T14:16:56Z  in response to Venkat_GulfSoft
          Can you send me the utility?
          vdevil786@gmail.com
          • deltabravo
            deltabravo
            20 Posts
            ACCEPTED ANSWER

            Re: exporting events from AEL to CSV or Excel

            ‏2013-01-30T23:07:34Z  in response to SystemAdmin
            Nice, I'm interested... danny(dot)butler(at)consolidated(dot)com
            • SystemAdmin
              SystemAdmin
              1283 Posts
              ACCEPTED ANSWER

              Re: exporting events from AEL to CSV or Excel

              ‏2013-02-07T13:11:59Z  in response to deltabravo
              Hi Venkat,

              Can you send me the GbsNcoSql? pax (dot) profundis (at) gmail (dot) com

              Thanks ;)
        • triple_s
          triple_s
          1 Post
          ACCEPTED ANSWER

          Re: exporting events from AEL to CSV or Excel

          ‏2013-10-22T07:01:36Z  in response to Venkat_GulfSoft

          Hi Venkat,

           

          Can you please send me the GbsNcoSql utility. sudhansu (dot) sabat (at) gmail (dot) com.

           

          Thanks..

          • var123input
            var123input
            10 Posts
            ACCEPTED ANSWER

            Re: exporting events from AEL to CSV or Excel

            ‏2013-11-20T09:18:20Z  in response to triple_s

            Hi Venkat,

            Can I also ask for a copy of the utility? charmed_akara@yahoo.com

            Thank you

        • R026_Viplav_Kumar
          R026_Viplav_Kumar
          3 Posts
          ACCEPTED ANSWER

          Re: exporting events from AEL to CSV or Excel

          ‏2014-06-20T15:30:49Z  in response to Venkat_GulfSoft

          Hi Venkat,

          Please share with me as well. I am in need of this kind of useful utility.

          Object Server events to CSV

          AEL to CSV

          Please share both tool.

          The ID is : viplavkumar@gmail.com

          Regards,

          Viplav

          Updated on 2014-06-20T15:33:19Z at 2014-06-20T15:33:19Z by R026_Viplav_Kumar
    • KumarBudige
      KumarBudige
      2 Posts
      ACCEPTED ANSWER

      Re: exporting events from AEL to CSV or Excel

      ‏2013-12-09T13:30:37Z  in response to Venkat_GulfSoft

      exporting events from AEL to CSV or Excel

      Hi Venkat,

      Can you please send me the GbsNcoSql utility at kbudige@gmail.com.

       

      Thank you.