#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.

Latest post by on Sunday, 23 September 2018 00:00 CEST

Sunday, 19 August 2018 11:19 CEST

jvdzon
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 

Sunday, 19 August 2018 15:05 CEST

uwix
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. :-)

Monday, 20 August 2018 08:50 CEST

jvdzon
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

Monday, 20 August 2018 10:46 CEST

uwix
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. :-)

Monday, 20 August 2018 11:04 CEST

uwix
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. :-)

Monday, 20 August 2018 11:08 CEST

jvdzon
Hi Nikolai,

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



Greetz,
Jim

Monday, 20 August 2018 11:55 CEST

uwix
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. :-)

Monday, 20 August 2018 12:28 CEST

jvdzon
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

Tuesday, 21 August 2018 10:04 CEST

uwix
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. :-)

Edited by uwix on 2018-08-22 10:18 CEST

Tuesday, 21 August 2018 18:52 CEST

jvdzon
Hi Nikolai,

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

Greets,
Jim

Tuesday, 21 August 2018 21:04 CEST

jvdzon
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

Edited by jvdzon on 2018-08-21 21:04 CEST

Wednesday, 22 August 2018 09:01 CEST

uwix
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. :-)

Wednesday, 22 August 2018 10:17 CEST

uwix
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. :-)

Edited by uwix on 2018-08-22 10:19 CEST

Wednesday, 22 August 2018 10:44 CEST

jvdzon
Hi Nikolai,

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

Cheers Jim

Wednesday, 22 August 2018 17:53 CEST

jvdzon
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
Edited by jvdzon on 2018-08-22 17:53 CEST

Thursday, 23 August 2018 09:38 CEST

uwix
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. :-)

Thursday, 23 August 2018 10:26 CEST

jvdzon
Okay Nikolai,

Excellent.

Greets,
Jim

Sunday, 23 September 2018 00:00 CEST

System Task
system
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.
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.