Add Customers from admin addon

[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.

[mprough]

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

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

[davewest]

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>

[mprough]

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

http://pro-webs.net/store/index.php?...products_id=96

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

~Melanie

[gee38l]

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>

hey all i have been having the same problem with the company name being over written with the address when manually adding customer.

I have made changes as mentioned above and its fixed the problem and the company name is now correct.... But it seems it created another issue where the 1st line of the address field is no longer there....

Anyone have any ideas?

[MaureenT]

Hi,

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

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.

[mprough]

I posted a link below to the updated module....

2 things you should understand..... My time for creating, lending support and just plain answering questions is donated by me.

Secondly, you read far enough down to find bug fixes... BUT failed to download the updated module from the link I posted.

The updated module has been submitted to the downloads section, but they are swamped ... Which is why I provided the link.

FYI also, there are some additional added instructions in the newest update... You are in fact 2 updates behind.

So... Download the module http://pro-webs.net/store/index.php?...products_id=96

and try again... or don't. Zen Carts by their very nature have a wide range of modules and customizations... The issue could be anything, but installing the latest version is a good start.

Additionally, are all of these sites with the same webhost? Have you checked if you can upload in this manner or know that you can?

~Melanie

[MaureenT]

I chose not to download the latest versions because it would require that I give Pro-Webs all of my contact information, which I'd really rather not do. Not that I expect to be spammed by them or other people that they might give my info to, but I already get too much unwanted email from companies that I had to give contact info to. No offense intended.

I'm aware that I am two versions behind. As far as I know, the only additional modifications made to version 1.05 were to fix the issue when adding customers individually via the form, the one that made the address info appear in the company field. I haven't gotten around to making those code changes yet since I figured they'd have no effect on the bulk upload problem. I also know about the work around to avoid the
Warning: in_array() [function.in-array]: Wrong datatype for second argument in /home/spiritc/public_html/reiki/admin/add_customers_backend.php on line 377 error message.

As I mentioned in my last message, one of the stores is hosted by a different company. With that store, I did not get the error message. Instead, I got a completely blank screen. The customers still were not added.

There was no need for you to tell me that your time is donated. I am well aware that every person who helps others on this board is donating their time. I've done the same thing, donating hours to help others here, including posting a mod. I'm certainly very grateful for the time people take out of their busy schedule to try to help others here.

If there were some important additional instructions, I would love to know what they were. I'm assuming that I already have all the code changes, unless there are others that weren't mentioned in this thread.

[davewest]

Ahh.. the thrills of open source... without some of our time, we would be putting out dollars for something that doesn't work.

MaureenT
The section of code that you show in error is looking at the file name! Do you have a space in the name, if so, replace it with a underline. maybe try a short name like test.csv

my test.csv file...

email,first_name,last_name,dob,gender,company,street_address,suburb,city,state,postcode,country,telephone,fax,newsletter,send_welcome
[email protected],road,wrongway,1910-01-01,m,,1234 deadend,,acton,CA,12345,US,111-111-1111,,0,0
[email protected],mad,baddog,2000-03-21,f,,1234 woody,,acton,CA,12345,US,111-111-1111,,0,0

The above worked without modifying the mod.

I did find a problem when converting the country into it's ID number. My site 'US' code was different then what was hard written. If you have problems, look at this section of code and change it to your country ID, mine was 241.

if ($country == 'uk') {
$country_id = 222;
} else if ($country == 'us') {
    $country_id = 223;
  }

See if that helps, the test.csv was tested on a Linux server, running Apache2, MySQL5 and PHP5

[MaureenT]

Ahh.. the thrills of open source... without some of our time, we would be putting out dollars for something that doesn't work.

Yep, that's the way it is. But, hey, at least we don't have to pay to get support, unlike some companies that shall remain nameless.

The file names I was using had no spaces or special characters, but there were spaces in the folder tree they were in, so I moved them to a spot where there were no spaces in any of the folder names. Unfortunately, it made no difference. I tried the csv you posted (thanks!) and named it "test", but still no joy.

The U.S. is the default 223 in this store, so that's not an issue. I do have to wonder, though, about adding customers who are in other countries besides the U.S. or the UK. You'd either have to add them manually with the form or change the code to accept other locations. Of course, if I don't get this bulk upload working, that's not going to be an issue for this store. ALL of the present customers will have to be added manually.

As for the servers, three if the stores I tested are on Unix, one on a Linux. The Linux is the one that comes back with a blank screen rather than the error message. MySQL version varies, 4 on the oldest server, 5 on all the others. The same goes for the PHP version.