javascript - File is not being downloaded when requested through Ajax using JQuery -

-

i need download .csv file information website, i'm using link , javascript/jquery table servr , create file.

i have link supposed download file when clicked:
<a class="areasummaryexport" value="1">...</a>

and have in js file:

this adds click listener link:

$('.areasummaryexport').on('click', function(){     exportareasummary($(this).attr('value'), $(this)); });

this function gets table server using ajax request , sends corresponding function process:

function exportareasummary(selected, sender){     $.ajax({         url: 'admin_ajax.php',         method: 'get',         datatype: 'json',         data: {action: 'exportareasummary', area: selected}     }).done(function(data){         console.log('done');         exporttabletocsv.apply(sender, [$($(data.table)[0]), data.name, data.header]);     }).error(function(xmlhttprequest){         console.log('error');         console.log(xmlhttprequest);     }); }

finally function adds href attribute link information of file download:

function exporttabletocsv($table, filename, header) {     console.log('printing');     var $rows = $table.find('tr:has(td),tr:has(th)'),          // temporary delimiter characters unlikely typed keyboard         // avoid accidentally splitting actual contents         tmpcoldelim = string.fromcharcode(11), // vertical tab character         tmprowdelim = string.fromcharcode(0), // null character          // actual delimiter characters csv format         coldelim = '","',         rowdelim = '"\r\n"',          // grab text table csv formatted string         csv = '"' + 'sep=,' + rowdelim +         (header? header.join(coldelim) + rowdelim : '') +         $rows.map(function (i, row) {             var $row = $(row),                 $cols = $row.find('td, th');              return $cols.map(function (j, col) {                 var $col = $(col),                     text = $col.text();                  return text.replace(/"/g, '""'); // escape double quotes              }).get().join(tmpcoldelim);          }).get().join(tmprowdelim)             .split(tmprowdelim).join(rowdelim)             .split(tmpcoldelim).join(coldelim) + '"',          // data uri         csvdata = 'data:application/csv;charset=utf-8,' + encodeuricomponent(csv);     $(this)         .attr({         'download': filename,             'href': csvdata,             'target': '_blank'     });     console.log('printed'); }

the problem gets info csv file , adds in href attribute in link, won't download file (i have click again work).

i know last function works because use somewhere else, there have table on screen there's no ajax involved. i'm guessing problem ajax, not sure where.

i tried firing click event through js doesn't work either.

i recommend create csv @ server side php program , set content-type "application/vnd.ms-excel" (or) "text/csv" , set "content-disposition: attachment; [yourfilename] "

refer create csv file user in php

refer force download csv file

simply put hyperlink as

<a class="areasummaryexport" href="admin_ajax.php" value="1">...</a>

Comments

Post a Comment

Popular posts from this blog

python - How to create jsonb index using GIN on SQLAlchemy? -

-
here's current code creating index jsonb. index("mytable_data_idx_id_key", mytable.data['id'].astext, postgresql_using='gin') but got error. sqlalchemy.exc.programmingerror: (psycopg2.programmingerror) data type text has no default operator class access method "gin" hint: must specify operator class index or define default operator class data type. [sql: "create index event_data_idx_id_key on event using gin ((data ->> 'id'))"] is there way create index on sqlalchemy? the postgresql specific sqlalchemy docs @ http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#operator-classes mention postgresql_ops dictionary provide "operator class" used postgresql, , provide example illustrating use: index('my_index', my_table.c.id, my_table.c.data, postgresql_ops={ 'data': 'text_pattern_ops', ...
Read more

PHP DOM loadHTML() method unusual warning -

-
i had following code works fine on localhost: $document = new domdocument(); $document->loadhtml($p_result); $form = $document->getelementsbytagname('form')->item(0); // code continues using $form variable after same code updated on outside server, loadhtml() failed , issued warning. warning: domdocument::loadhtml() expects parameter 1 valid path, string given in path/name/to/script.php returned null instead of object code pretty gets fatal error. note contents of $p_result absolutely same on outside server , on localhost. but why displays kind of warning , why not work? doesn't loadhtml() expects argument 1 string in first place? why method expects parameter 1 valid path ? just make clear i'm not calling loadhtmlfile() , i'm calling loadhtml() . thanks. you're affected one of php bugs . issue present in php 5.6.8 , 5.6.9. have affected php version on server, , bug-free version on localhost. the bug forbids null ...
Read more

c# - TransactionScope not rolling back although no complete() is called -

-
i'm using transactionscope rollback transaction fail bool errorreported = false; action<importerrorlog> newerrorcallback = e => { errorreported = true; errorcallback(e); }; using (var transaction = new transactionscope()) { foreach (importtaskdefinition task in taskdefinition) { loader.load(streamfile, newerrorcallback, task.destinationtable, processingtaskid); } if (!errorreported) transaction.complete(); } i'm sure there no transactionscope started ahead or after code. i'm using entity framework insert in db. regardless state of errorreported transaction never rolled in case of error. what missing ? transactionscope sets transaction.current . that's does. wants transacted must @ property. i believe ef each time connection opened reason. probably, connection open when scope installed. open connection inside of scope or enlist manually. ef has nasty "design decision": default opens ...
Read more