How do i generate new project_id

[Chris1981]

Hey All,

I am trying to create a little system that automatically changes a Quote into a Project when its status is "Approved"

The only bit i am stuck on is how the product_id gets generated... in my Save.php for the Quotes module i have started building the array of info that gets passed from the Quotes table into the Projects table but im stuck on the damn project_id.

Is there a function that makes a correctly formatted id that i could call?

Any input would be greatly appreciated.

Cheers peoples

[kuske]

In inlude/utils.php you find the function needed:

/**
* A temporary method of generating GUIDs of the correct format for our DB.
* @return String contianing a GUID in the format: aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee
*
* Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
* All Rights Reserved.
* Contributor(s): ______________________________________..
*/
function create_guid()

It returns a unique ID which can be used for every object.

[GameboyRMH]

Just thought I'd mention that Studio doesn't allow you to create a field with a name containing "project_id" (and a few others) and if you try this it won't save. Chances are there's a real problem with using such names so if you manually created one with "project_id" in the name, that might cause a problem.

[Chris1981]

How does the project_id get generated when you enter a brand new project ... i could just copy that process?

[dtokeefe]

include/utils.php

function create_guid()

[Chris1981]

Hey .. Thanks for that.

I gave it a quick go using just a test script as follows

 <?php
  require_once('include/utils.php');
 
  $Test = create_guid();
 
  echo $Test;
?>  

and i got an error message on the screen saying

Not A Valid Entry Point

Is there a way i can get past this, or do i have to include another file etc

Cheers,

[kuske]

At the start of every Sugar php file you find one line which ensures that only access can be done through the Sugar application and not someone randomly accessing one of the Sugar files.

This line looks like:

if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');

So I recommend to look in the WIKI how own modules must be designed, or better to the book (sugarCRM Developer's Manual p. 193 pp) and folow all rules for correct module design. If doing so you can call sugar-utils-functions.
No fear, it's really very simple.

good luck