Skip to main content
fenixryan
fenixryan
New Member
April 28, 2016
Question

bulk import blows up creating IP addresses

  • April 28, 2016
  • 1 reply
  • 7256 views

Hi sorry if I'm covering old ground but I come across this problem with fortios 3 through to 5.

 

I have to create a mass amount of addresses to distinguish sites. These are imported from a .csv extract using powershell to build the text file. This seems to work, I cannot say the exact limit, but if the file is say 100 lines script runs fine.

After 100 or more the script aborts a seems to truncate one of the commands.

 

I also get a error when trying to use the GUI to but at present we are without analyser to see what exactly happened.

 

If I copy and paste sections of 100 lines via ssh putty all is ok.

 

There seems to be a hard limit on the number of lines the batch importer can process, I was wondering if this could be overwritten

 

 

    1 reply

    emnoc
    emnoc
    New Member
    April 28, 2016

     I personally never seen this behavior and have import 1k of lines (set) from WebGUI.

     

    Are you 100% sure  the import file is "edit" correctly? My last big FGT shop I consulted in a had a script maker and they has script that blow up since an extra "edit" was in  the address book  :)  It took us a few days to find out what happen but it broke a lot of the automation.

     

     

    Either way use the "exec batch lastlog" from the cli and look for any errors that have been reported. This might shed some light.

     

    Ken

     

    fenixryan
    fenixryanAuthor
    New Member
    April 28, 2016

    Hi Ken cheers for the reply, but unlike you my experience has always seen issues importing large files.

    I will look through the files and thanks for the CLI command to look at the logs. Will have a look tomorrow as I've still got a big address list to import.

     

    Can you answer me a question though, do you put any formatting in your file, i.e. spaces to tab entries. Also can you give me a example of your file (obviously anonymised :))

     

    I will report back tomorrow on how I get on.

    Jus

    emnoc
    emnoc
    New Member
    April 29, 2016

    No formatting, the command post earlier will help diagnose issues with batch imports. I've used simple  shell scripting for formatting  similar to below link.

     

    http://socpuppet.blogspot.com/2012/11/fortigate-firewall-cfg-script-to-speed.html

     

    cheers

     

     

    Terms & ConditionsAccessibility statement