0
responses

Hello Team,

I have configured nxlog.conf for .csv file in my production server.

.csv file content :

(11/6/2021 4:18:18 PM) | 06/11/2021 15:42:26 | "SM/D Mior Ahmad Suhaimi bin Mohd Alwi" <miorsuhaimi@rmp.gov.my> | PUCHONG REPOT 8259/20 | Wrong or No request form
(11/6/2021 4:28:06 PM) | 06/11/2021 15:19:56 | "SI Mohamad Azizi B Yunus" <aziziyunus@rmp.gov.my> | JAYA GADING REPOT 2297/2021, SEK 395/397 KK. | Success
(11/6/2021 4:39:33 PM) | 06/11/2021 15:03:32 | "ASP Muhd Shamsuddin Wong bin Abdullah" <muhdshamsuddin@rmp.gov.my> | SRI PETALING 2159/21 | Success
(11/6/2021 5:14:42 PM) | 06/11/2021 16:06:01 | "Analisis Risikan Maklumat Telefon JSJN Bukit Aman" <telconaco@rmp.gov.my> | LMAF/JSJN/83/2021 | Success
(11/6/2021 6:00:43 PM) | 06/11/2021 17:10:16 | "Insp Ishak B Abu Bakar" <ishak_ab@rmp.gov.my> | PERMOHONAN BUTIR-BUTIR PEMILIK NOMBOR TELEFON | Wrong or No request form
(10/5/2021 9:00:45 AM) | 05/10/2021 08:04:08 | lflee@moh.gov.my | FW: JBS/021886/19 | Wrong or No request form

nxlog Conf file content for csv part :

<Extension csv>
Module xm_csv
Fields date1, date2, mailid, name, result
Delimiter |
#EscapeControl TRUE
</Extension>

<Input Security_processedlog>
Module im_file
Exec $type = 'Security_processedlog';
File 'D:\RPAMain\Logs\General\Security\ProcessedLog*.csv'
InputType LineBased
PollInterval 1
SavePos TRUE
Exec csv->parse_csv();
Exec $Message = $raw_event;
</Input>

I can see only the output for this entry

(10/5/2021 9:00:45 AM) | 05/10/2021 08:04:08 | lflee@moh.gov.my | FW: JBS/021886/19 | Wrong or No request form

Nxlog log says error for rest entries

(11/6/2021 4:18:18 PM) | 06/11/2021 15:42:26 | "SM/D Mior Ahmad Suhaimi bin Mohd Alwi" <miorsuhaimi@rmp.gov.my> | PUCHONG REPOT 8259/20 | Wrong or No request form
(11/6/2021 4:28:06 PM) | 06/11/2021 15:19:56 | "SI Mohamad Azizi B Yunus" <aziziyunus@rmp.gov.my> | JAYA GADING REPOT 2297/2021, SEK 395/397 KK. | Success
(11/6/2021 4:39:33 PM) | 06/11/2021 15:03:32 | "ASP Muhd Shamsuddin Wong bin Abdullah" <muhdshamsuddin@rmp.gov.my> | SRI PETALING 2159/21 | Success
(11/6/2021 5:14:42 PM) | 06/11/2021 16:06:01 | "Analisis Risikan Maklumat Telefon JSJN Bukit Aman" <telconaco@rmp.gov.my> | LMAF/JSJN/83/2021 | Success
(11/6/2021 6:00:43 PM) | 06/11/2021 17:10:16 | "Insp Ishak B Abu Bakar" <ishak_ab@rmp.gov.my> | PERMOHONAN BUTIR-BUTIR PEMILIK NOMBOR TELEFON | Wrong or No request form
(10/5/2021 9:00:45 AM) | 05/10/2021 08:04:08 | lflee@moh.gov.my | FW: JBS/021886/19 | Wrong or No request form

2021-06-11 19:44:39 ERROR procedure 'parse_csv' failed at line 376, character 22 in C:\Program Files (x86)\nxlog\conf\nxlog.conf. statement execution has been aborted; Invalid CSV input: '(20/5/2021 5:20:19 PM) | 05/20/2021 16:21:12 | "Analisis Risikan Maklumat Telefon JSJN Bukit Aman" <telconaco@rmp.gov.my> | LMAF/JSJN/56/2021 | Success'

2021-06-11 19:44:39 ERROR procedure 'parse_csv' failed at line 376, character 22 in C:\Program Files (x86)\nxlog\conf\nxlog.conf. statement execution has been aborted; Invalid CSV input: '(20/5/2021 6:07:09 PM) | 05/20/2021 17:21:40 | "SI Mohamad Azizi B Yunus" <aziziyunus@rmp.gov.my> | KUANTAN REPOT 7090/21, SEK 302 KK | Success'

Please suggest

Thanks

AskedJune 11, 2021 - 8:28pm

Answers (0)