In FPW it takes the header and imports it into the database as the first row. I don't know why it's ignoring the first row.
Are you using the standard "append from filename type delimited" command --- On Thu, 11/11/10, Richard Quilhot <quilh...@gmail.com> wrote: > From: Richard Quilhot <quilh...@gmail.com> > Subject: Re: A Peculiar CSV Import Issue > To: "ProFox Email List" <profox@leafe.com> > Date: Thursday, November 11, 2010, 12:24 PM > I know the import wizzard will allow > you to designate if the first record is > a header, but don't know the code / switch for it. > > Rick Q > quilh...@gmail.com > > > > > On Thu, Nov 11, 2010 at 12:17 PM, Kurt Wendt <kurtwe...@waitex.com> > wrote: > > > 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) > > te[excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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/804289.90417...@web31407.mail.mud.yahoo.com ** 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.
