mjhjmtu

I have data in file portals.csv like

filename is portals.csv

ip,time,name
1.1.1.1,2018-08-15 11:05:28:268813353,1.13.0-0007
1.1.1.2,2018-08-16 11:05:32:016469121,1.13.0-0007
1.1.1.3,2018-08-16 11:06:42:316469121,1.13.0-0007
1.1.2.5,2018-08-16 11:15:52:416469121,1.13.0-0007

Need the output like this, the time column data should take the current time with different second for each and every rows

ip,time,name
1.1.1.1,2018-08-17 15:00:01,1.13.0-0007
1.1.1.2,2018-08-17 15:00:02,1.13.0-0007
1.1.1.3,2018-08-17 15:00:03,1.13.0-0007
1.1.2.5,2018-08-17 15:00:04,1.13.0-0007

Here's an option using GNU Awk, using NR to increment an epoch timestamp passed in from the date command:

gawk -F, -v ts="$(date +%s)" '
 BEGINOFS = FS 
 NR > 1 $2 = strftime("%Y-%m-%d %H:%M:%S", ts + NR - 1)
1' portals.csv
ip,time,name
1.1.1.1,2018-08-17 09:47:17,1.13.0-0007
1.1.1.2,2018-08-17 09:47:18,1.13.0-0007
1.1.1.3,2018-08-17 09:47:19,1.13.0-0007
1.1.2.5,2018-08-17 09:47:20,1.13.0-0007

See The GNU Awk User's Guide: Time functions

Similar approach in Perl:

perl -MPOSIX -F, -lne '
 BEGIN$ts = time();
 $F[1] = strftime("%Y-%m-%d %H:%M:%S", localtime($ts + $. - 1)) if $. > 1; 
 print join ",", @F
' portals.csv 

Dealing with date / time fields never is an easy thing, so for a full blown solution, way more effort must be spent. If your input file has less than 60 lines, try

awk -F, -vDT="$(date +"%F %T")" 'NR > 1 sub (/:..$/, sprintf (":%02d", NR-1), DT); $2 = DT 1' OFS=, file
ip,time,name
1.1.1.1,2018-08-17 12:47:01,1.13.0-0007
1.1.1.2,2018-08-17 12:47:02,1.13.0-0007
1.1.1.1,2018-08-17 12:47:03,1.13.0-0007
1.1.1.2,2018-08-17 12:47:04,1.13.0-0007
1.1.1.3,2018-08-17 12:47:05,1.13.0-0007
1.1.2.5,2018-08-17 12:47:06,1.13.0-0007

or, slightly shorter,

awk -F, -vDT="$(date +"%F %H:%M")" 'NR > 1 $2 = DT sprintf (":%02d", NR-1) 1' OFS=, file

EDIT: For your additional request to extend this for up to 99 lines in the input file, try

awk -F, -vDT="$(date +"%F %H:")" 'NR > 1 $2 = DT sprintf ("%02d:%02d", int((NR-1)/60), (NR-1)%60) 1' OFS=, file