I know this is probably going to be some complex coding, however it's the only option I am left with. Our retail store uses retail express for it's P.O.S system and although they claim on their site (http://retailexpress.com.au/addons-integrations/) they integrate with Adobe Business Catalyst, it has since become apparent that they do not. Now we're left with both services as BC won't give out a refund.
What I'm instead looking to do is work out a way to use the export customers feature of Retail Express, then filter the data to those who have data in the CustomReference field. Following that all of those Customers should then be imported into Business Catalyst.
Whether this is something that can be coded for Excel to do, that'll help too. Basically just need to automate this as easy as possible! Thanks!