0

Link Project Database with Inventory

Hello,

Please can anyone tell me if there is a way to connect a project db to an inventory db? I would like to expand the functionality of our system to include the inventory template module, but need to be able to link it to projects within our already established projects db.

Many thanks, Anna

5 replies

null
    • CISOFT_Sarl
    • 3 yrs ago
    • Reported - view

    hi,

    with API ...

    • Anna_Wenlock
    • 3 yrs ago
    • Reported - view

    Hi Robert,

    Thanks...do you mean that I need to use the API and an external facilitator to achieve this? I was hoping that because both db's are within ninox, there would be a way to simply link them.

    Many thanks, Anna

    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    If you use the cloud version, you could export your data to .CSV file and import into the other.

    If you use app version you can even export and import in .ninox format.

    To link data there must be an key field that's equal in both datasets.

    See https://ninox.com/en/manual/import-and-export/importing-linked-data

    Steven

    • Anna_Wenlock
    • 3 yrs ago
    • Reported - view

    Right, I understand now. Thanks!

    • CISOFT_Sarl
    • 3 yrs ago
    • Reported - view

    Hi, yes with the imports csv it's ok, but with a strong job, everytime change you need reimport and you need select the good field and the format (number, date, text) and after this its synchornized. 

    My way, a database for example Customer this the main database, and all over databases requeste the data in the main and in the second database for example inventory you synchronise the table customer. In this way, tomorrow add a database invoice and the next day quote, and ..... and all database are the same model for customer.

    But if have not understand the question, sorry. Have a nice day. Robert

Content aside

  • 3 yrs agoLast active
  • 5Replies
  • 770Views