Re: Switching from merge to tab delimited..(v 2.x)
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 33505
interpreted = N
texte = see belowChristopher Feyrer wrote:> >>I'm dealing with a database with hundreds of fields. This is what I did to > >>accomplish the switch: > >> > >>1. I expored the database as tab delimited from Filemaker Pro. > >>2. I created a database.hdr file from the top line with the field of the > >>previous database, replacing commas with tabs so that the fields would be > >>tab seperated. Then, I put a carriage return at the end. > >>3. I commited and closed all databases. > > > >This all sounds right, so the most important thing is to make *sure* > >the .hdr matches the actual data perfectly. You might try pulling > >the .hdr into Excel, and then pull in the data on the lines below > >that, as a means of lining everything up. > > > > I'm on a Macintosh which does not have Excel. Any other ideas as to how I > can line these fields up? BBEdit would be extremely time consuming.. can > you think of another solution that would not take as much time?filemaker pro.> > > >It's also possible you really are out of memory, so try bumping > >WebCatalog's allocation up. > > > >>Also, I'm having trouble getting rid of vertical tabs from my database. > >>What's the best way to do this (can it be avoided during export from > >>Filemaker)? > > > >WebCatalog doesn't mind vertical tabs. In fact, it recognizes them > >for what they are (soft-returns) and will output them as hard returns > >if you wrap the database field tag inside an [input] context. > > > > Eek. Does this mean I have to go into each and every page of my website > and replace all field references to [input][field][/input]??only where you want to display the contents of that field while simultaneously having the soft returns converted to hard ones. If you don't need that in a given spot, then don't bother.There are> hundreds of database references in the site..this will be time consuming as > well! > > IT'll be quite frustrating if there are no alternatives. > > CJF > > Christopher Feyrer > System Administrator > FoodSpot.com > chris@foodspot.com > ------------------- > PGP 6.x key available. > > ------------------------------------------------------------- > 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://search.smithmicro.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
see belowChristopher Feyrer wrote:> >>I'm dealing with a database with hundreds of fields. This is what I did to > >>accomplish the switch: > >> > >>1. I expored the database as tab delimited from Filemaker Pro. > >>2. I created a database.hdr file from the top line with the field of the > >>previous database, replacing commas with tabs so that the fields would be > >>tab seperated. Then, I put a carriage return at the end. > >>3. I commited and closed all databases. > > > >This all sounds right, so the most important thing is to make *sure* > >the .hdr matches the actual data perfectly. You might try pulling > >the .hdr into Excel, and then pull in the data on the lines below > >that, as a means of lining everything up. > > > > I'm on a Macintosh which does not have Excel. Any other ideas as to how I > can line these fields up? BBEdit would be extremely time consuming.. can > you think of another solution that would not take as much time?filemaker pro.> > > >It's also possible you really are out of memory, so try bumping > >WebCatalog's allocation up. > > > >>Also, I'm having trouble getting rid of vertical tabs from my database. > >>What's the best way to do this (can it be avoided during export from > >>Filemaker)? > > > >WebCatalog doesn't mind vertical tabs. In fact, it recognizes them > >for what they are (soft-returns) and will output them as hard returns > >if you wrap the database field tag inside an [input] context. > > > > Eek. Does this mean I have to go into each and every page of my website > and replace all field references to [input][field][/input]??only where you want to display the contents of that field while simultaneously having the soft returns converted to hard ones. If you don't need that in a given spot, then don't bother.There are> hundreds of database references in the site..this will be time consuming as > well! > > IT'll be quite frustrating if there are no alternatives. > > CJF > > Christopher Feyrer > System Administrator > FoodSpot.com > chris@foodspot.com > ------------------- > PGP 6.x key available. > > ------------------------------------------------------------- > 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://search.smithmicro.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://search.smithmicro.com/
John Butler
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:
Re1000001: Setting up shop (1997)
Date fun with MySQL (2004)
Wholesale programming offer sold out ... (2006)
How To question on setting up downloads (1997)
final on include (1997)
Too Much Rootbeer Free Offer (1997)
A few questions. . . (1997)
Pithy questions on webcommerce & siteedit (1997)
Protect and Serve (1999)
Constructive criticism (2000)
PIXO support (1997)
Unix DB Permission Error (2002)
Why isn't this working (1999)
all db's in one folder and protected (1998)
select multiple 2 more cents (1997)
Running 2 two WebCatalog.acgi's (1996)
Hard Questions ? (1997)
unsubscribe (1997)
small hairball -- stuck on [showif] for related db (1998)
Unknown error: OrderNotCreated (1997)