# Parse File To Add PPP Secrets - Mikrotik Script RouterOS

    Parse File To Add PPP Secrets

    This script requires that entries inside the file is in following format:
    username,password,local_address,remote_address,profile,service

    For example:

    janis,123,1.1.1.1,2.2.2.1,ppp_profile,myService
    juris,456,1.1.1.1,2.2.2.2,ppp_profile,myService
    aija,678,1.1.1.1,2.2.2.3,ppp_profile,myService

    Code:

    :global content [/file get [/file find name=test.txt] contents] ;
    :global contentLen [ :len $content ] ;
    :global lineEnd 0;
    :global line "";
    :global lastEnd 0;
    :do {
           :set lineEnd [:find $content "\r" $lastEnd ] ;
           :set line [:pick $content $lastEnd $lineEnd] ;
           :set lastEnd ( $lineEnd + 2 ) ;

           :local tmpArray [:toarray $line] ;
    	:if ( [:pick $tmpArray 0] != "" ) do={
    	:put $tmpArray;
             /ppp secret add name=[:pick $tmpArray 0] password=[:pick $tmpArray 1] \
                 local-address=[:pick $tmpArray 2] remote-address=[:pick $tmpArray 3] \
                 profile=[:pick $tmpArray 4] service=[:pick $tmpArray 5];
    }
    } while ($lineEnd < $contentLen)
    Credit: wiki.mikrotik.com