hello, i have a database in which I am adding a field in a form.For the values of that field i want to fetch the data from other databse which is on other server.
I am taking the values according to condition like in both databse forms there is one same field . First I am fetching the values in flat file from the databse which is on other server. Now taking values from flat file for our database by matching our creteria.
Is this possible in anyway to fetch the data from external flat file?
It seems you have two different questions. You want to fetch data from another Notes database based on a key value in the current document – this can be done with @DbLookup function in a computed field. You can either store the value you look up, or not (“Computed for display”). If you store the value, it’s available for use in views, but it doesn’t automatically update when the source data changes.
But then it seems you are also asking about reading data from an “external flat file”. It’s not clear where this is coming from. You can read data from a file, using LotusScript, and add this into a field, assuming the user has access to the file. There are also various integration tools, such as DCRs and DECS, which let you do the integration on the server side. If you say more about what you’re trying to do, someone may be able to give a more detailed answer.
Thanks Andre…wel i am first fetching data from a different database into a flat file…
then i want to dump that data in my database…actually the problem is for eg:-i am storing information of an employee in a datasbase.Now email ids of that person are stored in some other database. Now i want that email ids shud be copied into my databse. I am creating field in my databse as “Email id” and in that field i want emailid of that person which is in some other databse…now if i am clear plz help me out…
It sounds like your task is somewhat complex, and I don’t think I can help you. You need to work with someone who knows how to do this stuff, and go through your requirements step by step. It may take some time.