Add Customers from admin addon

I haven't had any issues... Have it running on 6 stores currently all 1.3.8a

The line for the error is Gender....

Even if its not being used in the store, it must be uploaded in the CSV

This is part of the original script... Not the upload addition... You might try commenting out the function in add_customers_backend.php

	if (ACCOUNT_GENDER == 'true') {
		if (!in_array(array('m','f'), substr(strtolower($entry_gender), 0, 1))) {
			$errors[] = 'Gender not recognised. Expected "m" or "f", got: ' . $entry_gender;
		}
		$sql_data_array['entry_gender'] = $entry_gender;
	}

Difficult for me to troubleshoot as I am having no errors.

~Melanie

Melanie,

Thanks for that! Error disappeared with the fix.
Still not able to bulk upload. :(

I've checked the .csv I created, all appears correct, but you know how it goes, you can look at somethiing 100 times and miss the obvious.

I emailed my .csv file to you for your review. (It's a small test file, only two customers!)

Thanks,

Tina

I did not comment out the Gender issue as I believe it to be store specific.

However, I took the bug fixes down below and added them and resubmitted the contrib...

Looked at your CSV and uploaded it w/o error to my store... Second customer was not added as no name was present... Some info is required.

You successfully received welcome?

Select Part (Insert valid lines)

it will then ignore any inherent errors. I deleted the customer file no worries.

Also, the #1 address field was correctly imported to the correct spot in your customer record.

:( Still not working on my end.

Tina

Maybe there is a hosting specific problem.. I didn't write the existing module, we only added the ability to bulk upload.

Sorry, I really don't know except I am able to use it successfully.

I would be willing to have our contract programmers look in to it, except 2.0 is due soon and it seems rather pointless.

You have php 4x? and is it running as a cgi? this would be the most common incompatibility I can think of.

~Melanie

Ok - so my little brain was processing ALL the possibilities and I deduced that the program I used to create the .csv may be the culprit ~ so i created a .csv with excel, did an upload and EUREKA! Success (sort of)
See attached for error.

Attachment #5350

error: reads: admin error line 377 (same as before)

Thanks for all your time looking at this!

Tina

The errors are exactly what they say they are..... Last name is required.

Zones must be defined.

and it will not overwrite an existing customer file

Try this if you didn't when uploading Select Part (Insert valid lines)
The gender issue has to be store specific.... Maybe an admin can comment on its use/non-use?

Cheers,
Melanie

mprough:

The errors are exactly what they say they are..... Last name is required.

Zones must be defined.

and it will not overwrite an existing customer file

Try this if you didn't when uploading Select Part (Insert valid lines)
The gender issue has to be store specific.... Maybe an admin can comment on its use/non-use?

Cheers,
Melanie

Yes, I can live with the errors - other than the line 377 error - let me see if the fix earlier suggested for that error works on it.

Thanks again for all your help!
Tina

Hi all,
Ive read all the thread, tested the files and the fixes on a test site - all like the good noob I strive to be, with this outcome:

All works absolutely fine with the exception of:

1. array error (gender backend php)
2. Company field omits and replaced by first line of address.

Line 2). I can deal with by manually editing the fields once the customer has been created so not a prob but.....

Line 1). - All I need to know is Is this error OK to live with?? Am I gonna break anything if I put the mod on my live site? Is there a newer version due soon (preferable)?

Dont think for one minute that I dont love you guys and gals for all the effort and design cos I do.

Thank you.
Nick.

1. array error (gender backend php)
   This is a store specific thing.... Read down below and comment it out.

2. Company field omits and replaced by first line of address.
   This exists in the orig module only.... When using the bulk upload that we added the company is inserted fine. I need to fix that, but time is short.

The errors will not harm your store.

~Melanie

Hi, I have this module installed [the last version that was posted], and it works perfectly when I manually add a customer. I am running 1.3.8a.

However, when I try to bulk upload, nothing at all happens - Nothing. I browse to my file, select it, and hit upload. The screen just refreshes and shows me a screen with just the .csv bulk import box and the link to see the Single Customer Form. I get this regardless of the Insert Mode that I choose, and get it even if I don't select a file at all and just hit upload...I just don't know why I don't get any errors at all - yet the manual customer creation works just fine.

Any ideas? I have a list of about 700 customers I need to import and would greatly appreciate any help! I am not sure what directoy it is trying to load the csv file to so I can check permissions on it...I use Easy Populate with no problem in my store, but had to configure a separate folder first.

Thanks in advance for any assistance!

Make sure the CSV is formatted correctly. Also see before poster had to use different program for the CSV to get it to work on her site.

~Melanie

I've followed the instructions included in the installation package and created the file several times...I am using excel and did a 'save as' and selected .csv. I even included all of the fields even though it says only 4 of them are required.

What I find strange is that no matter what file I select to upload, I don't get any errors, it just doesnt do anything at all, just refreshes and takes me back to where I was before. I can select a Word Document, which I know would not work and it just does the same thing.

Can I send you my .csv file [It just has 3 names on it] just so you can look at it and confirm I did it right?

Thanks for your quick response!

Sorry for all the posts but I'm in a time crunch and want to get this figured out.

I'm pretty sure at this point it's a server issue since I get no errors and I'm confident my .csv file is correct. I have access to somebody who is a little more versed in PHP and our server than I am to troubleshoot, but need to give a little guidance to them about where to look. Is most of the code that deals with the bulk upload in the add_customers_backend.php file? Is there any other specific item or incompatibility I should be aware of? I saw what you had mentioned about php4.x and running as a cgi.

My Zen Cart installation is on a Linux server running Plesk 8.3, Apache, and PHP 5.1.

Thanks again for your assistance!

This is likely to be the file add_customers_backend.php

and it is VERY likely to be a Plesk related issue. Plesk has many issues with FTP and uploading within Zen Cart.

This is confirmed by the fact that I was able to upload your csv to my store.

~Melanie

I've got a problem with this mod that I haven't seen anyone else report. When I attempt to upload a CSV file, I get the following error:

Fatal error: Call to undefined function: strripos() in /home/tmvetsup/public_html/catalog_new/admin/add_customers_backend.php on line 15

That line on that file is as follows:

$pos = strripos($files['name'],'.')+1;

The CSV file was created in Excel, and all the necessary info is included. This error comes up regardless of which Insert Mode I use.

Oh, yes, and you can add me to the list of people who are having the previously reported problems when manually adding customers with the form. I got rid of the error message at the top by commenting out the offending code, but that bit about Address 1 being moved to the Company field is a real pain, resulting in a lot of wasted time going in to correct each record.

MaureenT:

I've got a problem with this mod that I haven't seen anyone else report. When I attempt to upload a CSV file, I get the following error:

Fatal error: Call to undefined function: strripos() in /home/tmvetsup/public_html/catalog_new/admin/add_customers_backend.php on line 15

That line on that file is as follows:

$pos = strripos($files['name'],'.')+1;

The CSV file was created in Excel, and all the necessary info is included. This error comes up regardless of which Insert Mode I use.

Oh, yes, and you can add me to the list of people who are having the previously reported problems when manually adding customers with the form. I got rid of the error message at the top by commenting out the offending code, but that bit about Address 1 being moved to the Company field is a real pain, resulting in a lot of wasted time going in to correct each record.

Hi,

I have not seen this error, suggest you reinstall following the directions carefully.... We all miss things :D

As far as the manual adding customers address thing... We didn't build that part, we only added the bulk ability which does not screw the address up. I haven't the time to fix it right now, but invite anyone who has solved it to post and we can repackage the mod again.

~Melanie

As far as the manual adding customers address thing... We didn't build that part, we only added the bulk ability which does not screw the address up. I haven't the time to fix it right now, but invite anyone who has solved it to post and we can repackage the mod again.In add_customers.php find... line 271

<td class="main">' . ENTRY_STREET_ADDRESS . '</td>
                    <td class="main">
                        <input size="30" name="entry_company" value="' . $cInfo->entry_company . '" />
                    </td>
```replace entry_company with entry_street_address

                <td class="main">' . ENTRY_STREET_ADDRESS . '</td>
                <td class="main">
                    <input size="30" name="entry_street_address" value="' . $cInfo->entry_street_address . '" />
                </td>

Cheers davewest the fix works and I have updated the mod.

http://pro-webs.net/store/index.php?main_page=document_product_info&cPath=30&products_id=96

I will resubmit it here in the add ons as well. Thanks

~Melanie

mprough:

Hi,

I have not seen this error, suggest you reinstall following the directions carefully.... We all miss things :D

As far as the manual adding customers address thing... We didn't build that part, we only added the bulk ability which does not screw the address up. I haven't the time to fix it right now, but invite anyone who has solved it to post and we can repackage the mod again.

~Melanie

What instructions? The instructions consist of a single line: "Upload all files to your store directory, the new menu item will be in the Customers menu." Short of missing one of the files, those instructions would be pretty hard to mess up. I have checked, and every single file in the download is present and accounted for in the correct folders of my site. Is there supposed to be something else to the instructions than the line above? I downloaded version 1.03 of the mod, which is the latest version available in the download area. I corrected the problem with the missing ?> in add_customer.php and removed the /admin/ from lines 156, 172 and 423, as instructed in this thread.

Since my last email, here is a list of what I have done to try to resolve this.

I have installed the mod on a total of four different stores, two of which are on different servers and use different versions of MySQL, one of those being on a completely different host. On all but the one that's on a different host, I get the same error message. On the one that's on a different host, I get nothing but a blank page. One store that I installed it on has no other modifications or add-ons, so it's not an issue with this mod butting heads with another one.

Thinking that there might be something wrong with the files Excel was creating, I tried another program. Same error message. I even tried using a file created in notepad.

I've triple checked all the headings to make sure they match what add_customers_formatting_csv.html says they should be. I've tried both with quotes around the values and without. I've tried eliminating all the values except the four that are required. I have tried everything I can possibly think of, and nothing works. I keep getting the same error message: Fatal error: Call to undefined function: strripos() in /home/tmvetsup/public_html/catalog_new/admin/add_customers_backend.php on line 15

I tested to see what would happen if I commented out that line. I don't get the error message. Instead, it just goes back to the form for adding customers and does not add anything.

At this point, I have run out of ideas and given up. I don't understand how I can be having the same problem on four different stores, on three different servers with three different versions of MySQL, yet not another soul here has this problem.

Perhaps someone here can give me a test CSV file that they have successfully tested on their own store, but, to be honest, I don't think it will do any good.