How do I 'see' the data structure in an .nsf file?
Hi,
I've recently been given the task of moving a project forward that consists of turning 15 pages of forms into one summary sheet form. (There are even more projects after this)
The problem I'm having is that no one is sure of how the data in the database is logically structured, where the linkages are, and which forms or sub-forms the data is being pulled from.
I have printed the data dictionary, but this is really not a big help, it doesn't list any of these properties.
The database is quite big with over 77,000 pages of information (about 552MB).
What I need to do is get a map of the structure and linkages of the data.
I have downloaded an article on the archtechture of notes to try and help me (I haven't had time to read it yet tho..)
I am open to converting the notes database to something else to to see the structure, I know this kind of map is available in MS access, but I am not sure how to do this either..
Any help would be appreciated..
I've recently been given the task of moving a project forward that consists of turning 15 pages of forms into one summary sheet form. (There are even more projects after this)
The problem I'm having is that no one is sure of how the data in the database is logically structured, where the linkages are, and which forms or sub-forms the data is being pulled from.
I have printed the data dictionary, but this is really not a big help, it doesn't list any of these properties.
The database is quite big with over 77,000 pages of information (about 552MB).
What I need to do is get a map of the structure and linkages of the data.
I have downloaded an article on the archtechture of notes to try and help me (I haven't had time to read it yet tho..)
I am open to converting the notes database to something else to to see the structure, I know this kind of map is available in MS access, but I am not sure how to do this either..
Any help would be appreciated..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
RAPUTA,
>
Is that an advert? :)
>
Is that an advert? :)
well, yes it is, qwaletee. I sponsor mainly you and sjef_bosman ;)
I forgot the email on my profile, so I think they cannot contact me, anyway :(
BTW, is it worth the email in the profile? should'nt exist in EE a feature for posting comments to profiles, where the member is the page editor? (sorry georgehullcentre, I didn't mean to use your question space for me, qwaletee began it :)
I forgot the email on my profile, so I think they cannot contact me, anyway :(
BTW, is it worth the email in the profile? should'nt exist in EE a feature for posting comments to profiles, where the member is the page editor? (sorry georgehullcentre, I didn't mean to use your question space for me, qwaletee began it :)
> ....having her open the database....
Funny you sometimes picture people.... how wrong can one be?
Why not add some more info about yourself on your profile.
PS:
Posted mail addresses will be removed (PE/Mods) for your own protection as sniffers may use it to spam you. If you want to provide your e-mail address, your profile is the place to do so. Do modify it in such way that sniffers will not easily recognize it.
Commercial activities (like ads) are not allowed.
Funny you sometimes picture people.... how wrong can one be?
Why not add some more info about yourself on your profile.
PS:
Posted mail addresses will be removed (PE/Mods) for your own protection as sniffers may use it to spam you. If you want to provide your e-mail address, your profile is the place to do so. Do modify it in such way that sniffers will not easily recognize it.
Commercial activities (like ads) are not allowed.
You left out Alexey. His answer i equally on point and different than the rest, maybe even more detailed.
It's easier to split 500pt 4 ways too! ;-))
Look, I started this answer with a list of things you should do for trying and grasp the structure of any notes database, but there are too many details to take into account, so I gave up. Follow sjef_bosman's suggestion and find a friendly and experienced Notes developer, having her open the database in Designer and tell you what she sees ;-)