Cases with a custom ID

💬 General Discussion
1

Hi

I have been evaluating SuiteCRM recently and I am now looking at the Cases section with a view of migrating all the tickets from our existing support solution (Kayako) into SuiteCRM.

I want to have a customer Case ID that is in a similar format. AAA-XXX-XXXXX
Where AAA are three letters from A-Z
XXX and XXXXX are numbers.
The ID is unique

Can this be done in SuiteCRM? and if so how.

Of course I expect the Case ID in the table to be a autonumber integer.

But the ID the contact would see on the email threads would have the custom (unique) ID as above.

Is this possible?

2

If you mean simply to ask whether you can import those ID’s the answer is Yes. SuiteCRM will use whatever unique Id’s you put in the database, the default UUID format (like 8602ef08-daf1-ba8c-7e77-58ee0bc96451) is not required.

If you want to keep that format in the future, even for Cases created with SuiteCRM, you need to customize some code, to intercept the place where that UUID is being created (for Cases) and make it use some different string.

So - it’s possible, but you’ll have to look for the place where that happens and do some (simple) coding.