This doesn't happen in FPW, does it happen in VFP? They changed the behavior?
--- On Thu, 11/11/10, John Weller <[email protected]> wrote: > From: John Weller <[email protected]> > Subject: RE: A Peculiar CSV Import Issue > To: [email protected] > Date: Thursday, November 11, 2010, 12:34 PM > I have had problems like this. > The command APPEND FROM <filename> TYPE CSV > will always drop the first line as it assumes it is the > header. If your > data does not have a header line then use APPEND FROM > <filename> TYPE > DELIMITED. > > HTH > > John Weller > 01380 723235 > 07976 393631 > > > > -----Original Message----- > > From: [email protected] > [mailto:[email protected]] > On Behalf > > Of Kurt Wendt > > Sent: 11 November 2010 17:17 > > To: [email protected] > > Subject: A Peculiar CSV Import Issue > > > > I'm working on this system for a client - where we > need to import CSV > > data into VFP. This particular CSV file gets generated > from UPS > > Worldship. Upon importing the data - we noticed that > the top record in > > my system was not getting the Tracking#. Upon stepping > thru the program > > - I found that the 1st line of data from the CSV file > was NOT being > > Imported at All by VFP! > > > > > > > > Now - I know a standard CSV file has field/column > labels as the 1st > > record of a CSV file. However, upon opening up the CSV > file from UPS in > > Notepad - I saw that the CSV file did NOT contain > those field headers! > > And, so - I am assuming that VFP is considering the > top line of data as > > field headers - and therefore ignoring the record. > > > > > > > > Could I be doing something wrong? Or, is this just a > Non-Standard type > > of CSV file - and now I have to code things > differently to handle it??? > > > > > > > > If I have to - I will code a work-around. My QA Tech > buddy suggested > > that I open the CSV file and insert the field headers. > Although, what I > > would really do is just generate this stuff to a > secondary/temporary > > type CSV file - as opposed to messing with the > original one. > > > > > > > > But, I figured I would post a message here to see what > others thought... > > > > Thanks, > > > > -K- > > > > > > > > Developer > > > > Waitex Information System, Inc. > > > > > > > > > > > > --- StripMime Report -- processed MIME parts --- > > multipart/alternative > > text/plain (text body -- kept) > > text/html > > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
