span8
span4
span8
span4
Hello,
I have inserted an Excel spreadsheet in SQL Server with total rows = 6.357.I want to update the existing table with an updated version of the same spreadsheet (i.e.2 row values have changed;else remains the same).
我的工亚搏在线作流程是:
Readers: (I) new excel spreadsheet and (ii) connection to the existing table in db.I then use the UpdateDetector transformer and the output is: Unchanged: 6.356 and Inserted: 1 and Deleted: 1.
This one is the one I modified in excel,so it is the right one.My modification however,was to add a prefix in two of the column values of one row.
Thus,I would expect to find the change in the UPDATE.Could you please enlighten me why this happens?
What I wish to achieve is,update the db with all the changes of the spreadsheet in any time.Do you think it is feasible,without having to specify a column value on the where clause?
I want to automate the process of updating the db based on an updated spreadsheet using FME Server.This means,I do not want to be the one that specifies the where clause or how the update will be performed,I was wondering if there is a "smarter" way to apply in the workbench to recognize all the changes that have been made and update accordingly.Thank you for your time.
Kind regards,
George Floros
The most common issue with this transformer is this phrase in the help:
Please note that to get correct results,the key attribute must be provided to both "Key Attribute" and "Attribute(s) to match" parameter prompts.
Make sure that your common ID has been specifedbothplaces,otherwise the behavior will not be as expected:
You may also want to consider upgrading to FME 2019 which has a completely revised ChangeDetector that can now also detect updates,but with a much more intuitive interface.I suspect that the performance is also much improved.
I have been using this reference id both as a key attribute and as an attribute to match.Could it be related to how Excel translates insert or update?
I'm not sure Excel is involved here,but it's difficult to say without knowing your data.My first tip would be to look very carefully at the features entering the UpdateDetector.You could e.g.use breakpoints or to the Inspector.In particular you should look at the updated feature and how it looks when it arrives at the Original and Revised ports.
How did you configure the UpdateDetector?Do you have a primary key to detect changes by?
SQL non-spatial database update very slow1 Answer
Connect to SQL Server 2000 (!)3 Answers
© 2019 亚搏在线Safe Software Inc |Legal