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

CSV Export to Follow Table Structure

James_Shreeve

Hi,

I've got an EB page which contains a couple of tables with various dates on it, I have it set up to export to CSV as this is used by our management. Obviously CSV files export the raw data but I was wondering if there would be any way to export the data as shown in the table, which is formatted in a more friendly way for users. I can deal with removing the Global ID and Object ID, its more the date formatting.

CSV export

EB table view

Many thanks,

James

Najděte více příspěvků označených jako

ArcGIS Online

Status: Otevřít

Komentáře

James_Shreeve

Hi @VenkataKondepati

I do apply formatting where it is possible. Tables direct from EB don't allow for advanced formatting as far as i'm aware.

Below is an example of advanced formatting I've done but I still get the raw data rather than the formatted version when I export to CSV.

Thanks!

dougbrowning

Also looking for a way to get the field name vs the alias as we can no longer use the CSV since it has spaces in the column names.

https://community.esri.com/t5/arcgis-experience-builder-ideas/table-widget-export-to-csv-is-using-the-field/idi-p/1619062

VenkataKondepati

Hi @James_Shreeve,
Not directly, the CSV export always pulls raw attribute values. To get user-friendly formatting (like readable dates), you’ll need to apply formatting before export. You can do this either by:

Adding Arcade expressions in the table widget to format dates (e.g., Text($datename, 'MM/DD/YYYY')) and exporting that field, or

Using a custom download widget or Experience Builder Developer Edition to handle client-side formatting before writing the CSV.

So, by default, no but with a small Arcade or custom export tweak, you can make it work as shown in the table.

Regards,
Venkat

Připojte se k diskusi

Přihlaste se pro psaní příspěvků, sledování obsahu a další. Jste tu noví? Zaregistrujte se zdarma.