JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Import Data app: Bulk excel import to form results in empty submissions for EU account.Asked by EpycEpyc on October 28, 2016 at 06:43 AM
I'm trying to add submissions via http://import.jotform.io/.
ALL my submissions via .XLS (of CSV) are empty.
I've created an Excel based on the suggested template:
Submissions excel import to form in
May I know what file type you are importing? Please note that CSV and XLS are different file types here with different template.
I tested the app and use the xls template for the xls file, and I was able to successfully import data. Here's what I did:
1. First, I created a new spreadsheet and saved it as Book1.xlsx. You can see below that I used the xls template format.
2. Here how I imported mine:
3. The data was successfully imported in my account:
In general, the app is working as expected. Could you please try again? Make sure you are using the sample template for the specific file type. To learn more about the Import Data app, you can check this guide: https://www.jotform.com/help/308-Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm
I hope this helps.
I appreciate all the information screens, but this is the exact process I do...
Template excel, save as .XLS (and not .XLSX), import the file, the webpage says it's 'ok' 1submission created.
But still NO CONTENT in my list...
I'm using a free account, is this possible the problem?
No, no matter if you're using a free account you still have access to all the integrations, widgets and apps that JotForm offers.
I have now also tested cloning your form and importing submissions on my end and I can see it works fine, here are some screenshots:
Here is the link to the Excel file that I imported: https://shots.jotform.com/kevin/Content/Files/974377/Import.xls
However, I have tested in a non-EU account and I can see you're using an EU account, I have now tested with an EU account and I can replicate the issue, I can see this happens only when you've transferred your data to our EU data center, this is why I could not replicate the issue when testing with my non-EU account.
I will forward this thread to our second level so our developers will investigate the issue and resolve it, we will let you know as soon as we get updates regarding this thread.
Do you have already an update regarding this issue?
Can I maybe change my account so this can work? For a client whom I am working for, this is high priority!
Thanks for the extra effort!
We are really sorry for the inconvenience. I have tried accessing your submissions again but the problem is still there. I have followed this up with our developer. You should get update when this is fixed.
Hi, any news or ETA on the solution.
Our client will start using these forms this week, and so an import is really necessary. Funny enough, that's why we advised them your tool..
We will offcourse subscribe for a paid version of the tool, but I'm waiting untill this solution comes through. Please give us an update on this.
Bram - Epyc
Unfortunately we still don't have an update on this issue. We cannot provide an ETA on when this issue will be resolved, however, I assure you that the resolution of this issue is very important to us. We will keep you updated on this thread once the issue has been fixed.
Thank you for your patience.
since patience is not one of my strong points (..) I'd like to inform if you guys made any progress on this. Client is really breathing down our neck, so we're kind of stuck between a rock and a hard place :(
We are sorry for the inconvenience you have.
I have asked for the progress from our software developer who is assigned to this thread. Hopefully, you are going to be informed via this thread.
Thank you for your understanding.
Forgive me for pushing, but no news on this?
Eventhough I didn't plan to, I've upgraded our plan to paying subscription, because our client couldn't wait any longer. So you understand we're having mixed feelings - paying for something that isn't delevering everything yet..
I understand. I see that the issue is marked as very important. Once we have any update in this regard you'll be posted here.
Since the issue seems to be with the EU accounts, you may import the file to your forms by moving your account to US servers temporarily by unchecking the Europe Datacenter in the account settings.
Once you are done with importing the data, if you want you may move the forms back to EU servers.
Let us know if you need any further assistance. We will be happy to assist.
Thanks for your reply. If I change my datasettings to US, I get this warning:
I'm not sure what it means, so my question: will my existing 4 forms keep their original URL? Since our client has communicated these URL's already, we can UNDER NO CIRCUMSTANCE use other URLs.
It looks like that you replied to the email attaching the screenshot. Unfortunately, the images attached to the email cannot be posted on the forum thread. Please access this forum thread using the URL https://www.jotform.com/answers/974377 and attach the screenshot.
As I tested with my test account, there shouldn't be any issue in accessing the form using the same URL after moving to US servers. Since the movement is temporary, you can switch back to EU servers once the import is completed.
Hope this information helps!