Resolved Export csv: custom_value without cryptic text

Hello Julius,
What if you open your export file using OpenOffice or LibreOffice, you still see those cryptic characters?

Hello Julius,
May be i understood your issue wrong. Are you saying that you have numbers in custom_value field which are not suppose to be there? Can you please clarify?

Hey Tharuna,

thank you for your quick reply.
I opened the file in open office.

In my exported file in "custom_value" I see in each cell at the beginning cryptic numbers e.g. the following: "402~283~403~Durchmesser: 100 cm, Höhe: 75 cm".
The correct custom_value would be: "Durchmesser: 100 cm, Höhe: 75 cm". So without "402~283~403~".

best
Julius

Hello Julius,
I really doubt if these are the values from your database because these numbers are not the same for each row. One other thing i noticed is that you have Abmessung~Material as custom fields which are exported under custom_title column but the values are more in custom_value instead of two. Would like to see how your custom fields are stored in database. Can you send me a private message of your site administrator login details and FTP details? I will take a look at the data.

Hey Tharuna,

"I really doubt if these are the values from your database because these numbers are not the same for each row."

You are correct. The numbers in custom value change e.g.

For the first product it must be: 60 cm x 40 cm, Höhe: 12 cm~Baumwolle und Wolle, Rückseite: Leinen, Füllung: ökologische Baumwolle

wrong are the first three letters "~~~"

For the second product it must be: "53 cm x 40 cm, Höhe: 12 cm~Baumwolle und Wolle, Rückseite: Leinen, Füllung: ökologische Baumwolle"

wrong are the following letters: "1195~~~"

For the third product it must be "56 cm x 35 cm, Höhe: 10 cm~Baumwolle und Wolle, Rückseite: Leinen, Füllung: ökologische Baumwolle"

wrong are the following letters: "1194~1195~~"

and so on....

"One other thing i noticed is that you have Abmessung~Material as custom fields which are exported under custom_title column but the values are more in custom_value instead of two.".

That is not correct. In the costum_value there a only two vales:

For the first product:

Value 1 (Abmessung): "60 cm x 40 cm, Höhe: 12 cm"
Value 2 (Material): "Baumwolle und Wolle, Rückseite: Leinen, Füllung: ökologische Baumwolle"

For the second product:

Value 1 (Abmessung): "53 cm x 40 cm, Höhe: 12 cm"
Value 2 (Material): "Baumwolle und Wolle, Rückseite: Leinen, Füllung: ökologische Baumwolle"

and so on...


"Would like to see how your custom fields are stored in database. Can you send me a private message of your site administrator login details and FTP details? I will take a look at the data."

I will send you a private message with admin login and ftp details.

Thank you

Hello,
Yes would like to check from where these extra vales are coming from. Will find this out once you send me the requested details.