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)
-> + Disabled Watch and Variable Vi... (4)
-> + Accessing Filemaker DB via ODB... (2)
-> + About XML Graphs (2)
-> + Error when generate java bindi... (2)
-> + Formatting a number to always ... (2)
-> + Bug with graphical mapper (2)
-> + Back Map to XML does not work (2)
-> + Floating Instruction Graphics (2)
-> + Mapping XSD (4)
-> + Output has dashes (Hyphens) th... (7)
-> + Fwd: Error Message (2)
-> + Error Message (5)
-> + EPG XML Generation (2)
-> + Connection to DB2 UDB (8)
-> + Instructions In Mapper (6)
-> + using oracle's orcl:right-trim... (2)
-> + xsl fo, generate links in pdf... (3)
-> + Documentation (annotations) in... (4)
-> + Linking to RDBMS to Applicatio... (2)
-> + Stylus build 653c // Metainfor... (3)
-> + namesspacing external entities (6)
-> + Suppress namespace on every no... (5)
-> + xpath: how do I get what I wan... (6)
-> + Still can't remove SS!! (2)
-> + Convert to XML (3)
-> + EDI Error (10)
-> + (500) internal server error wh... (2)
-> + Space formatting with   (4)
-> + UDDI Browser and WS Call Compo... (4)
-> + cursor weirdness (2)
-> + Open XML files in IE, edit wit... (3)
-> + Generate XML from schema (2)
-> + Line-oriented region problem i... (4)
-> + Using local DB2 database Alias... (2)
-> + Small but annoying display bug... (3)
-> - Blank values in lookup lists (11)
-> ->Blank values in lookup li...
-> ->Blank values in lookup li...
-> ->Blank values in lookup li...
-> ->Blank values in lookup li...
-> ->Blank values in lookup li...
-> ->Blank values in lookup li...
-> ->Blank values in lookup li...
-> ->Blank values in lookup li...
-> ->Blank values in lookup li...
-> ->Blank values in lookup li...
-> + xsd problem in mapper (2)
-> + Deployment License (2)
-> + XML post and web service (2)
-> + Stylus just wont start? (2)
-> - Can'rt remove SS from Windows ... (1)
-> + SenseX stops working on second... (4)
-> + dodgy(non-ascii) characters ca... (8)
-> + Optional values (ZZ1) causes e... (3)
-> + Have problems with displaying ... (9)
-> + Can Stylus Studio be used to m... (3)
-> + Erratic behaviour in EDIFACT a... (2)
-> + Year Calculation (2)
-> + How to ouput a real XLS (3)
-> + EDI 856 to XML - java.io.IOExc... (3)
-> + Problem transform EDI to XML (... (2)
-> + SS becomes unusable... (6)
-> + SS Enterprise 735f under WinXP... (7)
-> + Call Web Service, Nothing retu... (12)
-> + Error while debugging xslt wit... (2)
-> + DESADV D96A Schema vs XML inco... (4)
-> + Das Programm mit mysql ? (4)
-> + RegEx Search and Replace (6)
-> + SequeLink Server - Do I need a... (6)
-> + faultString: (401)Unauthorized... (7)
-> + Previewing XSL with javascript... (2)
-> + removing formating from XML (6)
-> + removing formating from XML (2)
-> + Custom EDI to XML conversion (2)
-> + Getting "Type not found" error... (4)
-> - Converting file and customize ... (1)
-> + formatting problem with xml ex... (2)
-> + Using DTD Entities and XSD (7)
-> + XML Schema (XSD), Adding comme... (2)
-> + DTD schema generation problem (2)
-> + How do i generate a schema fro... (4)
-> + Incomplete request message gen... (2)
-> + Installation issue for Stylus ... (2)
-> + DTD "ANY" isn't honored by val... (2)
-> + Replacing carriage returns wit... (3)
-> + WS with SOAP - problem with pa... (5)
-> + problem converting CSV to XML (2)
-> + validating xml with multiple s... (4)
-> + SOAP problems ! (2)
-> + mapping csv columns to schema (2)
-> - Access DB to XML doc using an ... (1)
-> - DataDirect SequelLink w/MS Acc... (1)
-> + Problem with DB to XML Source ... (3)
-> + problems to work from the comm... (3)
-> + Stylus Studio Enterprise WScal... (4)
-> + Erratic behaviour in EDIFACT a... (14)
-> + XML Pipeline Question (7)
-> + Stylus Studio reports invalid ... (4)
-> - Is there a way to generate a G... (1)
-> + Stylus produced XSLT not trans... (2)
-> + XML Editor spell check - bug w... (4)
-> + API unlocks OK, but fails in n... (4)
-> + EDI to XML conversion for UNOC... (11)
-> + Stylus crashed with recurence ... (2)
-> + terrible perfomance using the ... (4)
-> + XSD to RDBMS, e.g. SQL Server,... (3)
-> + relational database (7)
-> + Stylus Studio 6 wrongfully det... (6)
-> + Having trouble with schema val... (5)
-> + Stylus Studio 2007 Home Editio... (2)
-- Previous [1681-1700] [1701-1720] [1721-1740] 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.