and
That's done the job nicely! Thank you very much davewest.
D
and
That's done the job nicely! Thank you very much davewest.
D
Im having the same isssues, with regards to uploading bulk data via csv
Sadly daveWests fix of changing the add_customers_backend.php file doesnt work for the latest download of this mod as that code doesnt exist in that file .. .... or if it does im being completly blind and missing it!
any help would be greatly appreciated!
Scott
The code is around line 44 in the version I downloaded (1-07).
I also found that the module was very sensitive to the type application that created the CSV. For example no version of Excel for Mac would create a working CSV but Numbers did so no problem with the same data.
Hope this helps.
Thanks for the quick reply .... yeah i just downloaded 1.07 (latest one in the downloads section) and that file doenst have it in at all
the code that is around line 44 is now :
if ($country == 'uk') {
$country_query = $db->Execute("SELECT countries_id FROM " . TABLE_COUNTRIES . "
WHERE countries_iso_code_2 = 'GB'");
$country_id = $country_query->fields['countries_id'];
} else if ($country == 'us') {
$country_query = $db->Execute("SELECT countries_id FROM " . TABLE_COUNTRIES . "
WHERE countries_iso_code_2 = 'US'");
$country_id = $country_query->fields['countries_id'];
}
So sadly its slightly different! .....thanks anwyway!
Scott
Sorry - mine is the same. this is what I inserted for Ireland (IE is the ISO code for Ireland) and in the CSV I added a column "Country" and filled it with "ie" for each entry.
$country_id = $country_query->fields['countries_id'];
} else if ($country == 'ie') {
$country_query = $db->Execute("SELECT countries_id FROM " . TABLE_COUNTRIES . "
WHERE countries_iso_code_2 = 'IE'");
Last edited by Donaldo01; 23 Apr 2010 at 05:59 PM. Reason: Stupid typo!
OpenOffice works, MS office works, never had a Mac, so not sure on that one.... even phpmyadmin will create a CSV.. I've even used notepad to create small CSV's...
1.07 has the file, but your right, the code is different, but the same... written different, but does the same as before.
So.... just copy the last elseif as before...
and paste and change....Code:else if ($country == 'us') { $country_query = $db->Execute("SELECT countries_id FROM " . TABLE_COUNTRIES . " WHERE countries_iso_code_2 = 'US'"); $country_id = $country_query->fields['countries_id']; }
the blue letters into the two digits you need for the country you're looking for. The only difference here is you don't need to look for the database ID, the code gets it this time.Code:if ($country == 'uk') { $country_query = $db->Execute("SELECT countries_id FROM " . TABLE_COUNTRIES . " WHERE countries_iso_code_2 = 'GB'"); $country_id = $country_query->fields['countries_id']; } else if ($country == 'us') { $country_query = $db->Execute("SELECT countries_id FROM " . TABLE_COUNTRIES . " WHERE countries_iso_code_2 = 'US'"); $country_id = $country_query->fields['countries_id']; }else if ($country == 'us') { $country_query = $db->Execute("SELECT countries_id FROM " . TABLE_COUNTRIES . " WHERE countries_iso_code_2 = 'US'"); $country_id = $country_query->fields['countries_id']; }
Dave
Always forward thinking... Lost my mind!
Thanks for the reply dave..... sadly that didnt fix it and still has the same issue with regards to 'country is a required field'
hmmm i guess i wont use this mod
Cheers for all the help
Scott
"How about trying Apsona ShopAdmin? It's free, and it will probably work for you.
Hi,
Thanks for this mod, its working great.
One thing i would like to know is using the custom field i created for my registration page.
I've managed to get the field to show in the add_customer.php file but when the customer is added and i go to edit the customer in the admin panel the custom field shows up blank and the data has not been added to the database.
I followed the instructions for adding the custom field to the registration page (by exchanging customers.php for add_customers_backend.php). From what i can understand the code to add to the database is the same but there are a few differences between the files.
Any help will be much appreciated.
Thanks
Installed this module and all is fine except the following which I need help:
If you try to amend anything in options in admin/customers it will only remember the original that was setup in your module.
So for example if there is a group discount of 10% when customer is setup and you want to change this you can't without deleting the customer first and then re-enter all his details again with the new discount.
Bookmarks