Import Sites Doesn’t Work

Unable to import sites via .csv-file.

Hi @MorganGrip

The formatting in the CSV files is very sensitive. Can you please try downloading the Sample csv file from your Dashboard and changing the values in it?

Lines 9-13 are demo so you can replace or erase them. Make sure to keep the same formatting.

2 Likes

@MorganGrip It’s your syntax. You are using semicolons & spaces which are not correct. Please download the example CSV as @bojan states in his response.

You must include every column even if blank. Quotations may or may not be used.

The correct format is below: ( Single site per line. )

  • Site Name
  • URL
  • Admin Name

All other fields are optional
site name,url,admin name,group,security id,http username,http password,verify certificate,ssl version
"Site 1","https://site-1.com/","frus_admin","","","","","",""

same here… it has to be a “Comma Separated Values” CSV-File, not a “Character Separated Values”. So make sure you use Comma as separator.

Well, not really. Any character like semicolon, pipe or tab should be fine, too. It’s your syntax that requires commas as separators. It might be helpful to state this in the Doc/sample.csv or even the importer. More helpful would a little wizard or clearer info on why the import fails :wink:

@joker :wink: No. Not any character, semicolon, pipe or any other characters would work other then the comma separated list. The delimiters chosen within CSV files are at the discretion of the developers, which in this case the original “Comma” has been chosen.

Both, an example CSV as well as the link to our Knowledgebase Documentation stating that the correct syntax is a “Comma Separated list” are provided directly at the top of the Import page.

CSV: Comma-Seperated-Values

Everything I found on MainWP only states CSV, which either stands for “Comma separated” or “Character separated”. Please just state that you require a comma in the demo file and many more people will not have a problem with it.
Even Excel accepts a semi colon or tab-separated CSV file without any issue.

From the Wikipedia article you quoted:

The term “CSV” also denotes several closely-related delimiter-separated formats that use other field delimiters such as semicolons.[2] These include tab-separated values and space-separated values. A delimiter guaranteed not to be part of the data greatly simplifies parsing.

Alternative delimiter-separated files are often given a “.csv” extension despite the use of a non-comma field separator. This loose terminology can cause problems in data exchange. Many applications that accept CSV files have options to select the delimiter character and the quotation character. Semicolons are often used instead of commas in many European locales in order to use the comma as the decimal separator and, possibly, the period as a decimal grouping character.

@joker The delimiter “Comma” is stated in our Knowledgebase & given as the example.

Even Excel accepts a semi colon or tab-separated CSV file without any issue.

As said - it is to the discretion of the developer.

We will be sure to take into consideration to add that we use the original definition of CSV ( Comma Separate Values ) as defined by Google
If you have further suggestions please feel free todo so here: feedback.mainwp.com