Customers info not showing???

[maperr55]

HI,
I uploaded my customer information into mysql database table and can see them their. I go to customers in my admin section and can see the customers listed their just fine but when I open a customer to edit them all the boxes are blank ???. All the information is in the database why does it not show in customers?
????
Thanks,
Mark

[RescoCCC]

There are multiple tables in the database that involve customer data. Did you import in to each?

[DrByte]

Please click Reply below and answer all the questions in the Posting Tips section.

[maperr55]

What version of Zen Cart are you using?
1.3.9.h
DB : MySQL 4.1.20-max-log
PHP Version: 4.4.9 (Zend: 1.3.0)
Server OS: Linux 2.6.32.45

Has your site been upgraded? When? From what version(s)?
No upgrade.

If you've upgraded, HOW did you upgrade? (official upgrade procedure or an automated script from your hosting company?)
No
What addons have you installed? When?
add_pages_to_more_information_sidebox_2
add_customers_from_admin_1-07
events_calendar_1-02
backup_mysql_plugin_1-5
easy_populate_csv_1-2-5-7b
facebook_sidebox_1-0
twist_of_nature_1-01 ----- template being used....

HOW did you install it? (upload via FTP and run zc_install, or a one-click install from your hosting company? (one-click installs are NOT recommended))
FTP

In what ways is your site customized or different from a brand new uncustomized install?
Text changes in the sideboxes. Header replaced with different name and Picture.

If you're encountering display/layout problems, post your site URL* so it can be seen in action.
All appears fine except for blank boxes of the SQL import added customers. If you still need site access PM me and I will provide a link, Login ID and password you can use to access the site.

If you're encountering problems that could be related to your server or hosting company, include the name of your hosting company (not their URL).
Don't think so, but it is IX Webhosting anyway.

HAVE YOU LOOKED IN THE FAQ AREA for answers to your question? (ie: a search for your error message or what you want to edit/change, etc)
Yes, but nothing seemed to match or be related.


Have you searched the FORUM for your error message or for answers to the question you're asking?
Yes

WHEN did the problem "start"? How does that compare with other events of your hosting company, changes you've made to your site files/addons, or your admin settings, etc?
This is a new cart setup/install. Customers added manually work fine. The one I added via Mysql import shows only on the customers list in admin but their detail boxes are blank when edited.

If this is your first store, have you tested all aspects of transactions before going live?
Not my first store.

In regards to importing to each one, No. In looking I thought the basic customer info, ( F name, L name address, e-mail add, etc. ) were only on the tab called customers.

Thanks RescoCCC & Dr Byte
Mark

[DrByte]

Customers added manually work fine. The one I added via Mysql import shows only on the customers list in admin but their detail boxes are blank when edited.

How exactly did you "import" the data? Which tables did you import into? where did the data come from? Are ALL the fields blank, or just text fields or date fields or number fields?
What's the bigger picture here? Why are you importing customers? What else are you importing? Where did you come up with your strategy for doing these imports? What advice/guidance are you following to do this?

[maperr55]

Hi Doc,
Hope you are well,

How exactly did you "import" the data?
I logged into phpMyadmin to manage my data base.
using a CSV sheet with;
customers_id customers_gender customers_firstname customers_lastname customers_dob customers_email_address customers_nick customers_default_address_id customers_telephone customers_fax customers_password customers_newsletter customers_group_pricing customers_email_format customers_authorization customers_referral customers_paypal_payerid customers_paypal_ec
Using the admin tool import the CSV to the DB.


Which tables did you import into?

The customers table. Everything from the CSV shows now on the customer table.

Where did the data come from? I Exported a file as a template and entered the data into the appropriate column of the sheet.

Are ALL the fields blank, or just text fields or date fields or number fields?
In phpMyadmin you can see all the data on the customer table. With in the Admin section when you look at the customers list they show up their. When you click on a customer to view or Edit All fields are blank.


What's the bigger picture here? Why are you importing customers?
They are members. The few pages inside are for there viewing only. Just trying to make it so they will be given their ID and password and will have to do no more.

What else are you importing?
Nothing

Where did you come up with your strategy for doing these imports? From past work with loading DB tables.

What advice/guidance are you following to do this?
My own DB education and experiences and reading a few posts on Zen-cart community.

Thanks again Doc,
Mark

[DrByte]

You need to study the relationships between tables more adequately.
Customer data is stored in more than just the "customers" table. There's customer_info and address_book too, in addition to other places such as group_discounts and the various order tables and newsletter tracking and so on.

IT IS DANGEROUS TO SELECTIVELY PICK AND CHOOSE RANDOM DATA TO IMPORT/EXPORT. You run the risk of causing serious data corruption when you do as you've done.

A COMPLETE export+import is ALWAYS the safer route.

[maperr55]

HI Doc,
Thanks for the advice on the DB structure did not realize so many tables were tied together.
I did try an Export of the complete DB and got a file that had all the different tables in the file. I saw where information was on several of the sheets (tables) which was cool. Where I ran into a problem was after inputting all the data into the sheets when trying to save it in CSV format it would only save the open page of the file as CSV. I would have thought I would need all of this document to import to the DB tables. Should I have try and create a sheet for each table page of the document and import them a page at a time? I did create a back up of the DB before I started in case I blew it up.
Always appreciated thank you for your time and input.
Mark

[DrByte]

The proper way to do a complete database export is shown here: https://www.zen-cart.com/tutorials/i...hp?article=103

And a complete import is done by using the Import tab and specifying the .sql file you exported.

No CSV, no spreadsheets.

[maperr55]

HI Doc,
Great!!! I will read up on it and give it a whirl. I have nothing to lose at this point the alternative is to hand enter all 350 + members info.
Thanks again
Mark