Author Topic: Price Set Detail on Export (Read 675 times)

qjensen · March 21, 2011, 09:20:45 am

I have a couple of clients who would like a more detailed breakdown of the price set information on participant exports. What they want ends up looking like a pivot table when I look at the CiviCRM data structure.

Ideally the export would look like this:

Code: [Select]

Std Fields | Saturday Only | Saturday Lunch | Sat & Sun | Sunday Lunch |
------------------------------------------------------------------------
std info   | Yes           | Veg            | No        | No           |

Is there anyway to build a report/export like this with CiviCRM? Has anyone done something similar?

Donald Lobo · March 21, 2011, 10:05:30 am

quint:

check the price set custom search and do an export. basically does what u want

lobo

qjensen · March 22, 2011, 08:17:43 am

Thanks Lobo,

I haven't looked at the custom searches much, so I will have to educate myself.

Q

penguintrax · March 28, 2011, 12:51:29 pm

If you just go to Custom Searches (front page) you will see a link for Price Set Details for Event Participants

That said, when I selected the price set in question and clicked search, I received the following error:

Code: [Select]

<div class="crm-section">Database Error Code: Unknown column 'price_field_14' in 'field list', 1054</div>
                                        <div class="crm-section">Additional Details: <p><pre>Array
(
    [callback] =&gt; Array
        (
            [0] =&gt; CRM_Core_Error
            [1] =&gt; handle
        )

    [code] =&gt; -19
    [message] =&gt; DB Error: no such field
    [mode] =&gt; 16
    [debug_info] =&gt; 

UPDATE civicrm_temp_custom_886cf9f4a3aca78b2a6436502f7253e1
SET price_field_14 = 1
WHERE participant_id = 81;
 [nativecode=1054 ** Unknown column 'price_field_14' in 'field list']
    [type] =&gt; DB_Error
    [user_info] =&gt; 
UPDATE civicrm_temp_custom_886cf9f4a3aca78b2a6436502f7253e1
SET price_field_14 = 1
WHERE participant_id = 81;
 [nativecode=1054 ** Unknown column 'price_field_14' in 'field list']
    [to_string] =&gt; [db_error: message=&quot;DB Error: no such field&quot; code=-19 mode=callback callback=CRM_Core_Error::handle prefix=&quot;&quot; info=&quot;
UPDATE civicrm_temp_custom_886cf9f4a3aca78b2a6436502f7253e1
SET price_field_14 = 1
WHERE participant_id = 81;
 [nativecode=1054 ** Unknown column 'price_field_14' in 'field list']&quot;]
)
</pre></p><p></p></div>

According to my research in the database, price_field_14 is a price field option that's been disabled (it was used for an earlybird discount). I had been warned away from using the built-in discount function in Online Registration. Has this completely hosed my ability to do this export?

Donald Lobo · March 28, 2011, 03:04:53 pm

I suspect we did not account for that case when we wrote that custom search / export

Your best bet would be to investigate the code and fix the code. If you do so, please attach the patch to a newly created issue so we can integrate it into the main code base. If you are not familiar with php/mysql you might want to consider hiring a developer

lobo

penguintrax · March 29, 2011, 07:25:46 am

Thanks Lobo - this is for a nonprofit group, so hiring a developer for this is outside of the budget. It's just as easy for me to reenable that price set to run the report, then take it offline when I'm done.

Hopefully that is something that can be adjusted in the next release or at least have it be an option (Include disabled price sets?)

CiviCRM Community Forums (archive)

News:

Author Topic: Price Set Detail on Export (Read 675 times)

qjensen

Price Set Detail on Export

Donald Lobo

Re: Price Set Detail on Export

qjensen

Re: Price Set Detail on Export

penguintrax

Re: Price Set Detail on Export

Donald Lobo

Re: Price Set Detail on Export

penguintrax

Re: Price Set Detail on Export