I tried exporting to excel using feature on v5 but only comes txt file . I read examples it’s bit confusing for me. Screen shot example will help greatly.

you can get them at data on sql management studio. Open sql management studio > Database > Tables > dbo.Entities (right click select top 1000 rows) select items and copy, after paste on excel

Did you look up data exports? [image] Data Exports feature V5 Question I clipped this from a Staff discussion on this feature. The following is all quoted by @emre . SYNTAX {REPORT ORDER DETAILS:<expression>:<line format>:<delimiter>} Orders XML <orders> {REPORT ORDER D…

Yes. Export feature text file. Can’t read. Bilda suggest sql method I tried it. Did work.

You cannot export directly to XLS or XLSX files. Export to CSV file and Excel will be able to read it.

Thanks . Don’t know how? Any screen shots example?

[image] Data Exports feature V5 Question I clipped this from a Staff discussion on this feature. The following is all quoted by @emre . SYNTAX {REPORT ORDER DETAILS:<expression>:<line format>:<delimiter>} Orders XML <orders> {REPORT ORDER DETAILS: O.MenuItemName, O.…

[image] Karim112: Don’t know how? The same way you export to Text. Just change the extension for the Data Export from TXT to CSV and be sure your format delimiters match what your Locale uses, in general, a comma (,), or as the linked Topic shows, the semi-colon (;). [image] […

Karim we can better understand your question if you can try to explain your need in more detail. Why you need to create a batch file?

I got customers name address telephone sambapos . I need details so I cud export to excel. group them up. In category. Sent SMS messages.

Export customers details name phone etc to excel

V5 Question

emre November 22, 2016, 4:06pm 8