Search the Community

Dear All, I came across an issue of changed behavior in VW. Since VW 8.5 I use external .txt files to alter database records in VW. Task is, to easily replace specific values in VW database by another. Lets say: update all items in 'database-name' with price record 'Field_1'='30,00' to 'Field_1'='40,00'. Or update all records with item no. '3.1.01' to 'C.1.01' . So far I used the database sync commad somewhat like a SQL statment would do UPDATE 'database-name' SET 'database-name.Field_1'='new value' WHERE 'database-name.Field_1'='old value'; The external .txt. file contains two values: The 'old value' and the 'new value', seperated by tab. In VW I assign a database sync matching set to find all items with 'old value' (key) and assign the 'new value' (sync from .txt to VW in the same field than the key field). Done, all old values in all database records of the specific database are updated - well, at least up to VW 2015 this is working like charm. VW2016 and VW2017 will not update the key field with the new data :-( I enclosed a zip file with two simple VW files (2015 an 2017) with database and some simple objects with database records and a txt file to sync with. Is anyone able to verify this change in behavioir also? Thanks for your help! Edward DB_Test_files.zip

@JimWWe work in a remote location with unreliable internet, Dropbox and Google drive are not optimal because they have to sync to the cloud before the file is transferred over the LAN. Resilio sync is our preferred solution because it can operate wholly peer to peer, it is more flexible than google/dropbox as it allows any folder to be synced not just the one approved by google/dropbox and it is more cost effective. Could you support Resilio Sync please?