File Maker Pro Value List Field Export Proplem...
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26917
interpreted = N
texte = Has anyone ran across this problem? I have a client who will be exporting data from a FileMaker Pro database as a Tab Delimited file that actually will be used as an INCLUDE file. The Database only exports one field (a calculation) per record which looks like:[replace db=../data/product.db&eqProductIDdata=STR45117&append=T]ProductID=STR45117&A ccessories=STR45937 &ProductName=Litebox&PhotoLarge=&PhotoSmall=STR45117_YEL .jpg&DescriptionLong=Litebox standard system includes 120V AC and DC chargers, shoulder strap and mounting bracket. Includes a 8 watt spot lamp. Lamp head rotates so you can direct the light on your work. Runs up to 8 hours on a single charge. Power Failure version available. When the power goes out the light goes on, and then can be removed from the charging station for mobile use.&DescriptionShort=Litebox Standard System, 8 watt spot bulb, Yellow&DescriptionKeyFeature=8 hour run time, swivel head, firefighter favorite.....$101.95&BatteryType=Lantern Rechargeable&BatteryNumber=Sealed lead acid&ProductCatagory=Fire Industrial PolyCarbonate Police Emergency&Length=1 1.5&LightOutput=50,000 CP&LampType=&CandlePower=46,000-70,000 31,000-45,000&Manufacturer=Streamligh t&RunTime=8 Hrs.&SafetyRatings=&ShipWeight=10.25 LBS&Weight=7.4 LBS&PriceMSRP=179.95&PriceBG=106.95&PriceDiscount=&PriceFinal=106.95&PriceSa ve=73&Warning=&Status=NA&Primary=Yes[/replace]There will be one line of code like this for every record. This in effect updates or appends the current online database. The Problem I am having is getting gremlins from the Fields that contain Value Lists. These gremlins are used to delimit the multiple values in the value list fields. Does anyone have an idea on how to 'scrub' this data before it leaves FileMaker or Anywhere a long the line before it enters the WebCatalog Database? -- Eric Ridgley, Web/Graphic Designer...............Phone: 330.630.4487 Silver Creek, Ltd. ...............Fax: 330.630.5786 143 Northwest Avenue, Suite B101 ...............URL: www.silvercreek.net/ Tallmadge Ohio 44278 ...............URL: www.ridgley.org/------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
Has anyone ran across this problem? I have a client who will be exporting data from a FileMaker Pro database as a Tab Delimited file that actually will be used as an INCLUDE file. The Database only exports one field (a calculation) per record which looks like:[replace db=../data/product.db&eqProductIDdata=STR45117&append=T]ProductID=STR45117&A ccessories=STR45937 &ProductName=Litebox&PhotoLarge=&PhotoSmall=STR45117_YEL .jpg&DescriptionLong=Litebox standard system includes 120V AC and DC chargers, shoulder strap and mounting bracket. Includes a 8 watt spot lamp. Lamp head rotates so you can direct the light on your work. Runs up to 8 hours on a single charge. Power Failure version available. When the power goes out the light goes on, and then can be removed from the charging station for mobile use.&DescriptionShort=Litebox Standard System, 8 watt spot bulb, Yellow&DescriptionKeyFeature=8 hour run time, swivel head, firefighter favorite.....$101.95&BatteryType=Lantern Rechargeable&BatteryNumber=Sealed lead acid&ProductCatagory=Fire Industrial PolyCarbonate Police Emergency&Length=1 1.5&LightOutput=50,000 CP&LampType=&CandlePower=46,000-70,000 31,000-45,000&Manufacturer=Streamligh t&RunTime=8 Hrs.&SafetyRatings=&ShipWeight=10.25 LBS&Weight=7.4 LBS&PriceMSRP=179.95&PriceBG=106.95&PriceDiscount=&PriceFinal=106.95&PriceSa ve=73&Warning=&Status=NA&Primary=Yes[/replace]There will be one line of code like this for every record. This in effect updates or appends the current online database. The Problem I am having is getting gremlins from the Fields that contain Value Lists. These gremlins are used to delimit the multiple values in the value list fields. Does anyone have an idea on how to 'scrub' this data before it leaves FileMaker or Anywhere a long the line before it enters the WebCatalog Database? -- Eric Ridgley, Web/Graphic Designer...............Phone: 330.630.4487 Silver Creek, Ltd. ...............Fax: 330.630.5786 143 Northwest Avenue, Suite B101 ...............URL: www.silvercreek.net/ Tallmadge Ohio 44278 ...............URL: www.ridgley.org/------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Eric Ridgley
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[urgent] Phone number at SM (2006)
Loss in Form (1998)
New Plug-in and Type 11 errors (1997)
Re:WebDNA Writer Needed (1997)
turning every 5th line red (1998)
Authenticate Questions (2003)
[searchString] (1997)
triggering an update of two frames (1998)
[WebDNA] RESTART WebDNA (2016)
Bay Area Residents / Bay To Breakers (1998)
[math date] with non-US date format (2000)
[WebDNA] Emailer breaking format (2015)
Plugin causes type 2 error on WebStar startup (2000)
Math Help (2000)
PCS Frames-Default page is solution! (1997)
Showif for mulitple variations (1997)
RE: Re:Signal Raised (1997)
Shopping Carts folder does not exist in Linux (2000)
Shell script within a sandbox (2005)
PIXO (1997)