Results 1 to 6 of 6

Thread: Update Field Status in Database

  1. #1
    saimohang is offline Junior Member
    Join Date
    May 2012
    Posts
    8
    Rep Power
    3

    Default Update Field Status in Database

    Hi All,

    I'm very new to Zimbra Application. I've scenario like, added one button (Archive) in Compose mail window. If I click on the button then I need to store a Boolean value in database. I'm able to set the Boolean value by using event mechanism through Zimlet, but I'm failing to update this Boolean value in the database. Please any one let me know how can we do this process using zimlet or any alternate way to do this. I'm really breaking my head, sine last two days.

    Thanks & Regards

    Sai Mohan

  2. #2
    saimohang is offline Junior Member
    Join Date
    May 2012
    Posts
    8
    Rep Power
    3

    Default

    Hi All,

    Please any one reply to me, is there a way to add custom column to the database in zimbra? if so please let me know how can we do the above process. Actually I created a new column in database. After that I'm facing issue when I'm sending mail to others. I'm getting 'Service Failure Exception' while sending mail to other. For adding new column in database need to add details or code any where in the source. Please help me in this, is it possible in Zimbra or not.

    Thanks & Regards

    Sai Mohan

  3. #3
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,437
    Rep Power
    56

    Default

    You should not modify the Zimbra database, you may break your install and it probably will get wiped out during an upgrade - changes are not guaranteed to be kept.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  4. #4
    saimohang is offline Junior Member
    Join Date
    May 2012
    Posts
    8
    Rep Power
    3

    Default

    Hi Bill,

    Thanks allot for your reply, So is there any other way to update custom zimlet value in database. Actually in my scenario I need to store one value in the database this updated value can be used in Open ERP while pulling mails to Open ERP. Please let me know if any other way to do the process. Actually I done some process as below,

    1) Created zimlet with Proper UI button, Archive with check box and unchecked box image in compose window.
    2) I added handler object to interchange the images when user clicks on the button its working fine.
    3) Once user select unchecked image then in database I need to change the Boolean value to '1' (default I set this value to '0') in mail_item table for column archive_status (this I created newly added in "create_database.sql" file for mail_item table creation). I can able to update this value in database using JDBC. But when try to send mails to others I'm getting 'Service Failure Exception'.

    Please let me know if any other way to do this process. And when we try to pull the mails to Open ERP then we restrict mails will not to be import those are mails with Boolean value as '1'.

    Thanks & Regards

    Sai Mohan

  5. #5
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,437
    Rep Power
    56

    Default

    Unfortunately I'm not a developer so I can't help you with your question. Is this a zimlet you're developing? If it is I'll move this thread to the correct forum.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  6. #6
    saimohang is offline Junior Member
    Join Date
    May 2012
    Posts
    8
    Rep Power
    3

    Default

    Hi Bill,

    Once again thanks allot for your quick reply.

    Yes Bill, I developed a Zimlet to do this process, I think it is the best way to resolve as of my knowledge with less awareness in zimbra develoment. Please help me if any alternate solutions you found in any forum. It would be very thankful to you if you show me a way to solve this issue.

    Thanks and Regards

    Sai Mohan

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Update Database after upgraded to 7?
    By bhwong in forum Administrators
    Replies: 0
    Last Post: 05-06-2012, 06:18 PM
  2. Replies: 0
    Last Post: 01-19-2012, 12:26 AM
  3. Replies: 0
    Last Post: 01-19-2012, 12:26 AM
  4. Status Update?
    By soxfan in forum VMware Zimbra for Android
    Replies: 6
    Last Post: 10-05-2011, 01:32 AM
  5. can clamav update the virus database automatically?
    By nxzwt in forum Administrators
    Replies: 1
    Last Post: 02-01-2007, 12:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •