Data delete problems

[Echoreef]

i am using sugar 4.2.1a open source, and have configured it to the needs of my company, whilst i was builiding this system i entered some test data, when i came to delete all this test data it was still showing on the dashboard, i have gone into repair and deleted the cache files, but it still shows on the dashboard.

i am under pressure to load new data and upload the system for formal presentation but cannot do so until dashboard and pipelines are clear of erroneous information.

HELP HUGELY APPRECIATED BY A SEVENTEEN YEAR OLD NEWBIE!!!!!!!!!!!!!

[kbrill]

Are you getting rid of all data or just a subset of the data?

[Echoreef]

thankyou for the response i am trying to get rid of all test data, before i load up actual data any chance you can help??

[kbrill]

The easiest way is to install a new copy of sugarcrm with a different database name and get it working (no custom stuff, just standard install with no test data)

then edit your live versions config.php file and point it at the empty database.

then delete the other copy of SuagrCRM and that should do it.

[Echoreef]

can you talk me through this process in a more step by step way, also i have made large alterations within the "admin·" of sugar, these changes cannot be remade before i have to present, i wish to get rid of the data on my current adapted sugar, not start again.

ANY IDEAS?????

[kbrill]

when you say "large alterations within the "admin·" " do you mean programming changes, database changes or you have just editted the settings on the admin page?

You could also just use mysqladmin to empty the data tables (ie contacts, accounts, opportunities etc...)

[Echoreef]

by alterations i mean the fields on the individual pages, i have changed for example instead of the accounts tab being accounts it is now the flights and hotels information tab, so all the fields have been changed on most of the pages, and dropdowns etc hav been made, very little has been changed in the codes, just changing what shortcuts appear on individual pages.

what i want is my sugar system the exact same to what it is without the data that is currently showing on the dashboard, in reference to your suggestions could u break these down to step by step guides, i am very much so a newbie with computers let alone with sugar.

[kbrill]

I wouldn't attempt this if you don't have an understanding of the database structure. One mistake and you could ruin the install. Personally I would find someone to do it for me (place an ad in classifieds).

In order to do it you would need to know how to access your mysql database directly through the CLI or through a program like phpMyAdmin.

the CLI is accessed from a root login and type 'mysql -u username -p'

then after you are logged in type 'USE databasename' of course replacing databasename with the name of your sugarcrm database.

then run this code (I do not guarentee this AT ALL, do this slowly and check each table to make sure it's not data you want to keep, again I would get an expert to backup your system and clear it correctly)

TRUNCATE `accounts`;
TRUNCATE `accounts_audit`;
TRUNCATE `accounts_bugs`;
TRUNCATE `accounts_cases`;
TRUNCATE `accounts_contacts`;
TRUNCATE `accounts_opportunities`;
TRUNCATE `bugs`;
TRUNCATE `bugs_audit`;
TRUNCATE `calls`;
TRUNCATE `calls_contacts`;
TRUNCATE `calls_users`;
TRUNCATE `campaigns`;
TRUNCATE `campaigns_audit`;
TRUNCATE `campaign_log`;
TRUNCATE `campaign_trkrs`;
TRUNCATE `cases`;
TRUNCATE `cases_audit`;
TRUNCATE `cases_bugs`;
TRUNCATE `contacts`;
TRUNCATE `contacts_audit`;
TRUNCATE `contacts_bugs`;
TRUNCATE `contacts_cases`;
TRUNCATE `contacts_users`;
TRUNCATE `documents`;
TRUNCATE `document_revisions`;
TRUNCATE `emailman`;
TRUNCATE `emails`;
TRUNCATE `emails_accounts`;
TRUNCATE `emails_bugs`;
TRUNCATE `emails_cases`;
TRUNCATE `emails_contacts`;
TRUNCATE `emails_leads`;
TRUNCATE `emails_opportunities`;
TRUNCATE `emails_projects`;
TRUNCATE `emails_project_tasks`;
TRUNCATE `emails_users`;
TRUNCATE `email_marketing`;
TRUNCATE `email_marketing_prospect_lists`;
TRUNCATE `email_templates`;
TRUNCATE `feeds`;
TRUNCATE `inbound_email`;
TRUNCATE `inbound_email_autoreply`;
TRUNCATE `leads`;
TRUNCATE `leads_audit`;
TRUNCATE `meetings`;
TRUNCATE `meetings_contacts`;
TRUNCATE `meetings_users`;
TRUNCATE `notes`;
TRUNCATE `opportunities`;
TRUNCATE `opportunities_audit`;
TRUNCATE `opportunities_contacts`;
TRUNCATE `project`;
TRUNCATE `project_relation`;
TRUNCATE `project_task`;
TRUNCATE `project_task_audit`;
TRUNCATE `prospects`;
TRUNCATE `prospect_lists`;
TRUNCATE `prospect_lists_prospects`;
TRUNCATE `prospect_list_campaigns`;
TRUNCATE `tasks`;

[Echoreef]

thanks for ur help will let u no how i get on

[Echoreef]

had a brainwave used php myadmin, deleting each peice of data one by one (no mass updating particularly tedious), and it worked perfectly thanks for all your help u have saved me 6 weeks intensive work, for future reference if the same problem occurs using php myadmin is the way to go it is also very user friendly hence i managed to do this on my own.