Accessing Large amounts of data contained in a spread sheet dynamically from within Notes.
Hi
We have a internal product request system in Lotus Notes. At the moment the only way we have of looking up products is to post a spread sheet (obtained from another old system) in a Notes Document and provide a link in the application form to the spread sheet doc. This requires the user to follow the link then launch the spreadsheets and then type thier product number to get the product details which then have to be copied back into the original document.
This is quite a tedious process and obviosly not ideal. I'm looking for a way to somehow automatically lookup the details when the produuct number is entered. Either somehow geting the data from the spread sheet into Notes in an easy manner on a rountine basis (There is a lot data though!) or providing a lookup to the spread sheet (which can be updated easily enough).
Any ideas?
Cheers
Ian
Ps I've been generous with the points! ;-)
We have a internal product request system in Lotus Notes. At the moment the only way we have of looking up products is to post a spread sheet (obtained from another old system) in a Notes Document and provide a link in the application form to the spread sheet doc. This requires the user to follow the link then launch the spreadsheets and then type thier product number to get the product details which then have to be copied back into the original document.
This is quite a tedious process and obviosly not ideal. I'm looking for a way to somehow automatically lookup the details when the produuct number is entered. Either somehow geting the data from the spread sheet into Notes in an easy manner on a rountine basis (There is a lot data though!) or providing a lookup to the spread sheet (which can be updated easily enough).
Any ideas?
Cheers
Ian
Ps I've been generous with the points! ;-)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This imports data from Excel into Lotus Notes, skipping blank lines and column headers. This will only import 100 records at a time and can be changed by changing the written value.
Use Notes FX method...
I have given similar soln in this forum , let me find you the link
~Hemanth
I have given similar soln in this forum , let me find you the link
~Hemanth
ASKER
Thanks for that, I'd had a look and it's another option..
FX is more easy to implement and maintain.. Absolutely no coding.. And is handled native to the software
You might also consider having Notes automatically access the legacy system, instead of using a SS as intermediary.
But we need to know the structure of Excel how ur maintaing and for which fields it should be updated.