Delete Catalogue records

[Gfem]

Hello Experts, i noticed i have duplicate records of some of the records i had imported, due to importation of same items twice, please i'd prefer to empty the catalogue records from the database, how do i go about this please? thank you in anticipation.

[Verus Open Source Support]

Respected Patron,
Greetings from NGL Open Source

Kindly let us know the version downloaded. We will give you detailed steps for the same.

Looking forward to serve you.

NGL Open Source Support Team,
(Service Before Self)
--
Verus Solutions, India.
Web: www.verussolutions.biz
Telephone: [phone]
Yahoo Messenger: [hidden email]
Google Talk: [hidden email]
Skype Id for voice chat: newgenlib.oss
Forums: http://forums.newgenlib.org

On Sunday 25 January 2015 02:23 AM, Gfem [via NGL] wrote:

Hello Experts, i noticed i have duplicate records of some of the records i had imported, due to importation of same items twice, please i'd prefer to empty the catalogue records from the database, how do i go about this please? thank you in anticipation.

---

If you reply to this email, your message will be added to the discussion below:

http://forums.newgenlib.org/Delete-Catalogue-records-tp7575204.html

To start a new topic under NGL, email [hidden email]
To unsubscribe from NGL, click here.
NAML

[Gfem]

I, m sorry for the delay in response... the NGL version is V 3.0

[Verus Open Source Support]

Respected Patron,
Greetings from NGL Open Source

These are the following steps to clean your  database

Step 1: Close all applications.

Step 2: Open PgAdmin3

Step 3: Take a backup of the database newgenlib (By selecting and right clicking on newgenlib database node)

Step 4: Delete/drop database newgenlib (By selecting and right clicking on newgenlib database node)

Step 5: Create a new database with the name newgenlib. Now note that this database will not have any tables in it. Its an empty database.

Now lets create schema necessary for NGL

Step 6: Copy the following files into your C: drive for convenience
a. InstallNGL3.0/scripts/backupinplain.sql
b. InstallNGL3.0/scripts/AddedScripts.sql
c. InstallNGL3.0/upgrade303/V304AddedScripts.sql

Please note that the order of executing the script files is very important here

Step 7:

1. Open Command prompt
2. cd C:/"Program files"/Postgresql/8.3/bin (You need get into the bin directory)
3. psql -d newgenlib -U postgres (psql is a tool. You are connecting to newgenlib database using user postgres). You will be prompted for password.
4. \i C:/backupinplain.sql
5. \i C:/AddedScripts.sql
6. \i C:/V304AddedScripts.sql


Step 8: Start NGL Server

Step 9: Run NGL Indexer


Looking forward to serve you.

NGL Open Source Support Team,
(Service Before Self)
--
Verus Solutions, India.
Web: www.verussolutions.biz
Telephone: [phone]
Yahoo Messenger: [hidden email]
Google Talk: [hidden email]
Skype Id for voice chat: newgenlib.oss
Forums: http://forums.newgenlib.org

On Monday 02 February 2015 07:42 PM, Gfem [via NGL] wrote:

I, m sorry for the delay in response... the NGL version is V 3.0

---

If you reply to this email, your message will be added to the discussion below:

http://forums.newgenlib.org/Delete-Catalogue-records-tp7575204p7575224.html

To start a new topic under NGL, email [hidden email]
To unsubscribe from NGL, click here.
NAML