mingo-app / mingo

Found a bug? have a FR ?
59 stars 3 forks source link

[FR] int types in exported csv format #601

Closed emehmet closed 7 months ago

emehmet commented 1 year ago

Hi,

I try to export data as csv format. This is working great. But I need to export int data in csv. Because when I use import to another software lik Heidisql, it doesn't import it expectedly. All datas export as string.

Can you add customizable types like parseInt(data) or new Date(date)?

tothradoslav commented 9 months ago

Do you mean in this form?

Screenshot 2023-09-20 at 21 30 39

if so, you can enter almost any JS code in the Columns textarea and even use lodash, dayjs, etc. Each row is evaluated separately, so for example, you want to export "createdAt" as a date, use:

new Date(doc.createdAt)

Please let me know if this is what you meant.

tothradoslav commented 8 months ago

Done, We added an option "Only wrap strings" with the value wrapper.

tothradoslav commented 7 months ago

Hi, this has been released in the latest version. Please check it out and let us know if there's still an issue. Thank you!