Best Way to Import Event Fee?

[marqpdx]

Hi,

I'm nearly finished with an Event Import module (it's a hack but i'll share the code with anyone who wants it).
It's using Civi 2.2 and handles Events, Tell a Friend, Location & CiviAddress, Extra info (profile).

What i can't figure out, is there a way to import Fees?? We have sliding scale events and it'd be great to create two records for the Fees during import.

I know this involves the civicrm_option_value and civicrm_option_group tables, but are there others? Is there a hidden API for this??

thanks,
m

[Donald Lobo]

1. how do u decide which scale to charge the user? we have "an early bird" discounting scheme that stores two copies of the fees and uses one based on the date

2. check: CRM/Event/Form/ManageEvent/Fee.php, line 582 or so for how to use an internal function to create the option group/value pair

lobo

[marqpdx]

sweet!
thanks much Lobo,
that's perfect.
m

ps - the current csv file we're importing from has high/low sliding scale data, which we interpret for fee structures...

[marqpdx]

Hi All,

i managed to import event Fees, but not in the most elegant way (as Lobo suggested previously in this thread).

what i did was to create a new civicrm_option_group record, using as the 'name' field the value "civicrm_event.amount.EVENTID" (with the actual event ID in there).

then, taking the primary key from that newly created row, i inserted the corresponding civicrm_option_value records (two in our case. one for sliding scale upper and one for lower).

it appears to be working correctly.

did i miss anything? if not, give it a try if you need to import event fees.

thx,
m

[julianbrelsford]

marqpdx - i'm interested in trying out your event import module to see if it'll import a list of 300+ past events. I sent you a private message.

[Eileen]

I'm also interested in this module - perhaps you could document it in the code snippets part of the wiki?

[marqpdx]

hi all,

i finally got back onto this project, and posted a wiki page on importing events, which includes importing event fees.
it is at:
http://wiki.civicrm.org/confluence/display/CRMDOC/Importing+Events

it works well for me!

many smiles,
m