Rank: Member
Joined: 6/28/2010(UTC)
Posts: 38
|
When I imported my users, the import tool needed a file with a "First Name, Last Name, and Company name" (amongst all the other fields)
Now I need to modify the company name, but I do not see it on the EDIT USER screen.
I really need to update all 9937 users "company name"; using some SQL would be the easiest way to go, but I cannot find "Company Name" in the user table - it is in the Address table, but that table is empty in my database.
The company name shows up on orders, "bill to" and "ship to" addresses.
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
Take a look at the AddressBook field in the bvc_User table. It is an XML field that contains all of a users addresses. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 6/28/2010(UTC)
Posts: 38
|
In case anyone else runs arccross this. I was able to use the export/ import tool to get a tab delimited text file.
I opened this file in excel, and made my changes there.
I then imported the text file back to BV Commerce.
Excel did some nasty stuff to the file that had to be corrected, Then I imported the list again.
If there was a quotation mark or a comma in the address, excel wraped the field in double quotes. All of the double quotes had to be deleted before the import.
|
|
|
|
|
|
Rank: Member
Joined: 6/28/2010(UTC)
Posts: 38
|
On the "Edit User" screen ( users_edit.aspx ) whenever I click the "edit" button under Billing Address or Shipping Address, I get a red error message that reads "Password can not be any of the previous three passwords"
This is an unmodified BVC 5.7.3.
All of the users were imported using the BVC Import tool, Maybe some field was not set properly?
This makes simple user changes almost imposible for my customer.
The only way around this is to change the password 4 times for every user change.
|
|
|
|
|
|
Rank: Member
Joined: 6/28/2010(UTC)
Posts: 38
|
Additional:
I can understand this if I were actualy changing the password, but I am NOT
I only want to edit a shipping address.
The error message pops up when I click the EDIT button under "Shipping address" or "Billing address"
The code should check for previously used passwords ONLY when the password is changed and the SAVE Changes button is clicked,
NOT when I want to navigate to the Edit User Address screen.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.