Support

    You are here:  
  1. Home
  2. Support
  3. wapretorius
Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. 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: Sunday 12:57 pm
Add a reply View Replies (8)

Resolved Import Users CSV

  1. mr412
    mr412
  2. General
  3. Monday, March 11 2019, 12:59 PM
Hi,

I'm testing to import users with a csv file. How can I trigger to perform an update for fields like "map" and similiar fields after import? Otherwise I have to click every user manually and this makes an import useless.

Thank you in advance!
Responses (8)
admin
admin Accepted Answer
Admin
can you please send me your CSV file with only one line as example? (please archive the file in a ZIP or rename with txt extensions because this forum does not allow to upload .csv files )
  1. more than a month ago
  2. General
  3. # 1
mr412
mr412 Accepted Answer
Hi I have tested the modification unfortunately it not works =(
  1. more than a month ago
  2. General
  3. # 2
admin
admin Accepted Answer
Admin
Sorry I missing this last your question :D
Can you please take into account (if possible), if you create a new field and give a default value, that this is taken over by existing users in the "update process"?
Unfortunately we prefer to not do something like this, because when you change default value it need to update entire DB table.

Anyway if you want to add a default value for all users then you can launch a query in your DB* like: 
UPDATE #__jsn_users SET alias_of_field = "default value"


* all hosting providers give some tools to manage the database like phpMyAdmin
  1. more than a month ago
  2. General
  3. # 3
admin
admin Accepted Answer
Admin
Hi,
please try to replace file at /administrator/components/com_jsn/helpers/fields/gmap.php with attached file (unzip first), it should add automatically geo informations.

NOTE: I don't know exactly which limits have Google Maps APIs (requests for each minute), but we recommend you tp split your CSV file in many files with not more than 50 users for file.
Attachments (1)
gmap.zip
  1. more than a month ago
  2. General
  3. # 4
mr412
mr412 Accepted Answer
Thank you so much for this fantastic support!

Can you please take into account (if possible), if you create a new field and give a default value, that this is taken over by existing users in the "update process"?
  1. more than a month ago
  2. General
  3. # 5
admin
admin Accepted Answer
Admin
Hi,
we are working to make a plugin that should able it. Probably it will be ready tomorrow.

we will come back with a solution.
  1. more than a month ago
  2. General
  3. # 6
mr412
mr412 Accepted Answer
Thanks for reply. I linked the map with custom fields. I would prefer to trigger the update process from the map plugin. Because I have a CSV with Street and not with coordinates. I can not insert coordinates from the address from over 500 users...
  1. more than a month ago
  2. General
  3. # 7
admin
admin Accepted Answer
Admin
Hi,
to import map value you need to add following column to your DB: alias_of_fieldmap, alias_of_fieldmap_lat, alias_of_fieldmap_lng

so CSV could be something like this:

username,email,alias_of_fieldmap,alias_of_fieldmap_lat,alias_of_fieldmap_lng

robert.smith,[email protected],New York,40.6910834,-74.0120606
  1. more than a month ago
  2. General
  3. # 8
  • Page :
  • 1


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

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.