.NET

Reply
*Expert Elite*
Hallex
Posts: 1,569
Registered: ‎10-08-2008
Message 11 of 16 (354 Views)

Re: Data Extraction Using .Net

06-20-2012 08:07 AM in reply to: santoshr0114

Let me know after what I need to change in there

 

~'J'~

_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Mentor
santoshr0114
Posts: 161
Registered: ‎03-21-2012
Message 12 of 16 (338 Views)

Re: Data Extraction Using .Net

06-20-2012 10:29 PM in reply to: santoshr0114

Hallex,

 

I tried your code but everytime it asks for users selection. I can work more on your code and get it done my way.

 

I have figured out one more method where i can get all the text/string available in Entire Autocad Drawing, and also i am able to send it to excel file using OLEDB. I have done it in VB.Net. I will change the code to C# once i finish my task.

 

But the problem is:

  1. It is taking lot of time to finish the execution and sometimes it is also entering into inifinte loop.
  2. I am unable to link one text to another.(E.g: JOB NO is AP-0298 & PART-MARK is 09-401) Check the screenshot of the excel file.
  3. The text/string we are getting in excel is jumbled up and due to hidden text in drawing there are lot of empty rows in excel.

The solution i thought for linking the text with one another is.

Getting the Position (Co-ordinates) of the title (JOB NO) and assuming that X axis is same, we will give a specific range of Y co-ordinates that if a text/string exists in this range grab the text. and store it in an array/list.

 

Then we will have all the Heading/Title in one array and the values in one array. This is the idea for the Right Bottom table(Title Block)

 

For the Left bottom table(BOM). Search for the string Mark and increment only the Y Co-ordinate range and grab all the text untill the range gets bigger(As the last row and the first row height is big) And the same logic for other columns.

 

 

I have this idea but i am not sure how to do it.....

 

Regards
Santosh
*Expert Elite*
Hallex
Posts: 1,569
Registered: ‎10-08-2008
Message 13 of 16 (331 Views)

Re: Data Extraction Using .Net

06-20-2012 11:54 PM in reply to: santoshr0114

It is very scrupulous operation because all of the texts

 have a different coordinates of Y in the row, so I can't do the correct sorting

of these texts according this Y value, sorry, it is impossible to me

 

~'J'~

_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Mentor
santoshr0114
Posts: 161
Registered: ‎03-21-2012
Message 14 of 16 (325 Views)

Re: Data Extraction Using .Net

06-21-2012 12:23 AM in reply to: Hallex

Hi Hallex,

 

Thank You for your reply.

 

I am really interested in doing this, as this is quite challenging. Is there any possible approach.

 

You can give me some hints, as this is my first try in autocad customization.

 

 

 

Regards
Santosh
Mentor
santoshr0114
Posts: 161
Registered: ‎03-21-2012
Message 15 of 16 (299 Views)

Re: Data Extraction Using .Net

06-22-2012 05:24 AM in reply to: santoshr0114

Hi Hallex,

 

I have sucessfully copleted the task with a help of very senior person who has experience on Autocad customisation.

 

It was vary challenging.

 

Thank You for your time and responses

 

 

Regards
Santosh
*Expert Elite*
Hallex
Posts: 1,569
Registered: ‎10-08-2008
Message 16 of 16 (289 Views)

Re: Data Extraction Using .Net

06-22-2012 07:36 AM in reply to: santoshr0114

Good to hear,

Cheers :smileyhappy:

 

~'J'~

_____________________________________
C6309D9E0751D165D0934D0621DFF27919

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community