WinBatch Tech Support Home

Database Search

If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.

TechHome

WinBatch
OLE COM ADO CDO ADSI LDAP
LogParser

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

LogParser DataGrid

 Keywords: LogParser DataGrid MSUtil.LogQuery CSV CSVInputFormat DataGridOutputFormat
LogParserDataGrid.wbt 
;Microsoft LogParser 2.2 - CSV into DataGrid
;                          Grid is automatically provided by
;                          the LogParser dll
;
;Stan Littlefield, January 2, 2007
;//////////////////////////////////////////////////////////////////////////////////////

cCSV = StrCat(DirScript(),"carinv.csv")
If ! FileExist(cCSV) Then Exit
cSQL = "SELECT Stock_Number,Year,Make,Model,Mileage,[Date In Stock] into DATAGRID FROM %cCSV% ORDER BY Make"

BoxOpen("Please Wait...",StrCat("Processing LogParser Query",@CRLF,cSQL) )
oLog = CreateObject("MSUtil.LogQuery")
oLog.maxParseErrors = 100

oInput = CreateObject("MSUtil.LogQuery.CSVInputFormat")
oInput.headerRow = 1
oOut = CreateObject("MSUtil.LogQuery.DataGridOutputFormat.1")
BoxShut()
oLog.ExecuteBatch(cSQL, oInput, oOut)
If oLog.lastError <> 0
   cErrors = StrCat("Errors:",@CRLF)
   ForEach strMessage In oLog.errorMessages
        cErrors=StrCat(cErrors,strMessage,@CRLF)
   Next
   Message("Error Report",cErrors)
EndIf
oOut=0
oInput=0
oLog=0
Exit
;//////////////////////////////////////////////////////////////////////////////////////

CarInv.csv 

