How to automatically copy postcode from custom field to standard location field

[Mervyn Marsh]

We are importing job cards into trello, and importing the postcode for the job card (where the completed job will end up) into a custom field. Is there any way we can set up a rule to automatically copy the postcode from the custom field into the provided location field so that we can view each job card in map view? 

Or is there an alternative work around to viewing all the job cards in map view without manually having to add the postcode to the location field of each card? 

[Iain Dooley]

@Mervyn Marsh as far as I'm aware there is no way to write to the pluginData of other powerups than your own, only to read from them.

[milynnus]

@Iain Dooley

Picture is from Trello API documentation for Update a Card. It seems that something has changed

 

[Iain Dooley]

@milynnus neat! 

[milynnus]

@Iain Dooley 

Just managed to update the coordinates, address and locationName. The Map View changed on the card. Basically used the coordinates of New Location to replace the attributes  on the test card...one with dummy address and name.

[Mervyn Marsh]

Thanks for this. 

I'm not that tech savvy, but could you run through (ideally step by step) how we could create a butler rule to automate the process? 

Currently we have a post code in a custom field box, and we would somehow like to create a Butler rule which could copy the the location information from the custom field into the pre-existing location field on trello that links to the Map view. 

Trust that makes sense, and thanks again. 

[Mervyn Marsh]

This is also for UK postcodes and addresses

[milynnus]

@Mervyn Marsh 

This will require programming. Please leave me your contact via my profile page : website. 

[milynnus]

Endpoint will only be available for 24 hrs to minimise use of event quota.

More info here :https://trello.com/c/TVe3Rf7V/51-update-card-location-information-using-geocoding-services

@Mervyn Marsh @Hariii Umaiii 

Here's the endpoint you can call using Butler Http Request

URL is https://60389.wayscript.io/coordinates?country=UK

Payload for testing is

{
"card_id": "",
"street": "",
"city": "",
"state": "",
"zip": "GU50BD",
"display_address": "",
"display_locationName": ""
},

It will return {httpresponse.latitude} and {httpresponse.longitude}

The update to the card to show on Map View will need your Trello credentials. The endpoint will eventually be password protected. It is currently not activated hence it will just return the coordinates.

For USA it will be

URL is https://60389.wayscript.io/coordinates?country=USA

Payload for testing is

{
"card_id": "",
"street": "60 Lincoln Center Plaza",
"city": "",
"state": "",
"zip": "10023",
"display_address": "",
"display_locationName": ""
},

[milynnus]

@Mervyn Marsh @Hariii Umaiii 

Some time back I (think) wrote a program that update the location with Map Power Up installed, the map does not show on the card. Not sure whether that has changed recently. 

[milynnus]

@Mervyn Marsh @Hariii Umaiii 

Given my test just now (see my reply to @Iain Dooley ) you should be able to import locations with address, locationName and the coordinates. You need to translate the postal code to the above. If it is a matter of creating new cards it will be a lot easier. To update an existing card then you need the cross reference.

[milynnus]

@Mervyn Marsh @Hariii Umaiii 

Update: used free USA census geocoding website to get coordinates and update a card - address, locationName and coordinates.