SugarCRM Forums

Invalid Value: Expected Close Date in popup of Opportunity module

newroseji — Tue, 21 May 2013 21:49:07 GMT

Hello,
I am using Sugarcrm version 6.2.4. I have a Create Opportunity button in Opportunity popup for most of the modules where users can create new Opportunities. But, for some reason the Expected Close Date field keeps on showing error (like in the screenshot) when try to Save the record. It shows Invalid value: Expected Close Date if we put valid mm/dd/yyyy formatted date. However, if we put YYYY-MM-DD it validates but the date do not saves in database. The default date format that this very Expected Close Date field is taking mm/dd/yyyy. On the contrary, I can create Opportunity in traditional way and in sub-panel of detailView of Account.

Please, let me know what could be the issue and how can we solve it? I am sure there are lots of other developers facing the same issue.

Attached Images

REST, but without LDAP

urs.pamp@gmail.com — Tue, 21 May 2013 13:14:37 GMT

Hi!

We're having a SugarCRM instance here, that is connected to a LDAP server. Every user account, except the default "admin", was created through the LDAP connection.
Now, we want to pull data through the REST PHP (as mentioned here: Retrieving a List of Records - REST and PHP - SugarCRM Support Site). We noticed that it was not possible to access the data through the LDAP-accounts, so we decided to use the default "admin". Now we heard from our IT Devision that the LDAP log was full of failed connects with the user "admin". So SugarCRM wants to authenticate the user "admin" through LDAP, which is stupid. The same thing happens with local SugarCRM accounts.
The only setting I found that COULD deal with this problem was disabling "LDAP Authentication Only" in User Settings which did not the trick.

Does anyone know how to handle this problem?

Thank you!

How to Add Relationship Through Rest In SugarCRM

madhusudan2291 — Tue, 21 May 2013 13:05:59 GMT

Hi
I am using one-to-many relationship between Contact And CountryCity Module And I need to add a relationship to this using REST,

I have used following code to create a relationship between these two

$url = "localhost/RealEstateAgentCRM/service/v4/rest.php";

