- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Unanswered questions

10000 Posts

sorinduru

asked in Data

Generate numbers in pairs

Hello,how to generate numbers in pairs from 2 to 80 and from 3 to 77.ex: 2, 4, 6, 8,.....803, 5, 7, 9,.....77Nr. 1Nr. 2238077

270

4 years ago

cadfmegeo

asked in Transformers

System caller : comand line works in cmd not in system caller

Hello,I am using 7z to unzip files and would like to use it through System Caller. The command works perfectly fine in cmd, but not in system caller.Here is my command : "C:\\_temp\\7z.exe" x "C:\\_temp\\input\\data.zip" -o"C:\\_temp\\output"When this line is written in a .bat file and this file is executed through System caller, it works. What should I do to be able to execute my command directly in system caller? Many thanks in advance,

442

4 years ago

redgeographicsCelebrity

asked in Transformers

FME Pirate Fun

Ahoy mateys! Today is Talk Like A Pirate Day and so at the risk of getting keelhauled for this, I decided to have some fun with it and build the PirateOnChestOverlayer transformer (available in the Hub).Obviously inspired by the pirate song from Robert Louis Stevenson's Treasure Island :)Fifteen men on a dead man's chest Yo ho ho and a bottle of rumThere's of course Piratespeak log messages, thanks to heavy use of the MessageLogger custom transformer:And the nice thing is that if there's not enough pirates (we need fifteen, according to the song...) it will send out a press gang to round up some more (now if only it could invade other running workspaces and kidnap features from there...). However... if there's too many (we can only put fifteen men on a dead man's chest...) the extras will unfortunately have to walk the plank...Have fun!

240

4 years ago

benvkContributor

asked in General

Workspace Runner Failure Message - Could it be better than what I am currently doing?

Hey, I am currently running this workspace runner with an emailer sending me an email if it fails.Unfortunately my emails are not very valuable as it is a wall of text. I do love the way the translation log is formatted, so I am curious, can I instead of outputting this _failure_message, output the child workspace translation log? I would find that much more valuableCurrent email format which I am not happy with: Is anyone doing something similar, but providing more useful output upon workspace failure? Thanks heaps.

310

4 years ago

umapper1Contributor

asked in Transformers

Create tunnel shape using 3D ellipses

Hi community!Looking for some advice on how to tackle a scenario...I'm trying to get an egg shaped (or ellipse) 3d buffer around some line work. My thoughts were to create some offsets for the sides, centre and top of the ellipse, generate a surface over these using them as break lines then do a similar process for the bottom half. I'm stuck on how to orientate the ellipses in 3D as well as simply creating them from the points and lines that I have. Any suggestions on how to tackle this would be great, be it the ellipses or a new approach to modelling this 'tunnel' shape entirely. Some top notch paint illustrations below. Sample .fmwt data attached.Top view3D view3D view again

120

4 years ago

gellerroma

asked in Transformers

MeasureExtractor don't have value

Hello.I have input line data in EPSG:3857. And I break the line data into vertices and get points. (by Chopper)Next, I use the MeasureExtractor tool in the hope of getting M - values.However, the tool does not work and issues MISSING_GEOMETRY_MEASURE.Tell me pls, how can I get m - values for vertex?

610

4 years ago

simonhumeParticipant

asked in Data

Lat/Long how to display correctly

I'm looking for a bit of advice on how to correctly use the latitude and longitude information in a jpeg (from the exif information). I've exposed the jpeg_exif_gpslatitude and jpeg_exif_gpslongitude information in fme but, when i inspect the output, the lat and long are displayed with brackets like this; (52) (15) (7) (1) (9) (6) Which i think equates to Degrees, Minutes and Seconds? How exactly does this field need to be displayed so i can create a point using the vertex creator then output to shape? I've tried the StringSearcher with the following: Search in: jpeg_exif_gpslatitude Contains Regular Expression: [0-9][0-9] Which outputs 52 into a new column, but i'm struggling to add the other parts of this field to get a meaninful coordinate entry Any advice anyone can provide me with would be very helpfulregards

17313

4 years ago

mackenziebudda

asked in Transformers

Updating polyline attributes from overlapping polygons

