What: User needs to be able to specify ‘nth’ sheet in connection string for an Excel spreadsheet

Why: Needs to be able to specify "Sheet1" on the command line, no matter what the customer has named Sheet1 in Excel.

What: If customer saved the Excel workbook with Sheet .

Why: If customer saved the Excel workbook with Sheet3 visible, DJ needs a selection in the Sheet pick list called <Default> that will automatically open Sheet3 (like Excel does if you re-open that work book in Excel).

What: Menu selection for Sample Data File unavailable

Why: Unable to get menu selection to Create Sample Data File in DSD for UB92 schema.

What: Would like global support for code modules

Why: Users would like global support for Functions - the ability to have a function be global across an entire process.

What: Clean() Function

Why : The Clean() function takes a string value as a single argument, removes all non-printable characters and returns the string.

Added Clean function that takes one parameter, the string to clean. Return value is the string with all non-printable (in the current system language) characters removed

What: Add formatting option property to XML target spoke

Why : Add a formatting target property to control whether an XML file is created with hierarchical formatting or not. With the increase in near real-time processing using XML messages, the current formatting results in a larger message than may be necessary. Having an option to write the data string without formatting would help to alleviate some of this overhead.

What: ASCII Delim trg prop 'FieldDelimitStyle'=Text shouldn't quote dates

Why : The FieldDelmitStyle has three settings- ‘All’ places the delimiters specified in Field Start Delimiter and Field End Delimiter before and after every field. ‘Partial’ places the specified delimiters before and after fields only where necessary. A field that contains a character that is the same as the field separator would have the field delimiters placed around it. ‘Text’ places delimiters only before and after text fields (non-numeric fields). Strictly speaking, dates are not text, so they should not be quoted, or should be quoted differently. Change so that the 'text' delimit style only delimits text and name fields

Added a 'non-numeric' delimit style that will do what the 'text' style used to do, delimit all non-numeric fields.

What: Would like a Border property on HTML target connector for Mode=Table

Why : When a user writes to HTML in Map Designer, one of the mode options is Table. If a user selects this option, a border-less table is written to the output file. If this file is going to be viewed by human eyes, it would make it more readable if the table had a border. I would like to propose a Connector Property for Table Border (T/F).

What: Oracle 8.x/Oracle 9.x Connector - Source Database Alias combo box not being populated

Why : When using the Oracle 8.x or Oracle 9.x connector as the source the Source Database Alias combo box is not being populated with the server connections defined in the TNSNAMES.ORA and/or SQLNET.ORA files located in the %ORACLE_HOME%/network/ADMIN subdirectory.

What: COM SDK is incomplete

Why : The COM SDK contains old versions of the message steps and is missing Iterators, Aggregators, and the XSLT, Iterator, and Aggregator steps. The Start and Stop steps are being cast as PRJExpression instances. See CProject::get_Step() in djec\Project.cpp. The SendMessageStep and ReceiveMessageStep interfaces and co-classes need to be removed. The MessageStep interface and coclass should be changed to QueueStep andcompleted. Interfaces and coclasses need to be added for Iterators, Aggregators, andthe XSLT, Iterator, and Aggregator steps. The Project interface and coclass need to be updated to use the new interfaces

What: Java SDK is incomplete

Why : The Java SDK contains old versions of the message steps and is missingIterators, Aggregators, and the XSLT, Iterator, and Aggregator steps. There are several issues that need to be addressed.1. The SendMessageStep and ReceiveMessageStep interfaces and classes need to be removed. 2. The MessageStep interface and class should be changed to QueueStep and completed. 3. Interfaces and classes need to be added for Iterators, Aggregators, and theXSLT, Iterator, and Aggregator steps.4. The Project interface and co-class need to be updated to use the new interfaces.

What: International characters in src/trg filename cause issues in PD

Why : International characters in source file cause problems when loading transformations in the Process Designer.

What: International characters support in the Cobol Metadata Connector

Why : Currently there is no support for international characters in the Cobol Metadata Connector.

16027

What: Count parameter for the PutTree action

Why : It would be nice if the PutTree action could be executed based on conditional logic via a Count parameter. Currently there is no way to check if the Tree is empty before writing it.

What: Need to be able to set lock mode for SQL Server 2000 Mass Insert to S-Mode

Why : In the SQL Server 2000 Mass Insert adapter, there is an M-lock on the target table. This is a manipulation lock used when the layout of a table is subject to change. The appropriate lock level for this mode (just as the mode used by the Bulk Loader) should be S-lock (share lock). This should either be changed, or a target property should offer a means to change this.

16381

What: Access original filename of FileFolderQueue's messages

Why : When you read a message from a FileFolderQueue, there is currently no way to access the name of the original file. The workaround I have suggested is to use the FileList function to scan a directory for a list of files and then put it in a loop to repeatedly poll the directory. If FileFolderQueue's messages had a filename property, it would be much simpler to design processes with this behavior.

What: Log a warning/error when the field in the occurs depending on clause does not exist

Why : Enhanced the cobol metadata reader to log a warning/bug when this happens.

What: Macro manager does not allow one to use empty string as a value

Why : You should be able to create a macro that has the value of an empty string. The current dialog disallows this and displays a dialog box if the user tries. Empty strings are useful as macro values. They let one define macros that can serve as placeholders for optional values

