Search results by user ID 2196

Re: Importing Leads

DBMeador — Fri, 05 Jun 2009 21:25:03 GMT

I was not using the spreadsheet you sent me. I tried doing so just now and got the same error.

Re: Importing Leads

DBMeador — Fri, 05 Jun 2009 19:58:17 GMT

Ok. Figured it out.

Problem: There were comma's contained in one, and in some cases, two fields. The comma creates a separate record. This was a problem in both the Name field where I was entering them as "Last, First" and in the Company filed where there some listings such as "ABC Company, LLC".

Solution: Remove all comma's. This is mildly annoying in the name field as we like to sort our customer lists by last name and not having the comma makes this confusing. I simply re-entered as "First Last" and we'll get by. Is there a work around for this limitation?

Re: Importing Leads

DBMeador — Fri, 05 Jun 2009 19:15:42 GMT

Ryan,

I realized that after I posted the above, added the name field, and get the same error one number higher (25 fields, 26 records.)

Also, I've tried eliminating various combinations of columns to see if one in particular was causing a problem. I got the import to work with the Name and LeadSource columns only in the table. A word to the wise, however, once a record exists in the Method database, it doesn't like it when you try to import an expanded list with duplicate records contained. I had to go in and delete all the records I imported before trying again. There needs to be some type of "what to do with duplicates" or "check for duplicates and ask me what to do" or "import duplicate records yes/no" type of functionality built in to the API tool.

This is only an issue when importing a large list. Best work around is to test import with only one or two records until you're sure it's working properly.

What should I try next?

Re: Importing Leads

DBMeador — Fri, 05 Jun 2009 16:34:13 GMT

Ok...bringing the off set discussion back to the forum...

After emailing the list, here is Ryan's response:

Dale,

Paul sent me the spreadsheet you submitted for us. It looks like some of the column headings are not actually fields on the table you’re trying to import to. You need to create these fields on the table before you will be able to import them. Go over your information that you want to import and confirm that you have a field on the table for each column.

Ryan Bell

Business Systems Consultant

Method Integration

I have double checked my fields and can't find one missing, however am still getting the same error as before. Here is a table of the column headings in my list I'm trying to import. They seem to all be there...what do I try next?

Number	Field is contained in DB?	Field Name
1.	Yes	LeadSource
2.	Yes	ParentEntityName
3.	Yes	CompanyName
4.	Yes	ShipAddressAddr1
5.	Yes	ShipAddressCity
6.	Yes	ShipAddressState
7.	Yes	ShipAddressPostalCode
8.	Yes	BillAddressAddr1
9.	Yes	BillAddressCity
10.	Yes	BillAddressState
11.	Yes	BillAddressPostalCode
12.	Yes	FirstName
13.	Yes	MiddleName
14.	Yes	LastName
15.	Yes	GovPerson2
16.	Yes	GovPerson3
17.	Yes	GovPerson4
18.	Yes	TradeName1
19.	Yes	TradeName2
20.	Yes	TradeName3
21.	Yes	TradeName4
22.	Yes	IsProfitCorp
23.	Yes	UBI
24.	Yes	IsActive

Re: Importing Leads

DBMeador — Thu, 28 May 2009 00:53:45 GMT

Ryan,

I am attempting to follow these directions and am getting an Import Warning:

Error from the MethodAPI at row 2:

The number of fields (24) do not match the number of values (25).

I'm sure it's something simple...can you help?

Dale