User Guide
1. Streamline Client
2.Streamline Server
3. Starting Up
4. Connecting data
5. Demand and Sales Forecasting
6. Inventory Planning
7. Reference
Sidebar
dear-connection-guide
Book Creator
Add this page to your book
Add this page to your book Book Creator
Remove this page from your book
Remove this page from your book 
Manage book (
Help Table of Contents
4.5.2. How to Import Data from DEAR
In this article we describe:
- imported data, and
Integration Limitations
Currently, Streamline does not import the on-hand history of products from DEAR. This limitation makes Streamline unable to:
- calculate inventory turn-over,
- compute the number of days in the period you had run out of inventory (Stockout days), and
- automatically determine whether lost sales are caused by a stock-out or zero demand.
Imported data
Data imported into Streamline is described in the Inventory Management Systems article.
Data Import Workflow
Streamline uses DEAR API to import the data. To authorize Streamline, DEAR requires providing an Account ID and Application key. Below we describe how to get these credentials.
Generating Account ID and Appication Key
1. Go to the API integration page (see figure below).
2. Click the Plus button and enter a name for the new application (see figure below).
3. Click the Create button. After that, DEAR generates credentials for the new application (see figure below).
Creating a New Streamline Project
To create a new Streamline project based on DEAR data:
1. Go to the menu File > New > DEAR connection. The DEAR connection window appears (see figure below).
2. Fill in the Account ID and Key fields with the generated credentials.
3. Enter or choose the date to start the import from in the Starting date control.
To get accurate forecasts, we recommend providing Streamline with at least 24 months of sales history.
4. Click OK to start the import.
Import Options
dear-connection-guide.txt · Last modified: 2021/10/27 10:19 by admin
