Cannot find what you need? - Click here to contact us

Close




Import and export to Quickbooks, Sage, SAP etc with the Desktop version

Importing and Exporting to Other External Applications from Desktop Schedule it


Schedule it can import from and export to other programs such as Sage, Quickbooks, SAP, and many others via CSV files. You can fully customise the data and location of all the data in the reports and templates (CSV exports) so you can create many different exports for many programs.

The first step is to understand the data your program needs to import. Most software suppliers will give you CSV samples you can use and experiment with. You must first manually create a CSV file with Notepad, or from an Excel sheet, that you can use to successfully import some simple data into your chosen application. Once you have a proven CSV file and can import data into your chosen application send us the file so we can create a report that matches it. You can also create your own report/export files. For more details on creating custom reports please see this FAQ.

Different programs required data and column orders that are specific to their application. We may have some sample reports already for some external applications so please ask us first although each customer needs can be different.


Below are some useful links to help you create the initial CSV file so we can then work together to create a custom report to match your needs.


Sage


To Import your customers from Sage you can use this Sage customer report or create your own report files to make a CSV export.

With the supplied report...

1, Download the report and save it with your Sage reports
2, In Sage view your customer list and choose Reports, pick the saved report
3, In the report preview choose Export to 'Plain Text - OEM Files', and save the exported data
4, In Schedule it choose from the Data menu, 'Import Events/Resources from CSV'
5, In the file browser choose 'File Of Type' 'All Files', pick your exported txt file and press Open

...all the customers exported from Sage will now be imported into Schedule it.

Other website with details on creating CSV files for exporting and importing with Sage.

  • http://opentuition.com/...

  • https://support.sage.co.uk/...

  • https://support.sage.co.uk/...

  • http://help.sageone.com/...



    QuickBooks



  • http://support.quickbooks.intuit.com/...



    (import, export, transfer, sage, sap, quickbooks, quick books)
  • Last updated, 3 January 2014, 21:28




    Leave a reply (Login required)




    Schedule it Ltd
    /faq/10307/import-and-export-to-quickbooks-sage-sap-etc-with-the-desktop-version

    Subscribe to our newsletter and receive our free scheduling tips and articles to help you improve the planning in your business. Unsubscribe anytime.

    GET STARTED RESOURCES
    Login Support and Help
    Register Blog
    Features Privacy Policy
    Online Pricing Terms and Conditions
    On-Prem Pricing Industry Sectors
    Latest Version Reviews and Feedback
    Live Webinar Status
    APPS POPULAR SEARCHES
    Web App Team Scheduling
    iOS App Employee Planning
    Android App Customer Scheduling
    Zapier App Engineer Scheduling


    Start Your Free Trial Today



    Copyright © 2003-2022 Schedule it Ltd. All rights reserved.
    Schedule it on LinkedIn   Schedule it on Twitter   Schedule it on YouTube   Schedule it on Facebook
    Join Us - Live Webinar
    ...
     
    Help Topics
    Contact Us