Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Faulty .xls file produced when exporting

Faulty .xls file produced when exporting 16 years 10 months ago #386

  • crazycat
  • crazycat's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 77
ms excel yells :) see attachment. And file contents are messed up - some cols and rows got to be placed to the wrong positions.
Attachments:
As soon as you make something idiot proof, Nature makes better idiots!!!
The administrator has disabled public write access.

Re:Faulty .xls file produced when exporting 16 years 10 months ago #391

  • alex
  • alex's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 443
  • Thank you received: 3
Could you send me that xls file you generated?
The administrator has disabled public write access.

Re:Faulty .xls file produced when exporting 16 years 10 months ago #395

  • crazycat
  • crazycat's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 77
Do you mean - send to your email or post here?
You told me that you didn't receive my email I sent you previously.
As soon as you make something idiot proof, Nature makes better idiots!!!
The administrator has disabled public write access.

Re:Faulty .xls file produced when exporting 16 years 10 months ago #443

  • rsd
  • rsd's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 15
That is because the file is not a xls file, but a CSV file with space used instead of commas.
If you rename it to forme.csv instead of forme.xls, excel might not complain.
The administrator has disabled public write access.

Re:Faulty .xls file produced when exporting 16 years 10 months ago #458

  • crazycat
  • crazycat's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 77
rsd wrote:
That is because the file is not a xls file, but a CSV file with space used instead of commas.
If you rename it to forme.csv instead of forme.xls, excel might not complain.

Not quite. After renaming the file worning is gone, but the contents of the file are such a mess. Not even close to perfectly ordered rows and columns though.

Any other suggestions? I thought it is all connected to the way data is collected to a certain type of file, isn't it?

Cheers,
Adam
As soon as you make something idiot proof, Nature makes better idiots!!!
The administrator has disabled public write access.

Re:Faulty .xls file produced when exporting 16 years 10 months ago #471

  • rsd
  • rsd's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 15
I don't really have a copy of Excel to see how to open the CSV file.
Maybe Importing it would do (instead of opening).

Because the file is Tab separated field and not comma, this might be an issue to excel. (on OpenOffice after renaming to csv it works fine).

To convert it is quite simple:
$ perl -pe 's@\t@,@g' forme.csv

-rsd
The administrator has disabled public write access.

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!