thread Separating Items in CSV in Archived Discussions (Read Only)

Separating Items in CSV

Mikecvswmd — Tue, 30 Jan 2018 17:09:23 GMT

Is it possible to have items split up by column in CSV export by default? Like, one row for Item A, another for Item B, done as such for each sale going down the record. Maybe I missed the how-to on that one. As it is, all items get counted and batched into one column on the spreadsheet, which makes it hard to arrange sales by item in Excel.

Re: Separating Items in CSV

RHatch — Tue, 30 Jan 2018 22:52:34 GMT

What report are you looking at?

Re: Separating Items in CSV

Mikecvswmd — Thu, 01 Feb 2018 17:29:38 GMT

We are reviewing the standard CSV export. As far as I can tell, all Items are batched into one column, which makes arranging them by Item code in Excel very difficult.

Re: Separating Items in CSV

RHatch — Thu, 01 Feb 2018 18:31:29 GMT

Ok but what report? Transactions, items sales, etc. What do you mean by “item code” and what are you trying to accomplish?

i can help you out if I know more about what you are looking at and what you are wanting.