- Posts: 56
- Thank you received: 2
csv import & newline character?
13 years 6 months ago #96342
by sideways
csv import & newline character? was created 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.
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.
13 years 6 months ago #96520
by Jerome
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.
Replied by Jerome on topic csv import & newline character?
Hi,
Did you try with newlines using the format: "\r\n" ?
Regards,
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.
13 years 6 months ago #96541
by sideways
Replied by sideways on topic csv import & newline character?
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.
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.
13 years 6 months ago #96583
by nicolas
Replied by nicolas on topic csv import & newline character?
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.
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.
13 years 6 months ago #96616
by sideways
Replied by sideways on topic csv import & newline character?
That is entirely possible. :whistle:
Please Log in or Create an account to join the conversation.
Time to create page: 0.286 seconds