Excel download: Exporting Denormalized Data

  • Profile Image
    AlineRamosEcb
    Asked on November 08, 2019 at 05:34 PM

    Olá,


    Gostaria de saber se existe alguma forma de exportar os dados, porém desnormalizados.

    uma junção de Clientes x Produtos. Atualmente os produtos vem em um campo da exportação e isto dificulta nossa gestão de dados. 

    O melhor seria se exportasse em um formado para banco de dados, criando a tabela de clientes e a tabela de produtos.

    Existe esta possibilidade?

  • Profile Image
    jherwin
    Answered on November 09, 2019 at 12:27 AM

    Can you please explain your question in detail?

    Maybe you can show us a screenshot/visual on how you want your data to be exported so we can check/see if we can find a workaround for it?

    Guide: How-to-Post-Screenshots-to-Our-Support-Forum

    Looking forward to your response.

  • Profile Image
    AlineRamosEcb
    Answered on November 11, 2019 at 05:50 PM
    Boa noite,
    Segue em anexo um exemplo do que precisamos para que a exportação feita
    pelo jotform consiga ser lida pelo nosso ERP.
    Obrigada
    Em sáb., 9 de nov. de 2019 às 02:27, JotForm escreveu:
    ...
  • Profile Image
    jherwin
    Answered on November 11, 2019 at 06:14 PM

    Unfortunately, we did not receive the sample document you attached. Please upload it to the dropbox or google drive and then share with us the shareable link so we can see/download it.

    Looking forward to your response.

  • Profile Image
    AlineRamosEcb
    Answered on November 11, 2019 at 06:50 PM
    Favor considerar este arquivo, e desconsiderar o anterior. Obrigada
    Em seg., 11 de nov. de 2019 às 19:38, Aline Ramos <
    compracolaborativa@ecoisabio.com.br> escreveu:
    ...
  • Profile Image
    AlineRamosEcb
    Answered on November 11, 2019 at 06:50 PM
    OK. tente agora.
    https://drive.google.com/open?id=1lrSY3u5ldiDMMoqdTJTchZ5f2cvnHpZh
    Em seg., 11 de nov. de 2019 às 20:14, JotForm
    escreveu:
    ...
  • Profile Image
    jherwin
    Answered on November 11, 2019 at 07:06 PM

    Thanks for providing us the excel file. Upon checking, unfortunately, there is no way to achieve that automatically with Jotform. You still need to download the submission as excel and then edit it on your end.

    If you would like I can submit your feature request to our developer team so that if there is a response on the issue you will be notified here. However, please keep in mind that there's no assurance whether this will be implemented. It will highly depend on the viability of the feature, the number of similar requests we get, along with the workload of our Developers.

    We'll wait for your reply.

  • Profile Image
    AlineRamosEcb
    Answered on November 11, 2019 at 07:50 PM
    Seria ótimo se encaminhasse essa sugestão. Não parece ser tão complicado
    para quem tem acesso ao fonte do sistema. É uma funcionalidade essencial
    para todos seus clientes que desejam exportar um formulário de pedidos para
    o ERP. No nosso caso, o Bling. E ficaria muito agradecido se conseguissem..
    Obrigado pela atenção.
    Em seg., 11 de nov. de 2019 às 21:06, JotForm
    escreveu:
    ...
  • Profile Image
    gerardw
    Answered on November 11, 2019 at 09:55 PM

    I can see that you have taken this example from the form "92365894845676".

    Let me forward this to our developers to check if your requirement can be implemented. We will not be able to provide an ETA, but we will notify you once there is an update.

    Thanks!