DSP Expert

1. Community
2. Data Questions & Discussion
3. How do you load batch data into the ‘sdb’ database through ADM/DSP without deleting the existing data from the table?

VGazquez: Hi Syed, In addition to the previous answers, please check this post in Data Insiders, which details how to merge tables in Collect: https://support.syniti.com/hc/en-us/community/posts/36...

• View comment
• DSP Expert
• May 29, 2018 09:29
• 0 votes

1. Community
2. Data Questions & Discussion
3. How do you load batch data into the ‘sdb’ database through ADM/DSP without deleting the existing data from the table?

ASliney: What version of DSP are you on? You're running the package directly from Assemble, correct? Did you try putting in a dummy Where clause for the delete e.g., MATNR = '0'? I tested this on a...

• View comment
• DSP Expert
• May 28, 2018 13:53
• 0 votes

1. Community
2. Data Questions & Discussion
3. How do you load batch data into the ‘sdb’ database through ADM/DSP without deleting the existing data from the table?

PCardoso: My approach to enable this through a robust Collect process is to create a replica of the table in question with a different name (e.g. TABLE_Delta) and build the Collect Process using th...

• View comment
• DSP Expert
• May 28, 2018 15:02
• 0 votes

1. Community
2. Data Questions & Discussion
3. How do you load batch data into the ‘sdb’ database through ADM/DSP without deleting the existing data from the table?

ASliney: The truncate step is built into Collect (but not Assemble) and is not skippable. On the vertical view of the Assemble package, on the Advanced Properties tab, turn off Target Delete Record...

• View comment
• DSP Expert
• May 28, 2018 13:34
• 0 votes

1. Community
2. Data Questions & Discussion
3. Has anyone updated a custom WebApp built for Outlook 2003 to be compatible with Outlook 2010?

PWadekar: Recompile and minor re-structuring worked for outlook integration with DSP.

• View comment
• DSP Expert
• May 23, 2018 12:02
• 0 votes

1. Community
2. Data Questions & Discussion
3. Why is Excel Integration upload taking so long to upload records?

PWadekar: A. Try re-calculating stats for that table page. USE ; GO UPDATE STATISTICS dbo.; GO B. Try rebuilding index on the table for that page.

• View comment
• DSP Expert
• May 23, 2018 12:04
• 0 votes

1. Community
2. Data Questions & Discussion
3. Has anyone connected to or extracted data from Revel Systems Point Of Sale ?

CBermingham: I haven't worked with Revel POS, but since this post has been open for so long I will take a shot. If you have not found any way to connect via ODBC, Revel advertises an Open API for u...

• View comment
• DSP Expert
• May 18, 2018 14:29
• 0 votes

1. Community
2. Data Questions & Discussion
3. Is there a BOA Function to check a previous record?

EWeldon: Hi Abigail, SQL has functions for this starting with 2012: LAG (for the previous record): https://docs.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-2017  LEAD...

• View comment
• DSP Expert
• May 16, 2018 14:54
• 0 votes

1. Community
2. Data Questions & Discussion
3. Why is Excel Integration upload taking so long to upload records?

ASliney: Do you have auditing turned on? Even with only minimal record counts, auditing causes the Excel integration to time out. From the server you can look at the timeout messages in the server ...

• View comment
• DSP Expert
• May 15, 2018 14:43
• 0 votes

1. Community
2. Data Questions & Discussion
3. Why is Excel Integration upload taking so long to upload records?

EWeldon: Hey Brad, has the page changed recently? Have drop downs been added? Excel Integration is based off the Horizontal View, so if you have User Security in the Hor view, exponential amount of...

• View comment
• DSP Expert
• May 15, 2018 14:24
• 0 votes