What: Move Repository Dialog settings from registry to xml file

Why : Modify the Repository Dialog to store settings info in xml files instead of the registry.

What: Remove registry settings

Why : It looks like the Expression Editor is storing settings info in both the registry and the xml setting file. Remove the code that stores the info in the registry.

16870

What: Double-clicking on target field expressions opens RIFL editor

Why : Customer requested Map Designer UI enhancement so that when one double-clicks on a target field expression, it automatically opens the RIFL editor for that field, rather than having to click on the drop down and select 'build expression'

17009

What: enhance sortArray function to work with multi-dimensional arrays

Why : Since multi-dimensional arrays are stored as an one-dimensional indexed list, using the sortArray function causes unexpected results and even a loss of data integrity. In other words, it sorts ALL elements of the array regardless of coordinates. It seems like it should be able to specify key coordinates to sort on...even a concatenation of elements or an expression.

What: Running a Process Twice causes a Crash with Iterator Step

Why : Running the attached Process twice causes the following error: The instruction at '0x00319a4d' referenced memory at '0x000000e5'. The memory could not be read.

What: Need RIFL method to identify which thread is currently running

Why : When running a project with multiple threads, it is sometimes critical to know within a transformation which particular thread that transformation is using. This allows the safe creation and use of such global objects as incore lookups, message objects, and import objects.The method could be something simple such as GetThreadId() which would return a unique identifier. The content of the identifier (number, string, etc.) is unimportant so long as it is unique.

What: Would like a way to set the MacroDef File via SDKs at runtime

Why : Through out the Java and COM SDKs, there is no way to set the MacroDef file at runtime. It would be nice to have a method or property to set this.

What: new error code 28056: Error reading package manifest

Why : This error occurs when the engine attempts to execute a djar project which has a bad or missing Manifest.mf file. Created as an effect of bug 16783.

What: The "filereadline" function is off by negative one

Why : The filereadline function has a parameter by which the line number is specified to be read. What is actually happening is that the line before the line specified to be read in is being read instead. If a user specifies the 92nd record to be read what will be returned is the 91st.WINDOW:msgbox using the filereadline function .

What: Failure to load component crashes PD

Why : Failure to load a java-based messaging component can crash process designer.

What: Display message when component cannot be instantiated

Why : If a message component cannot be instantiated when creating a (queue) session, no error message is displayed. The GUI simply displays no properties. It seems like it would be better to display some kind of message indicating why the component could not be created.

What: add clear log file command line option

Why : In Map Designer, there is a "clear log file before each run" option, and via the SDK, one can call LogManager.ClearLogFile(), but there is no equivalent action for the command line interface, and no way to programatically get the log file path/name via a shell/batch script.

What: Error when there are child records in xml source.

Why : If there are child records in an xml source, there is a message in logfile about that child record. Message is 'Field type mismatch for Source connector schema record layout 'recordset' field 'R1'.' 'R1' is the name of the child record type.

17342

What: Add print capability to the data browser

Why : Add this via a right mouse on the grid AND a printer button on the toolbar.

What: Change Target clears Put Tree buffers

Why : When Change Target is called before a Put Tree action, the Put Tree writes blank lines.

What: Custom SegmentTerminator values do not save to the tf.xml file

Why : If you create a custom SegmentTerminator value in a transformation it will function properly. However, it will not save to the tf.xml file properly. Thus this custom value is lost the next time the transformation is loaded

What: Visual Source Safe doen not check in .map.xml files

Why : When you add a Process that has a Transformation to Visual Source Safe, it does not add the .map.xml files.

What: Salesforce2.5 connection uses too much system memory.

Why : Salesforce2.5 connection uses far too much system memory to establish its connection. If the user is actually successful at getting the connection established then viewing the data with the data browser will generate the following error: "Unable to read record: Get record: error server.user exception(unknown execption) 25504 in ReadSingleRecord(browse.frm)".WINDOW:Source step 1, connection.

What: Extract strings into resource property file

Why : Extract all strings into resource property file. This is easy for string handling and localization later

What: Need a CDecimal() function to return type decimal

Why : The Val() function right now is only capable of returning a value that is 17 digits long. This worked for 7.5.5, but we handle much larger numbers in Cosmos. Thus, the Val() function code should be written to return type decimal so it can return the larger values required in the new product.

What: Clicking the Source schema icon on the tool bar of the Map designer throws an exception

Why : Clicking the Source Schema icon on the tool bar of the map designer throws an exception, and hangs the Map designer application. Exception thrown: Object doesn't support this property or method in HandleDSTreeNodeClick(X_MapUtils.bas) (438)

What: Engine Profiler fails to open profiler output file

Why : Engine Profiler fails to open Profiler generated ouput file when using File Open menu.

What: Clean function

Why : Add clean function to UI.Added Clean function that takes one parameter, the string to clean. Returnvalue is the string with all non-printable (in the current system language) characters removed.

What: Add cdec function to UI

Why : CDec function that needs to be added to the UI. This is exactly the same as the CDbl function, except it returns a decimal value rather than a double.

What: Repository Manager object component "File Group" links need updating

Why : Target directories produced by the Repository Manager source code compile are now being placed at a new location in trunk 8.3 Object Component "File Group" links need to be pointed at the new location: dj800\target\RepositoryManagerUnless these links are updated, production of Repository Manager will be unsuccessful.