This article contains different troubleshooting steps you can perform in order to fix any issues you might experience while importing CSV files.

As a new user importing a CSV file to Design you might encounter some challenges until you get the hang of it, all of which, can usually be resolved by editing the file itself.

Headings in this article:

Weather files

  • All data is in one column
    • When importing weather files, and the preview of the file displays everything in one column, means that you have not set the delimiter properly.
    • The easiest way to identify the delimiters for the file is to open the file in any text-editor program (Notepad, Wordpad, Word, Notepad++ etc), which will display the file as it is, and here you should be able to identify the different delimiters.
  • "Error: One or more entries in the weather file is not in right format" 
    • There are are rows in the file which are not correctly set up. It might be hard to identify when there is no notification on which row the issue is identified: we recommend to look at the bottom row(s), as there are sometimes some text which needs to be removed.
  • "Error: Couldn't store data on server.Invalid Data on weather file on line 10"
    • There is an incorrect value or text somewhere on row 10 in the file, which needs to be fixed.

Extra asset with blank name and coordinates

  • Extra asset with blank name and coordinates
    • there are instances when importing assets that you have an additional asset added to the bottom with no title and blank coordinates. This is because the file you are importing has a blank row on the bottom, which can be mitigated by editing the file in any text editor program (not Excel), then go down to the bottom row, remove that row and save the file - the import will now only contain the number of turbines you want to add.


Imported asset not visible on the map

  • If you have imported any assets, and it's not displaying on the map, this usually indicates that the coordinates in your file has been swapped around. Try to edit the file to reverse coordinates.

Importing turbines to a case

  • All data is in one column 
    • When importing turbines, and all the information is found in the title cell, this means you have not set up the correct delimiters
    • The easiest way to identify the delimiters for the file is to open the file in any text-editor program (Notepad, Wordpad, Word, Notepad++ etc), which will display the file as it is, and here you should be able to identify the different delimiters.

Importing Inter array cables to a case

  • All data is in one column
    • When importing inter array cables, and all the information is found in the title cell, this means you have not set up the correct delimiters.
    • The easiest way to identify the delimiters for the file is to open the file in any text-editor program (Notepad, Wordpad, Word, Notepad++ etc), which will display the file as it is, and here you should be able to identify the different delimiters.

Importing Monopiles to a case

  • All data is in one column
    • When importing monopiles, and all the information is found in the title cell, this means you have not set up the correct delimiters.
    • The easiest way to identify the delimiters for the file is to open the file in any text-editor program (Notepad, Wordpad, Word, Notepad++ etc), which will display the file as it is, and here you should be able to identify the different delimiters.

Importing Transition pieces to a case

  • All data is in one column
    • When importing transition pieces, and all the information is found in the title cell, this means you have not set up the correct delimiters.
    • The easiest way to identify the delimiters for the file is to open the file in any text-editor program (Notepad, Wordpad, Word, Notepad++ etc), which will display the file as it is, and here you should be able to identify the different delimiters.

Importing Piles to a case

  • All data is in one column
    • When importing piles, and all the information is found in the title cell, this means you have not set up the correct delimiters.
    • The easiest way to identify the delimiters for the file is to open the file in any text-editor program (Notepad, Wordpad, Word, Notepad++ etc), which will display the file as it is, and here you should be able to identify the different delimiters.

Importing Jackets to a case

  • All data is in one column
    • When importing jackets, and all the information is found in the title cell, this means you have not set up the correct delimiters.
    • The easiest way to identify the delimiters for the file is to open the file in any text-editor program (Notepad, Wordpad, Word, Notepad++ etc), which will display the file as it is, and here you should be able to identify the different delimiters.

Importing Export cables to a case

  • All data is in one column 
    • When importing export cables, and all the information is found in the title cell, this means you have not set up the correct delimiters.

    • The easiest way to identify the delimiters for the file is to open the file in any text-editor program (Notepad, Wordpad, Word, Notepad++ etc), which will display the file as it is, and here you should be able to identify the different delimiters.