Script to export details to excel - URGENT

schneidz · 01-09-2014, 08:14 AM

i have yet to see an attempt from op that we can correct their code.

perumal07 · 01-09-2014, 11:21 AM

Quote:

Originally Posted by druuna

Again with the lack of information and input that is very inconsistent.....

You say you want these fields: What needs to be done with an entry like this (multiple block entries):Which is very different than this entry (multiple entries):Both seem like very sloppy copy/paste actions.

Why is this present an what needs to be done with it:And what about empty/missing entries:

Last time I will tell you this: PROVIDE ACCURATE INFORMATION OR WE CAN NOT HELP YOU.

Let me update you one more file which is latest which i got i havent work with excel before pls help me out.

perumal07 · 01-09-2014, 11:29 AM

Email ID: ithelpdesk@gmail.com
ithelpdesk@gmail.com
Host1 Nb messages: 6027 messages
Host1 Total size: 849995990 bytes (810.619 MiB)
Host2 Nb messages: 6105 messages
Host2 Total size: 860308551 bytes (820.454 MiB)
Host1 Nb messages: 6028 messages
Host1 Total size: 850022828 bytes (810.645 MiB)
Host2 Nb messages: 6021 messages
Host2 Total size: 851026822 bytes (811.602 MiB)
Transfer started on : Thu Jan 9 10:59:00 2014
Transfer ended on : Thu Jan 9 11:10:22 2014
Transfer time : 682.0 sec
Messages transferred : 10
Messages skipped : 6017
Messages found duplicate on host1 : 6
Messages found duplicate on host2 : 0
Messages void (noheader) on host1 : 0
Messages void (noheader) on host2 : 0
Messages deleted on host1 : 0
Messages deleted on host2 : 94
Host1 Nb messages: 6028 messages
Host1 Total size: 850022828 bytes (810.645 MiB)
Host2 Nb messages: 6021 messages
Host2 Total size: 851026822 bytes (811.602 MiB)
Host1 Nb messages: 6028 messages
Host1 Total size: 850022828 bytes (810.645 MiB)
Host2 Nb messages: 6022 messages
Host2 Total size: 851053660 bytes (811.628 MiB)
Transfer started on : Thu Jan 9 11:20:58 2014
Transfer ended on : Thu Jan 9 11:22:40 2014
Transfer time : 101.2 sec
Messages transferred : 1
Messages skipped : 6027
Messages found duplicate on host1 : 6
Messages found duplicate on host2 : 0
Messages void (noheader) on host1 : 0
Messages void (noheader) on host2 : 0
Messages deleted on host1 : 0
Messages deleted on host2 : 0
Email ID: ithelptest@gmail.com
Host1 Nb messages: 3370 messages
Host1 Total size: 496407958 bytes (473.412 MiB)
Host2 Nb messages: 3367 messages
Host2 Total size: 496952414 bytes (473.931 MiB)
Host1 Nb messages: 3370 messages
Host1 Total size: 496407958 bytes (473.412 MiB)
Host2 Nb messages: 3367 messages
Host2 Total size: 496952414 bytes (473.931 MiB)
Transfer started on : Thu Jan 9 11:19:30 2014
Transfer ended on : Thu Jan 9 11:20:58 2014
Transfer time : 88.2 sec
Messages transferred : 0
Messages skipped : 3370
Messages found duplicate on host1 : 3
Messages found duplicate on host2 : 0
Messages void (noheader) on host1 : 0
Messages void (noheader) on host2 : 0
Messages deleted on host1 : 0
Messages deleted on host2 : 0

if the data has double entrys it should take both entries and place in excel, if the email is empty in excel that field should be empty.

TB0ne · 01-09-2014, 11:31 AM

Quote:

Originally Posted by perumal07

Let me update you one more file which is latest which i got i havent work with excel before pls help me out.

Again, you need to spell out your words, please. And again, can you show us WHAT YOU HAVE ACTUALLY DONE/WRITTEN SO FAR???

Asking others to debug/write your scripts for you is not only lazy, but rude. You've been given MANY samples and examples thus far...how have you applied them?? What have YOU done?

perumal07 · 01-09-2014, 11:39 AM

Quote:

Originally Posted by TB0ne

Again, you need to spell out your words, please. And again, can you show us WHAT YOU HAVE ACTUALLY DONE/WRITTEN SO FAR???

Asking others to debug/write your scripts for you is not only lazy, but rude. You've been given MANY samples and examples thus far...how have you applied them?? What have YOU done?

i have tried few grep commands and try to use your privies script which shared by you but it didnt help. And i never worked in excel looping command thats y i asking for to help one if i got idea then i can make it.

TB0ne · 01-09-2014, 11:47 AM

Quote:

Originally Posted by perumal07

i have tried few grep commands and try to use your privies script which shared by you but it didnt help. And i never worked in excel looping command thats y i asking for to help one if i got idea then i can make it.

Again, SPELL OUT YOUR WORDS...it's "why", not 'y". And AGAIN...POST WHAT YOU HAVE TRIED. You SAY you've 'tried few grep commands', but don't tell us which ones. You don't tell us how you tried to modify them to fit your needs, or what the results were. These commands are Linux commands, and have ZERO to do with 'excel looping'.

perumal07 · 01-09-2014, 12:13 PM

Quote:

Originally Posted by TB0ne

Again, SPELL OUT YOUR WORDS...it's "why", not 'y". And AGAIN...POST WHAT YOU HAVE TRIED. You SAY you've 'tried few grep commands', but don't tell us which ones. You don't tell us how you tried to modify them to fit your needs, or what the results were. These commands are Linux commands, and have ZERO to do with 'excel looping'.

Header fields need to search in file

Email ID, Host1 Nb messages,Host1 Total size,Host2 Nb messages,Host2 Total size,Transfer time,Messages transferred,Messages skipped,Messages found duplicate on host1,Messages found duplicate on host2,Messages void (noheader) on host1,Messages void (noheader) on host2,Messages deleted on host1,Messages deleted on host2.

output should look like this when it is exported to excel i well get the report in colums

ithelpdesk@gmail.com,6027 messages, 849995990 bytes, 6105 messages, 860308551 bytes, 682.0 sec,10 ,6017,6,0,0,0,0,94
, 6028 messages, 850022828 bytes, 6021 messages,851026822 bytes,,,,,,,,,,,

TB0ne · 01-09-2014, 12:25 PM

Quote:

Originally Posted by perumal07

Header fields need to search in file

Email ID, Host1 Nb messages,Host1 Total size,Host2 Nb messages,Host2 Total size,Transfer time,Messages transferred,Messages skipped,Messages found duplicate on host1,Messages found duplicate on host2,Messages void (noheader) on host1,Messages void (noheader) on host2,Messages deleted on host1,Messages deleted on host2.

output should look like this when it is exported to excel i well get the report in colums

ithelpdesk@gmail.com,6027 messages, 849995990 bytes, 6105 messages, 860308551 bytes, 682.0 sec,10 ,6017,6,0,0,0,0,94
, 6028 messages, 850022828 bytes, 6021 messages,851026822 bytes,,,,,,,,,,,

Great, fine....so now, AGAIN....POST WHAT YOU HAVE TRIED TO DO ON YOUR OWN TO ACTUALLY ACCOMPLISH THIS.

Telling others over and over what you want is pointless...we will HELP you, but WE ARE NOT GOING TO WRITE THINGS FOR YOU. Show some effort of your own, and you'll get LOTS of help. Otherwise, take your problem over to the LQ Job Marketplace, and tell people how much you are willing to PAY to have someone do your work for you. They will gladly do it.