Discussions

 View Only
  • 1.  Import Excel data into multiple tables

    Posted 03-19-2019 16:03
    Suppose I'have the following Excel file:

    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1781768/RackMultipart20190319-62935-5s38gp-Table_inline.png?1553011190">

    How can I import this information into multiple tables (Projects, Employees, Membership)? I did take a look at the documentation
    here, here as well as this question. However, from my understanding this would be better suited for an initial import of data so that the database is set for further use on the database itself.

    It is important to note that, per business requirements, this is not a one-off operation as the Excel file must be continually imported to reflect changes. Any ideas would be greatly appreciated as the real file contains 55+ columns and doing things by hand would be time-consuming.




  • 2.  RE: Import Excel data into multiple tables

    Posted 03-20-2019 00:44
    It sounds like you want to run three separate csv imports to bring records into the three tables.  If yes, have you thought about importing CSVs using the sync tool?  Check out this article if you need more info: https://quandarycg.zendesk.com/hc/en-us/articles/360021085412 (only updates hourly)

    You could also setup table-to-table imports and schedule the import using Google Scripts. This could update more frequently than csv sync.  

    There are some other ways to go about this, but those are good low-code options.  Let me know if you're interested in more detail.  Thanks.


    Jake Rattner | Solutions Architect
    (847) 927-1427 | jrattner@quandarycg.com
    Quandary Knowledge Base