/Most common mistakes when importing data.

Search Knowledge Base by Keyword

Most common mistakes when importing data.

When uploading your Monthly data please be aware of these mistakes:

  • Your file must be in xlsx. format
  • Check your date format, please download a sample file and use it for your data or check the date format used in a sample file.
  • Use comma as decimal point
  • Your number must be in percentages

When uploading your Daily data please be aware of these mistakes:

  • Your file must be in .csv format
  • If you want to convert .txt file into .csv, please use OpenOffice Calc, when you use excel, your data will be in incorrect format.
  • Select the date format and item separator you want to use (for further instructions, please see our video How to properly set the file format for uploading daily data)
  • It’s better to set up in Excel dot as a decimal point. Go to Options – Advanced – Decimal separator

  • Use dot as decimal point

  • Be awared of mistakes in data in a row

  • Try to open your file in a simple text editor and check if there is not an empty space at the end of the row, if so, delete it and save your file, then import.

  • If you want to remove % from the file (Daily data are in format of numbers, not percentages), use in Excel function Find & Select, find percentages and Replace it for empty space.

When you uploading your AUM please be aware of these mistakes:

  • Your file must be in .csv format
  • Your numbers must be transposed in a row
  • Add an inception date at the begining of the file

  • Try to open your file in a simple text editor and check if there is not an empty space at the end of the row, if so, delete it and save your file, then import. (for further instructions, please see our video tutorial)

Need help? Feel Free to Ask