Notes Field Exchange (Notes/fx) not working in R6.01 - is there a bug? Have I missed something?
Hi
I have successfully used Field Exchange before in previous versions, but am having real trouble getting it working with R6.01.
Are there known bugs in this version regarding Notes/fx?
Initially, it did work, but now, having made various changes, some of the fields no longer exchange information (Excel <-> Notes). I've now made a simplified mock-up of the system, so I can replicate the problem without affecting the proper system, but in this mock-up UI can't get any of the fields to exchange information!
I have checked the following:
* Form Property 'Disable Field Exchange' not set
* The Named Cell Ranges match exactly the fields with which they should exchange information in Notes
Have I missed anything? I'm sure it worked 'just like that' in R4/R5 - what has changed?
Thanks.
I have successfully used Field Exchange before in previous versions, but am having real trouble getting it working with R6.01.
Are there known bugs in this version regarding Notes/fx?
Initially, it did work, but now, having made various changes, some of the fields no longer exchange information (Excel <-> Notes). I've now made a simplified mock-up of the system, so I can replicate the problem without affecting the proper system, but in this mock-up UI can't get any of the fields to exchange information!
I have checked the following:
* Form Property 'Disable Field Exchange' not set
* The Named Cell Ranges match exactly the fields with which they should exchange information in Notes
Have I missed anything? I'm sure it worked 'just like that' in R4/R5 - what has changed?
Thanks.
Also try opening the ole object by right clicking on it and selecting open if it opens in place then you have to goto form property's launch option and deselect all the check boxes for launch option (both in place and dialog)
Did you try the IDENTICAL form/documen n R5 and R6? That's really the only way to tell if it is an R6 issue or an application issue.
Of course, if you have incorporated R6-only code into the app, this will be harder to do.
One thing I find odd: you say SOME of the fields no longer exchange. hat means... some *D*O* work. That sounds more configuration than platform bug, unless you hit some weird limit, or the working ranges are defined differently.
Of course, if you have incorporated R6-only code into the app, this will be harder to do.
One thing I find odd: you say SOME of the fields no longer exchange. hat means... some *D*O* work. That sounds more configuration than platform bug, unless you hit some weird limit, or the working ranges are defined differently.
ASKER
HemanthaKumar: Thanks for your thoughts. The Launch options for the form are:
Auto-Launch = First OLE Object
Launch Object in PLace = False
Present Modal Dialog = False
Create Object in = Body
Launch When = Editing
Hide When = None
So both your suggested settings are already in place. But I still must be missing something.
Auto-Launch = First OLE Object
Launch Object in PLace = False
Present Modal Dialog = False
Create Object in = Body
Launch When = Editing
Hide When = None
So both your suggested settings are already in place. But I still must be missing something.
ASKER
qwaletee: Thanks for your thoughts.
Yes, in my original application, some of the fields DO still exchange data between Excel & Notes, but I can't find anything different about the ones that don't! I don't think the names are 'special' or reserved (InvoiceOrganisationName, InvoiceTelNo).
In my mock-up system, I simply can't get ANY of the fields to exchange data, even though the various settings are the same as in the original application! I have set up this mock-up so I can play with the various settings, without affecting the proper application (even though I've already stopped it working!).
My head's hurting now, hope to stop banging it against the wall real soon!
Yes, in my original application, some of the fields DO still exchange data between Excel & Notes, but I can't find anything different about the ones that don't! I don't think the names are 'special' or reserved (InvoiceOrganisationName, InvoiceTelNo).
In my mock-up system, I simply can't get ANY of the fields to exchange data, even though the various settings are the same as in the original application! I have set up this mock-up so I can play with the various settings, without affecting the proper application (even though I've already stopped it working!).
My head's hurting now, hope to stop banging it against the wall real soon!
IN the existing application, if using R5, all fields work, but using R6, only some fields do? And R6 is the only thing that is different (i.e., same document, same database file, not a replica, same version f Excel installed)?
ASKER
qwaletee: No, sorry, that's not the case. I have successfully implemented Notes/fx before using Excel, but I have not tried under R5 using this application. Unfortunately, it won't be very practical to try either, as I only have R5 access through a client of mine, & not the client whose system it is. I might see if I can find an R5 CD though, as it would be very interesting to see if it does work under R5.
<Watch this space>
<Watch this space>
Paul when you double click on the ole object does it open excel app ?
ASKER
When I double-click the embedded Excel file, the file opens in Excel. In this case, it opens in-place, although when initially created, it opens in separately in Excel.
Seems to be a normal behaviour.
So I conclude that it is a bug in R6. Contact Lotus regarding this issue, they might help you in resolving it. Or Download the new version 6.0.2CF1 or try beta version of 6.5 the problem might have been resolved ro might behave differently
So I conclude that it is a bug in R6. Contact Lotus regarding this issue, they might help you in resolving it. Or Download the new version 6.0.2CF1 or try beta version of 6.5 the problem might have been resolved ro might behave differently
ASKER
Aha! I've now tested the two mock-up systems on an R5 client (I didn't need a server), & the result is the same! No field exchange takes place at all.
These mock-ups were made (i) so that I could understand why some of the fields in the real system do work & some don't, but also so I could experiment with having one or two Notes forms (one for new docs with the Excel template, & one for existing docs without the template), but I can't even get the mock-up systems to behave like the real one! At least these ones are consistently not working!
Any other ideas?
These mock-ups were made (i) so that I could understand why some of the fields in the real system do work & some don't, but also so I could experiment with having one or two Notes forms (one for new docs with the Excel template, & one for existing docs without the template), but I can't even get the mock-up systems to behave like the real one! At least these ones are consistently not working!
Any other ideas?
Now to the basics.. Does this fields exist in Excel ?
Or try to exchange reserved fields like Title, Subject, Author, Keywords, Comments, Manager, Company, Category..
If those fields flow on either direction then the problem is that excel is not aware of user def fields.
Or try to exchange reserved fields like Title, Subject, Author, Keywords, Comments, Manager, Company, Category..
If those fields flow on either direction then the problem is that excel is not aware of user def fields.
ASKER
Great minds think alike. I've just created another mock-up database, & have included the LastSavedDate field in the Notes form, & it gets populated! However, none of the custom fields do. And, if I disable Field Exchange on the Notes Form, it stops getting populated! I know this is how it's meant to work, but that in itself is a bonus!
So what else is required to make the user-defined fields to work?
Thanks.
So what else is required to make the user-defined fields to work?
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Brilliant, thanks.
When did you start having to do that? I'm sure I've never done that before, & I remember no mention of that in any of the documentation, although to be fair, I didn't try the Excel documentation, which is where that would have to be.
Well, never mind, all's well that ends well, & thanks for your help!
Paul
When did you start having to do that? I'm sure I've never done that before, & I remember no mention of that in any of the documentation, although to be fair, I didn't try the Excel documentation, which is where that would have to be.
Well, never mind, all's well that ends well, & thanks for your help!
Paul
Yes, In Notes Documentation there is this fine print "see the documentation for the OLE server application". So it is your OLE which should give you most of this details. I assumed that you have already set these things and suddenly it stopped working.. wrong assumption ;-)
It might be a bug, if it worked in earlier release and not in the new release. So let us give a shot.
Check the launch options of the Form (3rd tab) and see if you are launching the ole object in seperate window or in place.
If you are using launch in place, then switch it off and try. It might help.
~Hemanth