Jump to content

Welcome, Guest!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

  • 0
Wartin

Differences from 'view' and 'export' from 'SQL Manager'

Question

I noticed that my products' description, after my test import, didn't have different lines, but just plain text all in one line.

I use the data from SQL query where I select product's description. If I press 'view' button, the description shows something like:

<div class="rte"> <p>adsf asd fasdfhal dsfash dfahsd fasjd</p> <p> </p> <p>asd</p> <p>f as</p> <p>df as</p> <p>df</p> <p>s</p> <p>long description</p> </div>

If I export the same SQL command, resulting .sql file reads:

adsf asd fasdfhal dsfash dfahsd fasjd^M
 ^M
asd^M
f as^M
df as^M
df^M
s^M
long description^M

Obviously, when I use that .CSV file in an import, the description fields get broken.

Maybe html is getting sanitized before exporting the CSV file?

Thanks!

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

I didn't know what all these buttons in products do:

1978569364_Capturadepantalla-2020-06-2821-57-30.png.0d1728f78f07f70713dceae4d66d6a80.png

Now I know the second is an export. Very nice. The last one add that query to SQL queries.

I don't know what could be wrong, but the exported file using button number two is separated only by ;

So when I open it in for example libreoffice all the rows appear one after the other, in one line.

 

Any help will be appreciated.

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...