Product(s):		OpenUtilities CONNECT
	Version(s):		23.00.01.XX - through
	Environment:		N/A
	Area:		Component Management
	Subarea:		Parts Database Management

Background:

This article will help users to configure and use of multiple URL Links are usually stored in Parts Database and Prior to OpenUtilities Substation 2023 U1 was only restricted to 1 URL link.

Note: For Parts Database and Project Database stored in SQL Server will need SQL Server Management Studio along with db.owner access to SQL Database.

Steps to Follow

A. Changing the Data Type of Parts Database.

1. Parts Database stored in MDB file
2. Parts Database Stored in SQL

B. Changing the Length of URL column in Project Database 's dbo.PartNUmber table.

 

A. Changing the Data Type of Parts Database. 

Parts Database stored in MDB file 

The below steps need to be followed if the Part Database data is stored in a MDB file.

1. Locate the Parts Database MDB based on environment is its Local / Network / ProjectWise. Use the details in the below screen shot to get the location and Name of the MDB file and the Table Name.




2. Now browse to the location and open it with Microsoft Access.


3. Right Click on the Table used to store Part Number >> Click "Design View".

 

4. Select URL field name and change the Data Type to "Long Text" >> Save.

 

Parts Database Stored in SQL

1. Launch SQL Server Management Studio, connect to SQL Server where Parts Database is stored.

2. Browse to Database that stores Parts Database >> Right Click >> select Task >> Generate Scripts.

3. In Generate Script dialog click Next >> click "select specific database objects" >> Tables >> select table where part number are stored >> Next.




4. Click Advanced >> select Type of data to script to "Schema and data" >> OK.




5. Check "Open in new query windows" >> Next >> Next >> Finish.




6. Now in the in the query window which is open locate the "URL" column and then change the length from "255" to "MAX".




7. Browse to the Table that has the part numbers by Right Click on table >> Rename. Rename the table to change the name for example "dbo.parts_database_old" as per below screen shot.

8. Now go back to the query that was created and modified in step 6 >> Execute.





B. Changing the Length of URL column in Project Database 's dbo.PartNUmber table. 

1. Launch SQL Server Management Studio, connect to SQL Server where Project Database for OpenUtilities Substation is stored is stored.




2. Browse to Database that stores Project Database >> Right Click >> select Task >> Generate Scripts.




3. In Generate Script dialog click Next >> click "select specific database objects" >> Tables >> select table dbo.PartNumber>> Next.




4. Click Advanced >> select Type of data to script to "Schema and data" >> OK.




5. Check "Open in new query windows" >> Next >> Next >> Finish.



6. Now in the in the query window which is open locate the "URL" column and then change the length from "255" to "MAX".




7. Browse to the Table dbo.PartNumber by Right Click on table >> Rename. Rename the table to change the name for example "dbo.PartNumber_old" as per below screen shot.




8. Expand dbo.PartNumber >> Keys >> right click on "PK_Partnumber" >> Rename it for example "PK_Partnumber_old.




9. Now go back to the query that was created and modified in step 6 >> Execute.

Original Author:

Satish Saptasagar