Method:Classic General Q&A

Re: mass update to records

swm023 — Mon, 23 Jan 2012 21:29:38 GMT

So I imported a file with RecordID and ProbabilityPercent (I'm updating probability percents). Everything imported properly but in order for my pipeline to calculate properly I have to go into each individual opportunity record and click inside the ProbabilityPercent box. This defeats the whole purpose of doing a mass update. Is there a way to get my pipleine to calculate without going into every single opportunity one-by-one?

Re: mass update to records

Method_Paul — Sat, 21 Jan 2012 12:51:55 GMT

To be safe, ALWAYS use the RecordID if you are able to. Guaranteed to be unique.

Paul

Re: mass update to records

swm023 — Fri, 20 Jan 2012 17:43:43 GMT

Great. Thank you. What is the key field I need to use in order to update the opportunity table?

Re: mass update to records

Anonymous — Tue, 17 Jan 2012 22:45:45 GMT

Hi swm023,

The best way to update the leads is to first export the customer table as well as its fields that you want to update in the format of .csv.

You will then be able to import the updated information back into that table. Its best that you export the RecordID field since it is considered the key field as well as the FullName so you can see which user you are updating.

I would also recommend that you watch the following webinar to give you a better understanding of the import/export process within Method CRM:

http://www.methodintegration.com/resources/webinars/CommunityWebinar28IntegrationToolsImportExport.wmv

I hope that helps.

Re: mass update to records

swm023 — Mon, 16 Jan 2012 23:15:46 GMT

Customer table. I'm trying to do a mas update to my leads.

I also want to do the same for opportunities.

Re: mass update to records

Anonymous — Mon, 16 Jan 2012 22:19:24 GMT

Hi swm023,

I wanted to confirm a few things first:

Are you trying to import into the Contacts table or the Customer table?

I need to confirm which table you are trying to import into first.

mass update to records

swm023 — Fri, 13 Jan 2012 22:00:40 GMT

What is the easiest way to do a mass update to leads, opportunites, etc.

I assumed that I could import an excel file with the information that I wasnt to update. I tried to do that for my leads. I created a file with FirstName and Name (the required fields) and 2 other columns for fields that I wanted to update. Upon updating, however, I received an error message that the contact couldn't be updated because it already existed and I needed to make it unique and try again.

Is there another way to do a mss update or am I doing something wrong?