×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

import external notes from Excel/Access onto NX drawing sheet

import external notes from Excel/Access onto NX drawing sheet

import external notes from Excel/Access onto NX drawing sheet

(OP)
i am trying to import external notes from excel or Access and show them on drawing

NX provide tabular notes which looks like a table and another option which is general notes,

for a beginner, which one is more easier to handdle in terms of programming?

thank you

RE: import external notes from Excel/Access onto NX drawing sheet

Creating either general notes or tabular notes is possible.
However, as of NX 8.5, the API coverage for general notes is more robust. For this reason, general notes may be easier to manage.

Now if you are running 64 bit NX and need to connect to a 32 bit Access database, that may run you into some trouble...

www.nxjournaling.com

RE: import external notes from Excel/Access onto NX drawing sheet

(OP)
Hi Cowski,

Hmmm, sound tricky but what kind of trouble i may have so that i can prepare now at least..
will this trouble go away if i run 64-bit office ?

RE: import external notes from Excel/Access onto NX drawing sheet

godpaul,
what version of NX are you on ?

RE: import external notes from Excel/Access onto NX drawing sheet

Quote:

Now if you are running 64 bit NX and need to connect to a 32 bit Access database, that may run you into some trouble...

Office ships with a driver that allows other programs to communicate with Access databases; 64 bit applications cannot use the 32 bit driver. MS offers a 64 bit driver for free on their website which will allow 64 bit applications communicate with 32 or 64 bit databases, but the catch is - you can't install it alongside 32 bit office. Running 64 bit office and converting the database to 64 bit could solve the problem, but the trouble there is NX does not yet officially support 64 bit office (at least as of NX 9). So there is a bit of a catch 22 if you are currently running 64 bit NX...

www.nxjournaling.com

RE: import external notes from Excel/Access onto NX drawing sheet

(OP)
thanks you, i am running NX 8.5.3.3

well, before cowski pointed out this issue, i never realize it, the reason is i think:
at the time i write program in Visual Studio, i just import Access Object Library, and i can start to do some code....like this:

Dim DB As DAO.Database
Dim rec As DAO.Recordset
Dim wrkspc As DAO.Workspace

Set wrkspc = Access.DBEngine(0)
Set DB = wrkspc.OpenDatabase(AccessLoc.Value, False, True)


Now, i realize this is not enough, because the code i write in VS will be copied pasteed into Journal and run AND may be i will try to make it an EXE application at the very end. BUT,.....as you point out, i cannot imagine how difficult it will be

so far i am still in the proof of concept stage, the access database, more ore less, is just simple table containing text and data, NOTHING fancy...

I dont know how you people import data from which software? Excel? SQL? or something else?


================================
in terms of the notes on drawing, well, notes are spreaded out everywhere...... the only way i can think of is to give each notes a initial name so that it can match with the name in database, then, if matched, data can be imported....

cowski , as you saw befrore, i used AppendedText to identify dimension and that identification can match with the text name in CSV file so that tolerance number can be imported to the correct place....

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources