Using readers and writers to extract and load data.
Recently active
I have 80km of embankments which have been laserscanned. I have a polyline running approximately along the top of the embankment. At regular intervals (20m) along this polyline I have a point feature from which I have created perpendicular lines 10 meters each side of the point. Each perpendicular line has been assigned an ID corresponding to it's distance from the start .ie 0, 20,40,60 etcFrom my DEM I need to extract the values along the perpendicular line. I then need to sort the z-values descending and keep the highest z-value. I then need to group the values according to the ID of the perpendicular line thus keeping the highest z-values along the perpendicular line. The resulting value must then be kept as an attribute of the center point (green) of the perpendicular line for a label on a map showing the ridge of the embankment and the highest point.I have managed to create perpendicular lines each side of the embankment but cannot find a transformer that will extract the val
I'm having trouble with FME closing up window holes. The holes don't disappear completely, but are instead covered up (randomly?) on either side by, as far as I can tell, a flat (triangulated) polygon. This problem exists when simply viewing the IFC in the inspector as well as writing it to Esri multipatch. The behavior doesn't show in all walls either, as you can see on the right grey side, where the window holes are as expected. Any ideas how I could remove the coverings?The bottom screenshot is the building viewed in Solibri Model Viewer.
Hi Team,fme 2016Both reading and writing to oracle spatial.My customer has @ symbol in his oracle password string.in my fmw file, oracle connection string is published parameter, and user has to pass the easy connect string to this parameter likeuser1/x3#@rtye@mydbnow there are two @ symbols and fme treats rtye@mydb as dbname and fails to connect.but thru oracle's sqlplus i can connect. not from fme.and if i give these three parameter separately to sql executor it works good. how can i connect with just one text string with @ symbol in password? please help.there are lot of fmws developed and i exposed connection string as published parameter
I want to expose the attributes of a esri sde30 to a dwg writer.How are the Settings of the dwg writer:Parametres>Advanced>Attribute Output:Or someware else?
How do I read attribute values from an arcgis feature service, update an attribute value for all records read, and write those updates back to the feature service as updates?I'm using the httpcaller to return attributes from an ArcGIS feature service. Below is the json result. { "attributes": { "OBJECTID": 103, "POI_ID": "8", "POI_TITLE": "Selmon Greenway", "DESCRIPT": "The Selmon Greenway begins at the Tampa Riverwalk. It’s a nice wide paved path that winds around and under the Selmon Expressway for about a mile until it ends at the Meridian Ave Greenway.", "FACILITYID": "191841", "LASTUPDATE": 1494363906000, "LASTEDITOR": "DPD3", "GlobalID": "{B93C41EA-5A6A-4BEE-8629-FE547DC74EB1}", "PICTURE": null }, "geometry": { "x": -9178887.5983503778, "y": 3241906.7689313167 } }I'm creating a url value for PICTURE and I want to write that new PICTURE vale back to the feature service as an update post. Below is the httpcaller post url I'm sending back to
Hi all,question please regarding "SOURCE_DATASET" value.My custom reader has its own dataset parameter, SB_DATASET.I need to sync SB_DATASET with SOURCE_DATASET: SOURCE_DATASET <-> SB_DATASET The following way doesn't work:SOURCE_SETTINGS...DEFAULT_VALUE SB_DATASET $(SB_DATASET)GUI TEXT SB_DATASET Dataset Name:...END_SOURCE_SETTINGSSOURCE_DATASET $(SB_DATASET)when IFMEReader::open(const char* datasetName, const IFMEStringArray& parameters) - is called - the datasetName is "."The opposite doesn't work as well:SOURCE_SETTINGS...DEFAULT_VALUE SB_DATASET $(SOURCE_DATASET)GUI TEXT SB_DATASET Dataset Name:--------OR-------->DEFAULT_VALUE SB_DATASET $[SourceDataset]GUI TEXT SB_DATASET Dataset Name:...END_SOURCE_SETTINGSSOURCE_DATASET \"$[SourceDataset]\"After creating the reader - SB_DATASET has "$[SourceDataset]" or empty value.Any ideas how to sync these two variables will be very appreciated.Thanks!
I have an enterprise geodatabase, but no SDE services running. Can I use the sde writer to write to it?
I have a multipoint feature class in an Enterprise Geodatabase that I need to copy over to a File Geodatabase. The problem is that not every feature in the feature class has multiple points. Only ~2% of the features have multiple points, but it is critical I retain the option to have multiple points. The problem is that the FME File Geodatabase writer will only copy over just those features that are represented by multiple points (selecting multipoint as the geometry) or just those features that are represented by a single point (selecting point as the geometry). How do I get FME to accept all of the points as potential multipoints and write everything in the File geodatabase?
Hey Everyone, it is me again with some more annoying questions!I have fulfilled most of my requirements for writing out to a CityModel. However, there is one req that is outstanding: adding the gml:id to the CityModel itself.i have followed the CityModel Templates that are available through hub, and have added an attribute (gml_id) for the citymodel feature, and exposed it as a format parameter. but it still does not write to the output GML file.I have even replicated the same ID as the gml_parent_id parameter in the building feature, but still no luck. It is very frustrating!Here are some screenshots of my workbench, and inspector against the CityModel Feature Class / table or however you would refer to it when in inspector. You will see it is using FME Generated ID, and actually the GML has it missing.The above workflow is just a snippet - the full workflow includes the buildings and surfaces also.Many Thanks in advances for any time anyone spends in helping me figure this one ou
Hi Everyone,A simple question i hope, but how can i use the right transformer, to ensure that a <gml:pos> is written in my CityGML? Currently a <gml:posList> element is written.Here is what i am getting:<bldg:lod2MultiSurface> <gml:MultiSurface srsName="EPSG:27700" srsDimension="3"> <gml:surfaceMember> <gml:Polygon> <gml:exterior> <gml:LinearRing> <gml:posList>555687.68 236458.51 216.48 555689.24 236454.66 214.32 555699.8 236458.94 214.35 555698.46 236462.26 216.21 555698.28 236462.72 216.47 555687.68 236458.51 216.48</gml:posList> </gml:LinearRing> </gml:exterior> </gml:Polygon> </gml:surfaceMember> </gml:MultiSurface></bldg:lod2MultiSurface>
Hi!I am trying to transform a dxf-file from SWEREF99 13 30 to SWEREF99 TM. I simply set the coordinatesytem to the one I want in the writer and executes. The result is a file that is more than ten times as big as the original. Why is this?Thankyou.
Hello,I have a kmz file and i would like to extract the name folder - Attached.Thanks, - Danilo
What is Maximum file size that i can upload to FME Shared Resource Data Folder?How can i limit or configure this file size?
Hi everyone,I am very new to FME having recently downloaded a free trial, so please bear with me.I work on a civil engineering project and the majority of our design data (AutoCAD 2013 DWG) is on the OSGB36 grid (Ordnance Survey Great Britain).To transform it to our local site grid I applied a series of modifiers (scaler, rotater, offsetter) then set a writer to output as DWG.We tested it with the largest of our model files and found that the output file was around 800Mb in size whereas the input file was only 200Mb. Does anyone have any idea why this could be happening?I am an Engineering Surveyor so I am rather unfamiliar with AutoCAD beyond simple commands & geometry etc, so the settings in the reader / writer don't mean much to me either!Thanks in advance for any help or advice.John R
I've built a Workspace to process an export file from a GIS system with the following structure:Layer name + comma separated attributesUnique ID (like ESRI Object ID)X YX YX YLayer name + comma separated attributesUnique ID (like ESRI Object ID)X YX YX YIf the last X and Y are the same as the first for that feature, it's a polygon layer, otherwise it's a line. Point layers have the X and Y as part of the layer name and comma separated attributes line.I extract the Unique ID for each feature and add it to the rows that are part of that feature. I then split the attribute rows from the vertex rows. Vertex rows go through the LineBuilder which outputs the results through the Point, Line, or Polygon port as appropriate.Based on which port the data comes out of, I'd then like to set the geometry type as an attribute or parameter to use in the Writer when I create the File Geodatabase feature class. I'm aware that I would need to use drop and create as trying to inser
Hi FME,Need the following help with the workflow:1. From our UI user is allowed to add only DWG and DGN file2. We want an if else statement so that if the users upload dwg, then FME can run the dwg converter workbench and if they upload dgn it runs a different dgn converter workbench. There must be some simple approach for this. Please share your suggestion.Thank you in advance..Regards,Ranjit
Hello,I am a FME beginner and I really love that whole folders can be added to a writer. However, I do have folders which contain many files of the same format each and I would like to add a folder to a reader and let FME guess the format of the files in that folder. It seems that this is not possible but only one of the two (add folder OR guess format from dataset)?thanks and best regards,Ludwig
Hi,I would like to write to elasticsearch, not from a table but from some JSON instead. I have prepared the JSON before hand because it has to be nested.The output format is like so:{ "mappings": { "storymap": { "properties": { "storyname": { "type": "text" }, "storyid": { "type": "integer" }, "storyjson": { "type": "text" }, "categoryname": { "type": "text" }, "subcategoryname": { "type": "text" }, "regions": { "type": "nested", "properties": { "region_id": { "type": "integer" } } } } } }} I have managed to get this output format using the JSONTemplater - thanks to @petrahammoser your post was helpful. But now I want to pass the JSON to an index in elasticsearch which is already created.I have tried but I am at a loss, the JSON do
Hi,While running job on FME Server I noticed it is getting restarted.Workspace I'm trying to run has Smallworld reader and GML writer (+few attribute manipulation transformers). It starts at e.g. 10:00, and after a few time Smallworld console returns stream exhausted traceback at e.g. 10:42. At the same time my job (started at 10 o'clock) is now running and started at 10:42.This repeats itself few time when it finally gives failure status with no description in log of that job.If I run same workspace in Desktop it results in FME.exe crash.Thanks,Želimir
Hi,I have just a 6 points ( attached ) and i would like to generate a kml file using the service KML Network Link.Each point has a number of sequence ( _feature_n ) to show each 30 seconds.How is the best way to do this? Thanks, - Danilo
We have a requirement to produce a report on a monthly basis, the workbench literally just reads a sql view, re-orders the results and outputs to excel.The workbench works using desktop and Server when manually run, however when scheduling the workbench fails with the following error;Excel Writer: No active sheet set, cannot write to the spreadsheet. This is an internal error, please contact support@safe.com I have attached the log file.System information-FME Server 2017.0.1.1 - Build 17291 - win64Running on Windows Server 2012 R2 Standard
Do you think there is a way in FME to extract traffic layer from Google? I want to analyze traffic in a certain zone and I can't find the way to get this data in FME.I tried to see into the documentation but without success : Google TrafficI'm starting to think that maybe Google doesn't want us to do that kind of stuff though...
Hello all. I am attempting to validate the use of this noble cause called FME. While appreciating your time I submit the following:A need has arisen to retrieve the PNEZD (point#, northing, easting, elevation, description) and all of the attributes of each cogo point in a Civil 3D drawing. We can have up to 17 attributes for each point. Is this do-able? If so we could automate the extraction of thousands of points from numerous drawings and life would be swell.
I have the logs which contain multiple warnings, including: " Could not overwrite existing destination file, since it is also the template file". When attempting to open the excel file after running the workbench it first displays an error message, then when you click past it there is another notification claiming another 'unknown' user is in the document. When clicking 'Read only' you can see the whole spreadsheet is broken i.e. all formatting lost