topic Re: Update Template tool did not go well in ArcGIS Survey123 Questions

Update Template tool did not go well

DougBrowning — Tue, 27 Dec 2022 20:05:39 GMT

Some of my forms are 3+ years old. I tried the new update template tool today and well it did not go great.

All my drop downs are a mess now. Errors on everything

Any ideas here? thanks

Re: Update Template tool did not go well

ZacharySutherby — Tue, 27 Dec 2022 21:55:36 GMT

Hello @DougBrowning,

What version of openpyxl is being used in the Python environment you have configured with Connect?

Re: Update Template tool did not go well

DougBrowning — Wed, 28 Dec 2022 14:46:47 GMT

Thanks. For now I went old school and did it column by column.

Re: Update Template tool did not go well

ZacharySutherby — Wed, 28 Dec 2022 16:45:58 GMT

Hello @DougBrowning,

Thank you for confirming! There was an openpyxl bug at that version (and prior) that is causing the data validation issue you are seeing. If you update ArcGIS Pro to the latest 3.0.3 version that should update your openpyxl package to 3.0.9 and the issue should be resolved. Alternatively you can clone your default Pro Python environment and update the package directly in the cloned environment.

Re: Update Template tool did not go well

DougBrowning — Wed, 28 Dec 2022 18:46:25 GMT

I can't move to ArcPro 3 yet but thanks for the answer.