Body: <p>I want to store data (date, integer #1, integer #2, integer #3) for an organizational contact in CiviCRM. Each month a new record record with the same format will be created for each contact, but with new data.</p>
  <p>What is the best way to do that in CiviCRM?</p>
  <p>I also want to import that data (historical data from past dates).  Can that be done?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-08-05T19:56:30.063Z
Comments.Text: Have a look at the answer here https://civicrm.stackexchange.com/questions/3957/how-to-import-to-multi-record-set-custom-fields
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-08-05T20:57:18.053Z
Comments.Text: That might work but I'd probably do it with activities and "regular" custom fields on the activity instead of multicustom, but to answer "best" properly depends on what the daily tasks are that use these fields and what reporting you need.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-08-06T03:29:02.803Z
Comments.Text: Each month a new record would be added (date of data, integer #1, integer #2, integer #3).  The data would be used record and then also to report on the changes (increase or decrease) of the data (integer # 1, integer # 2, integer # 3, etc.) from month to month.  I was thinking of making a report for that, possibly exporting data to a csv for use elsewhere and so that I could create annual totals or averages of the data.
Comments.UserDisplayName: EricLB
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-08-06T17:31:15.500Z
Comments.Text: So then custom fields on activities looks a good option as @demerit says. There are lots of reports for activities both standard ones and those provided by [extensions](https://civicrm.org/extensions?field_extension_civi_use_target_id=96)
Comments.UserDisplayName: Aidan
Tags: <custom-fields><data-import>
Title: How to store (and import) historical data (date, integer#1, integer #2, etc.)
ThreadText: # How to store (and import) historical data (date, integer#1, integer #2, etc.)
  
  (Asked by: username_0 on 2020-08-05)
  
  I want to store data (date, integer #1, integer #2, integer #3) for an organizational contact in CiviCRM. Each month a new record record with the same format will be created for each contact, but with new data.
  
  What is the best way to do that in CiviCRM?
  
  I also want to import that data (historical data from past dates). Can that be done?
  
  **Tags:** custom-fields, data-import
  
  > **Comments:**
  > **username_1**: Have a look at the answer here https://civicrm.stackexchange.com/questions/3957/how-to-import-to-multi-record-set-custom-fields  
  > **username_2**: That might work but I'd probably do it with activities and "regular" custom fields on the activity instead of multicustom, but to answer "best" properly depends on what the daily tasks are that use these fields and what reporting you need.  
  > **username_0**: Each month a new record would be added (date of data, integer #1, integer #2, integer #3).  The data would be used record and then also to report on the changes (increase or decrease) of the data (integer # 1, integer # 2, integer # 3, etc.) from month to month.  I was thinking of making a report for that, possibly exporting data to a csv for use elsewhere and so that I could create annual totals or averages of the data.  
  > **username_3**: So then custom fields on activities looks a good option as @demerit says. There are lots of reports for activities both standard ones and those provided by [extensions](https://civicrm.org/extensions?field_extension_civi_use_target_id=96)  
  
  ---
  
  ## 0 answers
  
  