DwZone Forum DwZone Forum
Welcome to the DwZone-it Forum
 
  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  
    RegisterRegister -->   LoginLogin  
Import/Export Tools  
DwZone Forum Index -> Import/Export Tools

Moderators: Administrators, Moderators 		 Mark all topics read
Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.
New Topic Search for
 View     Per page     Messages Since 
Messages 261 to 270 of 382 (Total: 233) First |  Prev |  Next |  Last  
 Subject Author Date  
   Re:Problems language Excel Export  
View this persons public profile  [email protected]   11:05 11 Apr 2008  
   Re:Problems language Excel Export  
View this persons public profile  gianluigi   11:44 11 Apr 2008  
   XML Page Caching  
View this persons public profile  [email protected]   5:48 9 Apr 2008  
   Re:XML Page Caching  
View this persons public profile  gianluigi   10:02 9 Apr 2008  
   Re:XML Page Caching  
View this persons public profile  gianluigi   10:20 9 Apr 2008  
   Re:XML Page Caching  
View this persons public profile  [email protected]   10:49 9 Apr 2008  
   formatting records  
View this persons public profile  [email protected]   1:56 9 Apr 2008  
    Re:formatting records  
View this persons public profile  [email protected]   2:13 9 Apr 2008  
 
well i've given it a go

modified the function

private function FormatValue(strValue, Format)
if lcase(left(Format,6)) = lcase("Number") then
FormatValue = FormatAsNumber(strValue, Format)
elseif lcase(left(Format,4)) = lcase("Date") then
FormatValue = FormatAsDate(strValue, Format)
elseif lcase(left(Format,8)) = lcase("Checkbox") then
FormatAsChk(strValue, Format)
elseif lcase(left(Format,5)) = lcase("Color") then
FormatValue = FormatAsColor(strValue, Format)
end if
end function

and added the fuction

private function FormatAsColor(strValue, Format)
tmpColor = strValue
tmpColor = replace(tmpColor,"#","0x")
FormatAsColor = trim(tmpColor)
end function

where

dwzXml_rs.addItem "bgcolour", "SkinBGColor", "Color", "Line"

and it seems to work
 
Reply to this current thread  View this persons public profile  Send Private Message
   Re:formatting records  
View this persons public profile  gianluigi   10:04 9 Apr 2008  
   Re:formatting records  
View this persons public profile  gianluigi   10:33 9 Apr 2008  
Last Visit: Tuesday 17 Jun, 2025 0:36 pm First |  Prev |  Next |  Last  
 Login
Username:  Password:    
Read Message Read Message   Unread message Unread message
Read message [popular] Read message [popular]   Unread message [popular] Unread message [popular]
Read message [locked] Read message [locked]   Unread message [locked] Unread message [locked]
All times are GMT-2

Jump to: