We have a store sign-in system that currently has NEW CUSTOMER and RETURNING customer options. New customers register/sign into the store to create a new account with their info, review a waiver, sign, check in. RETURN customer enters their email address, system pulls their data, they review, and check in. This is all the local "in-store" version.
We have an off-site version of this system whereby the system searches for DB, cannot find it, and runs in offline mode. Offline mode stores data in an XML file. We have a system that allows for uploading offline data back into the database when back online, but we need the system to run a checks and balances system.
1. Does this customer already exist, if so, load new data into existing customer record, update the location/event date/time of the recent visit.
2. If customer does not exist, create as new customer, load in data, update the location date/time of the recent visit.
3. Clear XML file on local system for next off-site event.
The data currently loads back into the system, but creates duplicate records. We need to have records combined if customer already exists in system, need it to be a more straightforward process.
23 freelancers are bidding on average $215 for this job
I will deliver it on time and will send daily update. I will make sure the things I have been doing is correct, neat and tidy and more importantly exactly what it needs to be done.