Title: Import External URL
Last modified: August 21, 2016

---

# Import External URL

 *  Resolved [aghilmort](https://wordpress.org/support/users/aghilmort/)
 * (@aghilmort)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/import-external-url/)
 * Can’t get import URL file format correct for importing external URLs. The importer
   simply keeps converting them to non-links. Please advise.
 * [https://wordpress.org/plugins/shorten-url/](https://wordpress.org/plugins/shorten-url/)

Viewing 5 replies - 1 through 5 (of 5 total)

 *  [Sed Lex](https://wordpress.org/support/users/sedlex/)
 * (@sedlex)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/import-external-url/#post-5022614)
 * What do you mean by non link ?
    Do you have a test file that I can test ?
 *  Thread Starter [aghilmort](https://wordpress.org/support/users/aghilmort/)
 * (@aghilmort)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/import-external-url/#post-5022659)
 * Suppose we manually added some external URLs. If we then click the export button,
   we download a text file which reads something like:
 *     ```
       1,1,OHxr4,,
       2,,7MwF3,,
       0,,Igaj0,http://www.azsos.gov/business_services/tnt/tnt_name_search_instructions.htm,Arizona
       0,1,MDfuk,http://www.commerce.state.ak.us/CBP/Main/CBPLSearch.aspx?mode=Corp,Alaska
       0,2,eKrYd,http://www.sos.state.al.us/vb/inquiry/inquiry.aspx?area=Business%20Entity,Alabama
       ```
   
 * However, suppose we want to add some external URLs for bulk upload purposes, 
   say like this.
 *     ```
       1,1,OHxr4,,
       2,,7MwF3,,
       0,,Igaj0,http://www.azsos.gov/business_services/tnt/tnt_name_search_instructions.htm,Arizona
       0,1,MDfuk,http://www.commerce.state.ak.us/CBP/Main/CBPLSearch.aspx?mode=Corp,Alaska
       0,2,eKrYd,http://www.sos.state.al.us/vb/inquiry/inquiry.aspx?area=Business%20Entity,Alabama
       0,,Fk1o8,http://www.sos.arkansas.gov/corps/search_all.php,Arkansas
       0,,aZoj2,http://kepler.sos.ca.gov/,California
       ```
   
 * If we attempt to upload this file, we simply receive a bunch of warnings saying
   line 282 is expecting two parameters and only received one and none of the external
   URLs are added. Furthermore, if we then download the updated list of URLs using
   the export button, it looks like this:
 *     ```
       1,1,OHxr4,,
       2,,7MwF3,,
       0,0,,,
       0,0,,,
       [... bunch more 0,0,,, rows, one per external URL we imported]
       0,,Igaj0,http://www.azsos.gov/business_services/tnt/tnt_name_search_instructions.htm,Arizona
       0,1,MDfuk,http://www.commerce.state.ak.us/CBP/Main/CBPLSearch.aspx?mode=Corp,Alaska
       0,2,eKrYd,http://www.sos.state.al.us/vb/inquiry/inquiry.aspx?area=Business%20Entity,Alabama
       ```
   
 * What we don’t know is if we’re somehow using the wrong file format for the import
   process or if there’s a glitch in the code, or if it’s something such as the 
   file must be encoded in some specific format such as Unicode, UTF-8, etc. Thoughts?
 *  [Sed Lex](https://wordpress.org/support/users/sedlex/)
 * (@sedlex)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/import-external-url/#post-5022709)
 * I have to look at this problem… as I am quite busy these time, I will look at
   it in one week … is that ok ?
 *  Thread Starter [aghilmort](https://wordpress.org/support/users/aghilmort/)
 * (@aghilmort)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/import-external-url/#post-5022734)
 * Sounds good. thanks!
 *  [Sed Lex](https://wordpress.org/support/users/sedlex/)
 * (@sedlex)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/import-external-url/#post-5022785)
 * Find the issue … I used mysqli_escape_string instead of esc_sql …
 * Sorry !
 * The next release will be issued in couple of hours

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Import External URL’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/shorten-url_ffffff.svg)
 * [Short URL](https://wordpress.org/plugins/shorten-url/)
 * [Support Threads](https://wordpress.org/support/plugin/shorten-url/)
 * [Active Topics](https://wordpress.org/support/plugin/shorten-url/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/shorten-url/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/shorten-url/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Sed Lex](https://wordpress.org/support/users/sedlex/)
 * Last activity: [11 years, 10 months ago](https://wordpress.org/support/topic/import-external-url/#post-5022785)
 * Status: resolved