Register  ::  Login
 
Update : February 07, 2012
Google AdSense Minimize
  
Welcome to Asbuilt-DBA forum ! Minimize

Here you can find a community of professionals who work with INtools® (SPI) and want to interact and exchange information, including problems encountered, offer solutions, and raise new topics.

This forum is composed of two main sections:
1.      Discussions, which is an open discussion forum where you can talk about any related topic to INtools.
2.      FAQ section that offers a variety of questions and answers regarding INtools.
We hope that you will enjoy participating in this forum. Participation in the forum is free of charge.
If you want to start a new forum, please contact the Webmaster.
Add to Google
INtools is trademark of Intergraph corporation
Forum Groups Minimize
SearchForum Home
  Aggregated  FAQ  Loop Drawing  loop drawing na...
 loop drawing name
 
 7/16/2007 10:37:05 AM
User is offlineMarco_IA
2 posts


loop drawing name

Hello.

I'm currently involved in a large project using INTOOLS 6. We are releasing our loop drawings (up to 8000-10000). We find very time consuming to change every loop drawing name (the default is for example LD SUA100) to our desired value.

Is there any solution to import values from an external source (a dbf table for example, or excel file) and update them in a single import?

Thanks,

Marco

 7/17/2007 3:47:36 AM
User is offlineadmin
177 posts
5th


Re: loop drawing name

Hi,

 

The simple way is to run the following process.

1.Connect yo the domain schema.

2.Run the following sql and save the results as excel file:

   select L.loop_id,L.loop_name,LD.dwg_id,d.dwg_name from loop     L,loop_drawing LD,Drawing D where L.loop_id = LD.loop_id and    LD.dwg_id = D.dwg_id and d.dwg_type_id = 2;

3. add in the excel file a new colum and add the new drawing name for each row.

4. run the following command you can generat from the excel file commands per dwg id and new dwg_name:

Alter table drawing disable all triggers;

Update drawing set dwg_name = < 'NEW Dwg_name'> where dwg_id = <Dwg_ID>;

.

.

.

Alter table drawing enable all triggers;

 

Regards

 

Ilan Hills


Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com
 7/19/2007 10:22:17 AM
User is offlineMarco_IA
2 posts


Re: loop drawing name

Hi,

Thanks very much for the info. I'll try to ask to get this completed as we don't have access to the database directly. I tought the prefix LD was in some way configurable. (maybe in a config file)

Marco

 7/31/2007 9:57:09 AM
User is offlineadmin
177 posts
5th


Re: loop drawing name

Hi,

 

Sorry about the answer delay I was on the roads.

You can’t configure the prefix through the INI file.

In version 7 you can add naming convention for the loop drawing.

 

Regards

 

Ilan


Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com
 10/26/2007 8:08:41 AM
User is offlinefba_sen57
73 posts
www.shell.com


Re: loop drawing name

Or like below:

Alter table drawing disable all triggers;

Update drawing set dwg_name = < 'NEW Dwg_name'> where dwg_id IN (all the Dwg_ID with comma for each dwg_id >;

eg Update drawing set dwg_name = 'your new drawing name' where dwg_id in (1234, 4567, 7890 etc); 

Alter table drawing enable all triggers;

  Aggregated  FAQ  Loop Drawing  loop drawing na...
Intools
 Search   Forum Home     

Search Engine Optimization and SEO Tools
My Google Pagerank