Dear Systems

The data from Dear Systems can be imported in just a few clicks into Lokad thanks to a native integration that leverages the Dear Systems API (see Dear Systems Integrations). In this page, we detail how to make the most of this native Dear Systems integration.

Setup of the Lokad/Dear Systems data connector

The suggested process to connect your Lokad and Dear Systems accounts is the following:

The last step will redirect you to your Lokad account, where the project DearSystems data source will have been created.

Two remarks:

Annex: Tables reference

Lokad retrieves extensive data from Dear Systems which include:

All data are aggregated per product and per warehouse. They are pushed to your Lokad account into the following files:

On Lokad’s side, the information about purchase orders has to be extracted from 2 files (DearSystems_PurchaseOrderLines, DearSystems_Purchases), that about sales orders from 4 (DearSystems_SaleOrderLines.tsv, DearSystems_SaleItems.tsv, DearSystems_Sales.tsv, DearSystems_SaleOrders.tsv). See later for more details about the tables fields.

Additional information can be found at the Dear Systems’s support page.

DearSystems_AdvancedPurchase.tsv

DearSystems_AdvancedPurchasePutAway.tsv

DearSystems_AdvancedPurchaseStocks.tsv

DearSystems_AttributeSets.tsv

DearSystems_BOMProducts.tsv

DearSystems_BOMServices.tsv

DearSystems_Customers.tsv

DearSystems_FinishedGood.tsv

DearSystems_ProductAvailabilities.tsv

DearSystems_ProductCategories.tsv

DearSystems_ProductFamilies.tsv

DearSystems_ProductFamilyAttachments.tsv

DearSystems_ProductFamilyLines.tsv

DearSystems_ProductMovements.tsv

DearSystems_Products.tsv

DearSystems_ProductSuppliers.tsv

DearSystems_PurchaseOrderAdditionalCharges.tsv

DearSystems_PurchaseOrderLines.tsv

This is the basic table about purchase orders. Additional information can be imported from DearSystems_Purchases.tsv

DearSystems_PurchaseOrders.tsv

DearSystems_Purchases.tsv

DearSystems_PurchaseStocks.tsv

DearSystems_SaleOrderAdditionalCharges.tsv

DearSystems_SaleOrderLines.tsv

This is the basic table about sale orders. Additional information can be imported from DearSystems_SaleOrders.tsv and DearSystems_SaleItems.tsv.

DearSystems_SaleOrders.tsv

DearSystems_SaleItems.tsv

DearSystems_Sales.tsv

DearSystems_StockAdjustmentExisting.tsv

DearSystems_StockAdjustmentNew.tsv

DearSystems_StockAdjustments.tsv

DearSystems_StockAdjustmentTransaction.tsv

DearSystems_StockTakeExisting.tsv

DearSystems_StockTakeNew.tsv

DearSystems_StockTakes.tsv

DearSystems_StockTakeTransaction.tsv

DearSystems_StockTransferLines.tsv

DearSystems_StockTransfers.tsv

DearSystems_SupplierAddresses.tsv

DearSystems_SupplierContacts.tsv

DearSystems_Suppliers.tsv

DearSystems_UnitsOfMeasure.tsv