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: Thursday 6:00 am
Add a reply View Replies (42)

Resolved Importing data to custom fields

  1. jodeepeevor
    jodeepeevor
  2. Features Request
  3. Tuesday, January 05 2016, 07:18 PM
hi there

ive checked your forum and ive seen the august 2015 post about this but im desperately hoping youve updated your import plugin to allow data to be imported to custom fields - this is essential for us and yes we're about to purchase your biggest subscription but this will be a hurdle for us - we have 1300 members all with address info that needs importing

please can you help asap? if there is a small charge for you to amend your plugin Im sure we can cover it and you will no doubt make many of your users including very happy.....

thanks jodee
Responses (42)
admin
admin Accepted Answer
Admin
hi,
our import plugin already allow to import Easy Profile custom fields. you can try with free version ;)
  1. more than a month ago
  2. Features Request
  3. # 1
jodeepeevor
jodeepeevor Accepted Answer
Pro
ah ok - i downloaded it from a thread in the forum and the custom fields failed. ill go to the download area and download it from there - this is great news thankyou!
  1. more than a month ago
  2. Features Request
  3. # 2
jodeepeevor
jodeepeevor Accepted Answer
Pro
ok i reuploaded the newer version but i still errors with my custom fields - see screenshot
  1. more than a month ago
  2. Features Request
  3. # 3
admin
admin Accepted Answer
Admin
HI,
please follow example for your CSV file.
- you need to use alias of fields in first row (i.e. adrress-line-1 is wrong, char - is not permitted in alias)
try to check
- field separator is ";"
- row separator is end of line
  1. more than a month ago
  2. Features Request
  3. # 4
jodeepeevor
jodeepeevor Accepted Answer
Pro
ok but char - is permitted - ive created all the fields and often use - in aliases

no matter

ill go and change the aliases to remove the -

thanks for the heads up!

jodee
  1. more than a month ago
  2. Features Request
  3. # 5
admin
admin Accepted Answer
Admin
hi,
"-" char is not allowed from version 1.3.12. which version you use?

oldest versions not support well latest Joomla
  1. more than a month ago
  2. Features Request
  3. # 6
jodeepeevor
jodeepeevor Accepted Answer
Pro
Actually the error was because i was using Mac csv not windows csv and so once i resaved the format it imported with success - well i thought with success because it said Notice 1 user imported however when i go and look at the user info there is no extra data added eg address date of birth etc.

please can you help?
  1. more than a month ago
  2. Features Request
  3. # 7
admin
admin Accepted Answer
Admin
Can you please post me your site details to check your configuration? you can use the form below the reply to keep private these infos.
Can you also post me your CSV file (with example infos)?
  1. more than a month ago
  2. Features Request
  3. # 8
jodeepeevor
jodeepeevor Accepted Answer
Pro
Hi there
Sorry I missed your reply - this is now rather urgent
Heres my csv and site info - ah i tried to upload the csv but it says its an unsupported format so Ive resaved it as an excel file
  1. more than a month ago
  2. Features Request
  3. # 9
admin
admin Accepted Answer
Admin
ah i tried to upload the csv but it says its an unsupported format so Ive resaved it as an excel file which wont upload either
Try to upload in Zip format :)
  1. more than a month ago
  2. Features Request
  3. # 10
jodeepeevor
jodeepeevor Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. Features Request
  3. # 11
admin
admin Accepted Answer
Admin
Hi,
found the problem, many users already exists before you install Easy Profile, so there is no association between Joomla User table and Easy Profile Custom Fields table.

To add new users Easy Profile Import plugin works, but when you try to update already existing users then the plugin not work.

To fix this you need to sync Users (I already do it) by using a tool in Easy Profile component (see screenshot). Now Import Plugin update also existing users ;)

NOTE: in your CSV file I see column "address_line_4" instead "address_line_3", this not make error because field (and column in DB) for address_line_4 exists, Now address_line_4 field in in the Trash.
Attachments (1)
Schermata 2016-02-08 alle 15.03.07.png Schermata 2016-02-08 alle 15.03.07.png
  1. more than a month ago
  2. Features Request
  3. # 12
jodeepeevor
jodeepeevor Accepted Answer
Pro
ok so ive finally gotten around to importing the full users list - it now throws up an error
Missing some required fields: Email, Name or Firstname
i have username and email and firstname but not name as it isnt needed

please can you help - my client is coming for a meeting tomorrow and I need to have this import done so I can create the maps of the users.

thanks jodee
  1. more than a month ago
  2. Features Request
  3. # 13
