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]
Login
Message << Older Topic   Newer Topic >>
Exporting from the Commanders Report - 11/20/2019 10:36:19 PM   
countrboy

 

Posts: 205
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: 5818
Joined: 1/17/2002
From: Bexhill-on-Sea, E Sussex
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: 205
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: 102
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: 1876
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: 205
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: 5818
Joined: 1/17/2002
From: Bexhill-on-Sea, E Sussex
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: 30
Joined: 6/26/2014
Status: offline
Thanks, y'all, this helped, IMMENSELY!

And now to some Data-Mining.....

(in reply to countrboy)
Post #: 8
Page:   [1]
All Forums >> [New Releases from Matrix Games] >> Gary Grigsby's War in the East Series >> Exporting from the Commanders Report Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.138