If I have a XML Feed that contains comma seperated values for example a address how can I map these to the database. For example: First Name, Surname, Address line 1 etc.
I also have another feed that contains product information and it has accessories. For example the fields are itemID, name, description, accessories and the accessories are comma seperated.
What I need to do is stick the itemID, name and description into the Item Table (To create the Product Record) and then for the associated I need to lookup the itemID for the accessory from the current database the Item Table and and then insert this itemID if it does not already exists from the looked up value into the associated table. But if the item is already in the assoicated table dont update it against that itemID dont update it.
For example itemID 1 is in the feed and it name is 'Test 10', its Description is 'Test Description' and its associated item are 'Test 12' and 'Test 13'.
Test 12 item number in the system for example might be itemID 12 and Test 13 might be itemID 13.
So into the associated Table it need to insert the following: