Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Friday 1:45 am
Add a reply View Replies (3)

Resolved How To Change Name and Alias of EasyProfile Field

  1. kennethefford
    kennethefford
  2. Support
  3. Tuesday, June 28 2016, 07:05 PM
Hi,

I have a selection of custom items added under EasyProfile. For example, I have a TEXT field named "Buyer" with alias "buyer". It is currently used to indicate when I have "Buyer" privileges. I am using a TEXT field because the field carries a setting to indicate details about who the user is a "Buyer" for. Essentially, an organization.

Now, I need to make some changes where I now need to support multiple details. My plan is to change the current "Buyer" field to "Organization" with alias "organization" then create a new DELIMITER field for "Buyer" with alias "buyer". I want to change the existing field because the data for existing users is already stored in the Joomla database, which I need to retain.

How do I do this? When I access EasyProfile via the admin panel it prevents me from changing the alias. Why? I want the TEXT field named "Buyer" to become "Organization", with correct aliases changed, then create a new "Buyer" field that is a DELIMITER and empty.

Thanks in advance.

Ken
  1. easy profile
Responses (3)
admin
admin Accepted Answer
Admin
Hi,
to do this you need to change alias from DB, the table is #__jsn_fields, also you need to change name of column from "buyer" to new alias in the table #__jsn_users

Why?
Because this operation alter title of column in user table. Alter tables can cause lost of data (rarely but possible), also can create problems with third-party plugins or integrations.
  1. more than a month ago
  2. Support
  3. # 1
kennethefford
kennethefford Accepted Answer
Pro
If it can cause problems, what is the best way to handle this change? I am asking because I want to avoid problems. If I change directly in the database might this still cause problems? What type of other plugins and modules could cause problems, because none of my existing modules and plugins integrate in any significant way with EasyProfile, at least not that I am aware of. But maybe they all do through integration with Joomla.
  1. more than a month ago
  2. Support
  3. # 2
admin
admin Accepted Answer
Admin
If it can cause problems, what is the best way to handle this change?
Manually with some tool like phpMyAdmin.

What type of other plugins and modules could cause problems
Sorry, I don't know, our plugins and modules will works without problems.
  1. more than a month ago
  2. Support
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.