Error using pulldata or dynamic data attachment error CSV column heading "

[sheldon.lucas]

Hi all,

When I try to use a form with the pulldata function I get the error CSV column heading ", when I preview or run the form. I have uploaded the form and csv to kf.kobotoolbox.org as a trouble shooting step and it works find there, so I think its my install.

Any ideas?

[Kal_Lam]

Welcome to the community, @sheldon.lucas! Woudl you mind sharing the CSV file with the community so that the community should be able to help you scan and see if your CSV should have any issues that is causing this error message to pop up.

[sheldon.lucas]

payslip.csv (71 Bytes)
Here is the file.

[Kal_Lam]

Maybe this should be the problem here:

Try making it as shown in the image below:

This should solve your issue!

[sheldon.lucas]

Sorry same issue.
When I tried to use the Dynamic Data Attachments approach I get the same error as well.

[Kal_Lam]

@sheldon.lucas

Sorry same issue.
When I tried to use the Dynamic Data Attachments approach, I get the same error as well.

Could you provide more details on this? Dynamic Data Attachement and pulldata functions are something different where the: the former pulls the information from a deployed survey project while the latter pulls the information through a CSV file.

[sheldon.lucas]

Sure.
I have installed KoBoToolbox on my own server.

I have a list, which I provided as csv, that I will use in a form to lookup data.
I first tried to use the pulldata function and then got the error I described.
I then tried to use the Dynamic Data Attachment support as that was a better fit, since we could add to the list via Kobo forms.
I also got the error using that functionality as well.

When I tried the pulldata function approach on kf.kobotoolbox.org and it worked, I figured something was wrong with my installation.

[Kal_Lam]

@sheldon.lucas

When I tried the pulldata function approach on kf.kobotoolbox.org and it worked, I figured something was wrong with my installation.

[Kal_Lam]

@sheldon.lucas, maybe if you wish to learn more about the dynamic data attachment, you could go through our support article:

New Support Article: Dynamic Data Attachments [Case Management]

This should also be possible @mike.destaubin! We will also keep this in mind when updating our article.

[sheldon.lucas]

The issue I have is that the pulldata nor dynamic work on my own installation, that is what I need help with.

[Kal_Lam]

So you mean it works smoothly in a publicly hosted server (KoboToolbox server) but not in your self-hosted server? If this is the case, maybe you will need to recheck your configuration.

[sheldon.lucas]

Yes thats correct. So where can I get guidance on where to check.? Once I dont have either of those features forms work as expected.

[javib94]

Did you solve this issue? Have you tried to put an image in the form? I think this problem is related to the fact that media files can’t be used in Kobo on Your own server installation. If someone knows how to fix it, please share with us.

[javib94]

This has to do with media files, maybe you can try this:

@javib94

Hi, months later, I found the solution in another forum. We have to change the “ip filtering” enketo configuration, the file is in ~/kobo-env/enketo_express/config.json.

Notice that when the server is in a private datacenter, usually the public IP is not directly associated with the machine, so thats why we have to change the allowPrivateIPAddress property to true.

 "ip filtering": {
        "allowIPAddressList": [],
        "allowMetaIPAddress": false,
        "allowPrivateIPAddress": true,
        "denyAddressList": []
    },

[addiserp]

thanks, i changed it and works “allowPrivateIPAddress”: true,

[Shadi]

Hi Friends,

I didn’t see the “” ip filtering" on our enketo files (config.json).
So what we can do .

Regards

[javib94]

If you mean that the “ip filtering” is not in the file, you can add it.

Anyway, you can change the file and restart the ee container. You can make the change even if it is still running.