Re: Webcat deletes last line from Excel-saved text db

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59067
interpreted = N
texte = Another Excel-related issue is to not import databases into Excel that start with a field named ID - they're imported incorrectly (it throws an error because it thinks it's a different format). Just make sure the first field is something else. >You must have a carriage-return at the end of the db file, so my guess is webcat is going back to the last return, which would be the beginning of your last line of the Excel file. > >FWIW, I *never* save my files from Excel. You have Microsoft "smart-quoting" to deal with and other issues, like the one you've found. Perhaps Mac Office doesn't "smart quote" - I don't recall. > >What I do is work up the data in Excel, then select the entire sheet, copy and paste it into a plain text editor, BBEdit would be good in your case. Tabular formatting will be preserved and you don't have any funny business added by the save procedure from Excel. > >GK > >At 04:14 PM 8/14/2004, you wrote: >>Hey- >> >>I've found that when I save a db in excel's tab delimited text (Mac Excel 98) format that webcat chops off the last entry ( and leaves a blank line in its place). This will continue with every Excel save and Webcat open. >> >> I've opened the Exel-saved db in a text editor and it looks normal, with no funny characters at the end, just a carriage return. >> >>Anyone experience this problem? >> >>Thanks, >>john > > >------------------------------------------------------------- >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 >Web Archive of this list is at: http://webdna.smithmicro.com/ -- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.com ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Webcat deletes last line from Excel-saved text db ( Gary Krockover 2004)
  2. Re: Webcat deletes last line from Excel-saved text db ( John Hill 2004)
  3. Re: Webcat deletes last line from Excel-saved text db ( John Hill 2004)
  4. Re: Webcat deletes last line from Excel-saved text db ( Gary Krockover 2004)
  5. Webcat deletes last line from Excel-saved text db ( John Bennett 2004)
Another Excel-related issue is to not import databases into Excel that start with a field named ID - they're imported incorrectly (it throws an error because it thinks it's a different format). Just make sure the first field is something else. >You must have a carriage-return at the end of the db file, so my guess is webcat is going back to the last return, which would be the beginning of your last line of the Excel file. > >FWIW, I *never* save my files from Excel. You have Microsoft "smart-quoting" to deal with and other issues, like the one you've found. Perhaps Mac Office doesn't "smart quote" - I don't recall. > >What I do is work up the data in Excel, then select the entire sheet, copy and paste it into a plain text editor, BBEdit would be good in your case. Tabular formatting will be preserved and you don't have any funny business added by the save procedure from Excel. > >GK > >At 04:14 PM 8/14/2004, you wrote: >>Hey- >> >>I've found that when I save a db in excel's tab delimited text (Mac Excel 98) format that webcat chops off the last entry ( and leaves a blank line in its place). This will continue with every Excel save and Webcat open. >> >> I've opened the Exel-saved db in a text editor and it looks normal, with no funny characters at the end, just a carriage return. >> >>Anyone experience this problem? >> >>Thanks, >>john > > >------------------------------------------------------------- >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 >Web Archive of this list is at: http://webdna.smithmicro.com/ -- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.com ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ John Hill

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:

Emailer setup (1997) Search Question (2003) quitting (1997) RE: type 2 errors with ssl server (1997) !@#$$@@# formulas database, tax and freight. (2002) browser info.txt and SSL (1997) WebCat editing, SiteGuard & SiteEdit (1997) Faxing orders in place of email (1997) SpiderBotLock! (2003) WC1.6 to WC2 date formatting (1997) Banners (1997) Payments -> Bank Accounts (2005) Security hole in WebCat? (1999) Table Loop Hoops (2000) MacWEEK article help needed (1996) TEXT Variable (2003) Timer Values on [redirect] (1998) Size limit for tmpl editor ? (1997) searching with groups (1997) snicker, snicker (1997)