× Looking for a useful answer?

Read this first and make sure you checked all steps: csvimproved.com/support/getting-started

Don't just say it doesn't work but describe in detail what is happening and add the following information:
* Version of the extension you are using
* CSVI version (Latest is not a version number)
* Sample of the file being imported
* A copy of the template you are using. Use the maintenance menu to create a backup of your template
* Collected debug information

Without this information you won't get a useful answer. If no debug log is attached, you will get a request to post it.

Where to get the debug information?

A tutorial ( csvimproved.com/support/questions-and-answers/390-how-to-collect-debug-information ) has been written to help you collect your debug information.

Export csv: custom_value without cryptic text

  • Julius.Piwowar
  • Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
More
1 week 4 days ago #60005 by Julius.Piwowar
Julius.Piwowar created the topic: Export csv: custom_value without cryptic text
Hello,

I just exported my data from joomla (see file attached).

In the field "custom_value" there are cryptic letters at the beginning of each cell e.g. "1190~1191~1192~"
Is there any way how I can export the custom value without this cryptic letters?

Best greetings and thanks
Julius




Setting Value
PHP Built On SunOS localhost 5.10 Generic_150401-49 i86pc
Database Type mysql
Database Version 5.6.42-log
Database Collation latin1_german1_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 7.2.14
Web Server Apache/2.4.37 (Unix)
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.9.0 Stable [ Amani ] 30-October-2018 14:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Attachments:

Please Log in or Create an account to join the conversation.

More
1 week 3 days ago #60008 by tharuna
tharuna replied the topic: 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?

Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory

Please Log in or Create an account to join the conversation.

More
1 week 3 days ago #60010 by tharuna
tharuna replied the topic: Export csv: custom_value without cryptic text
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?

Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory

Please Log in or Create an account to join the conversation.

  • Julius.Piwowar
  • Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
More
1 week 3 days ago #60014 by Julius.Piwowar
Julius.Piwowar replied the topic: Export csv: custom_value without cryptic text
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

Please Log in or Create an account to join the conversation.

More
1 week 2 days ago #60017 by tharuna
tharuna replied the topic: Export csv: custom_value without cryptic text
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.

Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory

Please Log in or Create an account to join the conversation.

  • Julius.Piwowar
  • Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
More
6 days 6 hours ago #60054 by Julius.Piwowar
Julius.Piwowar replied the topic: Export csv: custom_value without cryptic text
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

Please Log in or Create an account to join the conversation.