• 1

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 11 years 6 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 11 years 6 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 11 years 6 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 11 years 6 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 11 years 6 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 11 years 6 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.

Re:Faulty .xls file produced when exporting 11 years 4 months ago #1050

  • cbh
  • cbh's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
I'm not clear on where you would make this change - does the php for the component become readable when you register?

Using a tab or comma (preferably) by default would, I think, be a better solution. If I have spaces in input to a field, those are separated into separate columns in Excel, even if I don't want them to be.

Nice component, though. This fix would do it, for me.

Cheers
Chris
The administrator has disabled public write access.

Re:Faulty .xls file produced when exporting 11 years 3 months ago #1171

  • emagin
  • emagin's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 7
Can you elaborate on where to find this code?

1) I have not purchased this yet, it appears that some code is encrypted
So can you tell me if this is in the encrypted code or not

2) What file must we modify?

Thanks, CSV comma separated values is very important for me or Excel can't open the files.

Thank you!
The administrator has disabled public write access.
  • 1

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!