email parsing automation

Email Parser

Extract data from emails and automate your workflow

The forum is now read only. Please, go to the the main Email Parser website if you need help.
Post here if you experience problems or get unexpected errors.
Hi, I'm trying to write some email data to an access table via an odbc connection but I get this Error:
ERROR [42000] [Microsoft][Driver ODBC Microsoft Access] Funzione 'CHAR' non definita nell'espressione.
the last part is in Italian and means "The 'CHAR' function is not defined in the expression.

I've tryed with success to write the same data to a MySQL table and to a text file, to me the problem seems to lie with the access table, what could I've made wrong?

Every field in the table is text (255 char) .

Any help would be appreciated.

Full Output of emailparser

Running daily run output
1 value found for the field generico.
1 value found for the field stato.
No coincidences have been found for the field stato2.


Actions will be run with the following fields
Field name Value
Subject xxxxxx.local daily run output
From xxxxxx@xxxxx.it
To root
Body Removing stale files from /var/preserve: Cleaning out old system announcements: Backup passw ...
Body_HTML empty
CC empty
BCC empty
DateTimeSent 11/12/2012 3.01.05
DateTimeReceived 27/12/2012 23.50.09
generico dati 5.44T 4.60T 859G 84% 1.00x ONLINE
stato
stato2 empty



Running DR-populate
Connecting to ODBC Data Source
Running SQL statement
Error. ERROR [42000] [Microsoft][Driver ODBC Microsoft Access] Funzione 'CHAR' non definita nell'espressione..


Running dr-pop-txt
Opening text file C:\Documents and Settings\Administrator\Desktop\dr-pop.txt
Writing on text file
Closing text file


From LogFile
[ 28/12/2012 0.02 ] Processing email 1 of 50
[ 28/12/2012 0.02 ]
[ 28/12/2012 0.02 ] ········ Running filter daily run output
[ 28/12/2012 0.02 ] The email subject contains "daily run output"
[ 28/12/2012 0.02 ] Filter passed
[ 28/12/2012 0.02 ]
[ 28/12/2012 0.02 ] ········ Running filter perse
[ 28/12/2012 0.02 ] Email filter not passed.
[ 28/12/2012 0.02 ]
[ 28/12/2012 0.02 ] ········ Running daily run output
[ 28/12/2012 0.02 ] 1 value found for the field generico.
[ 28/12/2012 0.02 ] 1 value found for the field stato.
[ 28/12/2012 0.02 ] 1 value found for the field stato2.
[ 28/12/2012 0.02 ]
[ 28/12/2012 0.02 ] ········ Actions will be run with the following fields
[ 28/12/2012 0.02 ]
[ 28/12/2012 0.02 ]
[ 28/12/2012 0.02 ] ········ Running DR-populate
[ 28/12/2012 0.02 ] Connecting to ODBC Data Source
[ 28/12/2012 0.02 ] Running SQL statement
[ 28/12/2012 0.02 ] Error. ERROR [42000] [Microsoft][Driver ODBC Microsoft Access] Funzione 'CHAR' non definita nell'espressione..
[ 28/12/2012 0.02 ]
[ 28/12/2012 0.02 ] ········ Running dr-pop-txt
[ 28/12/2012 0.02 ] Opening text file C:\Documents and Settings\Administrator\Desktop\dr-pop.txt
[ 28/12/2012 0.02 ] Writing on text file
[ 28/12/2012 0.02 ] Closing text file
[ 28/12/2012 0.02 ]
Hi,

Could you post the SQL sentence that is causing the error with Access?

Just copy and paste here the SQL sentence in the ODBC action
Just copy and paste here the SQL sentence in the ODBC action

INSERT INTO dr
(Data, Mittente, Generale, Stato1, Stato2)
VALUES ('<%DateTimeSent%>', '<%From%>', '<%generico%>','<%stato%>','<%stato2%>')