Importing Accounts with Custom Fields

[sgharp]

HI All,

Sugar Community Edition v5.2.0f
Category Accounts
Operating System openSUSE 11.1 x64
php version 5.2.9
Database MySql v5.0.67
Web Server Apache 2.2.10

If I do a clean install of SugarCRM, I can create accounts via the interface or import them without problems. However, when I create custom fields and attempt to import or create accounts via the interface, the accounts import without errors but don't show up in sugar. The new accounts are in the database but no records are created in the accounts_cstm table and nothing displays in sugar.

Is there a special process needed to import accounts with custom fields defined?

Here's what I've tried so far:

1. Installed SugarCRM CE 5.2.0f and created custom fields for Accounts.
2. Imported data from CSV. No errors but no accounts show up in Sugar.
3. Dropped database and restored original database without custom fields.
4. Imported data from CSV. No errors and no accounts show up.
5. Dropped database and restored original again.
6. Entered account manually via Sugar interface. Account didn’t show up.
7. Attempted search for newly entered account and got error “Retrieving record by id accounts:f0557f56-2c52-f34e-1a80-4a44cdb97274 found Query Failed:SELECT accounts.*,accounts_cstm.* FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c WHERE accounts.id = 'f0557f56-2c52-f34e-1a80-4a44cdb97274' AND accounts.deleted=0 LIMIT 0,1::MySQL error 1146: Table 'sugarcrm.accounts_cstm' doesn't exist”
8. Renamed sugar folder to sugar_old , created new sugar folder & copied new installation into new folder. Modified config.php to point to correct db and folder.
9. Use browser to go to sugar, login, page displays blank. I had failed to change owner of folders after root copied them.
10. Created new account manually. Not only did new accout show up but acct entered in #6 above also showed up.
11. Imported data from CSV without custom fields and all accounts showed up in sugar.

I really must be able to import with custom fields.

Thanks for any help...

[crmbalah]

HI
check the import module and customize the code

[roblaus]

@crmbalah: Even though you won't understand it: si tacuisses philosophus mansisses

@sgharp: I think you should not play too much with your data without actually being aware of the consequences. I will test the import but since I did one yesterday (52e) I am almost sure that it does work.
Once you create custom fields there are two components - the definition of the fields in yoursugarpath/custom/modules/yourmodule and the representation in the database (as _cstm). If you have a Sugar version with custom fields and you connect an original (non customized) database it can not work. You must run a check database (or a quick repair) before.

Will check back.

[crmbalah]

HI
try to insert the same id in accounts_cstm table
sample
run the following query into your database directly.
insert into accounts_cstm set id_c= '(SELECT id FROM accounts)'

[roblaus]

As I said - no problem at all. See the pictures and check whether you did it the same way (this is a brand new 52e)

[crmbalah]

HI roblaus

thanks for your information.