Removing country when order downloaded

[saucysal]

For the purpose of bringing orders via Actinic into Sage, is there anyway of removing the country, in particular United Kingdom Mainland, from the addresses automatically so that I do not have to manually delete this each time in Sage?

Likewise, is there any way of automatically correcting mistyping of postcodes, eg changing MK402JY to MK40 2JY. If it is mistyped the customer is imported as a new customer when they already exist with the correct typing. I have tried checking the validation box in Advanced: Locations, United Kingdom Mainland, but it didn't stop me typing incorrectly, and didn't correct it on import.

Sarah




Sarah

[Nadeem]

Hi Sarah

is there anyway of removing the country, in particular United Kingdom Mainland, from the addresses automatically so that I do not have to manually delete this each time in Sage?

I'm Afraid not, Apart from a bespoke application reading the persons.csv from "C:\Program Files\Actinic Link\Sage Line 50\DataFiles\Site1\Source\persons.csv" and taking out the country. Then you process it via Actinic Link.

is there any way of automatically correcting mistyping of postcodes, eg changing MK402JY to MK40 2JY

You could achieve this by either using Javascript or use the PostCode Anywhere Plugin. You may need to search in google for a postcode validation script.

Kind Regards

[Jan]

You could add postcode anywhere to your site which would decrease the likelyhood of incorrectly formatted postcodes arriving in an order. We have a free guide for setting this up on the front page of www.mole-end.biz

Regards,

[saucysal]

Postcode Anywhere Town in lower case

I had a look at Postcode Anywhere, did a test one, and found that it typed the main town/city in lower case instead of uppercase, which is not compliant with the Royal Mail. However, I may be able to get around this by using the javascript code to convert it to uppercase.

Sarah