If you are unable to create a new account, please email support@bspsoftware.com

 

UPDATE/INSERT option does not bring in zeroes

Started by lebronjames, 23 Nov 2010 11:38:13 AM

Previous topic - Next topic

lebronjames

 I have several builds in my catalog that are designated as UPDATE/INSERT delivery. As you might know, that means it will update any existing rows with new data and/or insert any new rows that are coming in.

However, it doesn't seem to bring in rows that have been deleted or have had their value change to 0.

Example

Gloves are worth $1000. Someone updates it to be $0 using a Live Web Interface  (Contributor). When I run the build to update the target table with $0, it will not bring it in. It still keeps the $1000.

Please help.

MFGF

Hi,

How have you configured the table properties for the delivery?  Specifically, which items have you marked (or are marked by default) as 'key'?

Also, which update detection method are you utilising - UPDATE, SELECT or KEY CACHE?

Regards,

MF.
Meep!

lebronjames

I have made sure that all the keys match up correctly and are also unique for each row. I am using the UPDATE option right now. However, I tried the SELECT/COMPARE and it came up with the same results. Zeroes are never showing up.

MFGF

One other thought - if you check the Element Properties of the amount item in the Table Properties dialog, is it set to Additive Update?

MF.
Meep!

lebronjames

Iv'e been doing some research on this issue. I think that my problem goes beyond Data Manager. i noticed that the publish containers from Contributor ( my data sources) do not bring in the zeroes in teh first place.

To anyone familiar with Contributor and the Contributor Administration Console, the incremental publishes do not bring in any 0 values. If you have any ideas on how to do that, please help. Also, I have tried to click the checkbox that says "Include zero values." That does not work correctly and even if it did, it takes way too much time. I need my updates to be faster since there are live users depending on reports.

MFGF - I haven't looked into what "Additive Update" could do. Thanks for the advice. Im not sure it can fix this problem but I'll look into it. Thanks

MFGF

Hmmm. Sounds like they may be null values, which may account for the lack of updates.
Meep!