Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

If you have multiple entries to import and batch together, this can be done through a template.

  1. In the admin module expand Data Piping menu.

  2. Expand the Data Import menu.

  3. Click on Expense

  4. On top navigation bar, click on Action → Import From File

  5. In the pop up window, click on Download Template

  6. Locate where the file downloaded (this will be different based on your browser settings)

  7. Fill out the fields that are marked as required but also the fields you will need for your configuration. A good way to find out what columns are needed for your configuration is enter in a manual entry and see what fields are required to be populated to save the record.

  8. Once you have filled in all the fields and records, make sure to delete row 2 (the explanation of each field) before you import the file into DATABASICS.

  9. On top navigation bar, click on Action → Import From File

  10. Click Browse… to locate the completed template.

  11. Select the file and then Open.

  12. Click on Continue

  13. A pop up window with any confirmation, errors, or warnings will appear. Review the messages and click on the X to close the window.

  14. To review the new entries, use the “Load Status” filter and select “New” then “Apply” at the bottom.

  15. Select each record to review the data. If you need to update the record, you can click on “Update” at the bottom.

  • No labels