Forum Replies Created

Viewing 5 posts - 16 through 20 (of 20 total)
  • Author
  • in reply to: Replicating current Fusion Tables functionality #52223

    Hi Perry,

    I’ve installed PRO V7 following the instructions I received. I’ve made some progress replicating my map, but it’s been slow – it’s feeling like one step forward, one step back. If I can get this done, I’m certainly willing to share what I’ve learned to try to help others.

    In the meantime, I need to again ask for assistance. I’ll include here only the most time-sensitive problem because I can’t do any further testing without solving it. (I’ve found forum entries related to some of the others – like customizing the infowindow display, adding categories and correctly loading custom fields….I can put my questions there rather than in this thread if that’s more helpful.)

    CSV Import does not geocode addresses into markers

    This one is especially frustrating because it worked the first few times I loaded the file. I’ll explain in detail as that might help with troubleshooting.

    I have been using this syntax in the address field:
    384 Webster St., Needham, MA, 02494

    After several loads where the markers were successfully geocoded, my next load resulted in the error
    “This API project is not authorized to use this API”

    I have a valid API key, and I would see in Google Cloud console that it had been called. I went back and followed the instructions you provide to enable the Google Maps platform. That authorized a different key I already had, so I entered that key into the Google Maps API Key field on the Settings -> Advanced screen.

    Next load, the authorization error disappeared. However, now the imported markers were not showing up on the map. The address field is present and populated, but no marker is generated.

    If I edit one of the markers, the Address/GPS field is populated correctly from my import file, e.g.;

    384 Webster St., Needham, MA, 02494

    If I then click into the field, I get a popup beneath it with an address and a little “Powered by Google” notation. (I’ll attach a screengrab as a file.) If I accept that address and then save the marker, the marker now correctly appears on my map.

    So the google maps API is accessible and working. But why isn’t it recognizing and geocoding the addresses when my CSV file is uploaded? (I am selecting that option.)

    To be sure, the address field as repopulated by selecting and saving it has more information than the uploaded field, but that’s never been a problem when I’ve geocoded those addresses in fusion tables. Here are the two versions:

    • 384 Webster St, Needham, MA, 02494
    • 384 Webster St, Needham, Needham Heights, MA 02494, USA

    I’m attaching my test CSV file in case that’s helpful. The test map I’m working on is live here.


    • This reply was modified 6 months ago by mgreis. Reason: small corrections to syntax and formatting
    • This reply was modified 6 months ago by mgreis. Reason: small corrections to syntax and formatting; found the CSV marker download option
    You must be logged in to view attached files.
    in reply to: Replicating current Fusion Tables functionality #52217
    This reply has been marked as private.
    in reply to: Replicating current Fusion Tables functionality #52182

    Thanks, Perry! I have opened the ticket as requested.

    I will take you up on the offer to try the Beta for version 8. Selecting which custom fields display is what I would want in the initial replacement for my fusion tables map. I can always fall back to the current fusion tables map for the next several months if there is any problem.

    Would I order and install the PRO version of 7 before installing the beta? Or would I install the beta for now, then order & install the production version of 8?

    in reply to: Replicating current Fusion Tables functionality #52158

    Thanks, Perry.

    You can provide either a street address or coordinates as the address.

    Perfect. So the geocoding from addresses to coordinates takes place under the covers (more or less as it does in Fusion Tables when you upload a table or change the data)?

    Custom fields are displayed in infowindows.

    How is the display of custom fields in the infowindow controlled? Can you specify which custom fields appear? Is there an order, or formatting codes for them?

    At this point, I’m attempting to ascertain whether the top-level capabilities support easily replicating the basic functionality I currently have. If so, I would get a PRO license and migrate the fusion tables map immediately. I can then take time over the next month or two – with a license and access to support – to dig in on the more advanced features I would like to add.

    Regarding non-profit organisations, can you tell us a little bit more about your organisation?

    Founded in 2006, Green Needham Collaborative is a volunteer organization dedicated to securing a better future through local action. We engage in concrete projects to create a more sustainable and economically healthy community — one which is committed to reducing carbon emissions and using resources wisely. As we build on our successes, we promote the development of new social norms which will drive this transformation to a sustainable community. We are a 501(c)3 non-profit organization.

    The map in question highights the success of our 2014 Solarize Needham program and the subsequent growth in solar PV installations in our community.

    We are about to begin another round with the Solarize Plus Needham program. This program will promote solar PV, Air Source Heat Pumps and Electric Vehicles. The capabilities I want to add to the map will support our strategy of leveraging the 450 homeowners who already have solar in Needham. We want to make it easy for potential solar adopters to connect with friends and neighbors who already have solar to help them make the same decision.

    in reply to: Replicating current Fusion Tables functionality #52140

    Hi Perry,

    Thanks for the reply. I didn’t get an e-mail notification that you had replied (I’m pretty sure I checked that box when I entered he question…), so I am just circling back now. I am trying to get ahead of Google planned Fusion Tables shutdown this December.

    Can you expand on the difference between putting text/HTML in the description field and the use of custom fields?

    If I look at the sample CSV file on your Marker Importer Demo page, I see the description field. When I look at the info box that opens up for a marker, I see

    • The Title field from the CSV file
    • The marker’s geographic location, rendered as Lat/Long from the “address” field in the CSV
    • A live “Get Directions” link

    In Fusion Tables, I have fields with data I want to display. The data includes both address components (Street Address, Town, Zip) as well as other data (size of the PV array, installer, owner, etc.). My fusion table includes a compound address that Fusion Tables uses for geocoding.


    • Is a “custom field” simply an additional field in the CSV file? If so, how do I then get those fields displayed in the Infobox?
    • Is there a way to replicate the Fusion tables feature that allows placeholders to be filled with data columns? (see below for example code)
    • Can a geocoded address be provided to the plug-in as a location? If not, how would I render that into lat/long for the map?

    This is how Fusion tables allows the display of field data in the infobox:

    Size (kW): <b>{Nameplate Capacity (kW)}</b><br>
    Operational since: <b>{Commercial Operation Date †}</b><br>
    Installer: {Installer}<br>

    On a separate note, there is a notation at the bottom of your purchase page “If you are a non profit organization, please contact us”. My only currently planned use of this capability is for a non-profit, so I am interested in whatever might be available.


Viewing 5 posts - 16 through 20 (of 20 total)