This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DEVELOPERS FORUM - Parsing log file created by Batch Loader

stevestojanovski - Wednesday, April 25, 2012 2:30 PM:

I am using the Aras Batch Loader to load data into Innovator.  In my batch loader definition, I have the log level set to level "3".  This creates a very detailed log file including successful and failed items during the load.  I am primarily interested in the failed items during the batch load.

Are their any tools/scripts anyone can recommend to parse the log file generated by the Batch Loader and only provide me the failures?

Thanks,

Steve



Yoann Maingon - Wednesday, April 25, 2012 3:45 PM:

What's the output format? an XML File?



stevestojanovski - Wednesday, April 25, 2012 3:58 PM:

No it is not an xml formatted file.  It is a essentially a "log file" with each Log entry separated by a blank row. 

[ *** Worker process for lines 1702 - 1801 *** ]: 

[1:28:35 PM - Worker process for lines up to 1800 (Thread #1)]: Finished

processed successfully - 100

average processed request time - 23.232323 ms

failed to process - 0

total time - 2.3262326 sec

 

[ *** Worker process for lines 1802 - 1901 *** ]: 

[1:28:39 PM - Worker process for lines up to 1900 (Thread #1)]: Finished

processed successfully - 100

average processed request time - 21.672167 ms

failed to process - 0

total time - 2.1712171 sec

I found a tool called LogParser from Microsoft http://www.microsoft.com/download/en/details.aspx?id=24659 

Seems like it may do the trick for me.  Currently trying it out.  Will keep this thread updated.

 



stevestojanovski - Wednesday, April 25, 2012 4:14 PM:

I found something that will suffice for now.  Notepad++ has some nice find capabilities for a text file and let's me "mark" the rows that describe the failures.



Yoann Maingon - Wednesday, April 25, 2012 4:16 PM:

nice ! notepad++ is definitely a great editor!