Answers.Body: <p>Civireports can send a file automatically so set up a CiviReport with the filter of your choice, then under the &quot;Access&quot; tab, you can enter an email to send the report to. From there, check out Scheduled Jobs to configure the report to send the .csv file at whatever interval you wish</p>
  <p>(pete with appreciation to Justin for writing most of the answer)</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-16T08:15:49.860Z
Answers.Text: I've tried this way and it worked fine. My need actually is to start from the search builde because I need to grad value through relationships and the CiviReport tool is not sharp enough. Is there a way to create a CiviReport from the search builder or to programmatically send it per mail as csv?
Answers.UserDisplayName: Guillaume Sorel
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-12T08:46:46.767Z
Answers.LastActivityDate: 2021-02-12T08:46:46.767Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>In addition to CiviReport, the <a href="https://civicrm.org/extensions/sql-tasks-extension-configurable-recurring-tasks" rel="nofollow noreferrer">SQL Tasks</a> extension can handle this.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-12T15:41:03.103Z
Answers.LastActivityDate: 2021-02-12T15:41:03.103Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I need to daily update a list of members between civicrm and an external website on an other web server.</p>
  <p>Is there a way/extension to do so from a smart group ?</p>
  <p>First step would be to automatically generate a csv file.</p>
  <p>It seems that I can't do this with CiviRules.</p>
  <p>Second step, would be to export to a certain folder on an external web server.</p>
  <p>Any experience or ideas?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-02-11T21:43:05.183Z
Comments.Text: Civireports can send a file automatically
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-02-12T01:50:16.703Z
Comments.Text: Yep, to add to @petednz-fuzion's comment, set up a CiviReport with the filter of your choice, then under the "Access" tab, you can enter an email to send the report to. From there, check out Scheduled Jobs to configure the report to send the .csv file at whatever interval you wish.
Comments.UserDisplayName: Justin Moore
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-02-12T12:52:40.017Z
Comments.Text: thanks to both of you, I'll give a deeper try and report my (successful) process!
Comments.UserDisplayName: Guillaume Sorel
Tags: <export>
Title: How to automatically generate a csv file?
ThreadText: # How to automatically generate a csv file?
  
  (Asked by: username_0 on 2021-02-11)
  
  I need to daily update a list of members between civicrm and an external website on an other web server.
  
  Is there a way/extension to do so from a smart group ?
  
  First step would be to automatically generate a csv file.
  
  It seems that I can't do this with CiviRules.
  
  Second step, would be to export to a certain folder on an external web server.
  
  Any experience or ideas?
  
  **Tags:** export
  
  > **Comments:**
  > **username_1**: Civireports can send a file automatically  
  > **username_2**: Yep, to add to @username_1's comment, set up a CiviReport with the filter of your choice, then under the "Access" tab, you can enter an email to send the report to. From there, check out Scheduled Jobs to configure the report to send the .csv file at whatever interval you wish.  
  > **username_0**: thanks to both of you, I'll give a deeper try and report my (successful) process!  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2021-02-12. Score: 1
  
  Civireports can send a file automatically so set up a CiviReport with the filter of your choice, then under the "Access" tab, you can enter an email to send the report to. From there, check out Scheduled Jobs to configure the report to send the .csv file at whatever interval you wish
  
  (pete with appreciation to username_2 for writing most of the answer)
  
  > **Comments:**
  > **username_0**: I've tried this way and it worked fine. My need actually is to start from the search builde because I need to grad value through relationships and the CiviReport tool is not sharp enough. Is there a way to create a CiviReport from the search builder or to programmatically send it per mail as csv?  
  
  ---
  
  ### Answer by username_3 on 2021-02-12. Score: 1
  
  In addition to CiviReport, the [SQL Tasks](https://civicrm.org/extensions/sql-tasks-extension-configurable-recurring-tasks) extension can handle this.
  
  
  ---
  
  