Method:Classic General Q&A

Re: Error message upon import attempt

CatWineUSA — Tue, 08 Nov 2011 23:53:01 GMT

Thanks. Good point and will do.

I may need your email address to send you the entire file at some point.

Tom

Re: Error message upon import attempt

Method_Michael — Tue, 08 Nov 2011 22:56:58 GMT

Tom-

I don't think it was anything you did wrong. If this does happen again, let me know and I can quickly go in and fix it again. (You will have to re-enable MethodSupport if your account is going to be reset).

-Michael

Re: Error message upon import attempt

CatWineUSA — Tue, 08 Nov 2011 22:09:07 GMT

Michael -

Thanks, it worked. Was there something I was doing wrong?

We may need your help again for the full list. Wayne and I have plans to purge Method of all customers and leads are re-populate it due to a problem with Quickbooks.

Tom

Re: Error message upon import attempt

Method_Michael — Tue, 08 Nov 2011 16:01:59 GMT

Tom-

It should work now! I imported the sample data that you posted on the forums. What I did was regenerate the table by editing it and clicking Finished Editing fields.

-Michael

Re: Error message upon import attempt

CatWineUSA — Tue, 08 Nov 2011 15:49:39 GMT

Thanks. I checked the box under "activate". Is that all I have to do?

Do you also need the spreadsheet?

Tom

Re: Error message upon import attempt

Method_Michael — Tue, 08 Nov 2011 15:09:10 GMT

Tom-

Can you enable MethodSupport under Customize > Users and I will login and take a look and try to import that data.

-Michael

Re: Error message upon import attempt

CatWineUSA — Mon, 07 Nov 2011 22:33:27 GMT

No luck - same message. Very strange and starting to become really frustrating. I appreciate your help, and really want this to work, but I can't afford to keep spinning my wheels - too much to do.

Here's what my screen looks like -

Integration Tools menu >> Import / Export menu >> Prepare Data >> Validation >> Fixing Errors

You had following errors. Please fix them and continue.

Vertical Horizontal

Update existing records by matching the key fields

Record	Error Message	Import?
2	Error:The array of insertion fields you have provided contains a field name more than once. Please make sure each MethodAPIInsert call contains a unique value for each item in the arrInsertFieldsArray array.	Do Not Import Import
3	Error:The array of insertion fields you have provided contains a field name more than once. Please make sure each MethodAPIInsert call contains a unique value for each item in the arrInsertFieldsArray array.	Do Not Import Import
4	Error:The array of insertion fields you have provided contains a field name more than once. Please make sure each MethodAPIInsert call contains a unique value for each item in the arrInsertFieldsArray array.	Do Not Import Import
5	Error:The array of insertion fields you have provided contains a field name more than once. Please make sure each MethodAPIInsert call contains a unique value for each item in the arrInsertFieldsArray array.	Do Not Import Import

Re: Error message upon import attempt

Method_Michael — Mon, 07 Nov 2011 19:52:03 GMT

Tom-

It should work for 1000 records.

To import using clipboard for option 1 of import/exporting select Import into a table from the clipboard.

-Michael

Re: Error message upon import attempt

CatWineUSA — Mon, 07 Nov 2011 17:48:18 GMT

There's nothing different to my knowledge about this csv file.

How do you import from the clipboard?

If it works, do you see any issue doing so with a much larger file (1000 entries instead of 4)? I ask because this is simply a test to make sure I have the file set up properly. It if does, I need to import the same data from the larger file.

Re: Error message upon import attempt

Method_Michael — Mon, 07 Nov 2011 17:09:42 GMT

Tom-

I am unable to duplicate that exact message, even when I set columns name to have the same name or import into the same field.

What if you try import from clipboard? I used the sample data you gave me and pasted into the copy utility and it imported fine without any errors. I wonder if there is something potentially off with the CSV file, is there any thing special about this CSV file?

-Michael

Re: Error message upon import attempt

CatWineUSA — Mon, 07 Nov 2011 16:08:46 GMT

I thought that was a pretty good idea, but unfortunately it didn't work. I changed all three columns in which "name" was a separate word, and don't see any other similar conflicts.

Re: Error message upon import attempt

Method_Michael — Mon, 07 Nov 2011 14:31:43 GMT

Tom-

Try renaming removing the spaces from the headers. For example change Company Name to CompanyName, First Name to FirstName etc. Let me know if that addresses the issue.

-Michael

Re: Error message upon import attempt

CatWineUSA — Sun, 06 Nov 2011 15:41:54 GMT

That was my first guess - that I'd missed something in that respect - but no, there are no duplicate columns. I got your second point as well regarding blank columns, and dropped the "website" column for that reason as none of the four I was testing had websites, but the results were still the same. Here's what the data looks like. Hopefully it helps you.

Company Name	First Name	Last Name	Name	BillAddressAddr1	BillAddressCity	BillAddressState	BillAddressPostalCode	Phone	LocationVolume	IsLeadStatusOnly
2 Stop Beverage Shop	Manuel	Rodriguez	Manuel Rodriquez	37565 Colorado Ave	Avon	OH	44011	(440) 934-6141	$646,000	TRUE
102 Bottles-Beer On The Wall	Justin	Clemens	JustinClemens	115 N Willow St	Kent	OH	44240	(330) 677-9444	$1,938,000	TRUE
128 Liquors Inc	Adam	Crawford	Adam Crawford	9110 Louisville Rd	Salvisa	KY	40372	(502) 839-9547	$1,292,000	TRUE
Taste Of Wine	Bonnie	Nolan	Bonnie Nolan	90 S Main St	Miamisburg	OH	45342	(937) 247-1120	$1,615,000	TRUE

Tom

Re: Error message upon import attempt

Method_Michael — Fri, 04 Nov 2011 16:35:24 GMT

CatWineUsa-

One additonal note, 2 blank columns are also considered duplicates

-Michael

Re: Error message upon import attempt

Method_Michael — Fri, 04 Nov 2011 16:24:26 GMT

CatWineUsa-

In the CSV file do you happen to have 2 columns with the same name? For example 2 Website columns?

-Michael