Batch converter tool for listings

[sohilpandya]

Hi @NicoleCrockett & @KatieRussellTBE

We've done some research and found a batch converter from UK Grid reference finder.

We'd like you to use this tool to add a couple of extra fields - (latitude and longitude) in the spreasheet.

I'll try to describe the process down below, but happy to go over it on the phone if it makes it easier.

1. We need to copy the postcode and address from our spreadsheet as shown in the screenshot below.
   
2. copy to the batch converter here - https://www.gridreferencefinder.com/postcodeBatchConverter/
   
3. Remove the tab space between the number and address as shown in the screenshot below. This is an important step otherwise the returned data is not formatted correctly
   
4. Click Convert postcodes
5. The newly converted data should appear.
   
6. Copy everything and paste it into the spreadsheet
   
7. It should return 7 columns, we can delete all the columns except for latitute and longitude, leaving the spreadsheet like this:
   

We would need you to include these in the spreadsheet that you'll be forwarding to us. Please let us know if the steps above work for you.

[KatieRussellTBE]

Thanks @sohilpandya!
This seems to be working for the batch of just over 400 entries that I'm preparing for you. A few issues have come up - some of the TQ grid reference numbers produced in doing the above steps differ to those that volunteers have inputted. This may relate to what Andrew mentioned in the meeting last week.
Also, some entries that have more than one building have two post-codes - but we'll get round this by choosing one of the post codes to proceed with.
Occasionally, some of the post codes come up as not existing, but they are in fact correct. We'll look into this a bit more and get back to you.

[sohilpandya]

@KatieRussellTBE, how are we coming along with the spreadsheet. we are getting towards the end of the project and need the list as soon as possible.

Thanks

[KatieRussellTBE]

@sohilpandya - We should be able to get it to you by the end of today.

[KatieRussellTBE]

_BULK TEST_ILL_Survey Worksheet_FINAL.xlsx

Hi @sohilpandya - here is the prepared spreadsheet with 438 entries.

I've kept the columns separate for the street number, street name and post code as in the original spreadsheet that volunteers completed. This is because there are about 8 entries which come up as 'no post code' in the batch converter and so do not have any of the mapping reference numbers. Often this I think results from one entry having two buildings attached to it, each with a different post code. I'm not sure you have any suggestions for dealing with this? Or whether we have to choose just one of the post codes.

The first column is 'Building Name' - I've kept this in as it would be good to include this as part of the address line when displayed on the site, e.g. The Exmouth Arms, 10 Exmouth Market, post code. Is there a way of doing this? It's also something that @nogainbar may also need to be aware of for the design.

Finally, I've kept two columns for 'Date Built (actual)' and 'Date Built (estimated)' as sometimes the data appears in one column and not the other. We're only going to have one 'Date Built' field, and I've tried to merge them but the data gets lost. Perhaps you can help with this?

I hope this helps, but please let us know if you have any questions. - Many thanks!