Inserting Accounts from SQL

[Mikeyg79]

I'm trying to setup a demo of SugarCRM for the head of support at my company. What I'd like to do is pull our client data from a junky FileMaker database (I've done this already) and insert it into the SugarCRM database.
I think I can do it just fine, but I don't know how the unique IDs are created. Anyone have that little routine handy?

[roblaus]

As an example:
INSERT INTO sugarcrm.prospect_lists_prospects(
id,
prospect_list_id,
related_id,
related_type,
date_modified,
deleted
)
SELECT uuid( ) , '1092bfe6-314b-a3e8-c10a-4810863c6943', sugarcrm.leads_view1.id, 'Leads', now( ) , 0
FROM sugarcrm.leads_view1