Answers.Body: <p>I use a text editor with macros to automate the clean up of csvs and then create fields in CiviCRM to receive them. In the CiviCRM import process, simply match the csv fields to the CiviCRM fields.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-06-13T15:25:16.117Z
Answers.LastActivityDate: 2023-06-13T15:25:16.117Z
Answers.UserDisplayName: Hank
Body: <p>I'm looking for someone who knows CiviCRM's data importing and mapping processes. We have a .csv extract of data requiring some cleansing, importing and mapping. From what we can tell so far the process is multiple steps. We have captured these steps but we wish to determine if it can be developed into a more repeatable process.</p>
  <p>We have a test file and schema overview available.</p>
  <p>Look forward to hearing from anyone who thinks that can resolve/fix this challenge.</p>
  <p>Regards</p>
  <p>Warwick</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-06-13T19:42:30.383Z
Comments.Text: Happy to give you a walkthrough of importing to see if that is sufficient if this is your first civi import peter.davis@fuzion.co.nz
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-06-23T02:57:23.487Z
Comments.Text: Are you wanting information or to recruit a contractor? This site is for the former. You can find a list of partners who can be contracted on the CiviCRM.org website I believe. If you want help figuring out how to do it yourself you've come to the right place.
Comments.UserDisplayName: kapn
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-06-23T02:58:38.720Z
Comments.Text: You'll find as you go through the process that it is pretty clear. In addition, you can save your mappings with names that make sense to you for future reuse.
Comments.UserDisplayName: kapn
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-06-25T20:50:30.010Z
Comments.Text: Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
Comments.UserDisplayName: Community
Tags: <import><field-mapping><data>
Title: We need help with importing & mapping a .csv data extract from a 3rd party system
ThreadText: # We need help with importing & mapping a .csv data extract from a 3rd party system
  
  (Asked by: username_0 on 2023-06-13)
  
  I'm looking for someone who knows CiviCRM's data importing and mapping processes. We have a .csv extract of data requiring some cleansing, importing and mapping. From what we can tell so far the process is multiple steps. We have captured these steps but we wish to determine if it can be developed into a more repeatable process.
  
  We have a test file and schema overview available.
  
  Look forward to hearing from anyone who thinks that can resolve/fix this challenge.
  
  Regards
  
  username_0
  
  **Tags:** import, field-mapping, data
  
  > **Comments:**
  > **username_1**: Happy to give you a walkthrough of importing to see if that is sufficient if this is your first civi import peter.davis@username_1.co.nz  
  > **username_2**: Are you wanting information or to recruit a contractor? This site is for the former. You can find a list of partners who can be contracted on the CiviCRM.org website I believe. If you want help figuring out how to do it yourself you've come to the right place.  
  > **username_2**: You'll find as you go through the process that it is pretty clear. In addition, you can save your mappings with names that make sense to you for future reuse.  
  > **username_3**: Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_4 on 2023-06-13. Score: 0
  
  I use a text editor with macros to automate the clean up of csvs and then create fields in CiviCRM to receive them. In the CiviCRM import process, simply match the csv fields to the CiviCRM fields.
  
  
  ---
  
  