I have created a custom module Called Department and added One to Many relationship with Accounts. Im unable to view Account column in cvs file after exporting via Department listview. Any one can please suggest the solution?
Hi Lavanya MR,
what field are you exactly missing? The link to the account or fields from the accounts module?
On the export from listview you have no access to fields from other modules. Use a list and rows report instead which can also be exported to excel.
Björn Canales Pfisterer,
I want to export Account field which i have created relationship in Deparment.
EX: Consider below is the Department Listview.
When i export data from listview, Account column and respective account records details missing in excel sheet. How do i retrieve this data in excel from listview?. Please let us know the solution.
FYI: Account field added automatically in Department when i create one to many relationship between Department and Account modules.
1. If you have a one-to-many or many-to-many realtionship from Departments to Accounts, the csv export cannot contain any account information as there can be many accounts related to the department.
2. If you have a many-to-one or one-to-one relationship from Departments to Accounts, the csv export does not contain the account infomation by default but you could use an export generated in the Reports module to export them.
If you are running CE or want to have in the default export of the other editions you must add a custom function "create_export_query" to your custom module to fill the related fields in the csv export.
3. If you create a related field in the departments module referring to the Accounts module the system will create the Account field in the export by default.
Retrieving data ...