topic pulldata() function from CSV, doesn't works in ArcGIS Survey123 Questions

pulldata() function from CSV, doesn't works

Anonymous User — Fri, 15 Oct 2021 14:18:54 GMT

Hi everyone!

We tried to use pulldata function in order to extract information from CSV into a survey, however this function does'nt works.

Survey is too simple, we need some fields has populate when we select a name from a list. That's all.

We try to replicate an example from web and neither doesn't works.

Maybe somebody knows what happen?.

Thanks a lot.

CMT (Technical Monitoring Centre)

Re: pulldata() function from CSV, doesn't works

DeonLengton — Fri, 15 Oct 2021 14:36:04 GMT

You have done everything correctly except that your CSV file has semi-colons (;) instead of commas (,) in.

Replace the ; with , in your file and it will work.

Re: pulldata() function from CSV, doesn't works

AllisonHollier — Fri, 15 Oct 2021 14:36:27 GMT

The problem isn't your syntax, it's your spreadsheet. I believe it has to do with parsed data to columns. Or at least, it worked when I did it. See attached.

Re: pulldata() function from CSV, doesn't works

AllisonHollier — Fri, 15 Oct 2021 14:38:15 GMT

See, and I always avoid commas at all costs. LOL Different workstyles!

Re: pulldata() function from CSV, doesn't works

Anonymous User — Fri, 15 Oct 2021 14:46:48 GMT

Deon, your're absoutely right.

My CSV has semi-colons (;) instead comma (,), I didn't realized that detail. I'm sure that's about regional configuration.

Thanks a lot.

CMT

Re: pulldata() function from CSV, doesn't works

Anonymous User — Fri, 15 Oct 2021 14:50:14 GMT

Allison, thanks for your time.

Your're absoutely right too, I had problems with regional configuration so CSV file was saved incorrectly. I replaced CSV file on the media folder and it works perfectly.

Thanks!

🙂

CMT