[solved] Only a Subset of Profile Data Entered

More
9 years 6 months ago - 9 years 6 months ago #24408 by eileenrod
I mapped the 16 fields in the the Module to ES Profiles.
The Module reports 23 separate datum entered (see below).
Profile db export indicates only 6 fields entered.

Is this expected? What am I doing wrong? I'll send my site details now via form below.

16 Fields From Form
1 Gender Field ID
2 Date of Birth Field ID
3 Address Field ID
4 State Field ID
5 Postal Code Field ID
6 City Field ID
7 Country Field ID
8 Telephone Field ID
9 Website Field ID
10 Graduation Year Field ID
11 Graduation Age Field ID
12 Favorite Color Field ID
13 Job Field ID
14 Company Field ID
15 Car Field ID
16 Blood Type Field ID


Example Report From Module in Admin Cpanel Screen
Name Alexey Roganović
Gender male
Email alexeyroganovi@armyspy.com
Username Usbal1975
Date Of Birth 10/7/1975
Age 39
Telephone 920-893-1694
Street number 49
Street Old Plank Road Trail
City Plymouth
Postcode 53073
State Wisconsin
Country United States (US)
Coordinates 43.750679,-87.927754
Job Communications specialist
Company Rink's
Website statusswap.com
Car 2009 Dodge Viper
Blood type O+
Favorite Color Red
User Points 809
Graduation Year 2485
Avatar

Export from DB for sample student
1321 Tworris 2 256-352-7196 offshoreprices.com 2469 Blue Macromolecular chemist On Cue 1995 Chrysler Atlantic O+

User Listing for entry shows his name is Xiaoming Hê but this doesn't appear in the profile data.
Last edit: 9 years 6 months ago by nordmograph.

Please Log in or Create an account to join the conversation.

More
9 years 6 months ago #24411 by nordmograph
Everything looks fine so far

- username, name, email, password get added to the #__users table,
- most other fields get added to the #__social_fields data table
- address , city state, country zip get added to as one ES address field data (+ latitude and longitude)
- points get added to the points table,
- avatar to the avatar table.

- Need help? Post the URL of the related page (eventualy as confidential info), it will help solve your issue faster.
- An error, notice or warning? report the exact message including the line number
- If you get a white page , enable error reporting and / or check your server error logs.

Please Log in or Create an account to join the conversation.

More
9 years 6 months ago #24422 by eileenrod
Sorry, it was a bit late night for me last night. So I see the address fields are combined into the one field. And since the name is added to the #_users table it does not appear in the users profile in ES. That would have occurred if the user actually registered at the site and that data not been added directly via the module.

Please Log in or Create an account to join the conversation.

More
9 years 6 months ago #24423 by nordmograph
I see,
it is also actually adding the user alias (username) in ES, in the #__social_users table
and first and last names added to the ES #__social_fields_data (usertype)
So it should not be missing anything.

- Need help? Post the URL of the related page (eventualy as confidential info), it will help solve your issue faster.
- An error, notice or warning? report the exact message including the line number
- If you get a white page , enable error reporting and / or check your server error logs.

Please Log in or Create an account to join the conversation.

More
9 years 6 months ago #24430 by eileenrod
There are still problems, but I have two updates:

1) Jason @ Stack Ideas reports that they have changed the field data format for 1.3 and referred me to run some maintenance scripts which I've run. This enables users to see their birthday and address fields when they editing or exporting their profile.

Are you planning to update Sample Profiles?

Here are the descriptions of the scripts run listed in the ES back-end under "Maintenance":


Update fullname field data to multirow
Populate fullname field data from single row json data to multirow data.
1.3.0

Update fields to new privacy rules
Update core.view to field.element for all the fields in the privacy table.
1.3.0

Update country field data
Updates country field data to multirow and long name.
1.3.0

Update address field data to multirow
Populate address field data from single row json data to multirow data.
1.3.0

Set datetime field data key
Updates datetime and birthday field data to initialising datakey for the fields data.
1.3.0


2) As a reminder to anyone using Sample Profiles for EasySocial, there are only 12 fields you need to fill-in when editing the administration module for Sample Profiles because the following fields are ignored:

State Field ID
Postal Code Field ID
City Field ID
Country Field ID
The following user(s) said Thank You: nordmograph

Please Log in or Create an account to join the conversation.

More
9 years 6 months ago #24432 by nordmograph
Yes sure, the module will be updated as soon a s1.3 gets stable.
It is a very good thing that fields are split. I requested this to Mark when ES was 1.1
Especially required to query latitude and longitude easily (for our Geommunity3ES component for example)

Thank you for sharing this!

- Need help? Post the URL of the related page (eventualy as confidential info), it will help solve your issue faster.
- An error, notice or warning? report the exact message including the line number
- If you get a white page , enable error reporting and / or check your server error logs.

Please Log in or Create an account to join the conversation.

Time to create page: 0.333 seconds
Powered by Kunena Forum
Disclaimer: Nordmograph is not affiliated with or endorsed by The Joomla! Project™. Any products and services provided through this site are not supported or warrantied by The Joomla! Project or Open Source Matters, Inc. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.