Exporting from the Commanders Report

Matrix Games Forums

Forums Register Login Photo Gallery Member List Search Calendars FAQ

My Profile Inbox Address Book My Subscription My Forums Log Out

Exporting from the Commanders Report

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [New Releases from Matrix Games] >> Gary Grigsby's War in the East Series >> Exporting from the Commanders Report

Page: [1]

Message

<< Older Topic Newer Topic >>

Exporting from the Commanders Report - 11/20/2019 10:36:19 PM

countrboy

Posts: 213
Joined: 9/26/2015
Status: offline

I tried to export data from the Commanders Report, but when I open the file in Excel it's largely unusable due to the formatting of the data. Is there a way around this?

Post #: 1

RE: Exporting from the Commanders Report - 11/21/2019 4:54:37 AM

Chris21wen

Posts: 6249
Joined: 1/17/2002
From: Cottesmore, Rutland
Status: offline

quote:

ORIGINAL: countrboy

I tried to export data from the Commanders Report, but when I open the file in Excel it's largely unusable due to the formatting of the data. Is there a way around this?

There's a huge amount of data and the export is a simple way of providing access to it by the designer. Once it's exported it's up to sort it. Use column A, which identifies the different section (tab reports), and copy and paste the bits you want to a separate sheet.

< Message edited by Chris21wen -- 11/21/2019 4:55:00 AM >

(in reply to countrboy)

Post #: 2

RE: Exporting from the Commanders Report - 11/21/2019 5:21:16 AM

countrboy

Posts: 213
Joined: 9/26/2015
Status: offline

The problem is that when I open the file all of the data is in Column A. Each line is simply one long string of characters, all in Column A. It's completely unformatted.
I would post a screenshot but don't know how.

< Message edited by countrboy -- 11/21/2019 5:26:53 AM >

(in reply to Chris21wen)

Post #: 3

RE: Exporting from the Commanders Report - 11/21/2019 8:15:52 AM

deep42

Posts: 104
Joined: 3/19/2014
From: Frankfurt/Germany
Status: offline

countrboy,

the exportfile is a Tab seperated CSV file. If you use (a newer) Excel you should not use File > Open, but create a new empty Excel sheet, then use Data tab > From Text. Select the file and click import, then set data type to delimited and set delimiters to Tab.

More for example here: https://www.copytrans.net/support/how-to-open-a-csv-file-in-excel/
https://www.hesa.ac.uk/support/user-guides/import-csv or check the Excel docs

HTH
Peter

< Message edited by deep42 -- 11/21/2019 8:16:32 AM >

(in reply to countrboy)

Post #: 4

RE: Exporting from the Commanders Report - 11/21/2019 4:33:24 PM

thedoctorking

Posts: 2297
Joined: 4/29/2017
Status: offline

And if you are importing into an existing spreadsheet, open the export file in Notepad or some similar text editor and copy-paste.

(in reply to deep42)

Post #: 5

RE: Exporting from the Commanders Report - 11/21/2019 9:06:47 PM

countrboy

Posts: 213
Joined: 9/26/2015
Status: offline

Thanks deep42, will give that a try, sounds like the fix.

(in reply to thedoctorking)

Post #: 6

RE: Exporting from the Commanders Report - 11/22/2019 6:15:07 AM

Chris21wen

Posts: 6249
Joined: 1/17/2002
From: Cottesmore, Rutland
Status: offline

quote:

ORIGINAL: thedoctorking

And if you are importing into an existing spreadsheet, open the export file in Notepad or some similar text editor and copy-paste.

I use Libre and it asks you what separator you want to use whenever you open a CSV. I always thought excel did to!

(in reply to thedoctorking)

Post #: 7

RE: Exporting from the Commanders Report - 5/7/2020 12:41:14 AM

dmh0667FU

Posts: 33
Joined: 6/26/2014
Status: offline

Thanks, y'all, this helped, IMMENSELY!