MAM 7.6.1.2:

Reports:
Is there a way to export raw data to excel?
I only want to export the table data from the underlying object structure or query (not the title, totals, groupings, etc.).

(The formatting seen here isn't real formatting. I just hit CTRL+T to convert the data into an Excel data table.)


Reason:
Our Finance users don't really use reports...they only want to export the raw data to excel and plug it into their Excel-based processes.
I know it's possible to export reports to Excel, but there's a lot of extra fluff that get's put into the Excel sheet (even the XLSX and XLS Emitter formats have fluff). Our users don't need the extra stuff -- just the raw data.
Sure, users can manually delete the extra content each time they want to use the data...but that can get a bit tedious over time.

I looked into setting up separate object structures to use with Application Export. But I think it would be way to much work to set up duplicate object structures for all of our reports. It would be a lot more efficient if raw data could be exported directly from the report.
(We mostly use ad-hoc reports, not custom BIRT reports.)
#Maximo
#AssetandFacilitiesManagement

Original Message:
Sent: 11/4/2021 7:53:00 PM
From: User1971
Subject: Reports: Export raw data to Excel (table data only)

MAM 7.6.1.2:

Reports:
Is there a way to export raw data to excel?
I only want to export the table data from the underlying object structure or query (not the title, totals, groupings, etc.).

(The formatting seen here isn't real formatting. I just hit CTRL+T to convert the data into an Excel data table.)


Reason:
Our Finance users don't really use reports...they only want to export the raw data to excel and plug it into their Excel-based processes.
I know it's possible to export reports to Excel, but there's a lot of extra fluff that get's put into the Excel sheet (even the XLSX and XLS Emitter formats have fluff). Our users don't need the extra stuff -- just the raw data.
Sure, users can manually delete the extra content each time they want to use the data...but that can get a bit tedious over time.

I looked into setting up separate object structures to use with Application Export. But I think it would be way to much work to set up duplicate object structures for all of our reports. It would be a lot more efficient if raw data could be exported directly from the report.
(We mostly use ad-hoc reports, not custom BIRT reports.)
#Maximo
#AssetandFacilitiesManagement

You could define your own standard Data-Sets to push Maximo-data out in CSV-Format through the BusinessAnalyst WorkCenter in a recurring way (manual interface).
The DataSet Designer with query- and filtering functionality is available in WorkCenter technology too!

No fancy stuff either - that should do the job too!

Have a good weekend with trial & error :-)

------------------------------
Hagen Neulen
Solution Architect EAM Solutions
SVA System Vertrieb Alexander
70771 Leinfelden-Echterdingen / Germany
hagen.neulen@sva.de
+49 151 27 65 89 97
------------------------------

Original Message:
Sent: Thu November 04, 2021 07:52 PM
From: User1971
Subject: Reports: Export raw data to Excel (table data only)

MAM 7.6.1.2:

Reports:
Is there a way to export raw data to excel?
I only want to export the table data from the underlying object structure or query (not the title, totals, groupings, etc.).

(The formatting seen here isn't real formatting. I just hit CTRL+T to convert the data into an Excel data table.)


Reason:
Our Finance users don't really use reports...they only want to export the raw data to excel and plug it into their Excel-based processes.
I know it's possible to export reports to Excel, but there's a lot of extra fluff that get's put into the Excel sheet (even the XLSX and XLS Emitter formats have fluff). Our users don't need the extra stuff -- just the raw data.
Sure, users can manually delete the extra content each time they want to use the data...but that can get a bit tedious over time.

I looked into setting up separate object structures to use with Application Export. But I think it would be way to much work to set up duplicate object structures for all of our reports. It would be a lot more efficient if raw data could be exported directly from the report.
(We mostly use ad-hoc reports, not custom BIRT reports.)
#Maximo
#AssetandFacilitiesManagement

Just create or use a object structure that meets your needs and add it to an external system via a publish channel. Export it to a flat file which is a csv, easily consumed by Excel. This has been available for a long time and seems to fit your needs.
Does this make sense?

------------------------------
jeffk 2BC7
interloc solutions
grand rapids MI
------------------------------

Original Message:
Sent: Thu November 04, 2021 07:52 PM
From: User1971
Subject: Reports: Export raw data to Excel (table data only)

MAM 7.6.1.2:

Reports:
Is there a way to export raw data to excel?
I only want to export the table data from the underlying object structure or query (not the title, totals, groupings, etc.).

(The formatting seen here isn't real formatting. I just hit CTRL+T to convert the data into an Excel data table.)


Reason:
Our Finance users don't really use reports...they only want to export the raw data to excel and plug it into their Excel-based processes.
I know it's possible to export reports to Excel, but there's a lot of extra fluff that get's put into the Excel sheet (even the XLSX and XLS Emitter formats have fluff). Our users don't need the extra stuff -- just the raw data.
Sure, users can manually delete the extra content each time they want to use the data...but that can get a bit tedious over time.

I looked into setting up separate object structures to use with Application Export. But I think it would be way to much work to set up duplicate object structures for all of our reports. It would be a lot more efficient if raw data could be exported directly from the report.
(We mostly use ad-hoc reports, not custom BIRT reports.)
#AssetandFacilitiesManagement
#Maximo

Hi Jeff,

Pardon my ignorance. I'm don't think I'm following the part about the external system and publish channel. Would you be able to elaborate?

Cheers.


Original Message:
Sent: Fri November 05, 2021 09:55 AM
From: jeffk 2BC7
Subject: Reports: Export raw data to Excel (table data only)

Just create or use a object structure that meets your needs and add it to an external system via a publish channel. Export it to a flat file which is a csv, easily consumed by Excel. This has been available for a long time and seems to fit your needs.
Does this make sense?

------------------------------
jeffk 2BC7
interloc solutions
grand rapids MI

Original Message:
Sent: Thu November 04, 2021 07:52 PM
From: User1971
Subject: Reports: Export raw data to Excel (table data only)

MAM 7.6.1.2:

Reports:
Is there a way to export raw data to excel?
I only want to export the table data from the underlying object structure or query (not the title, totals, groupings, etc.).

(The formatting seen here isn't real formatting. I just hit CTRL+T to convert the data into an Excel data table.)


Reason:
Our Finance users don't really use reports...they only want to export the raw data to excel and plug it into their Excel-based processes.
I know it's possible to export reports to Excel, but there's a lot of extra fluff that get's put into the Excel sheet (even the XLSX and XLS Emitter formats have fluff). Our users don't need the extra stuff -- just the raw data.
Sure, users can manually delete the extra content each time they want to use the data...but that can get a bit tedious over time.

I looked into setting up separate object structures to use with Application Export. But I think it would be way to much work to set up duplicate object structures for all of our reports. It would be a lot more efficient if raw data could be exported directly from the report.
(We mostly use ad-hoc reports, not custom BIRT reports.)
#AssetandFacilitiesManagement
#Maximo