Skip to main content

Importing Data

There are different types of data which can be imported to AVIX. Often it is related to parts used for the process description or in work instructions.

It is also possible to import a task or a process step sequence from Excel. This is useful if some data is already present in Excel.

And instead of manually entering parts/tools, they can be imported directly into AVIX .
In AVIX there’s a built-in wizard to import parts and tools from an Excel document (.xls/.xlsx).

This is how it works:

  1. Click menu File → Import
  2. Select Excel file import and click next.

    ImportExcelDialog1.png

  3.  Select the Excel document
  4.  Select what to import and click next.

     

    image-1647280969661.png

  5. Select the sheet from Excel document that contains the data
  6. Map the fields containing data
  7. Click next to see a preview or click finish.

    image-1647281109819.png

    The way of importing process steps/tasks/time is the same as for parts and tools. Use the menu
    File → Import → Excel File Import

    Follow the wizard and map the data in AviX to the columns in Excel.
    Done!

    image-1647281182129.png

Following are the properties for all import types that can be imported via Excel:

image-1647281227518.png  image-1647281225000.png

image-1647281241306.png  image-1647281248028.png

image-1647281260593.png

When importing parts/tools images linked can also be imported. This is done by adding the source of the image, e.g. c:\images\hammer.jpg. Multiple images can be imported by separating the link using a semi-colon (;) e.g. c:\images\hammer1.jpg;c:\images\hammer2.jpg

image-1647281285008.png

 

 

 

Back to top