I am using the HDF Viewer to look at .hdf5-formatted output files from a river model. Basically there are a number of locations (identified by a unique number) that each have two output tables associated with them. Is there any easy way to batch import this information to Excel (vs. what I'm doing now is just opening each table and copying/pasting)? Thanks.
Justin D. Gragg
Managing Associate Geomorphologist/Hydrologist
ESA | Environmental Hydrology
1425 N. McDowell Boulevard, Suite 200
Petaluma, CA 94954
707.795-0900 main | 707.795-0902 fax
707.795-0913 direct
Justin,
You can export datasets to text files. If you open a dataset in HDFView, go
to Table -> Export Data To File.
Beyond that, you'd need a custom program. Personally, I'd write something
up in Python to convert datasets to CSV.
-John
···
On Fri, Oct 3, 2014 at 9:44 AM, Justin Gragg <JGragg@esassoc.com> wrote:
I am using the HDF Viewer to look at .hdf5-formatted output files from a
river model. Basically there are a number of locations (identified by a
unique number) that each have two output tables associated with them. Is
there any easy way to batch import this information to Excel (vs. what I’m
doing now is just opening each table and copying/pasting)? Thanks.
*Justin D. Gragg*
Managing Associate Geomorphologist/Hydrologist
ESA | Environmental Hydrology
1425 N. McDowell Boulevard, Suite 200
Petaluma, CA 94954
707.795-0900 main | 707.795-0902 fax
707.795-0913 direct
_______________________________________________
Hdf-forum is for HDF software users discussion.
Hdf-forum@lists.hdfgroup.org
http://mail.lists.hdfgroup.org/mailman/listinfo/hdf-forum_lists.hdfgroup.org
Twitter: https://twitter.com/hdf5
I think this tutorial will help you.
http://www.hdfgroup.org/HDF5/Tutor/cmdtoolcvrt.html#ascii
···
--
Save the Earth. Save Earth data in HDF-EOS. Save Big data in HDF.
On Fri, Oct 3, 2014 at 11:44 AM, Justin Gragg <JGragg@esassoc.com> wrote:
I am using the HDF Viewer to look at .hdf5-formatted output files from a
river model. Basically there are a number of locations (identified by a
unique number) that each have two output tables associated with them. Is
there any easy way to batch import this information to Excel (vs. what I’m
doing now is just opening each table and copying/pasting)? Thanks.
Justin D. Gragg
Managing Associate Geomorphologist/Hydrologist
ESA | Environmental Hydrology
1425 N. McDowell Boulevard, Suite 200
Petaluma, CA 94954
707.795-0900 main | 707.795-0902 fax
707.795-0913 direct
_______________________________________________
Hdf-forum is for HDF software users discussion.
Hdf-forum@lists.hdfgroup.org
http://mail.lists.hdfgroup.org/mailman/listinfo/hdf-forum_lists.hdfgroup.org
Twitter: https://twitter.com/hdf5
Thanks...I will take a look.
Justin D. Gragg
ESA | Environmental Hydrology
···
-----Original Message-----
From: Hdf-forum [mailto:hdf-forum-bounces@lists.hdfgroup.org] On Behalf Of H. Joe Lee
Sent: Friday, October 03, 2014 10:37 AM
To: HDF Users Discussion List
Subject: Re: [Hdf-forum] HDF Viewer - importing .hdf5 tables/data to Excel?
I think this tutorial will help you.
http://www.hdfgroup.org/HDF5/Tutor/cmdtoolcvrt.html#ascii
--
Save the Earth. Save Earth data in HDF-EOS. Save Big data in HDF.
On Fri, Oct 3, 2014 at 11:44 AM, Justin Gragg <JGragg@esassoc.com> wrote:
I am using the HDF Viewer to look at .hdf5-formatted output files from
a river model. Basically there are a number of locations (identified
by a unique number) that each have two output tables associated with
them. Is there any easy way to batch import this information to Excel
(vs. what I’m doing now is just opening each table and copying/pasting)? Thanks.
Justin D. Gragg
Managing Associate Geomorphologist/Hydrologist
ESA | Environmental Hydrology
1425 N. McDowell Boulevard, Suite 200
Petaluma, CA 94954
707.795-0900 main | 707.795-0902 fax
707.795-0913 direct
_______________________________________________
Hdf-forum is for HDF software users discussion.
Hdf-forum@lists.hdfgroup.org
http://mail.lists.hdfgroup.org/mailman/listinfo/hdf-forum_lists.hdfgro
up.org
Twitter: https://twitter.com/hdf5
_______________________________________________
Hdf-forum is for HDF software users discussion.
Hdf-forum@lists.hdfgroup.org
http://mail.lists.hdfgroup.org/mailman/listinfo/hdf-forum_lists.hdfgroup.org
Twitter: https://twitter.com/hdf5
Hi Justin,
I tried it and the tutorial topic that was previously mentioned on outputting an HDF5 dataset into ASCII (http://www.hdfgroup.org/HDF5/Tutor/cmdtoolcvrt.html#ascii) unfortunately does not work well with compound datatypes, such as tables. The h5dump output will be vertical and contain unwanted bracket characters. For example, here is a snippet of the ASCII output you get from running h5dump (with the
-d, -o, -y, -w options) with the file created by the table example from the High Level tutorial (ex_table_01.c):
{
"zero",
0,
0,
0,
0
}, {
"one",
10,
10,
1,
10
}, {
-- >8 cut ---
I entered an enhancement report to add a way from the command-line to export a simple table in an HDF5 file into an ASCII file (that can then be imported into Excel).
Thanks!
-Barbara
help@hdfgroup.org
···
-----Original Message-----
From: Hdf-forum [mailto:hdf-forum-bounces@lists.hdfgroup.org] On Behalf Of H. Joe Lee
Sent: Friday, October 03, 2014 12:37 PM
To: HDF Users Discussion List
Subject: Re: [Hdf-forum] HDF Viewer - importing .hdf5 tables/data to Excel?
I think this tutorial will help you.
http://www.hdfgroup.org/HDF5/Tutor/cmdtoolcvrt.html#ascii
Save the Earth. Save Earth data in HDF-EOS. Save Big data in HDF.
On Fri, Oct 3, 2014 at 11:44 AM, Justin Gragg <JGragg@esassoc.com> wrote:
I am using the HDF Viewer to look at .hdf5-formatted output files from
a river model. Basically there are a number of locations (identified
by a unique number) that each have two output tables associated with
them. Is there any easy way to batch import this information to Excel
(vs. what I’m doing now is just opening each table and copying/pasting)? Thanks.
Justin D. Gragg
Managing Associate Geomorphologist/Hydrologist
ESA | Environmental Hydrology
1425 N. McDowell Boulevard, Suite 200
Petaluma, CA 94954
707.795-0900 main | 707.795-0902 fax
707.795-0913 direct
_______________________________________________
Hdf-forum is for HDF software users discussion.
Hdf-forum@lists.hdfgroup.org
http://mail.lists.hdfgroup.org/mailman/listinfo/hdf-forum_lists.hdfgro
up.org
Twitter: https://twitter.com/hdf5
_______________________________________________
Hdf-forum is for HDF software users discussion.
Hdf-forum@lists.hdfgroup.org
http://mail.lists.hdfgroup.org/mailman/listinfo/hdf-forum_lists.hdfgroup.org
Twitter: https://twitter.com/hdf5
Thanks for the feedback Barbara, I tried it too without success (and yes I am working with simple tables).
Justin D. Gragg
ESA | Environmental Hydrology
···
-----Original Message-----
From: Hdf-forum [mailto:hdf-forum-bounces@lists.hdfgroup.org] On Behalf Of Barbara Jones
Sent: Monday, October 06, 2014 11:11 AM
To: HDF Users Discussion List
Subject: Re: [Hdf-forum] HDF Viewer - importing .hdf5 tables/data to Excel?
Hi Justin,
I tried it and the tutorial topic that was previously mentioned on outputting an HDF5 dataset into ASCII (http://www.hdfgroup.org/HDF5/Tutor/cmdtoolcvrt.html#ascii) unfortunately does not work well with compound datatypes, such as tables. The h5dump output will be vertical and contain unwanted bracket characters. For example, here is a snippet of the ASCII output you get from running h5dump (with the -d, -o, -y, -w options) with the file created by the table example from the High Level tutorial (ex_table_01.c):
{
"zero",
0,
0,
0,
0
}, {
"one",
10,
10,
1,
10
}, {
-- >8 cut ---
I entered an enhancement report to add a way from the command-line to export a simple table in an HDF5 file into an ASCII file (that can then be imported into Excel).
Thanks!
-Barbara
help@hdfgroup.org
-----Original Message-----
From: Hdf-forum [mailto:hdf-forum-bounces@lists.hdfgroup.org] On Behalf Of H. Joe Lee
Sent: Friday, October 03, 2014 12:37 PM
To: HDF Users Discussion List
Subject: Re: [Hdf-forum] HDF Viewer - importing .hdf5 tables/data to Excel?
I think this tutorial will help you.
http://www.hdfgroup.org/HDF5/Tutor/cmdtoolcvrt.html#ascii
Save the Earth. Save Earth data in HDF-EOS. Save Big data in HDF.
On Fri, Oct 3, 2014 at 11:44 AM, Justin Gragg <JGragg@esassoc.com> wrote:
I am using the HDF Viewer to look at .hdf5-formatted output files from
a river model. Basically there are a number of locations (identified
by a unique number) that each have two output tables associated with
them. Is there any easy way to batch import this information to Excel
(vs. what I’m doing now is just opening each table and copying/pasting)? Thanks.
Justin D. Gragg
Managing Associate Geomorphologist/Hydrologist
ESA | Environmental Hydrology
1425 N. McDowell Boulevard, Suite 200
Petaluma, CA 94954
707.795-0900 main | 707.795-0902 fax
707.795-0913 direct
_______________________________________________
Hdf-forum is for HDF software users discussion.
Hdf-forum@lists.hdfgroup.org
http://mail.lists.hdfgroup.org/mailman/listinfo/hdf-forum_lists.hdfgro
up.org
Twitter: https://twitter.com/hdf5
_______________________________________________
Hdf-forum is for HDF software users discussion.
Hdf-forum@lists.hdfgroup.org
http://mail.lists.hdfgroup.org/mailman/listinfo/hdf-forum_lists.hdfgroup.org
Twitter: https://twitter.com/hdf5
_______________________________________________
Hdf-forum is for HDF software users discussion.
Hdf-forum@lists.hdfgroup.org
http://mail.lists.hdfgroup.org/mailman/listinfo/hdf-forum_lists.hdfgroup.org
Twitter: https://twitter.com/hdf5