$username = "admin";
$password = "admin";
function call($method, $parameters, $url)
{
ob_start();
$curl_request = curl_init();
curl_setopt($curl_request, CURLOPT_URL, $url);
curl_setopt($curl_request, CURLOPT_POST, 1);
curl_setopt($curl_request, CURLOPT_HTTP_VERSION, CURL_HTTP_VERSION_1_0);
curl_setopt($curl_request, CURLOPT_HEADER, 1);
curl_setopt($curl_request, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($curl_request, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curl_request, CURLOPT_FOLLOWLOCATION, 0);
$jsonEncodedData = json_encode($parameters);
$post = array(
"method" => $method,
"input_type" => "JSON",
"response_type" => "JSON",
"rest_data" => $jsonEncodedData
);
curl_setopt($curl_request, CURLOPT_POSTFIELDS, $post);
$result = curl_exec($curl_request);
curl_close($curl_request);
$result = explode("\r\n\r\n", $result, 2);
$response = json_decode($result[1]);
ob_end_flush();
return $response;
}
$login_parameters = array(
"user_auth"=>array(
"user_name"=>$username,
"password"=>md5($password),
"version"=>"1"
),
"application_name"=>"RestTest",
"name_value_list"=>array(),
);
$login_result = call("login", $login_parameters, $url);
$session_id = $login_result->id;

$parameters = array(
'session' => $session_id,
'module_id' => '3671da49-2d13-aa21-7h49-519b11dgu34', // This is a contact Id
'module_name' => 'Contacts',
'link_field_name' => 'contacts_veon_country_city_list_1',
'related_ids' => array('3904da49-2d13-aa21-72a9-519b11d43b02'), // This is a City-Country id
);

$add_relationship_result = call("set_relationship", $parameters, $url);
print_r($add_relationship_result);

?>

Regards

Madhusudan Singh

modified the LDAP-settings -> locked out

urs.pamp@gmail.com — Tue, 21 May 2013 11:18:52 GMT

Hi!

Due to our IT support I had to do some changes to our LDAP config in SugarCRM. After saving the settings I was locked out of the system (even with the default "admin" user). I wanted to reset the LDAP settings so i googled and learned that the settings were stored in the DB in the table "config". So opened MySQLWorkbench and connected to the server and opened the table. I noticed that I wasn't allowed to do any changes in that table. In all other tables I'm able to modify the values.

Now, how can I reset the necessary LDAP settings? How can I make changes to the "config"-table?

Thanks in advance! I'm hoping for a quick answer...:)

How to add "Web to Lead form" with multiple product enquiry

cent — Tue, 21 May 2013 10:55:07 GMT

Dear Friends and Mahi,
I need to create a web to lead form . I plan to add a "One to Many" relationship in lead module to add multiple product as subpanel. But my doubt is
how to implement same in "Web to lead" form . Because i believe subpanel entry not show in "Web to lead" creation form . please advise me with a
solution.

Thanks,
Anes

How to change color of date when date have been Expired

ckander — Tue, 21 May 2013 05:03:56 GMT

Hi friends
I want some help about this

Case study is that I have been add new field(Date) in module , that date is showing Expiry date

Need Help : when date is expire date must change the color in List view and Detail view when date is expire
expiry duration is one year

Thanks in advance

Looking to hire somebody to customize SugarPro for us.

asia@openspectruminc.com — Mon, 20 May 2013 23:01:06 GMT

We currently have a self hosted SugarPro account setup that is 80% of
the way tweaked to how we need it to provide our team optimal
support/value. We have everything we need Sugar to do outlined and
documented... fields, equations, reports... simply need someone to
spend some time to make it all work as we're finding it's taking us
10x longer than we know someone who knows what they're doing would
take. If you know anyone familiar with making tweaks to Sugar that can
crank this stuff out quickly who wants to make some extra cash working
a few hours on this, please send them our way!

Will be mostly "get in and make the thing function how we need it" and
less strategy around process as we've already spent the time to think
through how we need things to operate within the system.

Does anybody here do that kind of thing?

Modulo de prestamos notificacion via mail

themian — Mon, 20 May 2013 22:55:56 GMT

Hola,

tengo un modulo que maneja un inventario de equipos, quiero realizar un modulo de prestamos. que notifique via mail cuando la fecha del prestamo caduque. es posible realizar esto �?

Saludos
muchas gracias por su ayuda.

Quick create opens in a new page without formatting

LaFortuna — Mon, 20 May 2013 21:44:52 GMT

Hi there,
After bringing a perfectly working instance of 6.5.12 CE into a new server I get a strange response (Chrome, Firefow and IE) when using the quick create buttons. Sugar does not expand the submodule but opens a new page on the same window with the form to be filled. (screenshot attached).

The server runs on CentOS 5.5 with php 5.3.25

I have tried:
- chmod -R 775 cache modules custom data
- Installing APC caching
- Restarting the server

For some reason, this instance also has problems displaying the studio an module builder in Chrome. It works OK in IE.

Thanks for your ideas.

Attached Images

View various revisions of audited field in KReporter report (Read from Change Log)

nnanna@cobranet.org — Mon, 20 May 2013 20:03:48 GMT

Hello,

I am wondering if there is a way to view various revisions of an audited field in a KReporter report for same row.

Let me give an example to explain.

I added auditing for "Description" field of the Cases module. I did this because with various edits of the Case, the Description would evolve (the way I intend to use it). Now I am wondering if it is possible to create a report that will have the various updated descriptions, this will mean it has to read from the Change Log.

I don't know if this is clear enough. Your help is appreciated.

Thank you.

Role Module List

Spectrum Merchant — Mon, 20 May 2013 19:21:17 GMT

I am trying to set up my Roles and when I am setting up the modules for each role, I do not know what each one is. Is there a list of definitions that explain what each one is. The far left column has all of the modules that I don't know what they are. Accounts, bug Tracker, Calls, Campaigns, Cases, Contacts, Documents, EAPM, Email Marketing, Email Templates, Emails, Leads, Meetings, Notes, Opportunities, Project Tasks, Project, Target List, Targets, Tasks are what is listed when I create a role and save it.

Please be kind as I am very new to this sort of thing. Thanks

sugarcrm eShop

ksharifi — Mon, 20 May 2013 19:17:58 GMT

hello everyone
i'm newbie to sugarcrm, i am looking for a crm and eshop in single bundle, i want to ask have sugarcrm built in eShop ? or i must looking for an eShop that compatible with sugarcrm ?
thank you.

Eshop integrate with sugarcrm

ksharifi — Mon, 20 May 2013 18:38:56 GMT

hello everyone
i am looking for both CRM and Eshop in single bundle, i want to know did you Know an open source eshop that compatible and good integratation with sugarCRM ?
thank you.

Change Color when check box is ticked?

jayo2005 — Mon, 20 May 2013 17:52:43 GMT

I have a questionnaire created and it contains some check boxes. I would like the checkbox and text to change color when ticked. Any idea how to accomplish this?

FlexRelate Parent field for SugarCRM

nnanna@cobranet.org — Mon, 20 May 2013 16:01:27 GMT

Hello,

Is there a way to safely change the Relate field (which relates to Accounts) in the Cases module to a FlexRelate field which will work (like the one in the Tasks module)?

I created a custom module similar to the Accounts module (it contains records like accounts, but is separate) for which I would haveto create Cases, and would rather use a parent flexrelate than create another standalone Relate field.

Your help appreciated. Thank you.