SmartsIntegrator Support and Discussion Forums

That looks good and works at this end. I think we have some kind of issue relating to updating of DLLs, which would explain why the extra trace didn’t appear and you are still getting this problem. This is probably because I forgot to ask you to stop and restart the servers, and also SmartsIntegratorDal.dll needs to go in the GAC. I think the easiest fix for this is for you to uninstall SmartsIntegrator and then reinstall it from http://www.smartsintegrator.com/download.aspx, if you are happy to do so. You won’t lose any data in this process.

Alternatively, if you’d rather fix things up manually, please update the attached DLLs in your installation folder. You will also need to update SmartsIntegratorDAL.dll in the GAC, by dragging it into C:\Windows\Assembly or executing GACUTIL.EXE /i SmartsIntegratorDAL.dll (GACUTIL.EXE is in the .Net Framework directory, or just search for it on your machine). And then I’d recommend a reboot or at least stopping and starting all SmartsIntegrator services. [If this GAC stuff makes no sense to you, go for the uninstall and reinstall option instead!]

In this latest build / update, the extra FTP trace is now set up via a registry entry. Please launch regedit.exe, and navigate to HKEY_LOCAL_MACHINE/Software/SmartsIntegrator. Right click in the right hand pane, and select New String Value. Name the string value FTPLogFile2, and set its’ value to be the full path to a file on your machine, to which the SmartsIntegrator service running your FTP receive port has write access. This will contain the extra FTP trace.

Once our builds are synchronized, I believe the Database problem will go away, and the extra trace will help us nail the FTP issue.

Thanks,

Ben.

Hi again P

I’ve just tested this, and it seems to work fine.

If the properties you are reading to are called FROM, SUBJECT and BODY, and you have a database table called emailDetail containing columns MessageId, EmailFrom, EmailSubject, EmailBody, you should be able to write the following Update SQL :

INSERT INTO emailDetail (MessageId, EmailFrom, EmailSubject, EmailBody) VALUES (‘%MessageID%’,’%FROM%’,’%SUBJECT%’,’%BODY%’)

Note the single quote marks to delimit the token content as a SQL string. Note also that this is best done with the SmartsIntegratorDAL.dll I just sent to you (or the latest download), which contains improved error handling if something is wrong. The latest download also contains improved help.

Let me know how you get on – otherwise if you can send me a database backup or outline the database structure I’ll be happy to set the port up for you and mail you over the export data.

Thanks,

Ben.

Hi,

I am working on another prototype to extract the data from an Email into a database. I am able to configure the receive port however I am getting the following error while extracting the “from”, “subject” and the “body” fields.

“MessagingException, Error in Send Port Message Processing for Send Port 'SQLRouting' : --> Incorrect syntax near 'd926a'.”

Also find attached the Configuration of the Send port.

Do you have an example configuration to achieve the same? Let me know.

Thanks and regards,

P