|
| A R C H I V E D M E S S A G E |
|
Subject: Please help with CSV output |
| Posted: 04/20/2004 at 3:33:29 am |
| By: jonnyknock |
| I there any way to enter a return or line break at the end of one entry?
My form has 5 fields.
When it sends the datat to the .dat file it doesn't add new information on a seperate line, it bunches it up. And becasue it doesn't start or end with a deliminator, most softwares import the last and first records as one.
Is there a way to have records placed on new lines?
| |
|
|
Subject: Example |
| Posted: 04/20/2004 at 3:35:49 am |
| By: jonnyknock |
| Say my required fields were Name and Age
After filling in the form this is sent to the .dat file
Jon,27
After a few it looks like this
Jon,27 Simon,60 Jim,20 Paul,54
Rather than like this
Jon,27
Simon,60
Jiom,20
Paul,54
Or like this even
,Jon,27,Simon,60,Jim,20,Paul,54, | |
|
|
Subject: Re: Please help with CSV output |
| Posted: 04/21/2004 at 6:09:19 am |
| By: Seth Knorr |
| This a good question.
At the end of every line of data written to the .dat file, biz mail form uses \n
to specify that the data file should have a line break and go to the next line.
However... Depending on what program you open the .dat into, it may not look like a line break. Instead some programs will put a figure that looks like a BOX, or looks similar to this: []
I obviously can't put the symbol here because it will just convert into a line break.
My suggestions would be.
1. Try opening it up in note pad.
2. Try opening it up in Word pad.
3. Try opening it up directly in excell.
If none of these work there may be a problem with your server converting the \n to line breaks when sending it to the data file.
Let me know how that turns out for you.
Seth
| |
|
|
Subject: Re: Please help with CSV output |
| Posted: 04/21/2004 at 7:27:09 am |
| By: jonnyknock |
| Hi seth it puts nothing in at all, even when viewing the original .dat file it's just a space...?
| |
|
|
Subject: Re: Please help with CSV output |
| Posted: 04/21/2004 at 7:29:58 am |
| By: jonnyknock |
| seems to work in firefox browser..IE 6 doesn't understand the /n
| |
|
|
Subject: Re: Please help with CSV output |
| Posted: 04/21/2004 at 7:47:51 am |
| By: Seth Knorr |
| 1. Are you on a windows server/ hosting account.
If so you have to contact your host to make bizmail.dat, Read, write, and executable for everyone.
2. It would have nothing to do with your web browser, it would only be a server isue. As that is where the script is run, and writes to the data file.
Seth | |
|
|
Subject: Re: Please help with CSV output |
| Posted: 04/21/2004 at 8:18:19 am |
| By: jonnyknock |
| My server is unix, I am using windows.
If I direct my browser to the .dat file it has no return, but if I use firefox as a browser it has a return on it.
I made the balnk .dat file in dreamweaver..perhaps that's why? | |
|
|
Subject: Re: Please help with CSV output |
| Posted: 04/21/2004 at 8:40:28 am |
| By: jonnyknock |
| Hi Seth
I remade blank .dat files in Notepad and it seems to work just grand now! Thanks for all your help!!
BTW, can it be a .txt file or anything else for that matter or does one have to specify a .dat? | |
|
|
Subject: Re: Please help with CSV output |
| Posted: 04/21/2004 at 11:49:29 am |
| By: Seth Knorr |
| It realy does not matter. Mainly I think on servers it may be posible to read a txt file uploaded in the cgi-bin, however with the .dat you can not. However generaly this is not the case.
Seth | |
|
|