I have a polyline (.shp) feature that is essentially just a road network in my city and I wish to update one of its attributes from an overlapping area (.shp). The overlapping area is a buffered corridor of a bikepath that I want to use to update the polyline attribute wherever they overlap. I'm using the lineonareaoverlayer with the following parameters:I want to preserve all the other attributes of the polyline road network. I just want to update the status attribute from overlapping area status attribute. See below:Line feature attributes: Area feature attributes:I want the Status to switch from Not ridden to Ridden anywhere on the line that overlaps with the area. From what I can tell I should be using the listexposer to access the list generated from the lineonareaoverlap transformer but no matter what I try I can't get it to work.

How to read an excel file, and write to the same file that FME is reading?

I receive an error when I try to read and write to the same excel file, is there something that I'm missing?

390

4 years ago

lizzygradidge

asked in Transformers

Splitting delimited addresses into attributes (exposing individual list elements)

I followed the esxample here to split my comma separated addresses .https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/attributesplitter.htm# However this is not working I exposed the elements of the AttributeSplitterBut they are not available in the AttributeSplitter output nor the AttributeManagerI also tried ListExploder but that gave me a multipe row of the address elements And I want the address parts in a single row in columns What Am I missing here?thanks

190

4 years ago

benvkContributor

asked in Data

Text File Writer is prefixing each line with a 'space' character

Has anyone had an issue when writing to text file, it prefixes each entry with a 'space' character?It is writing each new line nicely, appending to the existing data, but the data it writes always is inserted with a leading space.I can confirm the row being sent to be added to the text file does not have any leading space:When this is written, a space is appearing!

4 years ago

alex_apeldoorn

asked in Transformers

Featurereader error using DB/2 via ODBC - wrong SQL syntax

