Hello
We have a custom php website where we accept user registration. Now i want to migrate those users to phpfox 4
Can you tell me what the things we need to migrate from old user table to phpfox 4 tables? like user email, passwords or name
migrating to user table is only enough or we have to migrate users other details to other phpfox 4 tables too?
Please guide
Regards
Gaurav
The best way to understand what is needed is to set up a development site with a fresh install. Then you will go to the lists of the table I will provide below and copy the information into an excel spreadsheet with the name of the fields and the data that was put into those fields. Then you will add one user. Then go back to those tables and add the new info to the excel spreadsheet...do it for a third user as well. By doing this you will see a pattern and what data is needed for a new user to be correctly entered into phpfox. Here are the tables affected and they all need to be used so there are no issues later on. Using excel CSV files is a clean way to import users because if a specific field/column is all zeros you can put one zero in the box and drag down to create hundreds or thousands of rows in minutes if the default data for that field is zero. In most of the tables below the data is the same for all the users except the id number etc but it is still needed.
| phpfox_user |
| phpfox_user_activity |
| phpfox_user_count |
| phpfox_user_delete |
| phpfox_user_field |
| phpfox_user_space |
can u give me an example excel csv please
Not sure how accurate it is anymore as it was done five years ago.
| phpfox_user | ||
| user_id | increase by one | |
| profile_page_id | increase by one | |
| server_id | ||
| user_group_id | 2 | membership status |
| status_id | ||
| view_id | 7 | Looks like 0 is approved for users, 7 is approved for businesses and 1 is pending approval. |
| user_name | url ending or profile or business name | |
| full_name | name of business | |
| password | hash thing | |
| password_salt | hash thing | |
| gender | ||
| birthday | ||
| birthday_search | ||
| country_iso | ||
| language_id | ||
| style_id | ||
| time_zone | ||
| dst_check | ||
| joined | 1377108547 | |
| last_login | ||
| last_activity | ||
| user_image | 11%s.jpg | (increase by one) |
| hide_tip | ||
| status | ||
| footer_bar | ||
| invite_user_id | ||
| im_beep | ||
| im_hide | ||
| is_invisible | ||
| total_spam | ||
| last_ip_address | ||
| feed_sort | ||
To see how you need to import the excel/csv file is to export the table to excel/csv after you have entered the three users for each table. Then you see what goes in each row...then it is a copy and paste of your old data into the correct columns and then import it through phpmyadmin. If you don't know how to use that you might have to hire someone or their might be an app in the store but not sure how good it is.
all is set but we are facing issue with password conversion only
once the password work fine but when logout and login again then do nt accept pwd
anyone can help us to tell how to convert normal password to phpfox v4 password? anyhow phpfox also converting normal text to password and storing in database?
Kindly help us. this is the thing only left
