Updating records while importing

Sign In

Sign in to your account

If you are new here please register for an account

Username:

Password:

ログインを記憶

パスワードを忘れましたか？

返信を追加返信を表示 (39)

解決済み Updating records while importing

[How] is it possible to just update existing records while using vCursor.importText()?

There are no comments made yet.

返信 (39)

Christian Breu 承諾済みの回答

Is it possible or not?

There are no comments made yet.

Sergey Pashkov 承諾済みの回答

Hello Christian,

For example, if the imported text contains the RecID or primary key column, right?

There are no comments made yet.

Christian Breu 承諾済みの回答

Hi Sergey

Actually not really but they are products and have a barcode-number.
Is it possible directly while importing from text?

There are no comments made yet.

Sergey Pashkov 承諾済みの回答

Hi Christian,

No, it is impossible to do directly.

One of the possible ways:
1. Create intermediate (temporary or even RAM) table
2. Import records to this table
3. Use MERGE command to update existing and insert new records in the target table

There are no comments made yet.

Christian Breu 承諾済みの回答

Hi Sergey

Thank you for the clear answer.
I will take a look at that.

Best regards.

Chris.

There are no comments made yet.

Christian Breu 承諾済みの回答

Hello Sergey

Have to reactivate this thread...
Trying to use Merge but it does not work as I am expecting.

The sample from Wiki does not work – using dot-notation for fields is throwing errors!?
Found a sample from Ruslan that works but it is too simple.

this works without throwing an error:



MERGE main as mtarget

USING imp as isource ON (isource.artikelnummer = mtarget.artikelnummer)

WHEN MATCHED THEN 

UPDATE SET name = isource.name

this is throwing an error:



MERGE main as mtarget

USING imp as isource ON (isource.artikelnummer = mtarget.artikelnummer AND isource.barcode = mtarget.barcode)

WHEN MATCHED THEN 

UPDATE SET name = isource.name

this works without throwing an error:



MERGE main as mtarget

USING imp as isource ON (isource.artikelnummer = mtarget.artikelnummer AND isource.barcode <> mtarget.barcode)

WHEN MATCHED THEN 

UPDATE SET name = isource.name

**********************************************************

I want to do anything like this:



MERGE main as mtarget

USING imp as isource ON (isource.artikelnummer = mtarget.artikelnummer AND isource.barcode = mtarget.barcode)

WHEN NOT MATCHED BY TARGET THEN 

INSERT(artikelnummer, barcode, name) VALUES(isource.artikelnummer, isource.barcode, isource.name)

WHEN MATCHED THEN 

UPDATE SET mtarget.name = isource.name

and a second one to delete:



MERGE main as mtarget

USING imp as isource 

ON (isource.artikelnummer = mtarget.artikelnummer and isource.barcode = mtarget.barcode AND remove = 1)

WHEN MATCHED THEN 

DELETE

What did I misunderstand?
How to make it work?

Best regards.
Chris

There are no comments made yet.

Christian Breu 承諾済みの回答

I tested with VServer 7.1.6 – is it a problem with that version?

There are no comments made yet.

Sergey Pashkov 承諾済みの回答

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.

There are no comments made yet.

Christian Breu 承諾済みの回答

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

There are no comments made yet.

Christian Breu 承諾済みの回答

Do I have to set it as a feature request somewhere?

There are no comments made yet.

Sergey Pashkov 承諾済みの回答

I added a feature request for JOIN operation which is used in MERGE command.

There are no comments made yet.

Christian Breu 承諾済みの回答

Thank you Sergey!

There are no comments made yet.

Christian Breu 承諾済みの回答

Hoping for some progress about this topic.

There are no comments made yet.

François Van Lerberghe 承諾済みの回答

Hi Christian,

Try with this link code :



ON (isource.artikelnummer = mtarget.artikelnummer AND isource.barcode = CONCAT(mtarget.barcode))

There are no comments made yet.

Ruslan Zasukhin 承諾済みの回答

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

There are no comments made yet.

Christian Breu 承諾済みの回答

Hello Ruslan

Thank you for the info.
What does it mean v9.2 – before/until may 20?
This should be ok.

There are no comments made yet.

Ruslan Zasukhin 承諾済みの回答

9.1.5 archive can be found here already:

http://valentina-db.com/download/prev_releases/9.1.5

There are no comments made yet.

Christian Breu 承諾済みの回答

is it implemented already?

There are no comments made yet.

Christian Breu 承諾済みの回答

Can you please update the samples too?
I could not get it to work with 9.1.5

There are no comments made yet.

Ivan Smahin 承諾済みの回答

It should work for "MATCHED" actions as you wrote above ("NOT MATCHED" actions are still not supported for such a complex conditions).

There are no comments made yet.

ページ :
1
2

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

返信するにはログインしてください

投稿するにはログインする必要があります。右側のフォームからログインするか、新規アカウントを作成してください。ここで登録 »

パスワードを忘れましたか？

解決済み Updating records while importing

Categories

Valentina Server

Reports for...

Support

Company