Home

   Home

   Download


Help

   FAQ

   Installation

   Message Board

   Importing Data File
   Into GoldMine
   Into Act


Other

   Testimonies

   Custom Programming

   PHP Version


Other Favorites

   Hire a clean comedian

   Bible Search Engine

   Bible in a Year

   Parallel Bible

   The Richer Life










 





[ Message Board Home ]    [ Post Reply ]    [ Log In ]    [ Sign Up ]



  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



Reply To This Topic

Subject
Message  
Username
Password
Due to unrelated post's, you must have an
account to post a message. To Sign Up click here.




Copyright 2000-2010 Seth M. Knorr,
BizMailForm.com Forms Processor, All Rights Reserved