DSP Expert

1. Community
2. Data Questions & Discussion
3. How do I automate the movement of files using a custom application?

MBohne: This can also be accomplished using a DOS Batch file and either running it via Powershell, scheduled task, etc. The NET USE command can be fed login information to map a drive to a remote ...

• View comment
• DSP Expert
• June 18, 2018 08:37
• 0 votes

1. Community
2. Data Questions & Discussion
3. Can users work in the DSP while a CTS archive is being installed?

PTowe: Andy, having used CTS on a live system I can tell you how it appears to behave. As no-one else has replied, maybe this is better than no answer? My comments are based on CTS in ADM 6.5. Firs...

• View comment
• DSP Expert
• June 15, 2018 11:31
• 0 votes

1. Community
2. Data Questions & Discussion
3. How do you automate adding a sample line to dspCompose Excel Templates?

We have done this with Excel Integration on the page within dspCompose, Register a procedure to  the data entry button to insert a sample record. This will provide a record in the Excel spreadsheet...

• View comment
• DSP Expert
• June 08, 2018 11:23
• 1 vote

1. Community
2. Data Questions & Discussion
3. How do you extract multiple languages with special characters when a description is classified as "English"?

TEmpson: Hi Alyssa. Do you know what code page the Russian text is encoded with? We had a legacy system where they used western european code page, but then changed the code page on the fly in thei...

• View comment
• DSP Expert
• May 30, 2018 16:12
• 1 vote

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?

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: 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?

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. How do you configure summary emails so they are generated and sent on only the days the corresponding reports run?

CBermingham: Summaries run on their own schedule, which is controlled by a service page. Go to Monitor > Configuration > Schedule Service Page. There you can edit the "Build Summary Workflow Report...

• View comment
• DSP Expert
• May 24, 2018 18:23
• 1 vote

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