nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Pulldata from external csv not working

GISCQG

Hi All,

I have recently started using external csv for choices and the pulldara function. Everything had been working fine until I added a few more choices two days ago, and now the pulldata function is not working. I have checked for special characters, names, in the media folder, etc, and I'm not sure what I have done wrong. Preview in Connect works but doesn't in the field app. Please see external xls form attached and screenshot of pulldata calculation.

Thanks

fauna.xlsx

pulldata.JPG

Encontre mais publicações marcadas com

Accepted answers

Anonymous User

Hi @GISCQG,

Having a quick look at your CSV in a text editor, I can see two problems.

1. There appears to be an extra blank column at the end of the first 4 columns. This can be seen by the comma on the end of the lines.

2. There is an extra blank line at the end of the file (line 47).

I would suggest to remove this extra blank column and extra blank line, and try updating your survey.

It is always good practice to open your CSV files in a text editor (not Excel) to ensure they look correct as a plain CSV file. Sometimes Excel will add additional blank spaces, rows, columns that are not needed, and cause issues with the CSV parsing routines we use.

Regards,

Phil.

All comments

GISCQG

Hi Phil,

Thanks so much; that was the issue! I will start checking my CSV files in a text editor now. It didn't even cross my mind.

Thanks!

Anonymous User

Hi @GISCQG,

Having a quick look at your CSV in a text editor, I can see two problems.

1. There appears to be an extra blank column at the end of the first 4 columns. This can be seen by the comma on the end of the lines.

2. There is an extra blank line at the end of the file (line 47).

I would suggest to remove this extra blank column and extra blank line, and try updating your survey.

Regards,

Phil.

GISCQG

Hi Phil,

The pulldata function is not working in the field app. Field app version is 3.14.237 and Connect version is 3.7.62.

Please see attached csv.

Thanks

fauna.csv

Anonymous User

Hi @GISCQG,

Is the pulldata function not working in the field app or the web app? Can you please provide which version of Connect you published the survey with and also which version of field app you are using, or if the web app, which version is it version locked at?

Also, can you provide the actual CSV files you are using for the pulldata, as these will hold the key information to why they are not loading.

Regards,

Phil.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.