Support

  1. mr412
  2. General
  3. Monday, March 11 2019, 12:59 PM
  4.  Subscribe via email
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!
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,robert.smith@domain.com,New York,40.6910834,-74.0120606
  1. more than a month ago
  2. General
  3. # 1
mr412 Accepted Answer
Pro
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. # 2
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. # 3
mr412 Accepted Answer
Pro
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. # 4
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)
  1. more than a month ago
  2. General
  3. # 5
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. # 6
mr412 Accepted Answer
Pro
Hi I have tested the modification unfortunately it not works =(
  1. more than a month ago
  2. General
  3. # 7
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. # 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

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.