If I do an "APPEND FROM TYPE CSV" it does not import the first line. I just deleted the header line of a csv file and it did not append the first record of data. I added back in "x" as a first line and it ignored it and appended the whole file correctly.
If it were my project, I would just add something to the first line followed by the chr(13) + chr(10). HTH Jeff --------------- Jeff Johnson [email protected] (623) 582-0323 www.san-dc.com On 11/11/2010 10:17 AM, Kurt Wendt 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) > 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.
