Jump to content
  • 0

sync/update database records by external txt file



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!



Edited by EdwardP
typo error
Link to comment

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...