Auto-generate numeric username

Does CB support auto-generation of numeric username?

My client already has a list of members, each is assigned a unique membership ID (numeric). If I manually import the existing members to CB, can it do the following for new members?

1. Membership is paid annually (possibly using CB + SB Subs)
2. Hide username field from registration form
3. Once registration process is completed, username will be automatically generated based on the last membership ID. For example, if the last member's membership ID is 1200 then the new member will be assigned 1201 and so on.
4. Members will log in using their membership ID and password

I found 2 old posts discussing similar issue but I can't conclude if they will solve my current problem, especially #3 above. There should be some kind of counter that keep track the last membership ID generated.

www.joomlapolis.com/forum/154-advanced-members-support/151682-solved-can-i-use-this-hack-for-email-as-username#151682
www.joomlapolis.com/forum/159-wishlist/152046-numeric-usernames--numeric-membership-ids

No one? I assume this is not possible then?

CB allows to autogenerate username from Email at registration.

That's not exactly my question. I need auto-increment numeric username. Is this possible with CBSubs + any of the add-on/incubator project?

Probably the CB Queries from incubator could be your solution here:

www.joomlapolis.com/cb-solutions/incubator

Execute fully customizable database queries when CB events happen. This tool can be used to provide rudimentary integration with other bridged scripts. You can even connect to external host databases!

Using the on after new user creation and on after registration events you could set jos_users-username = jos_users.id

And not show username at registration, so that cb auto-fills it based on email before your trigger sets it to id.

I didn't try above, but it might work, if your joomla version accepts such all-numeric usernames. Otherwise prefix in the query with an alphanumerical character.

Thanks! That sounds doable. I'll go ahead with the purchase once my client approve the budget