.NET

Reply
*Expert Elite*
Hallex
Posts: 1,569
Registered: ‎10-08-2008
Message 11 of 16 (389 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: 188
Registered: ‎03-21-2012
Message 12 of 16 (373 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 (366 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: 188
Registered: ‎03-21-2012
Message 14 of 16 (360 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: 188
Registered: ‎03-21-2012
Message 15 of 16 (334 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 (324 Views)

Re: Data Extraction Using .Net

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

Good to hear,

Cheers :smileyhappy:

 

~'J'~

_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!