Hi all
I'm new to roundcube and i'm trying to set up a new server.

I have a lot of mailboxes (near 10k) with an old webmail (groupoffice) and I have to replace it with roundcube.

No issue installing roundcube and configuring it, it's working great. But I have to migrate the addressbooks from groupoffice to roundcube

I didn't find a migration script, so I have to write it on my own.

Please tell me if my assumptions are ok:

1. i batch-insert all email users to roundcube "users" db table (last_login and preferences empty)
2. add a contactgroup with the user_id taken from the users table
4. batch-insert all contacts from the old server addressbook to the contacts table, using the user_id taken at step1. The address book is mostly a vcard stored as text in "vcard" column, plus email,firstname,surname exposed in dedicated fields. What's the "name" field ?
4. batch-insert the relation between contacts and contactgroups in the table contacgroupmembers

Is this correct ?

Hello, please help if you can. I created a responce and have that working but the URL I wish to include is not a clickable link, is there a way to fix that

Check the Roundcube error log at <RC root>/logs/errors

Up please

Certainly! It depends on your email client. Some offer auto-complete from your address book, but it varies. Check your client's settings or help documentation for specifics.