Error importing accounts - how do I start over with an empty accounts file?

[mcichelli]

I have installed Sugar Suite Version 4.2.0c on Windows 2003 Server using the complete install package from the sugarcrm.com website. That went well.

I have made a number of screen format changes and added several new fields. I exported data from our current system for accounts and imported it into SugarCRM. It looked good, but I want to make changes. How can I delete all of the Account data without losing any of my customizations of screens and fields?

[Danielg42]

I've got the same issue.
Any help would be appreciated.

[Markku]

One solution is to go into PHPMyAdmin, clear the accounts table and then re-import the accounts.

If you delete accounts in Sugar, it doesn't actually remove the data from the database. It does a soft delete, which means it just marks the record as deleted so that it doesn't show up in the app anymore.

[Danielg42]

Thanks!
Unfortunatly, I dropped the account table instead of just emptying it and now sugar won't start back up.
Does anyone know how many fields I need to put in the account table when initially creating it?

Edit: Never mind
I exported all my remaining data (minus the account table of course) and reinstalled, then dropped all tables except the accounts and imported my old stuff.
Thanks again for tipping me off about phpmyadmin.

[Markku]

OK, so you did solve the problem, right?

[Danielg42]

Yes. 10 Char