Stock_Number,Year,Make,Model,Unit Type,Cost,Color,Mileage,Date In Stock,Recon Cost,R/W,Days in Stock,DIS,Day,Mth,Yr,,,,,,,,
ZB5238A,2006,BMW,3 Series,IMPORT,,Silver,1688,9/10/2005,,,478,3,Sat,Sep,2005,,,,,,,,
G5854,2005,Chevrolet,Impala,TRUCK,,Silver,22804,9/2/2005,,,486,3,Fri,Sep,2005,,,,,,,,
G5895,2005,Chevrolet,Malibu,DOMESTIC,,White,29418,10/13/2005,,,445,3,Thu,Oct,2005,,,,,,,,
G5896,2005,Chevrolet,Malibu,DOMESTIC,,Beige,29561,10/13/2005,,,445,3,Thu,Oct,2005,,,,,,,,
G5894,2005,Chevrolet,Malibu,DOMESTIC,,Silver,23046,10/13/2005,,,445,3,Thu,Oct,2005,,,,,,,,
G5880,2005,Chevrolet,Malibu,DOMESTIC,,Silver,23614,9/30/2005,,,458,3,Fri,Sep,2005,,,,,,,,
G5886,2005,Dodge,Durango,TRUCK,,White,24772,10/7/2005,,,451,3,Fri,Oct,2005,,,,,,,,
G5898,2005,Dodge,Neon,DOMESTIC,,Red,18018,10/17/2005,,,441,3,Mon,Oct,2005,,,,,,,,
G5900,2005,Dodge,Stratus,DOMESTIC,,Silver,18011,10/17/2005,,,441,3,Mon,Oct,2005,,,,,,,,
G5899,2005,Dodge,Stratus,DOMESTIC,,Red,10697,10/17/2005,,,441,3,Mon,Oct,2005,,,,,,,,
G5872,2005,Ford,Taurus,DOMESTIC,,,15620,9/20/2005,,,468,3,Tue,Sep,2005,,,,,,,,
G5887,2005,Hyundai,Sonata,IMPORT,,Blue,21964,10/7/2005,,,451,3,Fri,Oct,2005,,,,,,,,
G5740,2005,Infiniti,FX35,TRUCK,,Gray,18110,6/7/2005,,,573,3,Tue,Jun,2005,,,,,,,,
XG5869,2005,Kia,Optima,IMPORT,,White,1045,9/20/2005,,,468,3,Tue,Sep,2005,,,,,,,,
RS5825,2005,Kia,Sedona,IMPORT,,Gold,6936,7/26/2005,,,524,3,Tue,Jul,2005,,,,,,,,
G5892,2005,Mitsubishi,Galant,IMPORT,,Green,21848,10/13/2005,,,445,3,Thu,Oct,2005
XG5868,2005,Pontiac,Grand Am,DOMESTIC,,Silver,25848,9/20/2005,,,468,3,Tue,Sep,2005
G5874,2005,Subaru,Impreza,IMPORT,,Blue,13309,9/23/2005,,,465,3,Fri,Sep,2005
G5889,2004,Acura,RSX,IMPORT,,Black,22114,10/12/2005,,,446,3,Wed,Oct,2005
ZR5235B,2004,Acura,TL,IMPORT,,White,31378,8/9/2005,,,510,3,Tue,Aug,2005
ZN5200A,2004,Audi,A8,IMPORT,,Silver,0,6/14/2005,,,566,3,Tue,Jun,2005
MITSU1,2004,Chevrolet,K1500 Pickup+,TRUCK,,Blue,21921,7/8/2005,,,542,3,Fri,Jul,2005
G5884,2004,Dodge,Intrepid,DOMESTIC,,Beige,71308,10/5/2005,,,453,3,Wed,Oct,2005
ZQ5270A,2004,Ford,F150 Pickup+,TRUCK,,Burgundy,16424,8/11/2005,,,508,3,Thu,Aug,2005
ZG5293B,2004,Ford,Mustang,DOMESTIC,,Black,14336,9/19/2005,,,469,3,Mon,Sep,2005
G5858,2004,Honda,Accord,IMPORT,,White,12169,9/8/2005,,,480,3,Thu,Sep,2005
G5853,2004,Hyundai,Santa Fe,TRUCK,,,46129,9/1/2005,,,487,3,Thu,Sep,2005
G5856,2004,Mercury,Sable,DOMESTIC,,Green,48851,9/6/2005,,,482,3,Tue,Sep,2005
G5857,2004,Nissan,Murano,TRUCK,,Orange,22386,9/6/2005,,,482,3,Tue,Sep,2005
G5763,2004,Saab,3-Sep,IMPORT,,Silver,26022,6/24/2005,,,556,3,Fri,Jun,2005
G5847B,2004,Subaru,Impreza,IMPORT,,,12836,9/21/2005,,,467,3,Wed,Sep,2005
ZX5245A,2003,Acura,CL,IMPORT,,Gray,25655,8/9/2005,,,510,3,Tue,Aug,2005
G5879,2003,Acura,MDX,TRUCK,,,46896,9/27/2005,,,461,3,Tue,Sep,2005
G5846A,2003,Acura,TL,IMPORT,,White,39013,9/2/2005,,,486,3,Fri,Sep,2005
A2041A,2003,Audi,A4,IMPORT,,Beige,51940,7/20/2005,,,530,3,Wed,Jul,2005
G5877,2003,Audi,TT,IMPORT,,Black,25777,9/27/2005,,,461,3,Tue,Sep,2005
ZR5278A,2003,BMW,X5,TRUCK,,Green,39632,8/23/2005,,,496,3,Tue,Aug,2005
G5851,2003,Chevrolet,Cavalier,DOMESTIC,,White,49814,9/1/2005,,,487,3,Thu,Sep,2005
ZI5308A,2003,Ford,Explorer,TRUCK,,Green,8825,9/27/2005,,,461,3,Tue,Sep,2005
RS5817,2003,Ford,Focus,DOMESTIC,,Silver,36164,7/21/2005,,,529,3,Thu,Jul,2005
G5882A,2003,Ford,Focus,DOMESTIC,,,16986,10/4/2005,,,454,3,Tue,Oct,2005
G5843,2003,Honda,Pilot,TRUCK,,White,48004,8/25/2005,,,494,3,Thu,Aug,2005
G5891,2003,Hyundai,Elantra,IMPORT,,White,48230,10/12/2005,,,446,3,Wed,Oct,2005
G5865,2003,Mercedes Benz,ML500,TRUCK,,Silver,39566,9/15/2005,,,473,3,Thu,Sep,2005
G5810,2003,Mitsubishi,Lancer (Mitsubishi),IMPORT,,Yellow,24989,7/20/2005,,,530,3,Wed,Jul,2005
G5890,2003,Suzuki,Aerio,IMPORT,,Red,44130,10/12/2005,,,446,3,Wed,Oct,2005
ZE5318A,2002,Acura,TL,IMPORT,,,68910,10/5/2005,,,453,3,Wed,Oct,2005
A2047A,2002,Audi,A4+,IMPORT,,,0,9/19/2005,,,469,3,Mon,Sep,2005
ZX5263B,2002,Chevrolet,TrailBlazer,TRUCK,,Beige,71129,10/13/2005,,,445,3,Thu,Oct,2005
A2033A,2002,Ford,Taurus,DOMESTIC,,Red,97105,9/27/2005,,,461,3,Tue,Sep,2005
G5864,2002,Lexus,ES,IMPORT,,Burgundy,45978,9/15/2005,,,473,3,Thu,Sep,2005
G5878,2002,Lexus,RX,TRUCK,,Blue,0,9/27/2005,,,461,3,Tue,Sep,2005
G5893,2002,Lexus,RX,TRUCK,,Silver,44944,10/13/2005,,,445,3,Thu,Oct,2005
G5834A,2002,Mercedes Benz,C320,IMPORT,,Silver,55523,9/2/2005,,,486,3,Fri,Sep,2005
ZG5281B,2002,Mercedes Benz,ML320,TRUCK,,Gold,29337,9/26/2005,,,462,3,Mon,Sep,2005
G5757A,2002,Volkswagen,Jetta+,IMPORT,,Silver,58981,7/29/2005,,,521,3,Fri,Jul,2005
G5836,2002,Volvo,S80,IMPORT,,Silver,50110,8/17/2005,,,502,3,Wed,Aug,2005
CG5717,2001,Audi,Allroad+,IMPORT,,,48533,5/27/2005,,,584,3,Fri,May,2005
G5860,2001,Chevrolet,Blazer,TRUCK,,Beige,57358,9/12/2005,,,476,3,Mon,Sep,2005
G5848A,2001,Dodge,Intrepid,DOMESTIC,,Beige,44396,10/3/2005,,,455,3,Mon,Oct,2005
XG5870A,2001,Dodge,Stratus,DOMESTIC,,Green,28477,9/28/2005,,,460,3,Wed,Sep,2005
G5824,2001,Honda,Civic,IMPORT,,Red,135487,7/22/2005,,,528,3,Fri,Jul,2005
G5873,2001,Honda,S2000,IMPORT,,Red,39942,9/23/2005,,,465,3,Fri,Sep,2005
ZC5255A,2001,Lincoln,Navigator,TRUCK,,Gold,47353,9/13/2005,,,475,3,Tue,Sep,2005
ZH5264A,2001,Lincoln,Navigator,TRUCK,,Red,61383,9/1/2005,,,487,3,Thu,Sep,2005
G5885,2001,Subaru,Legacy+,TRUCK,,Green,88349,10/5/2005,,,453,3,Wed,Oct,2005
ZJ5239B,2001,Toyota,4runner,TRUCK,,Gold,79154,8/5/2005,,,514,3,Fri,Aug,2005
ZV5256A,2001,Toyota,Camry Solara,IMPORT,,Black,15656,9/30/2005,,,458,3,Fri,Sep,2005
G5883,2001,Volkswagen,Passat,IMPORT,,Green,57491,10/5/2005,,,453,3,Wed,Oct,2005
A2030A,2000,Audi,A6,IMPORT,,Gold,38733,9/12/2005,,,476,3,Mon,Sep,2005
G5839,2000,Ford,Windstar,TRUCK,,,59919,8/17/2005,,,502,3,Wed,Aug,2005
ZL5215B,2000,Hyundai,Elantra,IMPORT,,Gray,92286,9/3/2005,,,485,3,Sat,Sep,2005
G5876,1999,Honda,Odyssey,TRUCK,,Gray,98421,9/27/2005,,,461,3,Tue,Sep,2005
ZQ5287A,1999,Jeep,Grand Cherokee,TRUCK,,Gold,64340,8/31/2005,,,488,3,Wed,Aug,2005
G5875A,1999,Lincoln,Navigator,TRUCK,,Black,74437,9/30/2005,,,458,3,Fri,Sep,2005
ZW5320A,1999,Mazda,Protege,IMPORT,,,76170,10/12/2005,,,446,3,Wed,Oct,2005
ZC5305A,1999,Mercury,Cougar,DOMESTIC,,Silver,76665,9/26/2005,,,462,3,Mon,Sep,2005
ZL5251A,1999,Nissan,Pathfinder,TRUCK,,Brown,111272,8/26/2005,,,493,3,Fri,Aug,2005
A2017C,1999,Plymouth,Neon,DOMESTIC,,Black,146217,9/29/2005,,,459,3,Thu,Sep,2005
ZA5294A,1999,Pontiac,Grand Am,DOMESTIC,,Black,116133,9/16/2005,,,472,3,Fri,Sep,2005
ZU5274A,1998,Audi,A6,IMPORT,,Gray,81958,8/19/2005,,,500,3,Fri,Aug,2005
ZH5300A,1998,Buick,Regal,DOMESTIC,,,110435,9/26/2005,,,462,3,Mon,Sep,2005
G5835A,1998,Chevrolet,Cavalier,DOMESTIC,,Blue,127613,9/20/2005,,,468,3,Tue,Sep,2005
G5867A,1998,Ford,Escort,TRUCK,,,84305,9/20/2005,,,468,3,Tue,Sep,2005
ZM5257B,1998,Isuzu,Trooper,TRUCK,,,87681,8/31/2005,,,488,3,Wed,Aug,2005
ZZ5217A,1998,Jeep,Grand Cherokee,TRUCK,,Black,122760,10/3/2005,,,455,3,Mon,Oct,2005
R5820A,1998,Plymouth,Neon,DOMESTIC,,White,91950,9/7/2005,,,481,3,Wed,Sep,2005
G5852A,1996,Pontiac,Sunfire,DOMESTIC,,Black,201508,10/3/2005,,,455,3,Mon,Oct,2005
G5859A,1995,Ford,Explorer,TRUCK,,White,171183,9/30/2005,,,458,3,Fri,Sep,2005
G5862A,1995,Honda,Accord,IMPORT,,Green,85887,10/17/2005,,,441,3,Mon,Oct,2005
A1131A,1987,Audi,5000,IMPORT,,,56695,6/21/2005,,,559,3,Tue,Jun,2005
A2042B,1987,BMW,6 Series,IMPORT,,Blue,142079,9/27/2005,,,461,3,Tue,Sep,2005
G5881A,2005,Acura,RSX,IMPORT,,Silver,7127,10/14/2005,,,444,3,Fri,Oct,2005
G5881,2005,Chevrolet,Malibu,DOMESTIC,,White,21902,9/30/2005,,,458,3,Fri,Sep,2005
G5897,2005,Chrysler,Sebring,DOMESTIC,,Gray,13640,10/13/2005,,,445,3,Thu,Oct,2005
G5901,2005,Dodge,Grand Caravan,TRUCK,,Silver,26445,10/17/2005,,,441,3,Mon,Oct,2005
G5800,2005,Dodge,Neon,DOMESTIC,,White,21270,7/14/2005,,,536,3,Thu,Jul,2005
R5822,2005,Mazda,Mazda6,IMPORT,,Red,26938,7/21/2005,,,529,3,Thu,Jul,2005
G5844,2004,Acura,TL,IMPORT,,Blue,15808,8/30/2005,,,489,3,Tue,Aug,2005
ZX5316A,2004,Jeep,Wrangler,TRUCK,,Black,6846,10/14/2005,,,444,3,Fri,Oct,2005
G5862,2003,Acura,TL,IMPORT,,Black,46467,9/15/2005,,,473,3,Thu,Sep,2005
ZZ5197A,2003,GMC,Yukon,TRUCK,,White,71203,9/19/2005,,,469,3,Mon,Sep,2005
G5866,2003,Mitsubishi,Diamante,IMPORT,,,9147,9/16/2005,,,472,3,Fri,Sep,2005
G5888,2002,Hyundai,Accent,IMPORT,,Gold,23792,10/7/2005,,,451,3,Fri,Oct,2005
XG5805,2002,Subaru,Legacy+,TRUCK,,Silver,53915,7/19/2005,,,531,3,Tue,Jul,2005
ZU5263A,2001,Volvo,V70+,IMPORT,,White,56927,9/9/2005,,,479,3,Fri,Sep,2005
A2048A,2000,Jeep,Grand Cherokee,TRUCK,,Gray,82321,10/14/2005,,,444,3,Fri,Oct,2005
G5837,2000,Pontiac,Grand Prix,DOMESTIC,,,72389,8/17/2005,,,502,3,Wed,Aug,2005
G5840A,1998,Jeep,Cherokee,TRUCK,,White,87204,8/17/2005,,,502,3,Wed,Aug,2005
KG7932,1996,Mitsubishi,Galant,IMPORT,,,38500,10/5/2005,,,453,3,Wed,Oct,2005
G5897A,1994,Nissan,Altima,IMPORT,,Silver,194624,10/14/2005,,,444,3,Fri,Oct,2005
G5866A,1992,Mitsubishi,Diamante,IMPORT,,,152936,10/17/2005,,,441,3,Mon,Oct,2005

Article ID:   W18084

Filename:   LogParser DataGrid.txt
File Created: 2009:03:26:09:58:24
Last Updated: 2009:03:26:09:58:24