Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: DEREK DODOO
  Where is DEREK DODOO?
 READING, UK
 United Kingdom
 DEREK DODOO
 Tags
Subject: RE: problem with text file generated- urgent
Thread ID: 143090 Message ID: 143136 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Saturday, August 25, 2007 8:06:46 AM         
   


> >
> > Keep in mind that SDF have Header record, all field names are there in first row of the SDF file.
> > If that is not an issue and the importing application stops in the middle of the import may be, just may be, the porblem is in other application, not in yours. Could you import the same file in Excel?
>
>
> The third party software was being fed with text generated from another application using visual basic.
>
> I was giving the exact data structure, and I built it in vfp, to do same.
>
> Which format will include carriage return in the generation of the textfile.
>
> Thanks

CR+LF are included in all text formats as end of line marker.
I remember one ERP (I think it was SUSYSTEMS but I could be wrong) didn't liked CRLF at the end of the last line. Others wanted EOF (Ctrl+Z) marker at the end of file. So you have two choices

1. Ask developers of that application what they don't like in your file.
2. Ask your user to send you a file which are imported correctly in that application and see the difference.



-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

ENTIRE THREAD

problem with text file generated- urgent Posted by DEREK DODOO @ 8/24/2007 7:40:55 PM
RE: problem with text file generated Posted by Pamela Thalacker @ 8/24/2007 7:47:45 PM
RE: problem with text file generated Posted by DEREK DODOO @ 8/24/2007 7:59:28 PM
RE: problem with text file generated Posted by Barbara Peisch @ 8/24/2007 8:34:06 PM
RE: problem with text file generated Posted by Pamela Thalacker @ 8/24/2007 9:07:40 PM
RE: problem with text file generated- urgent Posted by Borislav Borissov @ 8/24/2007 9:02:09 PM
RE: problem with text file generated- urgent Posted by DEREK DODOO @ 8/25/2007 6:21:19 AM
RE: problem with text file generated- urgent Posted by Borislav Borissov @ 8/25/2007 8:06:46 AM
RE: problem with text file generated- urgent Posted by DEREK DODOO @ 8/27/2007 3:22:22 PM
RE: problem with text file generated- urgent Posted by Borislav Borissov @ 8/27/2007 3:59:29 PM
RE: problem with text file generated- urgent Posted by tushar @ 8/27/2007 4:31:14 PM
RE: problem with text file generated- urgent Posted by tushar @ 8/25/2007 8:52:10 AM
RE: problem with text file generated- urgent Posted by Cetin Basoz @ 8/24/2007 9:28:50 PM