Forums

[SOLVED]Using Export csv GF but getting error

desertdiana 09 Jul, 2013
Hi,

I set up the CSV export and it does work once. I if want to download the file again I get this error:

Not Found

The requested URL /administrator/https://ortl.org/components/com_chronoforms/exports/volunteer_download/csv_export_jos25_chronoforms_data_Volunteer_new4_201307091352.csv was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Is this right, does it remove the records in the database or something?

Diana
GreyHead 09 Jul, 2013
Hi Diana,

There's an extra /administrator/ crept in there from somewhere??? If you remove that then the file exists and downloads correctly.

Please drag a Debugger action into the On Submit event, then submit the form and post the debug results here.

Bob
desertdiana 09 Jul, 2013
Here is the code when I use the test form in chronoforms:
Data Array:

Array
(
    [option] => com_chronoforms
    [tmpl] => component
    [chronoform] => volunteer_download
    [event] => submit
    [Itemid] => 
    [input_submit_1] => Click here to download
    [8ca4d9b21b92e73df2e819f8a8180676] => 1
    [csv_link] => http://ortl.org/components/com_chronoforms/exports/volunteer_download/csv_export_jos25_chronoforms_data_Volunteer_new4_201307091505.csv
    [csv_count] => 1
    [csv_size] => 0.5
)

Validation Errors:

Array
(
)

 

You may download your file from click here . 1 records were exported. The file size is 0.5 kb.
Debug Data

    CSV Export
        $download_export: 0
        $download_nosave: 0
        Save folder is:
        /home/ortlorg/public_html/components/com_chronoforms/exports/volunteer_download/
        $download_export: xxx
        $download_export: 0
        File name is:
        csv_export_jos25_chronoforms_data_Volunteer_new4_201307091505.csv
        $query: SELECT * FROM `jos25_chronoforms_data_Volunteer_new4` ;
        1 records were found to export.
        Save link is:
        http://ortl.org/components/com_chronoforms/exports/volunteer_download/csv_export_jos25_chronoforms_data_Volunteer_new4_201307091505.csv
        File size is: 0.5 kb


Here is the debugger code when I submit from the article that I added the form to:

Data Array:

Array
(
    [chronoform] => volunteer_download
    [event] => submit
    [Itemid] => 612
    [option] => com_content
    [view] => article
    [id] => 799
    [input_submit_1] => Click here to download
    [8ca4d9b21b92e73df2e819f8a8180676] => 1
    [csv_link] => https://ortl.org/components/com_chronoforms/exports/volunteer_download/csv_export_jos25_chronoforms_data_Volunteer_new4_201307091507.csv
    [csv_count] => 1
    [csv_size] => 0.5
)

Validation Errors:

Array
(
)

 

You may download your file from click here . 1 records were exported. The file size is 0.5 kb.
Debug Data

    CSV Export
        $download_export: 0
        $download_nosave: 0
        Save folder is:
        /home/ortlorg/public_html/components/com_chronoforms/exports/volunteer_download/
        $download_export: xxx
        $download_export: 0
        File name is:
        csv_export_jos25_chronoforms_data_Volunteer_new4_201307091507.csv
        $query: SELECT * FROM `jos25_chronoforms_data_Volunteer_new4` ;
        1 records were found to export.
        Save link is:
        https://ortl.org/components/com_chronoforms/exports/volunteer_download/csv_export_jos25_chronoforms_data_Volunteer_new4_201307091507.csv
        File size is: 0.5 kb

GreyHead 09 Jul, 2013
Hi Diana,

As you can see all the links there are correct - so where is the extra /administrator/ coming from? Where do you get that broken URL from?

Bob
desertdiana 09 Jul, 2013
I have no clue about the administrator and can you give more details on the broken url?
GreyHead 10 Jul, 2013
Hi Diana,

This is from your post here:

The requested URL /administrator/https://ortl.org/components/com_chronoforms/exports/volunteer_download/csv_export_jos25_chronoforms_data_Volunteer_new4_201307091352.csv was not found on this server.


Bob
desertdiana 31 Jul, 2013
Found the problem..............I had /administrator/ in the thank you message. Removed it.


<p>You may download your file from <a href="/administrator/{csv_link}"> click here </a>. {csv_count} records were exported. The file size is {csv_size} kb.</p>


Works now....YAY!!

Diana
This topic is locked and no more replies can be posted.