admin
admin Accepted Answer
Admin
Hi,
you need to use as separator for field the character ";" instead ",", for example your first line is:
username,email,title,firstname,lastname,address_line_1.....

correct is something like this:
username;email;title;firstname;lastname;address_line_1.....


PS. I have deleted your attachment, it contains personal user data;)
  1. more than a month ago
  2. Features Request
  3. # 14
jodeepeevor
jodeepeevor Accepted Answer
Pro
thanks - i did find and replace in textedit and i now get 10 errors - it says 1271 user imported

Error


Num of this row not match with number of declared field
  1. more than a month ago
  2. Features Request
  3. # 15
admin
admin Accepted Answer
Admin
Hi,
maybe you have some user info with ";" char, for example if you had address like "Street 126, Washington", then you have converted this like "Street 126; Washington", so the plugin see 2 columns
  1. more than a month ago
  2. Features Request
  3. # 16
jodeepeevor
jodeepeevor Accepted Answer
Pro
yes i did have that but i corrected all of those -

its flagging up this symbol - �

do you know what that is please?
  1. more than a month ago
  2. Features Request
  3. # 17
admin
admin Accepted Answer
Admin
I'm sorry, but I not understand your last reply, can you provide me some screenshot?
  1. more than a month ago
  2. Features Request
  3. # 18
jodeepeevor
jodeepeevor Accepted Answer
Pro
its ok it turned out to be a non-code-compliant " - i did a find and replace and its all imported now - phew!

thanks for your help!
  1. more than a month ago
  2. Features Request
  3. # 19
jodeepeevor
jodeepeevor Accepted Answer
Pro
so now i have all my users info - how do i now go about adding them to a map - i have two groups of users that i want to show maps of - are there instructions you can link me to please?
  1. more than a month ago
  2. Features Request
  3. # 20
jodeepeevor
jodeepeevor Accepted Answer
Pro
i understand i now need to populate the google maps custom field and use the module - but how do i show one page with a map for one group of users and the second page with a map of a second group of users please?
  1. more than a month ago
  2. Features Request
  3. # 21
admin
admin Accepted Answer
Admin
Hi,
Google map field create in DB 3 columns: FIELDALIAS, FIELDALIAS_lat, FIELDALIAS_lng. You need to populate all these fields to see users on the map.

but how do i show one page with a map for one group of users and the second page with a map of a second group of users please?
You can fill "SQL Custom Where" parameter in module options, see here how it works: http://docs.easy-profile.com/article/sql-custom-where

This special parameter is available in Users List menu items, Users List module and Users Map module.

In your case you can use this value:
group_id IN ( HEREGROUPID )
  1. more than a month ago
  2. Features Request
  3. # 22
jodeepeevor
jodeepeevor Accepted Answer
Pro
do i need to create the google map custom fields or are they already there? can i simply do a new import? or will i then lose the other field data by clicking overwrite existing users - ie if i do a new import should i have all the original fields in there too?

what is the fieldalias please? i know what the latitude and longitude are but not clear on what should go in the field alias field

thanks jodee
  1. more than a month ago
  2. Features Request
  3. # 23
jodeepeevor
jodeepeevor Accepted Answer
Pro
also where do i download the google maps module please?

also is the group id the id of the group i create in joomla for the two sets of users i want to display?

ie i create two modules and one show group id1 and the other shows groupid2

ive never worked with sql so im hopign you mean that i do all this within the module itself not working in the db?

thanks jodee
  1. more than a month ago
  2. Features Request
  3. # 24
jodeepeevor
jodeepeevor Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. Features Request
  3. # 25
admin
admin Accepted Answer
Admin
Hi,
do i need to create the google map custom fields or are they already there?
You need to create it.
can i simply do a new import?
Yes but you need to import also latitude and longitude, otherwise users will not show on map module.
or will i then lose the other field data by clicking overwrite existing users - ie if i do a new import should i have all the original fields in there too?
When user already exists all imported data will be overwritten. If you import only some field then others fields will not be modified when user already exists.
what is the fieldalias please?
See screenshot, for example if your Google Map field have alias "gaddress" then you need to import these columns "gaddress", "gaddress_lat", "gaddress_lng". gaddress_lat is latitude, gaddress_lng is longitude.
also where do i download the google maps module please?
User Map Module is already included in Easy Profile Pro package, you can manage this as all Joomla Modules
also is the group id the id of the group i create in joomla for the two sets of users i want to display?
You can see ID of usergroups from Administration->Users->Groups, in usergroups table there is a column ID
ie i create two modules and one show group id1 and the other shows groupid2
You need to create 2 modules, one for each your usergroup.
ive never worked with sql so im hopign you mean that i do all this within the module itself not working in the db?
You need to put in SQL Custom Where this code:
in map module 1, I assumed group1 have id equal to 10
group_id IN ( 10 )

