Results 1 to 2 of 2
  1. #1
    Master Untangler johndball's Avatar
    Join Date
    Apr 2008
    Location
    Virginia
    Posts
    174

    Default Tool to bulk import custom URLs?

    Is there a tool to bulk import custom URLs? If not, I created one today in Excel 2013 but it isn't sexy at all. I didn't want to upload it here if there was a better way (better tool) of importing bulk URLs.
    --
    "I have often regretted my speech, never my silence." - Xenocrates
    https://www.johndball.com

  2. #2
    Master Untangler johndball's Avatar
    Join Date
    Apr 2008
    Location
    Virginia
    Posts
    174

    Default

    This is the Excel spreadsheet I'm using to bulk import. I have it set to do up to 50 URLs at a time.
    Copy your URLs in a list and post into column "F" starting at row 3.
    Trim the rows that don't contain URLs.
    On the last row, in column "L", add a closed bracket "]".

    Copy "A 56" to Notepad++, Notepad, or other text editing program that strips formatting. Save as "filename.json".

    Make a backup copy of your existing rules. I set mine to append but it seems to pepper them throughout the existing rules. Nonetheless, it added all of the new rules while preserving the existing works.

    Works on Untangle 9 and Untangle 11 in my environment. Certainly not the easiest method but better than single clicking and adding one by one. I'm open for better methods.


    Edit: Funny how things "don't show up" on first search. I came across this thread. Changed the wording in my search. http://forums.untangle.com/web-filte...eb-filter.html
    Attached Files Attached Files
    Last edited by johndball; 12-19-2014 at 06:56 PM.
    sklkevin likes this.
    --
    "I have often regretted my speech, never my silence." - Xenocrates
    https://www.johndball.com

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

SEO by vBSEO 3.6.0 PL2