1. 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!
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. # 1
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. # 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
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
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.