What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Import Data App: Matrix field with input textboxes incorrectly imports when value has "comma" on them

    Asked by adatshalom on July 22, 2015 at 06:02 PM

    I think I have a workaround for my own use (will search and replace commas with semicolons in my Excel file). However, this is slightly unsatisfactory. Commas are not special characters in XML, so I don't know if you have some other value that I could use that would actually display as a comma or to distinguish a text comma from a row comma for import purposes.

    app import data Import Data app comma
  • Profile Image
    JotForm Support

    Answered by jonathan on July 22, 2015 at 07:15 PM

    Hi,

    If I understand correctly, you are saying that the current delimiter used by Import Data App (which is comma sign) is not working on your import process?

    I understand that when you export the form data that have a Matrix table field on it, the resulting data for the Matrix field is also delimited by comma sign.

    So what happens now, when you try to import the previously exported data using the Import Data Apps, is it will breakdown the Matrix data into multiple field data because of the comma delimiter.

    Please confirm if this what happens in your case. 

    If it is not, please clarify so we can check on it further.

     

    Thank you.

     

  • Profile Image

    Answered by adatshalom on July 22, 2015 at 10:35 PM

    That is correct.

    Thus, original data:

    Column 1 Row 1 Entry             Column 2 Row 1 Entry
    Column 1 Row 2 Entry             Column 2 Row 2, Entry

    translates through 

    Column 1 Row 1 Entry|Column 2 Row 1 Entry,Column 1 Row 2 Entry|Column 2 Row 2, Entry

    to become

    Column 1 Row 1 Entry             Column 2 Row 1 Entry
    Column 1 Row 2 Entry             Column 2 Row 2
    Entry

     

  • Profile Image
    JotForm Support

    Answered by EltonCris on July 23, 2015 at 06:48 AM

    @adatshalom 

    If I understand you correctly, it is the matrix values that contains comma right?

    Example: 

    Now you want to escape the comma separated values during the import for matrix tables? If yes, you can try replacing the commas with the following special HTML character for comma. This might help.

    ,

    So on your example, it will become:

    Column 1 Row 2 Entry             Column 2 Row 2, Entry

    This looks fine on my test, hopefully it does the same thing on your end.

    Hope this helps!

  • Profile Image

    Answered by adatshalom on July 23, 2015 at 09:08 AM

    That works for the first two pieces--separating into the matrix properly and displaying in the grid view, but when you edit the submission, you still see , instead of a comma, which I suspect will be disconcerting to our members.

  • Profile Image
    JotForm Support

    Answered by Charlie on July 23, 2015 at 01:04 PM

    It seems like our developers have updated the Import Data App, but it looks like they are still making some test, I see the bug ticket here is still unresolved: http://www.jotform.com/answers/615408.

    The Import Data App now shows the template for the Matrix field:

     

    However, it looks like the comma separates the value on a new row instead. So for input fields that have commas in it, it will import it incorrectly.

    I'll forward this to our developers to have it checked.

    Apologies for the inconvenience.

  • Profile Image

    Answered by adatshalom on July 27, 2015 at 11:56 AM

    Fantastic! Thanks for your efforts; works like a charm.

  • Profile Image
    JotForm Support

    Answered by Charlie on July 27, 2015 at 12:55 PM

    You're most welcome. We're glad to be of a help.

    If you needed any assistance again, please do not hesitate to open a new thread here in the forum.

    Thank you.