FANDOM


Pre-requisiteEdit

This Wiki assumes that you have already installed NGL WorkBench. To Download and install NGL Work Bench  Click here

We strongly recommend you to download the latest version of NGL WorkBench. The above documentation link provides the link to the latest version of NGL WorkBench

Opening the functionality?Edit

Step 1: Run NGL WorkBenchEdit

Go to C:\NGLWorkBench and double click on RunNGLWorkBench.bat

8
This will open a Login screen






Step 2: Login to NGL WorkBenchEdit

10
Enter Login Id and Password. You must use the Login id and Password that is used to login into NGL Carbon (Librarian Interface)







Step 3: Go to Utilities -> Import Catalogue Records-> From CSV FileEdit

11

This will open the Catalogue record import utility









Import ScreenEdit

12












Preparing the CSV file containing catalogue recordsEdit

Setting the column names in your CSV fileEdit

18

Click on show column names to be used button.









19

The system will display the valid column names to used as heading. The first and foremost row of your CSV file must contain the mentioned column names.











See the example below

20
21







Other file formatsEdit

If you have files like XLS, XLSX, tab seperated values (TSV files), ODS (OpenOffice Spreadsheet format); make sure that you save it as comma seperated values file with the above preperation

Importing the dataEdit

Step 1: Select the prepeared CSV fileEdit

22

Click on the ...(File browse) button to select the above prepared CSV File









23

Select the file and click on the Open Button









24

The system will display a preview of the first 100 records. Please note that all the columns will not be displayed.









Step 2: Apply settingsEdit

24

Default delimiter: If you have multiple accession number/barcodes for a title you can delimit multiple accesssion numbers/barcodes using semicolon(;). If you are using any other delimiter you can replace semicolon (:) with that character

Accession number range: In the accession number column if you have mentioned a range, for example 1-30, it means that 1,2,3....,28,29,30 belong the same title. Then make sure that this check box is selected. If any prefix is being used, for example: S1-S30, here the prefix is "S". Then mention the prefix. Please note that this utility take minus (-) as the range specification character.

If you are not using any range in your Accession number column you must uncheck this check box. System will also perform dupe check before it inserts every catalogue record. This means that if you have 10 rows with the same Title, Author, ISBN, Publisher but with different accession numbers/barcodes; system will create only one catalogue record with 10 holding records.

Log File Location: Here you can specify the log location. The utility will write result of the import process to this log file

Date format: In field like "DATE OF ACCESSIONING", you can mention the date format used


Step 3: Click on the Import Button to initiate importEdit

25

This process will import all the records and show the process below. You will finally see a message "Task Successful" once all the records are imported








Step 4: Final Step. IndexingEdit

26

The NGL Indexer is available on the NGL Server. Make sure that NGL Server (Apache Tomcat) is running.

Now double click on RunIndex.bat (Present in C:/Indexer)




You can now search your catalogue to see the imported records

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.