email in DB in the new sugar

[kazu182]

Hi there,
I am working on migrating our current sugar (4.1) to the new version (5.0) and I was wondering if anyone had similar issues in the new email style in the mysql db.

In my old sugar db for example, in the leads table, there are the fields 'email1' and 'email2' ... same thing for the "users" table.

However, simply importing these fields doesn't seem to work in the new versions (email lists shows up empty).

I looked into the new db, and I noticed that these fields were missing in the new tables from 'Leads' 'users' and likely other tables that had an email field

Is there a way to correctly migrate the emails in the old sugar across this new sugar structure?

Any input of this will be of great help !


thanks

[susiewilliams]

Hi there,

The wiki has the exact info you're looking for:
http://www.sugarcrm.com/wiki/index.p...address_change

I would also recommend checking out the new Developer website (http://developer.sugarcrm.com) for other information that may be useful to you.

[al3]

This might have been overlooked on part of the developers.

I did an upgrade to 5.0 on a local machine that worked fine... the email1 and email2 fields were still in the Account table.

However I did a clean 5.0 install on a server. It did NOT include the 2 fields into the new schema. When I tried to populate my MySQL database from local to server via mysqldump, I got an error... and it could not find the two fields.

I had to add them manually (phpMyAdmin) to the server database in Accounts, Leads, Contacts.

The upgrade should have deleted the email fields so the old schema would be consistent with a fresh-install schema.

Maybe there was a better way to populate my database then a dump? Is there an export database function somewhere?

Al