Method:Classic General Q&A

Re: Deleting Imported Records

Method_Michael — Tue, 20 Mar 2012 13:40:20 GMT

emiller-

I was able to duplicate this. IsLeadStatusOnly is a special field that gets disabled once a customer is synced to QB. I will have to look into this further.

How many customers/leads did you import? If it wasn't that many it may just be easier to manually delete from in Method and re-import them with IsLeadStatusOnly set to true.

-Michael

Re: Deleting Imported Records

emiller — Mon, 19 Mar 2012 23:20:19 GMT

Okay, I tried that but the IsLeadStatusOnly is not available when I select update checkbox?

Re: Deleting Imported Records

Method_Valbon — Mon, 19 Mar 2012 20:11:59 GMT

emiller,

You defiantly don't want to delete the customer table since this table syncs with QB. In-fact you probably won't' be able to even if you wanted to. You are more concerned with the customer records in the table not the actual table itself.

Ok…a couple of very important concepts when importing leads. You must be absolutely sure to use the 'IsLeadStatusOnly' field otherwise you will be in big trouble sending your leads as customers. If you did not use this field, you might still be ok as long as the sync didn't take place since your import. You can use the same Import tool to update the records to include that field.

I'm going to ask you read an earlier post that might help you when importing leads (click here). Give that a read and let me know if you have more questions. If you need more help you can always contact us to seek consulting services for assistance.

Hope this helps.

Re: Deleting Imported Records

emiller — Mon, 19 Mar 2012 18:50:09 GMT

Table I'm dealing with is the customer table. I have the synch turned off so it's not trying to synch. I was trying to import these as leads and messed up. I saw there was the option to delete the customer table but was concerned this could mess something else up?

Re: Deleting Imported Records

Method_Valbon — Mon, 19 Mar 2012 17:36:13 GMT

Hi emiller,

Just curious, did you import these records using the Import tool? Or did they come in from QB during the sync? Also do you know what table are you dealing with?

Depending on the Method table involved this could be easy, difficult … or not possible at all. If the table is Method only data (a table that does not sync with QB) than you could:

delete the records manually
customize a screen to loop through the table and delete all records in that table

If the table does sync with QB, it might still be possible but could have other consequences. I would make sure nothing unexpected happens if you delete some of the records directly in QB first.

Important: if you were using this to test Method by syncing it with a sample file and now want to change the QB file to a different QB file to sync with … you should cancel this account and sign up for a new Method account.

Deleting Imported Records

emiller — Mon, 19 Mar 2012 16:39:12 GMT

Just getting up to speed on Method and imported some records we want to remove. What is the easiest way to clear all the customer info out of the Method database?