I have text files as attachments to emails in Notes Database and I would like to get the information from the attachment and store it in Sql database.Could any one suggest the best possible way to accomplish this?
Subject: Notes Database to Sql
What sort of information do you have in the text file attachments? Are they records that need to be imported? Or do you have to do some funky parsing to extract the data that you need? Or do you want to send the entire attachment into a BLOB field?
Subject: RE: Notes Database to Sql
Thanks a lot for replying Cesar…I have set of data in the text file
It goes like this
// Name: Tom
// Age:22
// Location:Sydney
etc…
Subject: RE: Notes Database to Sql
Apart from Thomas’s advice, it would seem that your task is relatively simple. You will need to detach the files one by one, and then read them back in via LotusScript. While reading them, you can parse them based on the prefix (search between "// " and “:”) to retrieve the actual field name in your SQL table. You can either create the records directly from the files as you read them or you may want to store the data into some sort of internal structure to generate an SQL command file. Some of this will depend on how many records you must process, and if you need to do any integrity/uniqueness checking before uploading.
The Enterprise Integration forum will get you started on how to connect to the SQL data.
Subject: RE: Notes Database to Sql
Hi Cesar,Thanks for the response.Iam a begginer in Lotus notes and dont have any idea about the SQL connection.Can you provide me any sample if possible…
Subject: Notes Database to Sql
See also the Enterprise Integration forum. The posters there will as a rule be the most up-to-speed on this topic.