XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » Blank values in lookup lists
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + XML Publisher Generation of XS... (3)
-> + SS Error: Segment UNB: Segment... (6)
-> + SS Enterprise 2007 R2 does not... (2)
-> + Generating XSD from XML - glob... (3)
-> + SS Enterprise 2007 R2 does not... (2)
-> + SS dies on xsl files loads (7)
-> + EDIFACT UNA section ? (3)
-> + SS closes when I attempt to sa... (2)
-> + Support for SPEC 2000 & genera... (6)
-> + Uninstall failure (10)
-> + WSDL to JAVA code (2)
-> + Can't Connect to DB - SQL 2005... (3)
-> + Java editor (3)
-> + Trouble getting my xsl scenari... (6)
-> + Activation Key Not Compatible.... (2)
-> + Stylus Studio 2007 R2 and Regi... (3)
-> - XSD file displayed in Excel an... (1)
-> + What Is This vmm File? (5)
-> + Another in Release 2 (3)
-> + Error on Release 2 (3)
-> + Query DB and convert output to... (11)
-> + import static HTML into XML Pu... (2)
-> + saxon 8.9 include path resolut... (10)
-> + Can't drag field delimiter (2)
-> + Enterprise Edition Relase 2 up... (4)
-> + Upgrade to Enterprise Release ... (2)
-> + HTML to XSLT wizard missing in... (7)
-> + sqlxml.dll error after update ... (4)
-> + Printing the tree or the grid ... (2)
-> + Sorting problem with xsl[decim... (2)
-> + 2007 R2 Saxon: missing Convert... (4)
-> + EDIFACT D96A INVRPT into a SQL... (2)
-> + any addon Feature or tool that... (2)
-> + Catalog Assistance - (3)
-> + WYSIWYG does not show (3)
-> + HL7 support in Stylus (2)
-> + Xerces parser missing from Sty... (4)
-> - automatic DTD verification bef... (1)
-> + Try this (2)
-> - 2007 R2 java code generation -... (1)
-> + 2007 R2 Java built-in XSLT (4)
-> + 2007 R2 saxon 8.9 debug proble... (2)
-> + Stylus Studio Schema Validatio... (3)
-> + Bug: losing items when editing... (2)
-> + 2007 R2 Java built-in XSLT (2)
-> + XML->EDI: inconsistent treatme... (13)
-> + 2007 R2 global java classpath (2)
-> + New Web Service Call Failing (6)
-> + Grid view for nested tables (2)
-> - Revisit Old Problem from last ... (1)
-> + Install Question (3)
-> + hex value problem (5)
-> + WSDL Overview Diagram? (2)
-> + Outputing HTML from an XSLT 2.... (2)
-> + Stylus Studio Schema Publicati... (2)
-> + Re-usable XML Schema (3)
-> + .net xslt extension objects (6)
-> + InstallShield problem (2)
-> + Changing default XSLT processo... (2)
-> - SS incorrectly handles paramet... (1)
-> + Can't add file to project (7)
-> + Stylus invoking when i login i... (2)
-> + How to utilize Saxon (custom) ... (3)
-> + xsl:decimal-format (5)
-> + Hidden Costs of SS? (2)
-> + Eclipse Plugin available? (4)
-> + Having trouble with xpath quer... (2)
-> + Specifying processor to use wi... (3)
-> + MySQL or Generic JDBC Data Sup... (8)
-> + JAXB java generation doesn't s... (3)
-> - Eclipse (1)
-> + XSTL Debugger not working for ... (6)
-> + SS w/ Visual Studio and VSS (2)
-> + SS crashes on load (2)
-> + Can't find file ... then does,... (2)
-> + Diff folders not working (4)
-> + last node in preceding-sibling (3)
-> + SQLXML and Subquery (2)
-> + Xquery - No ReleationalDB opti... (3)
-> + Is a default adapter - not Tid... (8)
-> + Need actual (18)
-> + include path for external enti... (2)
-> + xpath query in SQL server (4)
-> + XPATH Query that works in 2006... (4)
-> + Need help with XML Assignment (3)
-> + Java Compiler in Windows Vista... (6)
-> + Sense:X Only Shows One Enumera... (3)
-> + adding tables and relationship... (6)
-> + preview automatically starts a... (12)
-> + French date in excel 97 using ... (2)
-> + How to maintain large XSL (2)
-> + French date in excel 97 using ... (2)
-> + How to pass EDIFACT as paramet... (3)
-> + C# Generation from XSD (5)
-> + Oracle RDBMS <-> .XSD (2)
-> + Support for Berkeley DB XML 2.... (2)
-> + conrext lost with xslt 2.0 for... (4)
-> + BizTalk schema problem (4)
-> + MSXML 6 properties resolveExte... (3)
-> + Deployment adapters and lookup... (2)
-- Previous [1621-1640] [1641-1660] [1661-1680] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Declan LeonardSubject: Blank values in lookup lists
Author: Declan Leonard
Date: 20 Feb 2007 11:15 AM
Is it possible to consider blank values in lookup lists. For example where <tans> node is empty set <trans> node to manual.

Also is it possible to set a default value using this functionaly?

If this is not possibe using lookup lists is there any other was to do this with *.conv files?

Thanks,
Declan
Postnext
Tony LavinioSubject: Blank values in lookup lists
Author: Tony Lavinio
Date: 20 Feb 2007 11:20 PM
It should be possible to replace a blank field with a value
for using a lookup list. If you send along a small test case
to stylus-field-report (at) progress.com or attach one here,
we'll take a look.

Also, could you tell us which release of Stylus Studio? There
should be a build number followed by a letter under Help|About.
Postnext
Declan LeonardSubject: Blank values in lookup lists
Author: Declan Leonard
Date: 21 Feb 2007 04:03 AM
Thanks for the reply Tony.

The Stylus build I am using locally is 501J. We are also using the deployment adapters to do these conversions.

I've attached the .csv and .conv files. See the Transmission field. I want to set this field to Manual where no value is supplied.

Thanks,
Declan


UnknownCarzone(1).conv


Unknowncontentsmall.csv
content file
Postnext
Tony LavinioSubject: Blank values in lookup lists
Author: Tony Lavinio
Date: 22 Feb 2007 10:39 AM
Okay, that explains the problem.

The bad news is that support for looking up an empty
value in a list isn't present in 7.1 (2006, build 501).

The good news is that it was added in 7.3 (2006 release 3,
build 653) and if you download it, you'll discover that
we let your license key activate it AND it has support
for replacing an empty value with an item in a list.

See http://www.stylusstudio.com/update

You might also download the 2007 release, which has a really
cool XML publisher that can write HTML+CSS or XSL:FO.

Postnext
Declan LeonardSubject: Blank values in lookup lists
Author: Declan Leonard
Date: 22 Feb 2007 10:43 AM
Thank Tony,

Is the equivilent release available for the deployment adapters as well? This is mainly where we need this functionality as we process as large number of csv documents on the fly.

D
Postnext
Tony LavinioSubject: Blank values in lookup lists
Author: Tony Lavinio
Date: 22 Feb 2007 10:51 AM
The equivalent build of deployment adapters has the fix as well.

(Convert-to-XML inside of Stylus Studio actually calls the
Convert-to-XML deployment adapter, but pipes the output
directly to the preview window.)
Postnext
Declan LeonardSubject: Blank values in lookup lists
Author: Declan Leonard
Date: 22 Feb 2007 10:54 AM
Nice one, cheers Tony
Postnext
Declan LeonardSubject: Blank values in lookup lists
Author: Declan Leonard
Date: 22 Feb 2007 11:08 AM
Sorry to bother you again Tony, but could you point out to me where I can download the 2006 V3 of the deployment adapters. I don't see them on the update page.

Thanks,
D
Postnext
Tony LavinioSubject: Blank values in lookup lists
Author: Tony Lavinio
Date: 22 Feb 2007 12:39 PM
http://download.stylusstudio.com/stylusstudio/downloads/stylus-studio-deployment-components-7r3.zip

Postnext
Declan LeonardSubject: Blank values in lookup lists
Author: Declan Leonard
Date: 15 Mar 2007 11:32 AM
Tony,

I've only got chance to test the no value lookup list funtionality with the deployment adapters today and it doesn't seem to be working. The test was performed using version 7.3 of the adapters.

The lookup lists are handled correcly using the full desktop version of stylus version 7.3.

Could you take a look at this when you get a chance. If you need any more info let me know

Thanks,
Declan
Posttop
Declan LeonardSubject: Blank values in lookup lists
Author: Declan Leonard
Date: 22 Mar 2007 10:27 AM
Hi,

Did anyone get a chance to look into this problem?

Thanks,
D
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.