import external notes from Excel/Access onto NX drawing sheet

[godpaul]

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

 

[cowski]

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

 

[godpaul]

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 ?

 

[jerry1423]

godpaul,
what version of NX are you on ?

 

[cowski]

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

 

[godpaul]

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....