Hi,I am trying to read features from a DB/2 database using an ODBC connection. This is the statement that throws an error; Database Generated Error Information:Database Error Message: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token [ is ongeldig. Geldige tokens: ( NEW FINAL TABLE UNNEST LATERAL XMLTABLE JSON_TABLE <IDENTIFIER>.Database SQL Statement Text: SELECT * FROM [BZSAART00] WHERE 1=0 The problem seems to be with the [ ] around the table name. When I use an SQL executor without the [] it works just fine However since the attributes might differ (I want to loop thru 27 tables to read it's content) using an sqlexecutor is not an option since the attributes to expose will differ per table. Anyone knows a way to get the featurereader to use the right syntax? Is this a bug? Regards,Alex

Directory and File Pathnames FME Server with Windows Login

Hello, I would like to access a protected network address with a reader (Path / filename) and search the folder structure. To do this, I have to log in with my user name and password. I get access through the Windows network, but not via the FME server. I have already tried all 5 network authentication methods. What to do here?

180

4 years ago

wishmaste

asked in Transformers

how to use texture atlas in obj to b3dm translation?

We use fme when converting obj files to b3dm format. There were so many buildings and Each building has texture. We created texture atlas(100 building in one texture) due to poor performance of cesiums bad. But fme import the texture atlas to b3dm file for each building. Is it possible to use the external atlas in b3dm.

150

4 years ago

mark2atsafeSafer

asked in General

Question of the Week: Reading and Writing Nested Zipped Shapefiles

Hello FME'ersIn the week that we hosted a webinar all about the Shapefile format, it's appropriate to have a question-of-the-week on the same subject.Question of the WeekThis week's question came from a user on Live Chat and concerns how to read Shapefiles nested inside multiple folders inside a compressed Zip file.Q) I have a URL for a “zipped” shapefile. However, the shapefile is actually nested two folders into the zip file. If I download this file from the browser and set the Shapefile reader dataset to: /Users/[username]/Downloads/MajorRoads.zip/**/**/*.shp ...then this is read in properly by FME. However when applying a similar logic to a URL: http://[server]/data/downloads/roads.zip/**/**/*.shp ...then FME fails to read the shapefile. The download begins but errors when trying to create feature types.Is this the expected behaviour?A) There are two forms of what we might call "path filtering." The older style - which you are trying to use - is now obsolete, and won't work with UR

1080

4 years ago

pascalfilippi

asked in Transformers

Need explanation how to iterate on the reader

Hello guys,i would like to iterate on my reader, i have one reader who read the county feature of the state of New York and a other one who read 8 millon of small polygon who are a mix with slope + swamp and forest. Well i would like to iterate each county of new york than clip each county by this small polygon and result will be a county with holes and finaly i write all the county with holes in geodatabase. (evry data come from an esri geodatabase) I read that i can create a master workbench and child workbench and use workbenchrunner. well i ve seen in this forum a guy who write that "If nothing else works, you could iterate over the input features using a master workspace that runs the clipping workspace using e.g. the WorkspaceRunner. You can there parametrize which block to process using a published parameter. But my tip is to start with the top two recommendations first. " the thing i can not really visualize what he mean, so if somebody can send me schema or picture

How to keep color on the first row of excel writer?

I am writing out to excel and need to have the top row have different colors. Is there a way to just color top row? When I assign a color in the writer it applies it to the whole column.

700

4 years ago

rohan

asked in Transformers

Excel FeatureReader reading empty row

I have a simple workbench consisting of a FeatureReader, a VertexCreator and a FeatureWriter writing to a postGIS table. I am reading an Excel spreadsheet.The problem is that the FeatureReader is reading an extra row beyond the data and passing null coordinates into the VertexCreator. I have 103 records, but for some reason it is reading 104. The columns in the last row are all marked as missing. I have checked to see if there is any spurious data, like white space in the last row that might be getting registered as data, but I can't find anything.

Extracting geomtry from Oracle 12c database to WKT

I have a 12c Oracle database that has a line feature class and a point feature class that contains geometries , i want to know how i convert to OGC wkt and extract to a .csv file, i have tried to use the Geometry extractor and write to CSV , but when i view the file within the data inspector , no geomtry is present and no values to depcit the geomtry are present either, is there something that I am missing in my workbench ?

200

4 years ago

jamal

asked in Transformers

How to convert polygons to lines and vice versa?

How to convert polygons to lines and vice versa? I couldn’t figure out how the conversions are implemented in the FME. For example, how polygons are converted to polylines and vice versa? Thank you Best Jamal

Process failing due to conflicts found in version

I have a fme process that runs daily that updates records in a geodatabase table. Every couple of days I get an error after the process attempts to reconcile the version. The version is dedicated soley for this process. The process fails after it can not successfully reconcile the version. I am getting the below error: "Conflicts were found when reconciling version 'GAS.FMEPROD' with target version 'SDE.DEFAULT'. Conflicts were found in the table(s): GAS.gValve. These conflicts must be manually resolved. The reconcile operation will be undone and none of the changes will be saved" I am not sure if anyone has had this issue before. Any solution or information that can be provided would be helpful. Thanks.

4 years ago

goatboy

asked in Transformers

Distance down road

Hi, I am trying to create a service area of 2km down a road network from a known starting point. Ie select any road/or part of road within 2km of my starting point (via the road (not an isochrone)). The equivalent of ArcGIS service area. I have read and downloaded the FME "Calculate Emergency Travel Times" example but am a bit lost. Im guessing i need to use the Network Cost Calculator... Any suggestions or ways forward would be appreciated. Thanks Goatboy.

600

4 years ago

bastianr95

asked in Transformers

How to trim lines with multiple ends to get only the "best"/longest line?

Hi! I got several lines made of polygons with the CenterLineReplacer (medial axis), but i only want to keep the longest line with only two ends of each line. Is there a way for that? In the picture below you can first see the line with several ends, in the second picture you see the line as it should look. Thank you in advance!

280

4 years ago

tnarladniEnthusiast

asked in Data

Reading Excel formatting

Is there to read in the formatting of the excel? I need to find all the records that are filled in red and exclude them. I tried fme_fill_color and fme_color but those weren't it. Thanks!

1270

4 years ago

ahmad_saleh

asked in Transformers

How to remove “Self intersections” Polygons using FME

How to remove “Self intersections” using FME I wonder if there is a method to repair the self-intersections in the FME such as the ArcGIS tools “(Check geometry and repair geometry). I have used GeometryValidator but it fails to repair the polygons, What might be the issue here ? Regards, Ahmad Saleh

6300

4 years ago

Page 353 / 400

Badge winners

baileyatsafehas earned the badge 12 Days Participant (2024)
dos_gishas earned the badge 12 Days Participant (2024)
j.botterillhas earned the badge 12 Days Participant (2024)
fme_studenthas earned the badge Welcome Back
evoteckhas earned the badge 12 Days Participant (2024)

Show all badges

30,185: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.