in map module 2, I assumed group2 have id equal to 11
group_id IN ( 11 )
  1. more than a month ago
  2. Features Request
  3. # 26
admin
admin Accepted Answer
Admin
Missing screenshot :p
Attachments (1)
sc_alias.png sc_alias.png
  1. more than a month ago
  2. Features Request
  3. # 27
jodeepeevor
jodeepeevor Accepted Answer
Pro
what data would go in the field address alias then? i understand what goes in the lat and long - they are the coordinates for the address but what goes in the third field please?
  1. more than a month ago
  2. Features Request
  3. # 28
admin
admin Accepted Answer
Admin
In this column you need to put text address.
  1. more than a month ago
  2. Features Request
  3. # 29
jodeepeevor
jodeepeevor Accepted Answer
Pro
oh because ive added address fields eg address_line_1 etc and postcode etc
  1. more than a month ago
  2. Features Request
  3. # 30
jodeepeevor
jodeepeevor Accepted Answer
Pro
i just tried to add the gaddress_lng and it came up with an error
  1. more than a month ago
  2. Features Request
  3. # 31
jodeepeevor
jodeepeevor Accepted Answer
Pro
same thing happened for lat - but both saved and are now in the list of fields....
  1. more than a month ago
  2. Features Request
  3. # 32
admin
admin Accepted Answer
Admin
Hi,
you don't need to create gaddress_lat and gaddress_lng, these column already create by gaddress field
  1. more than a month ago
  2. Features Request
  3. # 33
admin
admin Accepted Answer
Admin
gaddress_lat and gaddress_png are service columns for gaddress field, but if you want to import you need to add these columns in CSV
  1. more than a month ago
  2. Features Request
  3. # 34
jodeepeevor
jodeepeevor Accepted Answer
Pro
so should i delete the two long and lat that are there or they correct now?

it would be lovely if we could manually add the long and lat and text address field but it doesnt seem to work - if you go to users and into a user record and type the address in the google address field (see screenshot) and then hit enter it removes the address.

whereas if i click the location green box it shows my home here now

can you advise how to help us be able to add lat and long manually please?
  1. more than a month ago
  2. Features Request
  3. # 35
admin
admin Accepted Answer
Admin
o should i delete the two long and lat that are there or they correct now?
Yes, but I think you need also to recreate also Google Map field, if you delete lat and lng field then I think our system will delete also Google Map service columns on DB.

if you go to users and into a user record and type the address in the google address field (see screenshot) and then hit enter it removes the address.
Can you provide me your site details to check this? you can use the form below the reply in "Site Details" tab.

can you advise how to help us be able to add lat and long manually please?
Sorry this is not possible, you can do this by adding these value directly on DB or by using import plugin.
  1. more than a month ago
  2. Features Request
  3. # 36
jodeepeevor
jodeepeevor Accepted Answer
Pro
site details below
  1. more than a month ago
  2. Features Request
  3. # 37
admin
admin Accepted Answer
Admin
Hi,
tried, for me works, I have put string "Zurigo" and press enter, see screenshot
Attachments (1)
Schermata 2016-02-24 alle 12.34.34.png Schermata 2016-02-24 alle 12.34.34.png
  1. more than a month ago
  2. Features Request
  3. # 38
jodeepeevor
jodeepeevor Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. Features Request
  3. # 39
admin
admin Accepted Answer
Admin
Hi,
1) Import plugin does not add usergroups, it only import custom values.

2) You need also to add "firstname", this is always required because it builds the Joomla name

3) You need to import also latitude and longitude, if you have a gmap field called address, then you need to import: address,address_lat,address_lng

4) You need to set access in plugin parameters from Extensions->Plugin Manager
  1. more than a month ago
  2. Features Request
  3. # 40
jodeepeevor
jodeepeevor Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. Features Request
  3. # 41
admin
admin Accepted Answer
Admin
Hi,
1) if your users have all same usergroup, so you can simply order by registered date and add to usergroup with batch process from Users->manage, or you can set in Users->manage->options (button)->Usergroup for new users (parameter) your usergroup, when you will do import then users will be automatically adds to this usergroup.

2) Yes Mandatory are firstname and email, instead "firstname" you can use "name". Joomla require
username - if missing will be generated from name
name - this is required
password - if missing will be generated
email - this is required

4) I have just tried and seems to works, anyway we will investigate about this, is possible that you have confused with Plugin Access Level?
  1. more than a month ago
  2. Features Request
  3. # 42
  • Page :
  • 1


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