Rapaport TechNet
 
Developer Forum [ All Topics | New Topic ]
Thread: Synchronize data

Hi, Is there a way to synchronize data between my database and technet database? I have downloaded the data feed and updated my database, now I want to delete the old items in my database. Please help me on this. Thanks, An Truong

>> add a comment
An Truong
02/21/2010 08:55


3 Replies:

Hi An Truong I would put the new data in a temp table and then do a selects with left join and inner join on the Lot# Example: ---------------------------------------------------------------------------------- diamonds to add will be this, select * from Temp_Table Left join Old_Table ON Temp_Table.LotID = Old_Table.LotID Where Old_Table.LotID is null ---------------------------------------------------------------------------------- diamonds to update will be this, select * from Temp_Table inner join Old_Table ON Temp_Table.LotID = Old_Table.LotID ---------------------------------------------------------------------------------- Diamonds to delete will be this, select * from Old_Table left join Temp_Table ON Temp_Table.LotID = Old_Table.LotID Where Temp_Table.LotID is null

>> add a comment
Ahaliav Fox
2/22/2010 3:08:00 AM
Hi Ahaliav Fox, Thank you, this is not what I mean. The data feed contains the new items but that does not mean the items in the old data feed are not available in the market. Maybe I should go to Support forum to ask for help from site admin. Thanks, An Truong

>> add a comment
An Truong
2/22/2010 8:54:00 PM

Our user id is : 56850, Company name: Intercontinental jewelers.

Website URL: http://www.intercontinentaljewelers.com/

 

We initially had nearly 14000 diamonds in our website which was synchronized using the rapaport API. Recently we shifted our server, during which we lost many data from our DB and currently we are able to see only 6000+ diamond records in our DB. We want all these 14000+ diamond records to be synchronized with our current website DB.

 

We already called India customer care and mailed them as well. But we didn’t get a right support from them. They have asked us to mail you and get your support. Kindly help us in synchronizing the lost 14000+  diamond records into our website.
>> add a comment
Shankar
11/22/2013 12:29:00 AM