Author Topic: IMPORT ACTIVITY (Read 1603 times)

CousiMo · December 27, 2007, 06:46:12 pm

using civicrm 1.9

import activity.
did a test run , certain fields show up. but some dont. and cant see the details only delete

the following import was done with its data:
email john@john.com
activity type phone interview
activity date 12/11/07

not sure what the following civirm field are , please explain, but this is the data
module test 1
call back test 2
activity id test
activity summary test 4
test test5

results:
activity type phone interview
activity date 12/11/07
activyt summary test4

1. the rest dont show up
2. how do i view it (it only has the delete option)
3. how do i see and input "created by"
4. how do i see and inpute " status"
5. how do i see and input "details"
thanks you

yasheshb · December 28, 2007, 04:56:31 am

if you check out the file "sql/civicrm_41.mysql"

here's the details of the activity_history table where you can get informaton on the fields you're looking for

module test 1
call back test 2
activity id test
activity summary test 4

- module varchar(64) COMMENT 'Display name of module which registered this activity',
- callback varchar(64) COMMENT 'Function to call which will return URL for viewing details',
- activity_id int unsigned NOT NULL COMMENT 'FK to details item - passed to callback',
- activity_summary varchar(255) COMMENT 'brief description of activity for summary display - as populated by registering module',

hth

yashesh

CousiMo · December 28, 2007, 01:02:05 pm

Thank you for the ref

the follwoing import was done
first name : john
last name : schwartz
acitivity type : exit Interview
Date of activity : 12-11-07
Module : CiviCRM
call back : CRM_Activity_BAO_Activity::showActivityDetails
activity summary : summary lala

i imported this to the demo site please look up the activity for john schwartz and see if youcan click on the details to see more information.

such who the person is creating the activity and details of the activity

http://demo.civicrm.org/drupal/civicrm/contact/view?reset=1&cid=1148

thanks again

CousiMo · December 28, 2007, 01:08:36 pm

i just noticed the following: http://issues.civicrm.org/jira/browse/CRM-702

NOTE: When viewing inserted activity history items - only items w/ callback AND activity_id values should include a 'Details' link (this s/b existing functionality - but pls verify when testing imported records).

how will i be able to import information to the activity_id values? which is part of the civicrm_activity> import now only inputs in the civcirm.activity_hisotry tables

thanks

CousiMo · January 03, 2008, 05:10:33 pm

any help would be greatly appreciate in this.. i need to import activity with notes attached to them,

thanks

Donald Lobo · January 03, 2008, 06:56:44 pm

You will need to write a custom importer and/or a sql import script. If you need help, you might want to check the civicrm professional listing

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: IMPORT ACTIVITY (Read 1603 times)

CousiMo

IMPORT ACTIVITY

yasheshb

Re: IMPORT ACTIVITY

CousiMo

Re: IMPORT ACTIVITY

CousiMo

Re: IMPORT ACTIVITY

CousiMo

Re: IMPORT ACTIVITY

Donald Lobo

Re: IMPORT ACTIVITY