Fine line import

Last modified at July 19th, 2023

Overview

This document will outline the Fine Line Import feature,which will allow users to import, and remove fine lines quickly and efficiently.

 

Procedure

The Inventory Fine Line Import can be found by navigating to Software Settings → Inventory → Fine Lines.

 

Graphical user interface, application, Word

Description automatically generated

Fig. 1

 

If security allows, click the Import button.  A file dialog will appear.  Select the import file.  If the import completes, it will display import statistics.

 

Graphical user interface, text, application

Description automatically generated

Fig. 2

 

Further details can be found in the system log.

Graphical user interface, text, application

Description automatically generated

Fig. 3

 

Import File Format

 

The file format required for importing Fine Lines is as follows:

Graphical user interface, application, table, Excel

Description automatically generated

Fig. 4

 

Worksheet Name: FineLine

 

Columns:

Column Name

Mandatory

Valid Values

Description

Yes

Alphanumeric up to 40 characters

Remove

No

Remove, Blank

 

If the Remove column is set to Remove then the import will attempt to remove the fine line from the database as long as it is not inuse.  If it is in use or linked to records, then it will not remove it.

 

Security

There is a security feature within the Software settings list (in User Settings) which will determine which users will be able to import fine lines.  It is under Software Settings → Inventory Fine Lines → Import.

 

Table

Description automatically generated

Fig. 5

 

https://static.helpjuice.com/helpjuice_production/uploads/upload/image/6119/direct/1689788075275-Fine%2BLine%2Btemplate.xlsx

Was this article helpful?