Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

gzip tool unable to read file meta data, when gml is gzipped inside

steven4320555
8 - Asteroid

The anticipated gzip support was recently released in 2018.2, I finally got some time to get started with some of OS Mastermap data stored as gz with gml inside. 

 

Unfortunately, I got the following message when I tried to open the  gz file.

"error extracting file: unable to read file meta data"

 

I guess it might have something to do with the fact that gz read only support limited file format, although gml is supported if it is not gzipped. (as I shared in https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Support-for-GZIP-gz-compressed-files-in-inpu... )

 

Just want to bring this issue to the attention of the developers and the community, in case someone might have a similar problem, or may have time and may be able to provide some signpost.

 

One workaround I can think of is to unzip the gz file into temporary files (I have over a thousand, would not be a problem for batch macro), and then use the existing gml capactiy. But as a lazy user, who is a little scared and short of time to use the run command tool, as introduced here:  https://tarsolutions.co.uk/blog/unzip-a-file-in-alteryx/ . Just to check if supporting gml will be soon released in beta version, I am happy to help test it out.

 

Many thanks

Steven

 

11 REPLIES 11
blyons
11 - Bolide

I don't think it is restricted to whether you have gml inside. I am getting the same error with a standard .GZipped text file. See https://community.alteryx.com/t5/Alteryx-Designer-Discussions/GZIP-support-not-working-in-2018-2-Inp...

 

DanM
Alteryx Community Team
Alteryx Community Team

@blyons and @steven4320555,

 

The gzip files must be a tar.gz and at this point we only support the file formats below.

 

The following file formats can be read from a .tar.gz file and extracted to a temporary location on your hard drive:

 

.cydb, .dbf, .kml, .grc, .grd, .qvx, .sas7bdat, .sav, .sz, .xlsm, .xlsx, .xlsx (legacy), .xls, .xml

 

https://help.alteryx.com/current/DataSources/GZipFiles.htm <https://help.alteryx.com/current/DataSou...

 

DanM

blyons
11 - Bolide

That is extremely disappointing, especially since that was not what anyone in the idea thread even requested.

steven4320555
8 - Asteroid

Thanks for the reply. Is there any plan for include more file type in the near future? Will it be something in the beta scheme if you may know?

steven4320555
8 - Asteroid

People will need to do it step by step, but it good to take users need into consideration, especially some big users. I am a free academic account user, so I am not asking more.

ARich
Alteryx Alumni (Retired)

Hi @steven4320555,

 

We will look at adding gml as a supported file inside a gzipped archive. Gml is not one of our most frequently used file types, so we didn't include it in the first round, but we can certainly iterate and add! Thanks for the feedback!

 

Best,

Alex

ARich
Alteryx Alumni (Retired)

Hi @blyons,

 

Thanks for the feedback. Since .gz doesn't provide any metadata, we ran into some technical issues implementing straight .gz files. Therefore, we touched base with some users and decided on .tar.gz extensions as a first iteration. We're looking into what's necessary for all .gz files at the moment. Apologies for the disappointment and we hope to get this to you soon!

 

Just to confirm- your use case is reading in a log file from a .gz archive, correct? What is the the file type of your log file inside the archive?

 

Best,

Alex

steven4320555
8 - Asteroid

Hi

@ARich Thanks very much for the quick reply. It is good news. Just to confirm if the plan will be to add gml support in .gz? Or it has to be .tar.gz? 

 

My user case is some bulk downloaded data from OS Mastermap topographical layer in GB. I used FME to handle the data, but it took days, I am looking forward to see what Alteryx can do. As you might know recently, there is some good move towards opening up more open spatial data in UK, and a lot of the spatial data is in .gml format (it might be an incentive for Alteryx to prioritize the support). https://www.agi.org.uk/news/agi/1297-open-mastermap-webinar-recording-availablehttps://www.gov.uk/government/news/unlocking-of-governments-mapping-and-location-data-to-boost-econo...https://www.ordnancesurvey.co.uk/about/news/2018/mastermap-announcement.html 

 

Another user case, for gml data in UK and EU will be the INSPIRE polygon (they are not gzipped and can be opened with Alteryx directly). eg. in England and Wales "The INSPIRE Index Polygons can help you locate registered freehold land and property in England and Wales; the data is updated monthly." https://www.gov.uk/guidance/inspire-index-polygons-spatial-data#about-inspire-polygons 

GML format

GML is an open data format that is widely used across Europe and complies with the EU INSPIRE Directive. By supplying data in GML format, HM Land Registry support the use of open standards and supply a standard data structure to users of all GIS/CAD systems.

blyons
11 - Bolide

My files are text inside .gz. A sample can be found attached to this thread: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/GZIP-support-not-working-in-2018-2-Inp...

 

Labels