CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Batch geocode script (updateaddress.php) -- what user/pass for Standalone?
Pages: [1]

Author Topic: Batch geocode script (updateaddress.php) -- what user/pass for Standalone?  (Read 1797 times)

mchampion

  • Guest
Batch geocode script (updateaddress.php) -- what user/pass for Standalone?
April 20, 2010, 08:46:01 am
hey all:

So, we have an install of standalone 3.1.3 and imported just about 6000 contacts, and as you all know, geocoding is off during import. i saw the batch geocode script so that was no worry.

However, I have been unable to get the UpdateAddress.php script to run (in browser, or with wget in terminal) -- all three user/name/sitekey params dont get passed it seems.

for example, i run (ALLCAPS swapped with actual info):
wget -v -a testlog.txt 'http://PATH/TO/UpdateAddress.php?name=USERNAME&pass=PASSWD&key=SITEKEY'
     [ UPDATE: i have also tried " " in addition to ' ' around the url, but no difference ]

and my log file shows
"08:25:49 (390.62 KB/s) - `UpdateAddress.php?name=USERNAME&pass=PASSWD&key=SITEKEY' saved [40]"
and the DLed file shows:
"ERROR: Invalid username and/or password"

if i swap the order of user:pass:sitekey around i get slightly different errors.

i have created new admin-levl user and the username/pass do NOT have the forbidden characters (http://wiki.civicrm.org/confluence/display/CRMDOC/Command-line+Script+Configuration mentions "& = + $ ? % , / : { } | ' #"

and i have tried my root dbuser/dbpass from civicrm.settings.php

BUT NO LOVE...

i ve googled and scoured this forum, but i havent see a clear answer: can you use this script with standalone install (ie, not JUST a drupal/joomla user?)

(ie, does "# name - Valid username for an authorized Drupal or Joomla user. A CiviCRM contact associated with this user must exist." mean NO standalone?)

thanks
mario
« Last Edit: April 20, 2010, 09:06:07 am by mchampion »

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Batch geocode script (updateaddress.php) -- what user/pass for Standalone?
April 20, 2010, 12:33:08 pm

since you are just getting started, we strongly encourage you to move to drupal/joomla instead of standalone. We are dropping the standalone release from 3.2 and are not supporting it

http://civicrm.org/blogs/lobo/dropping-support-civicrm-standalone-v32

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

mchampion

  • Guest
Re: Batch geocode script (updateaddress.php) -- what user/pass for Standalone?
April 20, 2010, 01:20:53 pm
yes, i understand that, and as resources become available we probably will.

BUT, what of the original question: does updateaddress.php work for the standalone??

thanks
mario

mchampion

  • Guest
SOLVED. Batch geocode script (updateaddress.php) - what user/pass for Standalone
April 21, 2010, 09:49:43 am
In the end here is what worked for me:
comment out line 82 in bin/UpdateAddress.php
"CRM_Utils_System::authenticateScript( true, $name, $pass );"

and then in terminal did the command-line:
wget -v -a testlog.txt "http://PATH/TO/bin/UpdateAddress_mmc.php?key=SITEKEY"

et voila, 5800 new geocodes like 10 minutes later...

REMEMBER TO UN-COMMENT THAT LINE WHEN YOU ARE DONE.

hope this helps someone else, i'm sure i'm not the only one already using Standalone install.

thanks for a great tool, all the people
mario

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Batch geocode script (updateaddress.php) -- what user/pass for Standalone?

This forum was archived on 2017-11-26.