Page 1 of 4 1234 LastLast
Results 1 to 10 of 35

Thread: SugarCRM Excel Add-in

  1. #1
    Boossss is offline Sugar Community Member
    Join Date
    Jan 2008
    Posts
    19

    Cool SugarCRM Excel Add-in

    Hi,

    Here is NDNKoders first release of SugarCRM Excel Add-in.
    This is an easy way of building your Excel reports or extracting information from your Sugar Modules.
    I've added some of the chart's that I buit with this Add-in and with Excel's Dynamic Charts to this post's attachments.

    Please try it out and give us some feedback.
    We plan to have a final release early next year...

    For more information, videos and updates please visit us at http://boossss.wordpress.com

    In case the toolbar doesn't appear please run the registry file in the attachment RegFile.zip

    The sugarcrm url must be in the following format:
    http://<sugarurl>/soap.php


    This project is now available on SugarForge for download.
    Attached Images Attached Images     
    Attached Files Attached Files
    Last edited by Boossss; 2008-11-18 at 09:06 AM.

  2. #2
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: SugarCRM Excel Add-in

    Quote Originally Posted by Boossss
    Hi,

    Here is NDNKoders first release (Beta 1 - it has some bugs ) of SugarCRM Excel Add-in.
    This is an easy way of building your Excel reports or extracting information from Sugar.


    Please try it out and give us some feedback.
    We plan to have a final release early next year...

    For more information, videos and updates please visit us at http://boossss.wordpress.com

    Download SugarCRM Excel Add-in
    I have just installed it but I am not seeing a button for it in excel 2003

    Where will it show?
    Mike Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk]www.ivy.ltd.uk

    php version 5.2.6
    MySql 5.1.59

  3. #3
    Boossss is offline Sugar Community Member
    Join Date
    Jan 2008
    Posts
    19

    Default Re: SugarCRM Excel Add-in

    Hi Mike,

    I have updated my first post's attachments with the correct versions, please uninstall the version you have previously installed and install the new one. If the toolbar still doesn't show on the toolbar please run the file in the RegFile.zip

    These addins can always be found in the Excel's Tools->Add-Ins then select Automation and look for NDNExcelIDTE.Connect

    Sorry for the inconvinience it's the problem with Beta versions eheheheheh

    Thanks

  4. #4
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: SugarCRM Excel Add-in

    Quote Originally Posted by Boossss
    Hi Mike,

    I have updated my first post's attachments with the correct versions, please uninstall the version you have previously installed and install the new one. If the toolbar still doesn't show on the toolbar please run the file in the RegFile.zip

    These addins can always be found in the Excel's Tools->Add-Ins then select Automation and look for NDNExcelIDTE.Connect

    Sorry for the inconvinience it's the problem with Beta versions eheheheheh

    Thanks
    getting there

    now I enter the username & password & save
    I the restart excel & look at the saved info and it put the password in the username field and username in paswword field
    Mike Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk]www.ivy.ltd.uk

    php version 5.2.6
    MySql 5.1.59

  5. #5
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: SugarCRM Excel Add-in

    By putting username in password in wrong fields and saving it then shows the details correctly

    when i click on modules I get: The request failed with an empty response.
    Mike Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk]www.ivy.ltd.uk

    php version 5.2.6
    MySql 5.1.59

  6. #6
    Boossss is offline Sugar Community Member
    Join Date
    Jan 2008
    Posts
    19

    Default Re: SugarCRM Excel Add-in

    Hi Mike,

    I've corrected the username/password issue and updated the installation file in the first post's attachment's.....

    I only mentioned in my blog (http://boossss.blogspot.pt) that the sugarcrm url must be in the following format:
    http://<sugarurl>/soap.php

    Thanks for the feedback Mike.....

  7. #7
    kuske's Avatar
    kuske is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    Germany
    Posts
    2,597

    Default Re: SugarCRM Excel Add-in

    If you use your excel plugin with SSL and not authenticateds cerificates you get the error message

    The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
    Harald Kuske
    Pre-Sales Engineer Central Europe

    SUGARCRM Deutschland GmbH
    Erika-Mann-Str. 53, 80636 Munich, Germany
    Email: hkuske@sugarcrm.com
    Home: http://www.sugarcrm.com


  8. #8
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: SugarCRM Excel Add-in

    Quote Originally Posted by Boossss
    Hi Mike,

    I've corrected the username/password issue and updated the installation file in the first post's attachment's.....

    I only mentioned in my blog (http://boossss.blogspot.pt) that the sugarcrm url must be in the following format:
    http://<sugarurl>/soap.php

    Thanks for the feedback Mike.....
    All working now - thanks
    Mike Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk]www.ivy.ltd.uk

    php version 5.2.6
    MySql 5.1.59

  9. #9
    Boossss is offline Sugar Community Member
    Join Date
    Jan 2008
    Posts
    19

    Default Re: SugarCRM Excel Add-in

    Hi Kuske,

    We have not tried to use the Add-in with SSL I'll try to solve this issue and then I'll update the SugarCRM Excel Add-in.

    Thanks...

  10. #10
    Boossss is offline Sugar Community Member
    Join Date
    Jan 2008
    Posts
    19

    Default Re: SugarCRM Excel Add-in

    Quote Originally Posted by mikesolomon
    All working now - thanks
    Hi Mike,

    Thanks for the patience

Page 1 of 4 1234 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. some add on SugarCRM I wish to do...
    By martinsimard in forum Developer Help
    Replies: 3
    Last Post: 2007-11-17, 05:28 PM
  2. Replies: 61
    Last Post: 2006-10-22, 08:40 AM
  3. Cron - Sugar Log Error
    By aguerrave in forum Help
    Replies: 9
    Last Post: 2006-05-10, 10:57 AM

Bookmarks

Posting Permissions

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