« Previous Next »

Thread: [BUG] LongNames in OUTPUT directive

Last post 12-06-2005 2:08 PM by LogParser User : nanoo. 8 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (9 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 08-01-2005, 1:44 AM

    [BUG] LongNames in OUTPUT directive

    Reply Contact

    I discovered that long the SQL directive INTO does not support Long Names like : E:\My Documents\Inetpub\wwwroot\graph.gif

    You have to use short names E:\MYDOCU~1\Inetpub\wwwroot\graph.gif 

     

    Is it normal ???
    Tags:

  • 08-01-2005, 6:12 AM In reply to

    RE: [BUG] LongNames in OUTPUT directive

    Mark as Answer
    Reply Contact

    Hi,

    Problems are in space characters in FROM clause. In help we can see:

    Each element can not contain spaces, ',' (comma) characters, or ';' (semicolon) characters, unless the element is enclosed by the ''' (single quote) or '" (double quotes) characters, as in the following example: 

    file2.txt, 'C:\Program Files\file3.txt', file4.txt
    Tags:

  • 08-01-2005, 7:11 AM In reply to

    RE: [BUG] LongNames in OUTPUT directive

    Mark as Answer
    Reply Contact

    Igor,

    Even with simple or double quotes, I have an error !

    SELECT TO_STRING(time, 'HH') AS Hour, SUM(cs-bytes) AS UPLOAD INTO 'E:\Space bug\result.gif' FROM 'E:\My Documents\Inetpub\logs.alacrity.be\logs\W3SVC1611885703\ex*.log' GROUP BY Hour ORDER BY Hour ASC

    SELECT TO_STRING(time, 'HH') AS Hour, SUM(cs-bytes) AS UPLOAD INTO "E:\Space bug\result.gif" FROM "E:\My Documents\Inetpub\logs.alacrity.be\logs\W3SVC1611885703\ex*.log" GROUP BY Hour ORDER BY Hour ASC

    SELECT TO_STRING(time, 'HH') AS Hour, SUM(cs-bytes) AS UPLOAD INTO E:\SPACEB~1\result.gif FROM 'E:\My Documents\Inetpub\logs.alacrity.be\logs\W3SVC1611885703\ex*.log' GROUP BY Hour ORDER BY Hour ASC

    This is the only solution (in green) that works, with the short names...

    Tags:

  • 08-03-2005, 8:03 AM In reply to

    RE: [BUG] LongNames in OUTPUT directive

    Mark as Answer
    Reply Contact

    I think you're right, the CHART output format does not de-quote the output filename...thanks for finding the bug!

    Will be fixed in the next release.....thanks so much!!!!!!!!!!!
    Tags:

  • 08-05-2005, 12:28 AM In reply to

    RE: [BUG] LongNames in OUTPUT directive

    Mark as Answer
    Reply Contact

    Hi Gab,

    Thank you for your answer ! I'm glad to know the issue of this problem

    Tags:

  • 11-19-2005, 5:14 AM In reply to

    RE: [BUG] LongNames in OUTPUT directive

    Mark as Answer
    Reply Contact

    Any ideas when this might be fixed?
    Thanks
    Andy
    Tags:

  • 11-25-2005, 4:35 PM In reply to

    RE: [BUG] LongNames in OUTPUT directive

    Mark as Answer
    Reply Contact

    In the meantime, this c# code might be useful for those who want to use a short path
    Hope it helps
    Andy
    Tags:

  • 12-06-2005, 1:57 PM In reply to

    RE: [BUG] LongNames in OUTPUT directive

    Mark as Answer
    Reply Contact

    I just ran into this very same bug today and thought I was done for.  Once again you guys are on top of things as usual.

    I found this link, that will convert long name to short name format, for users like me that are a little more partial to VB.NET.

    I just tried it in my app and it works like a charm!
    Tags:

  • 12-06-2005, 2:08 PM In reply to

    RE: [BUG] LongNames in OUTPUT directive

    Mark as Answer
    Reply Contact

    Gabriele,

    It's not charts specific.  FYI: This is the line I was using when it failed for me:

    logparser "SELECT * INTO 'c:\temp\12345.xml' FROM 'c:\documents and settings\user.dom\my documents\visual studio\app\parsethis.txt'" -compactN -i:COM -iprogid:APP.InputFormat.EVTTXTInputFormat
    Tags:
Page 1 of 1 (9 items)
Microsoft Communities