Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
Add a reply View Replies (26)

Resolved Updating records while importing

  1. Christian Breu
    Christian Breu
  2. as Valentina DB Server
  3. Wednesday, March 27 2019, 11:08 PM
  4.  Subscribe via email
[How] is it possible to just update existing records while using vCursor.importText()?
Comment
There are no comments made yet.
Responses (26)
Ivan Smahin
Ivan Smahin Accepted Answer
Please check v.9.2 (coming soon) - all kind of merges are supported now.
Comment
There are no comments made yet.
  1. 4 hours ago
  2. as Valentina DB Server
  3. # 1
Christian Breu
Christian Breu Accepted Answer
Hi Sergey

~ 3 Mio records to merge daily.
Comment
There are no comments made yet.
  1. 6 days ago
  2. as Valentina DB Server
  3. # 2
Sergey Pashkov
Sergey Pashkov Accepted Answer
Hello Christian,

Unfortunately, this task requires much more time than we planned.

How big are the table and CSV file?
Is it necessary to merge them regularly?

We continue to work on improving MERGE, but maybe a stored procedure can be used for it?
Comment
There are no comments made yet.
  1. 6 days ago
  2. as Valentina DB Server
  3. # 3
Christian Breu
Christian Breu Accepted Answer
Thank you Ivan.
If possible, eliminate the limitations.
Like that, I cannot insert a record (WHERE NOT MATCHED BY TARGET) and this is a core requirement!
Comment
There are no comments made yet.
  1. one week ago
  2. as Valentina DB Server
  3. # 4
Christian Breu
Christian Breu Accepted Answer
The problem is, like that it is not possible to insert a record (when not matched by target).
But this was the main requirement...
Comment
There are no comments made yet.
  1. one week ago
  2. as Valentina DB Server
  3. # 5
Christian Breu
Christian Breu Accepted Answer
Thank you Ivan.
If possible, please extend it to be without limitations.
Comment
There are no comments made yet.
  1. one week ago
  2. as Valentina DB Server
  3. # 6
Ivan Smahin
Ivan Smahin Accepted Answer
It should work for "MATCHED" actions as you wrote above ("NOT MATCHED" actions are still not supported for such a complex conditions).
Comment
There are no comments made yet.
  1. one week ago
  2. as Valentina DB Server
  3. # 7
Christian Breu
Christian Breu Accepted Answer
Can you please update the samples too?
I could not get it to work with 9.1.5
Comment
There are no comments made yet.
  1. one week ago
  2. as Valentina DB Server
  3. # 8
Christian Breu
Christian Breu Accepted Answer
is it implemented already?
Comment
There are no comments made yet.
  1. one week ago
  2. as Valentina DB Server
  3. # 9
Ruslan Zasukhin
Ruslan Zasukhin Accepted Answer
9.1.5 archive can be found here already:

http://valentina-db.com/download/prev_releases/9.1.5
Comment
There are no comments made yet.
  1. one week ago
  2. as Valentina DB Server
  3. # 10
Christian Breu
Christian Breu Accepted Answer
Hello Ruslan

Thank you for the info.
What does it mean v9.2 – before/until may 20?
This should be ok.
Comment
There are no comments made yet.
  1. one week ago
  2. as Valentina DB Server
  3. # 11
Ruslan Zasukhin
Ruslan Zasukhin Accepted Answer
Hi Christian,

Ivan worked the prev week to improve join, and MERGE

we will ship OR 9.1.5 or 9.2 next week.

IF this is VERY VERY urgent -- let me know, then we will try 9.1.5 asap
if can wait to weekend - then we hope for 9.2 ready
Comment
There are no comments made yet.
  1. one week ago
  2. as Valentina DB Server
  3. # 12
François Van Lerberghe
François Van Lerberghe Accepted Answer
Hi Christian,

Try with this link code :


ON (isource.artikelnummer = mtarget.artikelnummer AND isource.barcode = CONCAT(mtarget.barcode))
Comment
There are no comments made yet.
  1. one week ago
  2. as Valentina DB Server
  3. # 13
Christian Breu
Christian Breu Accepted Answer
Hoping for some progress about this topic.
Comment
There are no comments made yet.
  1. 2 weeks ago
  2. as Valentina DB Server
  3. # 14
Christian Breu
Christian Breu Accepted Answer
Thank you Sergey!
Comment
There are no comments made yet.
  1. 4 weeks ago
  2. as Valentina DB Server
  3. # 15
Sergey Pashkov
Sergey Pashkov Accepted Answer
I added a feature request for JOIN operation which is used in MERGE command.
References
  1. http://valentina-db.com/bt/view.php?id=8513
Comment
There are no comments made yet.
  1. 4 weeks ago
  2. as Valentina DB Server
  3. # 16
Christian Breu
Christian Breu Accepted Answer
Do I have to set it as a feature request somewhere?
Comment
There are no comments made yet.
  1. 4 weeks ago
  2. as Valentina DB Server
  3. # 17
Christian Breu
Christian Breu Accepted Answer
Hi Sergey

A full implementation of Merge, to work as expected, would be great – save my day...
...and a reason for my customer to update to the latest version of VServer. ;)


Thank you for support.
Best regards.

Chris
Comment
There are no comments made yet.
  1. 4 weeks ago
  2. as Valentina DB Server
  3. # 18
Sergey Pashkov
Sergey Pashkov Accepted Answer
Hello Christian,

No, it is in the latest versions, too.
It is a limitation of the JOIN operator, we'll check if there any other way to do it.
Comment
There are no comments made yet.
  1. 4 weeks ago
  2. as Valentina DB Server
  3. # 19
Christian Breu
Christian Breu Accepted Answer
I tested with VServer 7.1.6 – is it a problem with that version?
Comment
There are no comments made yet.
  1. 4 weeks ago
  2. as Valentina DB Server
  3. # 20
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories