Using readers and writers to extract and load data.
Recently active
Hello, I'm using HTTPCaller to call a Web Feature Service URL as a single feature and pull out a further series of web feature services using XMLFragmenter to generate a subsequent list of URLs. This approach has worked a few other times and works well in this instance .... until I use a second HTTP Caller to call the URLs using the attribute generated from the XMLFragmenter (and a bit of string replacement and concatenation). At first, there is no apparent problem. Even looking at the Data Inspector attached to the HTTPCaller rejection port, it appears to be straightforward. However, pasting the URL into a browser directly leads to a failure and copying and repasting the URL into Word reveals the characters %EF%BB%BF as a hidden part of the URL. This also appears as a square (control character?) and the characters  as a surprise part of the URL when the _error attribute is looked at in the Data Inspector table. . As you'll have guessed by now, I am not a web developer a
hello all, i got an excel file with two columns, one with reference letter and one with a value, i want to turn the values into headers within a SQL tables, each sql table being one reference number what would be the best way going about it? i have been messing around with listbuilder then expose the values which does give me one row per reference number, also each reference number has a different amount of values, so exposing them leaves a lot of missing values and i am still lost on how to turn them into header, maybe a custom transformer with a loop could help? any help would be great,
Hello, I am working on a dynamic workspace that is supposed to read multiple feature types that are determined at run-time. These feature types have different WHERE clauses. I am using a process similar to the ones described in the document below. However, while I can read multiple feature types I cannot find a way to associate each feature type with its own respective WHERE clause. I am using the feature reader transformer to read any layer I like and the data sources can be separated by a ":" however the transformer takes only one where clause which is applied to all feature types. http://fmepedia.safe.com/articles/How_To/Pass-a-List-of-Tables-or-Layers-to-an-FME-Reader-using-Python-Scripted-Parameters Any help or ideas are greatly appreciated! Regards, Nenad K.
Hi Guys, I'm not sure if this is possible..... I have a lot of profile drawings in one dwg....(screenshot) Is it possible to generate an automatization in FME to create pdfs for each drawing with the same scale? Do i have to set frames first or can i create frames in FME? Problem: the drawings have not the same size as you see on the screenshot....Any Ideas? Thx and Greetz Franco
Hi, I am trying to do a really basic function. I have a CAD file which i add an attribute to and populate with the fme_basename. I then have an EXCEL that contains the fme_basename and also another field called 'DESCRIPTOR' basically what i want to do it a test where FME says If the fme_basename = the Basename from excel then populate new field with the value from descriptor. I have used an attribute creator with a conditional value but does not seem to work?
Printing workbenches in A4 paper size in pdf file, I wanted to print the workbench below in A4 paper size in pdf file but it appears that there is no sufficient tools to better layout it in the A4 paper (having it centered, etc.) How this can be implemented in FME? I am not if there is a tool to export the model directly as jpg file the same way we do in the model builder of the ArcGIS Thank you Best Jamal
We have an inspire transport networks water dataset that we would like to setup a WFS service for. The data is already in gml format and validates ok with the XSD’s provided by FME. I have tried to follow the article: https://knowledge.safe.com/articles/How_To/How-to-Create-a-WFS-Service-Using-FME-Server and indeed I do get getCapabilities to work and also manage to get data out through a web browser. The actual server is inside our firewalls - but can be seen through php here: http://153.44.6.24/inspireWFS/php/dataRequest.php?version=1.1.0&request=GetCapabilities or to get some data (be a bit patient) http://153.44.6.24/inspireWFS/php/dataRequest.php?version=1.1.0&request=GetFeature&typeName=kyv_wfs:WaterwayNode The problem is when using the data inspector or other software to view the data. Now I am doing it inside our firewall, Thus, there is no script in between to further mess things up with links and what not... It all looks promising and I can choose within the v
Hi, I've got a weird difference between x-y coordinates between two points which is causing some issues. Using a FGDB, with a featureclass with points included, as a basemap I draw a polygon using the esri snapping function on. This polygon has its corners snapped to the points and is saved in a .shp shape file. In ArcMap the x-y coordinates of the corner points are exactly the same as the points underneath them. Now when using FME and FME dataviewer these points have slightly different x-y coordinates only differing on the 9th decimal. Meaning that the points do not fall inside the polygon creating difficulties. To keep it simple the x-coordinate of the point is: 67479.59299999848 and the x-coordinate of the polygon corner point is: 67479.593000002205 Now my question is this: What makes the differences because the difference isn't just plain and simple rounding. With rounding I would expect a .593000000000 not a 2205 at the end. Hope someone has an answer to how this work
I am getting error as "Unable to login to smallworld". Following error is coming. Creating reader for format: Smallworld 4 Trying to find a BUILTIN plugin for reader named `SWORLDSWAF' Trying to find a DYNAMIC plugin for reader named `SWORLDSWAF' Loaded module 'SWORLDSWAF' from file 'C:\\Program Files\\FME\\SWORLDSWAF.dll' FME internal API version is '3.7 20150407'. The 'SWORLDSWAF' module was built with FME API version '3.6 20090807' Creating reader for format: Smallworld 4 Trying to find a BUILTIN plugin for reader named `SWORLDSWAF' Trying to find a DYNAMIC plugin for reader named `SWORLDSWAF' FME internal API version is '3.7 20150407'. The 'SWORLDSWAF' module was built with FME API version '3.6 20090807' Opening the Smallworld Reader on dataset `.' Smallworld Translator version: 4.3dev.6 Number of Features: 0 Parameters : 19 Connecting to Smallworld on localhost:30000 using s
Hello everybody, i am pretty new the FME. so please dont bash if this is actually a simple question. I would like to intersect a Digital Elevation Model with 3D-Buildings. What would be the preferred data type (TIn, Raster, Triangles...etc) of the DEM (i have got a regurlarly spaced point file .xyz with z-values and breaklines in an esri-shape) to intersect it with the buildings (which i have in a CityGML-file)? As a result i would like to get the lowest point of each building, which i will use to calcalute the height of the buildings (the roofs i ahve already...). Thanks for any suggestions about what kind of DEM and transformers to use... Greets Patrick
Hello, i am trying to convert an skp file into a gml one, following Citygml principles. During the inspection, there are 3 attributes:1)citygml_feature_role 2)citygml_feature_role_attr_name 3)citygml_feature_attr_value, that no matter what i change in attribute creator, have the same writings:1)cityobject member 2)missing 3)missing. Can someone please explain me what am i doing wrong? Thank you very much
Hi! I know it is possible to convert VRML files into 3D PDFs using version 2015. But is it also possible with the 2014 version? Best regards, Alex
I have shape file with buildings (poligones) and a LiDAR pointcloud (las file). I would like to know and detect if the buildings geometry are changed. How i can compare my point cloud to my shape file to locate for example new building or if a buildings is bigger? I tried with hullaccumulator but the poligone created is not very accurate and i can't detect changement on my buildings... Thanks
Hi, is it possible to creat differents input and output ports in a pythoncaller? if it is, how could we do? Thank you. Yann
Hi all, I am currently trying to add a gml:id attribute to all my CityGML geometries in FME. I can easily create this attribute for each object (i.e. PlantCover, Road, RoofSurface ...). However, when I want to assciate a material to a surface, I need to grab the id of the surface (i.e the geometry gml:Polygon). How can I do that in FME ? Best regards, Asher
Worspace runner reads a feature type (SDE feature class) and I'd like to pass the line feature and its attribute - one feature at a time - as part of my translation on the worker workspace using a Workspace Runner transformer. I know the features will enter and exit the workspace through the workspace runner from within the runner workspace but how can I use it inside the worker WS? There is another reader with multiple related feature classes with the feature type, from the runner WS, in the worker WS that is translated with each feature from runner workspace. On each feature from the runner, an attribute named featureID is needed for the where clause parameter of the reader feature types inside the worker workspace, how do I implement this in the Main workspaces? On the Workspace Runner tranformer that paramater looks like this Parameter column: "FEATUREID_TO_PROCESS" ; Value column: @VALUE(featureID). I tried creating a User parameter in the runner WS and used Apply
I would like to know if it's possible to read pipes invert elevation from a Civil 3D file using Civil 3D reader. It seams that I can't see this information in FME Data inspector but I hope there's a way to get that attribute out of Civil 3D files. Same thing for Structure insertion rim elevation. I'm using Edition: FME Desktop Oracle Edition (floating) 2015.1 with Win64 Thanks for helpin' !
Hi all, Could someone tell me how can I put non-spatial features into a shapefile? Here is an screenshot: (as you can see, with inspector they are found 4 features, but once I check the Shapefile, there are just writen two features) Note: the original Shapefile has spatial and non-spatial features inside. Many thanks, JuanM.
Hello! How I can tranform shp file with "height" to citygml lod2 model with roof and textured wall?
Hello All: I am creating a workspace that translates an Autocad .dwg cad file into an xml. The workspace works fine. One of the validation I would like to do on the cad file in the workspace is to check if the input cad (.dwg) file is a 3d or 2d file. I know how to check the dimension of each of the cad layers using DimensionExtractor transformer. But I want to check whether the cad file itself is in 2D or 3D. I have been researching all of the Autocad Reader Feature Type Propoerties. One of the Format Attributes that might be able to give some info on the cad file's raw dimensions is autocad_dim_flag (or autocad_dimension_flag). Unfortunately, I have not stumbled upon any available documentation on how to extract any dimension (2D or 3D) info from the cad file. Any help/sugggestion is highly appreciated! Thank you!
I've gor an ascii raster that I want to convert to a xyz file. This should not be to difficult now should it?! I get this errorr: POINTCLOUDXYZ writer: Failed to obtain point cloud from feature. Only features with point cloud geometry are expected A fatal error has occurred. Check the logfile above for details
We are beginning to process Travel Time probe data using INRIX and Excel. My question is if there is any documentation on the use of FME and probe data?
Apologies for this very simple question, but I don't seem to be getting a Help tab in my 2015.0 Desktop. From a previous version (2012?), I seem to recall that when you selected a Transformer in the Transformer Gallery, a Help tab/box would show you the basic instructions for that transformer. However, I can no longer see it. And when I select View --> Windows --> Help, I can switch on/off any of those windows, except Help. I can tick it and untick it but nothing happens. Could it be that it is an undocked window, which sits outside my screen boundaries? If so, how can I get it back in view, so i can dock it? (Note I can still access the FME online help, it's just this window within Desktop that seems to have gone) Fingers crossed there is a very simple solution...
Hi, On the FME Server I get an error when writing to SOSI. "504 ERROR 0.0 9.0 2014-12-12 08:44:20 BADNEWS: File C:\\apps\\FMEServer\\Server\\fme\\metafile\\SOSI.fmf could not be opened (tabrdr.cpp:1048)" A workspace is tested and works well on FME Desktop of course. Is there any special setup for GeoSOSIprofessional when working together with FME Server? Tips?
Hi all, We're currently processing a 1.6gb jpeg2000 file. We're applying a clipper to break it down to a 4x4 grid and then resampling using bilinear interpolation within the RasterResampler transformer. Its setup to clip first the resample. All files are running locally. The issue is at current estimates, per grid cell will take 40 hours. Strangely enough, we processed a 1.2gb jpeg2000 file a while ago with same setting presumadly, and took 19 hours for the entirety of the project. Not sure whats happened. Wanted to ask if any has tips/tricks to improve speed or recommend different transformer combinations. Cheers,