Inserting Opportunites

[emanresu]

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

[roblaus]

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