All Questions
29 questions
8
votes
6
answers
11k
views
Adding a column to export but hiding from the grid?
I've created a custom report. The report has a significant number of fields in it which are required for when it's exported in CSV form.
What I'm trying to figure out is if there's a way to omit the ...
- 493
5
votes
3
answers
14k
views
How to add export functionality in Magento 2 new grid system
In Magento 1 I could add export functionality to any admin grid I create by adding this
$this->addExportType('*/*/exportCsv', Mage::helper('helper_alias')->__('CSV'));
$this->addExportType('...
- 199k
4
votes
1
answer
7k
views
Magento2: Export grid data in xls format
I have created a grid using UI componet, I want to export grid data in .xls file.
How can I do this, please advice me.
- 638
4
votes
1
answer
3k
views
How to join a collection with a query
I have a table represented in backend with two rendered fields, but when I try to make a CSV export from this grid, those two fields are not included.
So I tried to make a join from the initial ...
4
votes
1
answer
550
views
Data value is appearing instead of data label in grid export
I have an options array in below format.
array (size=3)
0 =>
array (size=2)
'value' => string 'one' (length=3)
'label' => string 'Number One' (length=10)
1 =>
...
- 9,010
3
votes
2
answers
5k
views
Export functionality of Custom UI grid in Magento 2 not working
When I tried to export data to Csv or xml from ui grid in magento2 it says:
1 exception(s):
Exception #0 (Magento\Framework\Exception\LocalizedException): Invalid UI Component element name: ''
I ...
- 31
3
votes
1
answer
198
views
Magento 1.9 - The export error after customizing grid on shipment page
I got a issue about export our shipment information.
Before i start with this issue, i add the "shipping method"column, is called customizing column, on shipment grid!
Like this,
app/code/core/...
- 594
3
votes
1
answer
2k
views
Add custom column to grid that can be exported
I want to add a column to sales order invoice grid, that should be exported as it is shown in the grid.The column is a calculated column, based on the row data, so there is no explicit database entry ...
- 335
2
votes
2
answers
1k
views
export fails on custom grid
I have changed the transaction grid so I needed to do it in local folder because they were comming from Core files. here is the folders structure
so in the controller I have done this:
public ...
- 1,069
2
votes
1
answer
2k
views
Magento 2 : How To Add Export Functionality in Admin Custom Grid Using only Block file?
I have create custom grid in customer information.
Create export functionality in custom admin grid without template file and ui component
Meetanshi\OrderHistory\view\adminhtml\layout\...
2
votes
0
answers
328
views
Admin Grid (UI Component) - Remove columns from export in magento2
I know there is a way to remove columns from export in magento1 through "is_system" config attribute in UI component. What's the solution in magento2??
- 79
2
votes
0
answers
386
views
add export functionality in custom grid (not ui grid ) Magento2
I have created a custom admin grid using 2 tables and that is working fine.
This is not a UI grid, but a grid same as Magento 1.
Please suggest me, how can I add a export feature in that.
- 321
2
votes
0
answers
2k
views
Magento 2 admin customer grid export to csv with custom fields
I need to modify the columns in the customer csv file generated by the Ui module in magento 2.
The problem is that the csv file is generated in a generic class of Ui Module, and not from the customer ...
- 1,576
1
vote
2
answers
9k
views
Export button in custom Grid Magento 2
I have created a custom grid and trying to add export button for it.
here is the code i used in my listing.xml file.
<exportButton class="Magento\Ui\Component\ExportButton">
<...
- 1,961
1
vote
1
answer
531
views
Grid Row Total issue in exported CSV - Magento 2
I am facing an issue in My custom grid. I have added 'Export to CSV' in Grid and it is working fine.
Issue is I have added a row total in grid but in Exported CSV, total is actually the total of all ...
1
vote
1
answer
862
views
Custom Export Report issue in Magento 2
I need to export the custom grid to the csv file. I have used the below code in my listing.xml file.
<exportButton class="Magento\Ui\Component\ExportButton">
<argument name="data" ...
- 177
1
vote
2
answers
847
views
GrandTotal(excl. tax) and Payment Method in Admin >> Sales >> Invoice grid
I have Magento CE 1.9.2.1 installed in my site.
Now I want to also include custom made columns "Grandtotal Excl. Tax" and "Payment method" to my Admin >> Sales >> Invoice grid and also include those ...
- 1,992
1
vote
0
answers
785
views
Magento 2 : How to export my custom grid data in product edit page admin?
When I click Export Button
Vendor\Module\etc\adminhtml\di.xml
<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:...
1
vote
0
answers
1k
views
Magento 2.3 Ui grid not working when store column is present
I have created a custom grid using UI component. "Store" column is one of the columns.
The issue is, when there is Store column, export function is not working.
The error comes from the following path ...
- 79
1
vote
0
answers
609
views
Magento 2 add custom columns in export
I created some columns in sales order grid like product SKUS, It is visible in grid column as well,
But while I am export using export button, CSV return blank columns for SKUS.
Any one have idea ...
- 1,040
0
votes
1
answer
2k
views
How to export selected products to xml in admin product grid
i need to export selected product to xml form admin product grid.
i have refer this to export selected product to csv.
Can anyone help for this.
- 9,597
0
votes
2
answers
189
views
Rename export csv file
Is there a way to rename the default export.csv filename to another filename?
I'm using the magento 2 export in my listing.xml
- 15
0
votes
1
answer
556
views
Deprecated Functionality: explode(): Passing null to parameter #2 ($string) of type string is deprecated
"<?php
namespace Rkd\test\Block\Adminhtml\Alltest\Alltest;
use Rkd\Reports\Helper\Data as ReportsHelper;
class GridExports extends \Magento\Backend\Block\Widget\Grid\Extended
{
protected $...
- 97
0
votes
1
answer
996
views
Magento 2 admin grid csv export not working properly
I added csv export in admin grid and want to have export functionality whether admin user have filtered results or not.
now I'm filtering data by daterange. some dates are working properly and gives ...
0
votes
0
answers
19
views
how to custom value which will be exported?
I have a grid and buttons for exporting like this.
There is field status in my grid. The value is 1 or 0. After exporting the grid, the value of this status is 1 or 0 in the CSV file. How can I make ...
0
votes
0
answers
183
views
CSV Export missing the custom column field added by renderer magento
Because my grid has a problem when join table, so I used renderer to show data like this
'brand' => array(
'header' => Mage::helper('advr')->__('Brand'),
'...
- 307
0
votes
1
answer
665
views
Grid csv/excel export not working
I currently can't export anything in the grids for products, clients and newsletters in my computer (and from another computer in another state). It downloads properly from my phone.
When I click ...
- 131
0
votes
1
answer
877
views
Exporting Full Custom Grid Data
Trying to export the full grid data of a custom module. The function itself works but there's a limit of 20 (well a limit of how many rows are visible on the page). I need to export the full data from ...
- 109
0
votes
1
answer
755
views
Custom admin grid Excel XML export - result contains no rows data, only columns names
I created custom admin grid in my module. And CSV Export for it works fine, but Excel XML Export does not contain any rows data
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?&...
- 1,655