Problem exporting contacts

benedata

Hello all,

I am having a problem exporting all fields from contacts data to Excel, trough the export button in my screen. I did add some fields tot Contact (Such as Titles before - in Dutch: Titels voor , Titles after and Publication options > CommonData arrays.

Now when I export my contact,I get the following error in my excel file:

Type: E_USER_ERROR (256) Message: Unknown field "Titels voor" for recordset "contact" File: /storage/web/public/sites/www.benedata.nl/epesi/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php Line=43 error backtrace: [PHP core called function]     function called: handle_epesi_error(256 "Unknown field \"Titels voor\" for recordset \"contact\"" "/storage/web/public/sites/www.benedata.nl/epesi/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php" 43 Array ("contact" "Titels voor" Array (#40) true Array (#14) "/")) File: /storage/web/public/sites/www.benedata.nl/epesi/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php     line 43     function called: trigger_error("Unknown field \"Titels voor\" for recordset \"contact\"" 256) File: /storage/web/public/sites/www.benedata.nl/epesi/modules/Utils/RecordBrowser/csv_export.php     line 65     function called: get_val("contact" "Titels voor" Array (#40) true Array (#14)) <hr>

I have looked at the permissions of the table Contact in the rord brower and they seem ok.

Thanks in advance for your help.

Regards,
Carine Dingemans
Benedata

ajb

What kind of fields are that?
Do they work in the GUI?

Regards,
Adam

benedata

Hi Adam,

They work when I select Print, then all fields are promted to document. The fields are common data records from the contact table :
group= multiselect field from CommonData > Contacts_groups, sorted on value
titlesv= selectfield, from CommonData >Titlesv > sorted on value

For all the fileds, I have Export permissions.

I hope this helps.

benedata

Oh, and I can edit the fields in the GUI, when I create or modify a contact.

ajb

I assume that you're using the latest version of EPESI.
Probably I've found the issue. Please edit file: modules/Utils/RecordBrowser/csv_export.php
Line 65. There is

		$val = Utils_RecordBrowserCommon::get_val($tab, str_replace('%%','%',$v['name']), $r, true, $v);

Replace it with

		$val = Utils_RecordBrowserCommon::get_val($tab, $v['id'], $r, true, $v);

It's been fixed in the current development version - even improved, that you can select fields to export.
That should fix your current issue.

Regards,
Adam

benedata

Hi Adam,

You have found the issue! Thank you so much, it works like a charm now.

I am on the latest version of Epesi and I love it!

Warm regards,
Carine Dingemans
Benedata

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge