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; } } }

Experience Builder (Excel Export Date Formatting Issue)

JacobBlankenship1

I am exporting a CSV from a table in Experience builder (through action widget) and the date format comes out as 3/22/2023 in the CSV. However the correct time format should be 3/22/2023, 5:37 PM. In Experience Builder it shows the correct information but gets truncated in the CSV export for some reason.

Not sure if there is a setting I am missing or what.

I am using Enterprise Experience Builder Developer edition.

Thanks

Find more posts tagged with

Accepted answers

All comments

Raquel

Hello @Jianxia!
This also happens when text fields contain commas, meaning the data from a table cannot be correctly converted to Excel because the CSV cannot be properly formatted.
Could you please add a download option or a widget similar to the Table to Excel geoprocessing tool in ArcGIS Pro? This way, there are no issues with line breaks or commas.
Thank you!

Thanks!

MarlboroughDistrict_Council

I've just come across this as well. Clearly its not been fixed yet! Any update on a fix ESRI?

SolanaFoo2

Any updates on fixing this bug? Thanks

JianxiaSong

@JacobBlankenship1, it turns out a known issue. We will investigate it. Although the issue below is for the Query widget, it applies to any export to CSV actions.

BUG-000153124 In ArcGIS Experience Builder, the export as CSV option for the Query widget does not generate the full date and time

JacobBlankenship1

@Jianxia Do you know of anyone that might be able to answer this question?

JacobBlankenship1

More information:

Experience builder Table View

When I export it as a JSON format the GPS time will be exported in Unix Epoch Time and than can be converted to a readable data format.

However, I need it to be in a csv format for the user to use.

JacobBlankenship1

@jcarlson Looked at it in notepad and it still came out in the same format of 3/23/2023

jcarlson

Can you check the contents of the CSV in its raw text? Open it with Notepad or something similar, and verify how the date values are being saved. I've noticed that Excel applies default formatting to imported CSVs sometimes that I don't want.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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