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:

  • our data retrieval logic is read-only: your Dear Systems data will not be modified in any way by Lokad; in the future, if Lokad were to add write capabilities for Dear Systems, we will make it very explicit whenever you are about to change anything within Dear Systems.
  • your company remains the sole owner of your data; by default, we treat this data as if an NDA was in place between your company and Lokad; if you want an actual NDA to be signed, just drop us a message.

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 3 (DearSystems_SaleOrderLines.tsv, DearSystems_Sales.tsv, DearSystems_SaleOrders.tsv). See later for more details about the tables fields.

Additional information can be found in Dear Systems’s support page

DearSystems_AttributeSets.tsv

DearSystems_BOMProducts.tsv

DearSystems_BOMServices.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_Sales.tsv.

DearSystems_SaleOrders.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