CSV Output has Epoch Date Value

Permanently deleted user

February 13, 2017 21:20

I'm generating an .csv output for a client, and it generates, but the output contains the rest service's epoch date. Also, I can't find a way to create an alias name for the column names in the output.

 

Is there any way to control how the output is generated with new alias names?

 

Walter

 

 

0

• 

  Nico Burgerhart

  February 13, 2017 22:25

  If you use a workflow, on the DataTable To CSV activity there is a setting to use the alias names.

   

  But you can also just loop through the datatable fields and change the column names.

   

  See the sample workflow here where I modify the column names in the datatable by changing the field name into the alias name.

   

  https://support.geocortex.com/essentialsGSCForum?sub-nav=forum&main-nav=essentials&#!/feedtype=SINGLE_QUESTION_DETAIL&criteria=ALLQUESTIONS&id=9066000000008XEAAY

   

    Use Column Aliases Use column aliases of the DataTable in place of column names, where applicable. Changing the date display is more challenging I think but it should here also be possible to modify the datatable (e.g. adding a new field and "recalculate" the dates.)

   

   

   

  0
• 

  Permanently deleted user

  February 14, 2017 15:33

  Nico,

   

  Thank you so much. That worked perfectly. 

   

  Really appreciate your help Nico....!!

   

  Walter

  0

Please sign in to leave a comment.