Importing Text / Rich Text to Database

Ask the community
, ,
1

Hi everybody!
I am trying to do the following: Import text I have stored in an excel and saved to a .csv into my wix database.

The text looks like this:

"Risikoeinschätzung:

  • 0 Punkte: Schlaganfallrisiko = 0,3%

  • 1 Punkt: Schlaganfallrisiko = 0,9%

  • 2 Punkte: Schlaganfallrisiko = 2,9%

  • 3 Punkte: Schlaganfallrisiko = 4,6%"

I tried using text fields and rich text fields. However when I try to import the csv the following problem turns up:
The 8 columns of my csv are reduced to only one.

940×640 41.2 KB

I also tried copying the original text from a word document to the excel .csv file:
"
Risikoeinschätzung:
· 0 Punkte: Schlaganfallrisiko = 0,3%
· 1 Punkt: Schlaganfallrisiko = 0,9%
· 2 Punkte: Schlaganfallrisiko = 2,9%
· 3 Punkte: Schlaganfallrisiko = 4,6%"

And I have tried to use the following “Rich Text”:

Risikoeinschätzung:

< p>· 0 Punkte: Schlaganfallrisiko = 0,3%

· 1 Punkt: Schlaganfallrisiko = 0,9%

· 2 Punkte: Schlaganfallrisiko = 2,9%

· 3 Punkte: Schlaganfallrisiko = 4,6%

However nothing worked…
Any ideas what I am doing wrong?

Any kind of help or guidance is very appreciated!
Thanks
Konstantin

2

This issue is not code related, therefore you would have been better suited going through Wix Support and not this code forum.

The data imported from a CSV file or added via code is not validated, therefore you will need to reformat it when you have imported it from the CSV file.

It is the same with text and numbers, you can import text into number field, however it would show as error afterwards.

https://support.wix.com/en/article/about-importing-data-in-the-data-manager