Excel download: Exporting Denormalized Data

  • AlineRamosEcb
    Asked on November 8, 2019 at 5: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?

  • jherwin
    Replied on November 9, 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.

  • AlineRamosEcb
    Replied on November 11, 2019 at 5: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:
    ...
  • jherwin
    Replied on November 11, 2019 at 6: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.

  • AlineRamosEcb
    Replied on November 11, 2019 at 6: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:
    ...
  • AlineRamosEcb
    Replied on November 11, 2019 at 6:50 PM
    OK. tente agora.
    https://drive.google.com/open?id=1lrSY3u5ldiDMMoqdTJTchZ5f2cvnHpZh
    Em seg., 11 de nov. de 2019 às 20:14, JotForm
    escreveu:
    ...
  • jherwin
    Replied on November 11, 2019 at 7: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.

  • AlineRamosEcb
    Replied on November 11, 2019 at 7: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:
    ...
  • Girish JotForm Support
    Replied on November 11, 2019 at 9: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!

  • AlineRamosEcb
    Replied on November 22, 2019 at 2:50 PM
    Ok, estamos no aguardo.
    Em seg., 11 de nov. de 2019 às 23:55, JotForm
    escreveu:
    ...
  • John Support Team Lead
    Replied on November 22, 2019 at 7:09 PM

    As checked, there aren't any updates yet for this feature request ticket. 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.

    If there's any news, we'll sure let you know on this thread as soon as it's available.