inbound_email table : id needed

[nmctech]

Hi,

We've a scenario where we want to populate the database for all our users as we want to migrate from an existing database. One of our requirements is we want to populate the inbound_email settings for everybody in the database.

I've figured out how to encrypt the email_password but the 'id' field in the inbound_email table mystifies me. I don't know how it is getting created or if I create any random alpha numeric number, it will work.

I understand a 32 bit id is created every time any user creates an inbound mail account. Also if we add to the inbound_email table, is it sufficient or other tables need to be affected as well?

I'm using 5.0.0e .

Thanks in advance !

[roblaus]

Hi,

You are talking about a so-called universal unique identifier which (theoretically at least) should be the only such string in this very world of ours. It is used to identify unique records and makes it (theoretically) possible to copy records from one DB to another without the need to change the ID. It's usually created by calling a function of the DB - I believe it's uuid() in the case of mysql.
This string identifies the inbound email account in Sugar and is also used in all other tables that reference to this particular account. Some but not all of them are:

email_cache
emails
inbound_email_cache_ts

rgds
rl

[nmctech]

Hi,

I tried playing around with uuid but that is not what SugarCRM is using. The 'id' field in inbound_email table and the other places where unique id's are being created like in the user table, SugarCRM is using some other function to create those id's based on the time stamps and/or username, first and last name etc.

If somebody could please tell me in this respect what those functions are (that are generating those id's), I would greatly appreciate it.

Thanks in advance !

Sourabh

[kuske]

It is a real uuid, even in inbound_email.
In thread http://www.sugarcrm.com/forums/showthread.php?t=25197 there are some remarks to the generation of the uuid in Sugar.
But you can take without any problems the mysql function uuid().