Skip to main content
  • EN
Hi!

 

I have a zip-file (attached) that I want to parse with a workspace on FME Server. I want to use an Excel reader to read the Excel-file in the ZIP, then if the Shape-file column in the Excel-sheet contains a file-name I want to use the FeatureReader to read the Shape-file (which lies in a known sub-dir). The Excel file reads fine, but I can’t seem to produce the right path to pull up the Shape-file..?  The trouble I’m having is producing the temporary path to the Upload service, including the sessionID and the ZIP-file “directory”?? Any help would be appreciated.

 

https://dl.dropboxusercontent.com/u/44513131/DATAPAKKE.zip

 

/Above is the ZIP-file I'm using for testing]
Hi,

 

 

I can't get FME 2014 SP1 to read it properly either, unless I first delete the Excel-file from the zip archive.

 

 

You might be better off using a WorkspaceRunner with a separate workspace rather than the FeatureReader.

 

 

You might also want to send your zip-file to your reseller (or Safe) to see if this is an intended "feature" or a bug.

 

 

Lykke til.

 

 

David
Or, for FME Server, the FMEServerWorkspaceRunner...

 

 

David
Got this reply from Safe Software Support (De Wet van Niekerk) which solved the case:

 

-------

 

I would recommend not supplying the path to the Excel file directly, but rather the path to the zipfile as a publishe parameter INPUT_ZIPFILE of type "File (Existing)". Then, build up the path to the Excel file as follows:

 

$(INPUT_ZIPFILE)/*/*.xlsx

 

 

Read the value from the Excel file, and then you can build up the shapefile path as follows in an AttributeCreator:

 

$(INPUT_ZIPFILE)/*/@Value(InternID GU)/GU_flate/@Value(Shapefil-navn)

 

-------

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.