Answers.Body: <p>Looks like you'd export from CiviCRM into CSV and then wrap your data in <code>&lt;tags&gt;</code> like e.g. <code>&lt;SalInvoice&gt;</code> and <code>&lt;/SalInvoice&gt;</code>. Also needs to add a line of vendor info, see:</p>
  
  <p><a href="https://partners.sagenorthamerica.com/irj/go/km/docs/sageKM/Simply%20Accounting%20by%20Sage/Assets/dev-import.pdf" rel="nofollow noreferrer">https://partners.sagenorthamerica.com/irj/go/km/docs/sageKM/Simply%20Accounting%20by%20Sage/Assets/dev-import.pdf</a></p>
  
  <p>Once you get one working by manually inserting tags and vendor info to CSV data
  from your CiviCRM then you can script it.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-10T12:27:17.573Z
Answers.Text: Thanks Karin.  Do you have any experience of doing this yourself?
Answers.UserDisplayName: William Mortada
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-10T12:48:28.223Z
Answers.Text: Not for Sage specifically - no. But other than QuickBooks - using some CSV format - yes.
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2016-05-10T12:14:51.740Z
Answers.LastActivityDate: 2018-10-26T09:20:35.800Z
Answers.LastEditDate: 2018-10-26T09:20:35.800Z
Answers.UserDisplayName: KarinG - Semper IT
Answers.Body: <p>Yes we can import data directly to sage but using custom format </p>
  
  <p>I did take a copy of CSV.php file and created a custom_export.php and then did the changes </p>
  
  <p>But you can also directly change CSV.php file and do the required changes - In most case sage file will need only minimum fields like which can do by altering the SQL</p>
  
  <p><strong>Type -  Account Ref - Nominal - Reference - Date - Transaction - Net - Vat - Tax code</strong></p>
  
  <p>If you need more details please let me know - I guess this helps!!!  </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-12T14:42:46.637Z
Answers.Text: Reason why we use scripts to change CSVs outside of CiviCRM is b/c we trust CiviCRM will always be capable of outputting CSV files; overrides are time consuming re upgrades/testing.
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-12T14:48:12.883Z
Answers.Text: Thanks Ramesh.  That's helpful. Could you provide the full path to the file you edited?  And, if you are happy to share it, it would be great to see your custom_export.php file.
Answers.UserDisplayName: William Mortada
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-12T15:16:35.863Z
Answers.Text: CRM/Financial/BAO/ExportFormat/  you will find CSV.php and IIF.php - so you can do the changes in CSV.php file
Answers.UserDisplayName: Ramesh - ARTECH Consultancy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-12T15:20:37.320Z
Answers.Text: look for function generateExportQuery() has the full SQL and makeCSV($export) is used for exporting
Answers.UserDisplayName: Ramesh - ARTECH Consultancy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-12T15:29:42.497Z
Answers.Text: please drop a mail to ramesh@millertech.co.uk I am happy to discuss more and also to share the code - thanks
Answers.UserDisplayName: Ramesh - ARTECH Consultancy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-16T06:14:35.247Z
Answers.Text: Can this make it in to some documentation or blog or somewhere?
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-17T08:22:57.497Z
Answers.Text: Sure I will do  - I will try to release an extension if possible
Answers.UserDisplayName: Ramesh - ARTECH Consultancy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-12T14:32:37.290Z
Answers.LastActivityDate: 2016-05-12T14:32:37.290Z
Answers.UserDisplayName: Ramesh - ARTECH Consultancy
Body: <p>I am aware that you can export financial data from CiviCRM as an IIF or CSV file.  Can this data be imported into Sage accounts software?</p>
  
  <p>Does anyone have any experience of this?</p>
  
Tags: <export><financial-accounts>
Title: Can you import financial data into Sage accounts?
ThreadText: # Can you import financial data into Sage accounts?
  
  (Asked by: username_0 on 2016-05-05)
  
  I am aware that you can export financial data from CiviCRM as an IIF or CSV file. Can this data be imported into Sage accounts software?
  
  Does anyone have any experience of this?
  
  **Tags:** export, financial-accounts
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2016-05-12. Score: 3 | Accepted answer
  
  Yes we can import data directly to sage but using custom format
  
  I did take a copy of CSV.php file and created a custom\_export.php and then did the changes
  
  But you can also directly change CSV.php file and do the required changes - In most case sage file will need only minimum fields like which can do by altering the SQL
  
  **Type - Account Ref - Nominal - Reference - Date - Transaction - Net - Vat - Tax code**
  
  If you need more details please let me know - I guess this helps!!!
  
  > **Comments:**
  > **username_1**: Reason why we use scripts to change CSVs outside of CiviCRM is b/c we trust CiviCRM will always be capable of outputting CSV files; overrides are time consuming re upgrades/testing.  
  > **username_0**: Thanks username_2.  That's helpful. Could you provide the full path to the file you edited?  And, if you are happy to share it, it would be great to see your custom_export.php file.  
  > **username_2**: CRM/Financial/BAO/ExportFormat/  you will find CSV.php and IIF.php - so you can do the changes in CSV.php file  
  > **username_2**: look for function generateExportQuery() has the full SQL and makeCSV($export) is used for exporting  
  > **username_2**: please drop a mail to username_2@millertech.co.uk I am happy to discuss more and also to share the code - thanks  
  > **username_3**: Can this make it in to some documentation or blog or somewhere?  
  > **username_2**: Sure I will do  - I will try to release an extension if possible  
  
  ---
  
  ### Answer by username_1 on 2016-05-10. Score: 2
  
  Looks like you'd export from CiviCRM into CSV and then wrap your data in `<tags>` like e.g. `<SalInvoice>` and `</SalInvoice>`. Also needs to add a line of vendor info, see:
  
  <https://partners.sagenorthamerica.com/irj/go/km/docs/sageKM/Simply%20Accounting%20by%20Sage/Assets/dev-import.pdf>
  
  Once you get one working by manually inserting tags and vendor info to CSV data
  from your CiviCRM then you can script it.
  
  > **Comments:**
  > **username_0**: Thanks Karin.  Do you have any experience of doing this yourself?  
  > **username_1**: Not for Sage specifically - no. But other than QuickBooks - using some CSV format - yes.  
  
  ---
  
  