1. ocbinfo
  2. RO CSVI
  3. Thursday, 07 April 2016
  4.  Subscribe via email
Hello,

We just started using CSVI which works great in general.

We wanted to give the file to a company, but they say the file is LR and not CRLF.

Also it need to be that its only one product per row.

Can anyone tell me how this works?
Accepted Answer Pending Moderation
Hello,

Interesting question :) CSVI doesn't and can't specify which line-endings to use as this is determined by PHP.

Also it need to be that its only one product per row.
CSVI exports products per row, it is most likely due to how you are reading the file. Make sure you specify the field separator and text delimiters.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,

Interesting question :) CSVI doesn't and can't specify which line-endings to use as this is determined by PHP.




Can you give me a bit more details? So its based on my server if it uses LR or CFLR? Can you tell me how to change this?
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

Can you give me a bit more details?
Sure.

So its based on my server if it uses LR or CFLR?
The LR doesn't exist. There are 2 flavours:
Unix: LF (Line Feed "\n";)
Windows: CRLF (Carriage Return Line Feed "\r\n";)

CSVI uses the PHP command fopen to open the file and this page explains more about line endings.

Actually I did some more checking, CSVI does add the CRLF at the end of each line. When checking an export file here, the text editor reports it as Windows line-endings. Do you make any changes to the exported file before sending it off?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Okay, this is all a bit new to me.

I checked the file in several editor and for it it looks not like it is in only one line.

Also i can't see "\r\n" at the end of a line.

I didn't changed any on the file.

I created a new template, maybe it need to change some settings here?

Can you tell me how exacte i should make the settings?
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,

Okay, this is all a bit new to me.
Then you are straight into the deep ;) This is pretty technical.

Also i can't see "\r\n" at the end of a line.
You cannot see them as they are non-printing characters. Usually editors will show what type of line-ending is used.

Can you tell me how exacte i should make the settings?
There is no option for setting this.

checked the file in several editor and for it it looks not like it is in only one line.
You see the output on multiple lines as well, correct?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation


Also i can't see "\r\n" at the end of a line.
You cannot see them as they are non-printing characters. Usually editors will show what type of line-ending is used.



checked the file in several editor and for it it looks not like it is in only one line.
You see the output on multiple lines as well, correct?



Yes, all Editors i tried i see it over many lines.

Ok, can you recommend me any editor where i can prrof this? I tried different CSV Editors and i can´t see it anywhere. (CRLF)

So, can you tell me how should i go on. The company still can't work with the data in this format, and its the only reason we bought CSVI.
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,

Yes, all Editors i tried i see it over many lines.
So that means the lines have the correct line endings.

Ok, can you recommend me any editor where i can prrof this?
On Windows you can use Notepad++. You could also try a bigger editor like jEdit which is Java so it runs on all systems.

So, can you tell me how should i go on.
I can't because you tell me you need files that end with CRLF and that is what CSVI uses.

The company still can't work with the data in this format, and its the only reason we bought CSVI.
You are pointing the finger at CSVI which I think is unfair. In my professional opinion I would say it's just crazy that a company bothers their clients with such a technical thing as linefeeds. Their system should be able to read the 3 different types of linefeeds that exist. Pretty much every program does that. You said so yourself, you tried a bunch of programs and they read the CSV file that CSVI exports just fine. Over the last 10 years this is the first time I hear such a thing.

In a more useful opinion, let the company explain what their issue is, it can't be the linefeed I think. Having trouble reading a file could also have to do with other non-printing characters but that would mean your data is already "corrupt". How do they read the file then?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hi Roland,

Thank you for your answer.

I really don't want to point with finger on you or your product. We think its great powerful tool, but as i told, iam a bit new to this and i can just repeat what the partner says to us.

So that means the lines have the correct line endings.


Iam not sure about this, for it looks like many lines, also it seems not all fields are filled correctly, maybe its issue with our product description which includes HTML tags.

On Windows you can use Notepad++. You could also try a bigger editor like jEdit which is Java so it runs on all systems.


When i use this editors it don't shows up in one line, also it don't show CLRF (or LF).

I can't because you tell me you need files that end with CRLF and that is what CSVI uses.


Can i maybe send you a generated CSV file, so you can have a look at this?

In a more useful opinion, let the company explain what their issue is, it can't be the linefeed I think. Having trouble reading a file could also have to do with other non-printing characters but that would mean your data is already "corrupt". How do they read the file then?


The company told me again that the file seems to be okay, but that it has no CLRF.


Thank you for your help in advance.
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,

I hope you are not copying verbatim what the company is telling you because CLRF doesn't exist, it is CRLF (CarriageReturnLineFeed).

When i use this editors it don't shows up in one line, also it don't show CLRF (or LF).
You probably don't know how to use it. In Notepad++, you go to View -> Show Symbol -> Show End of Line. This will then show the CRLF at the end of the line.

Can i maybe send you a generated CSV file, so you can have a look at this?
Sure, send me the file and I will check it.

The company told me again that the file seems to be okay, but that it has no CLRF.
See for yourself when you turn on the view symbol.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!