Support » Plugin: Forminator - Contact Form, Payment Form & Custom Form Builder » Ungültiger Zeichenwert für Konvertierungsangabe

  • Resolved freejan56

    (@freejan56)


    Hi there,
    the e-mail thats been send by forminator cannot be read by Arclab Inbox2DB. It tells me: Ungültiger Zeichenwert für Konvertierungsangabe and it is something formated wrong to transfer data from the mail to the excel-sheet. How can I fix it. I am not very skilled with wordpress, neither forminator, programming. I am more a simple user. If you need some more information I will do the best to give you the correct answer and data. I have been searching in google, wordpress.org but i could not find anything near to my problem.
    Thx for helping me out.
    Jan

    The page I need help with: [log in to see the link]

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @freejan56

    Sorry to hear you are having this issue.

    Could you please export your form and we can take a closer look?

    https://wpmudev.com/docs/wpmu-dev-plugins/forminator/#import-export

    You can upload the file on Google drive and share the link.

    Best Regards
    Patrick Freitsa

    Thread Starter freejan56

    (@freejan56)

    Hi Patrick,

    thx for answering so soon. That does not happen all the time 😉
    Hereis the link from the form-export:
    https://drive.google.com/file/d/1zrZuLOnpi-ee5kYOVkDhgWvhQ1HwGZXF/view?usp=sharing
    Could the problem be that I have no additional Mail-Server installed in WordPress?
    egards
    jan

    Plugin Support Adam – WPMU DEV Support

    (@wpmudev-support8)

    Hi @freejan56

    Thank you for sharing the form!

    The form itself seems fine but I think one/some of the fields might need slight adjustments to make sure that they are passed over and have proper format. Let me explain.

    I wasn’t familiar with Arclab Inbox2DB so I checked it and, as far as I understand, it works in such a way that you give it access to your inbox and it reads selected e-mails from it (in this case Forminator notifications), then it is parsing content of such e-mail in order to extract selected data from it and put it into the database of choice.

    It’s using Microsoft ODBC database driver and the error that you are getting (the “Ungültiger Zeichenwert…” one) is coming from that DB driver.

    According to this article (assuming that Google Translate translated error message correctly; unfortunately I don’t speak German), it’s related to date format:

    An empty string is not a valid date/time literal and it does not represent a NULL value. An attempt to convert an empty string to a date/time value will result in SQLState 22018 error and the message “Invalid character value for cast specification”.

    In other words, the error suggests that the date the DB driver gets is either empty or uses incorrect format.

    In the Inno2DB app you should be able to check logs. Is this error the only one that it shows or does it give some more details by any chance? Specifically, does it show the data that this error is related to or, at least, the DB field name?

    Could you check it please?

    Also, are you able to share content (just make sure to mask sensitive data such as e-mail address, full name, phone number from it) of some example e-mail that Inbox2DB wasn’t able to process (that gave this error)?

    Basically, we need to find out about that data (most likely date) that results in error and that, hopefully, will help make adjustments to either Forminator field settings or its e-mail notification configuration.

    Best regards,
    Adam

    Thread Starter freejan56

    (@freejan56)

    Hi Adam,
    thx for such a explanatory answer. Your german is most probably better than my english, but as long as we get along, it is OK. I guess you are right. The problen is the date.
    With freetourhamburg.com (another of our sites) I had the error:
    Error: Detected unknown or invalid string identifier: FIELD.
    Datum/Date/Fecha
    17-06-2021
    and here you will find the mail
    https://drive.google.com/file/d/1xxFfQ1070GzjUZJqv9uplrmKVYdR7U1R/view?usp=sharing
    I guess it does not like those “minus”
    I will see if I can change that.
    regards
    jan

    Thread Starter freejan56

    (@freejan56)

    Hi again,

    actually there are 2 date format possible german dd.mm.yyyy or english mm/dd/yyyy.
    Is there any way to change it in forminator?
    Thx
    Jan

    Thread Starter freejan56

    (@freejan56)

    2 date format in inbox2DB

    Thread Starter freejan56

    (@freejan56)

    Hi Adam,

    I discovered that I can export automatically all submissions as an excel-sheet and I will arrange my issue with it. It is a lot easier. Thx for your help
    regards
    Jan

    Plugin Support Adam – WPMU DEV Support

    (@wpmudev-support8)

    Hi @freejan56

    Yes, you can export them like that indeed! I should have mentioned that but I assumed that the Inbox2DB is used for some very specific reason so I skipped it, sorry about that!

    Anyway, I’m glad to know that you found solution!

    Have a great day,
    Adam

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Ungültiger Zeichenwert für Konvertierungsangabe’ is closed to new replies.