Skip to main content

csv import & newline character?

More
13 years 6 months ago #96342 by sideways
Hello

I have a csv where all text fields are enclosed in double quotes. It imports just fine except that any newline (\n) characters within the quotes are ignored by hikashop after import.

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

More
13 years 6 months ago #96520 by Jerome
Hi,

Did you try with newlines using the format: "\r\n" ?

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

More
13 years 6 months ago #96541 by sideways
Thanks for your reply.

I just rewrote the code in our csv builder application to insert "\r\n" instead of "\n" but it made no difference to the end result. Still, I can confirm it looks ok if i open up the text in a texteditor in both "\n" & "\r\n" cases. I just seems hikashop is not picking up the linebreaks.

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

More
13 years 6 months ago #96583 by nicolas
Why do you think that Hikashop is not picking up the linebreaks ?
Are you sure that you're not missunderstanding linebreaks in text files and HTML linebreaks ?
The linebreaks in text files won't display on HTML pages since you need to use HTML linebreaks <br/> instead.

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

More
13 years 6 months ago #96616 by sideways
That is entirely possible. :whistle:

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

Time to create page: 0.191 seconds
Powered by Kunena Forum