Results 1 to 2 of 2

Thread: Inserting Opportunites

  1. #1
    emanresu is offline Sugar Community Member
    Join Date
    Dec 2005
    Posts
    47

    Default Inserting Opportunites

    We use a custom programme to insert new opportunities from our website into opportunities which works well. Have used UUID() to generate the unique ref that Sugar needs and NOW() for the posting date.

    Just a couple of quick questions on how to update the Account field (Lookup table?) and the Date_Closed field. Has anyone succeeded in updating these fields from outside Sugar


    Sugar Version 4.5.1b (Build 1246)
    Shared Unix server

  2. #2
    roblaus's Avatar
    roblaus is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Vienna / Austria
    Posts
    2,850

    Default Re: Inserting Opportunites

    Hi,

    Account: you must create a new record in accounts_opprtunities that contains its own uid, the id of the account and the id of the opportunity, the date modified and tinybit for deleted yes/no (0/1)
    Date: Just insert it as 'yyyy-mm-dd hh:mm:ss' There is a space between dd and hh.

    rgds
    rl
    __________________________
    Robert Laussegger
    http://www.iscongroup.net

    Bei Fragen: support@iscon.at
    Die deutschen Sprachdateien für SugarCRM und das deutsche Handbuch gibt es hier: http://goo.gl/kPsAz
    Ab sofort auch mit 6.4.2

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 2006-12-26, 02:31 PM
  2. Inserting new leads via external form
    By rbarrero in forum Developer Help
    Replies: 4
    Last Post: 2006-07-28, 09:49 PM
  3. Inserting new leads via external form
    By rbarrero in forum General Discussion
    Replies: 0
    Last Post: 2006-07-27, 10:37 PM
  4. Replies: 4
    Last Post: 2005-08-28, 12:29 PM
  5. Replies: 0
    Last Post: 2005-02-18, 08:39 PM

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
  •