basic import update
play

Basic Import & Update Mike Konovalske & Jason Swain - PowerPoint PPT Presentation

Basic Import & Update Mike Konovalske & Jason Swain Technical Team, Lucity General Tab Data Source Tab Data Source Connection Mapping Tab Formulas Correlations Tab Example #1 Contractor Data From csv to Lucity In this example a


  1. Basic Import & Update Mike Konovalske & Jason Swain Technical Team, Lucity

  2. General Tab

  3. Data Source Tab

  4. Data Source Connection

  5. Mapping Tab

  6. Formulas

  7. Correlations Tab

  8. Example #1 Contractor Data From csv to Lucity • In this example a contractor created data in an excel document and then needs to push it into Lucity • Adding new records only • One time import • In the example we are using a csv file, but we could import from multiple text formats as well as databases.

  9. Example #2 WO Asset Record to Inventory • Hydrant information on a work order asset record needs to be pushed to the Hydrant record • Updating existing records, not adding anything • Inspections are happening continuously so the import will need to be run on a schedule every 2 hours • We can use our own Lucity databases as the source data in order to push data from one area of Lucity into another automatically.

Recommend


More recommend