#66 – CSV export

Posted in ‘FoolLog Component/Plugins’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Sunday, 19 August 2018 11:19 CEST
Hi Nikolai,

When you take a look in the site, could you also take a look at the CSV Export?
I don't seem to get it working. Also I cannot change the location of the Export.

Cheers,
Jim 
jvdzon
Sunday, 19 August 2018 15:05 CEST
Hello Jim,

Well, the file CSV export file is created succesfullly otherwise the "Download CSV" button wouldn't appear. Also erasing it works fine. Could you check for some user rights settings using htaccess which could prevent downloading? Maybe the CHMOD rights using a FTP client can be changed (should work fine with 0755for full safety).

The location cannot be changed for the export file. The only reason it's visible is for the administrator to see what path is used to store the file. That way using FTP the file can also be downloaded. That said maybe you could check something for me; is the "tmp" folder present after creating the export file in the "administrator/components/com_foollog" folder? That should be the case but an extra check is always best :-)

Greetz, Nikolai.
UWiX

Bug? That's not a bug, that's a feature. :-)

uwix
Monday, 20 August 2018 08:50 CEST
Hi Nikolai,

I cannot see the whole path for the export.


So I looked around but could not find the export file in the foollog directory.
Regarding your message above, "is the 'tmp' folder present", no it is not present.
All files have access 0755

I created manually the tmp folder..


Retried to create the CSV, it says it works, but the tmp directory remains empty and the CSV cannot be downloaded.
So currently I think the CSV is not at all created as I cannot find it with my FTP program.

Cheers,
Jim
jvdzon
Monday, 20 August 2018 10:46 CEST
Dear Jim,

When you click in the "Save Path" field you can scroll using the cursor-keys :-) The path where the export file is stored is: /administrator/components/com_foollog/tmp
Just noticed a space at the end of the path (in the Save Path field). Could be this is the problem why it's not downloading correctly. I'll look into it.

Greetz, Nikolai
UWiX

Bug? That's not a bug, that's a feature. :-)

uwix
Monday, 20 August 2018 11:04 CEST
Dear Jim,

Could you check the following folder on your site (using FTP): /media/com_foollog/export ?
Is there a "FoolLogCSVExport.txt" file present?

Greetz, Nikolai
UWiX

Bug? That's not a bug, that's a feature. :-)

uwix
Monday, 20 August 2018 11:08 CEST
Hi Nikolai,

Just tried to generate the export CSV.
There is no "FoolLogCSVExport.txt" present in that directory.



Greetz,
Jim
jvdzon
Monday, 20 August 2018 11:55 CEST
Hi Jim,

An update version of the component can be found here: FoolLog Dev Releases.

It's version 1.32 and should fix the trouble with downloading the CSV Export file. Also setting filters after downloading is bugfixed :-) Could you try this version for me please? Thanks!

Greetz, Nikolai
UWiX

Bug? That's not a bug, that's a feature. :-)

uwix
Monday, 20 August 2018 12:28 CEST
Hi Nikolai,

Updated:


Results:
1. The CSV file is being generated. It is visible in the media directory.
2. The CSV file is not downloadable, when pressing the download button nothing happens. I would expect a download falling into my downloads directory
3. The CSV file can be transferred by means of FTP and seems to be correct.
4. I still cannot use the next buttons after setting a filter.

I know from own experience that this kind of troubleshooting is very difficult. I greatly appreciate your activities, if necessary I can support more by an interactive teamviewer session as I mentioned before.

Greets,
Jim
jvdzon
Tuesday, 21 August 2018 10:04 CEST
Hello Jim,

A new test version is available here: version 1.32b.
In the test environment everything works well for the download button (even with the other version released yesterday) but I made some more changes. Hope this works fine.
Otherwise a quick TeamViewer session could give me a better direction - if you are available this morning :-)

Thanks for all your testing so far! Oh, pagination is fixed in this updated test-version.

Greetz, Nikolai
UWiX

p.s. you can post the TeamViewer ID and password in this ticket or e-mail me at **********.

Bug? That's not a bug, that's a feature. :-)

uwix
Tuesday, 21 August 2018 18:52 CEST
Hi Nikolai,

I was not able Today to react. Will try the 32b version shortly. You'll hear from me soon.

Greets,
Jim
jvdzon
Tuesday, 21 August 2018 21:04 CEST
Hi Nikolai,

Results 1.32b

  • Advancing the pages works.
  • Creating the correct CSV file, works, I tried a few possibilities.
  • The "FoolLogCSVExport.txt" file is present in the directory.
  • There is no more warning that it overwrites the existing file, for me totally no problem.
  • Erasing the file works fine.
  • Hitting the DownloadCSV button does not work yet. (Macbook Pro, Safari, High Sierra)



Tomorrow I have a busy day. Partly available between 09:30 and 11:00 and later in the afternoon again.

Greetz,
Jim

jvdzon
Wednesday, 22 August 2018 09:01 CEST
Hello Jim,

No need for the TeamViewer session anymore - thanks for that. In our online environment the problem of not able to download also occurs.
Strange enough in our test environment all works well - so, we have another bug to solve :-(

I'll keep you updated.

Greetz, Nikolai
UWiX

Bug? That's not a bug, that's a feature. :-)

uwix
Wednesday, 22 August 2018 10:17 CEST
Hi Jim,

Well, took some rewritting of the download method but in our test- and online demo-environment all seems to work fine now when clicking the download button.
Develeopment version 1.32c can be found here - if you have time to test it, that would be great!

Have a nice day.

Greetz, Nikolai
UWiX

p.s. Made this ticket public again for other users to follow. No personal information is shown.

Bug? That's not a bug, that's a feature. :-)

uwix
Wednesday, 22 August 2018 10:44 CEST
Hi Nikolai,

At this moment I am quite busy but in the afternoon I probably will be able to do the test.

Cheers Jim
jvdzon
Wednesday, 22 August 2018 17:53 CEST
Hello Nikolai,

Works excellently now. :thumbs:

Paging goes well,
filters work,
CSV generation works fine.
CSV download also works fine.

Super ! Thanks.

If you would like it, my colleague webmaster of this site, Marina and I, could give you hints on further development or ideas for your foollog component.
E.g. we have a forum, called CJForum, it is also a Joomla extension. It might be nice to gather more info from that also, just like you do for Kunena. Interesting things are of course, who is posting, which forum part, when, etc.

Cheers,
Jim
jvdzon
Thursday, 23 August 2018 09:38 CEST
Goodmorning Jim,

Glad everythings works out fine with the component now. Took some sweat and tears but there's no bug that cannot be concurred :-)

Thank you for the suggestion of CJForum - I'll contact you by e-mail about this, if that's okay.

Greetz, Nikolai
UWiX

Bug? That's not a bug, that's a feature. :-)

uwix
Thursday, 23 August 2018 10:26 CEST
Okay Nikolai,

Excellent.

Greets,
Jim
jvdzon
Sunday, 23 September 2018 00:00 CEST
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.
system
This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.
Support Availability

Working days: Monday to Friday. The is available 24 hours a day, 7 days a week but will only be answered during workings days according CET.
Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 48 hours. When we expect longer delays we will notify you when you file a ticket or reply.