Support

    You are here:  
  1. Home
  2. Support
  3. amberkrafts
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: Tuesday 5:31 am
Add a reply View Replies (10)

Resolved Migrating Easy-profile, settings, fields and users to fresh joomla installation

  1. Zephyrinus
    Zephyrinus
  2. General
  3. Thursday, July 09 2015, 11:33 AM
Hi,

Is it possible to export the JSN_users part of the database, and copy paste all easy-profile files to migrate the EP part of a website to a fresh installation of Joomla?

Can you help me out please?

warm regards,
Responses (10)
admin
admin Accepted Answer
Admin
You need to import only custom fields? or you need to import also Users?
  1. more than a month ago
  2. General
  3. # 1
Zephyrinus
Zephyrinus Accepted Answer
Pro
Both :-)
  1. more than a month ago
  2. General
  3. # 2
admin
admin Accepted Answer
Admin
Hi,
try to follow these steps:

- Export following tables from Old Database with some Mysql tool like PhpMyAdmin:
#__users
#__jsn_fields
#__jsn_users

- Make new installation of Joomla (with same table prefix of previous installation)

- Install Easy Profile

- Delete following tables from Database with some Mysql tool like PhpMyAdmin:
#__users
#__jsn_fields
#__jsn_users

- Import tables on New Database with some Mysql tool like PhpMyAdmin.

With this you should import all custom fields and users, you will loss only Easy Profile Options (Components->Easy Profile->Options), so you need to copy parameters value manually

NOTE: With Never tried :(
  1. more than a month ago
  2. General
  3. # 3
hsmdk
hsmdk Accepted Answer
Hi,

are in process to do the same, move to a fresh installation.

Why do the table prefix to be the the same, if you just export /import data via a csv file ?

Regards
  1. more than a month ago
  2. General
  3. # 4
admin
admin Accepted Answer
Admin
Hi,
here we are talking about an import via SQL not CSV, so you need to use prefix of new Joomla installation.
  1. more than a month ago
  2. General
  3. # 5
hsmdk
hsmdk Accepted Answer
Hi,

Thanks for your reply

I have try to export data form the old table (csv) and import then in the new table , there are no error massage in the import, however when i look in the back end there are a warring " missing a column for this field..." but it not all fields , fieldtypes "delimeter" here is no warring.

Have look a the csv files and the tables (collums) are equal (same numbers of collums)

The old version are 1.3.2 and the new version is 1.3.12

do you have a hint ?
  1. more than a month ago
  2. General
  3. # 6
admin
admin Accepted Answer
Admin
Hi,
I have try to export data form the old table (csv)
We not have export tool

You can import user data, but fields that you want to import need to exist.

we recommend to use SQL (not CSV) to import Easy Profile field database structure
  1. more than a month ago
  2. General
  3. # 7
hsmdk
hsmdk Accepted Answer
Hi

I was aware that uoy do not have an export/import Tool, but i simply exportet data from the old table and importet in the new table, by using csv files. and is was here i go the " missing a column for this field..." error massage in the back end. It was only the fields table.

You recommend to use SQL, can this been done in this way

1. Export the old table to a sql file
2. Edit the Sql file so the database fix is the same as i my new installation
3. Delete the field table in the new installation
4. Import/ execute the SQL file there create the table and the data (fields)

Are there other Things i schould be aware of ?

Reagrds
  1. more than a month ago
  2. General
  3. # 8
admin
admin Accepted Answer
Admin
Hi,
this is normal, CSV not create table structure.

You need to export all SQL commands to restore tables data and structure, so you need to have something like:
D*R*OP TA*BL*E IF EXISTS `prefix_jsn_users`;



CRE*AT*E TA*BL*E `prefix_jsn_users ` (.....

NOTE: I have added "*" because our system block all SQL command to prevent SQL injection.


You need only to:
- Export tables from old DB (SQL)
- Change prefix from old to new DB
- Import new SQL file

ANOTHER TIP: If you want to keep usergroups you need to export also tables
- #__user_usergroup_map
- #__usergroups
  1. more than a month ago
  2. General
  3. # 9
hsmdk
hsmdk Accepted Answer
Hi ,

I did not get to work, so i didt manual, spo the system work now. i have a another question but i will se in the form first...

Thanks for ypur help

Reagrds
  1. more than a month ago
  2. General
  3. # 10
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.

Request Support

Support is currently Offline
Ask a Question
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.

We use a few cookies

Our site uses non fat, delicious cookies which help us improve your user experience. You can read more about it in our Legal page.