- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Best Answers

9928 Posts

Recently active

Most views Most replies

freddy17Contributor

asked in Transformers

dwg - workspace didnt generate any output

Hi Everyone I am slightly bamboozled and wanted to know if someone knows where I am going wrong or if this is a potential bug.I have had used the FME Cloud and FME Server for loads of FME Server Apps, and havent come across this issue so far. I get the following warning after running a fme server app I am converting a .dwg file to an excel file. If I use a feature_reader set for readings dwg:Autodesk AutoCAD DWG/DXFI get the warning, that the no output can be generated. But if I read an ifc and convert it to excel, all is well. Is there maybe a problem reading dwgs? Why is there no output generated? The FME Server Jobs show that the job is completed without any errors. I have uploaded a .dwg and .ifc and the workspace regardsFred

225

1 year ago

thomastupuivaoContributor

asked in Transformers

Is there a transformer that will convert a multilinestring to a linestring object?

Is there a transformer that will convert a multilinestring to a linestring object? I'm trying to load road centrelines in an oracle spatial database, but the road centreline table in oracle uses GTYPE 2002 (line). Multilinestring is 2006, so I can't apply a spatial index. Any suggestions please?

2562

1 year ago

mlufkinContributor

asked in Authoring

Creating Bingo cards?

Hi there,Slightly off the wall here, but has anyone created a workspace that can create Bingo cards? Ideally a 5x3 grid of random numbers between 1-90, but no repeating numbers...?Obviously, RandomNumberGenerator can give us a way to actually play the game...but I'm thinking whether FME can create the cards for users to play with..?Thanks!

887

1 year ago

jasoncContributor

asked in General

How to dissolve polygons based on an attribute where a dissolved record will include non touching polygons with the same attribute? Using Multi Polygon geometry

962

1 year ago

kzkjcContributor

asked in Transformers

Excel Writer - Multiple Row Number Attributes?

Hello, I am writing to an excel sheet with an existing template. Before the writer, I am using a counter (starting at 0) and attribute creator to then use "Use attribute names as column positions" and "Row number attribute". My attributes are B, C and D which are various strings and B_row_number (@Evaluate(16*@Value(_count)+10)) and CD_row_number (@Evaluate(16*@Value(_count)+16)). I would like the output sheet to look like the image below:Unfortunately, I can't assign different "Row Number Attributes" to arrange it this way (B using B_row_number, and C,D usin CD_row_number). I get the feeling there is a simple workaround I'm not seeing. Any help is appreciated! Thank you.

672

1 year ago

jonvelcoContributor

asked in General

FME Server can't open Oracle client libraries but Desktop can

On the FME Server VM I have setup, the 64 bit Oracle Instant Client isn't being recognized by FME Server. I have the PATH environmental variable set to the folder. I also installed Desktop on the same VM and it has no problem connecting to Oracle databases. What else can I try? This is the error I get when running the workbench in Server:Oracle client libraries (e.g. oci.dll) could not be loaded. Ensure that the 64-bit client is installed and properly configured, and the PATH environment variable includes the file path to your Oracle client. Refer to https://community.safe.com/s/article/how-to-setup-an-oracle-instant-client-for-use-with for more informationThe Oracle Instant Client setup is the "Basic Package" Version 21.9.0.0.0 FME Server2022.2.4 Build 22792 - win64 FME Desktop2022.2.4.0 (20230303 - Build 22792 - WIN64)Database Edition

953

1 year ago

galigisEnthusiast

asked in General

How to Write features in a specific order / Hierarchy?

Hi Community, I'm working on a workflow that needs to write a final Feature class based on a particular hierarchy. The workflow includes a few 'AreaOnAreaOverlayer' steps + ListConcatenator to indicate which parcel overlaps which, below a screenshot with the desired hierarchy:1 - Most important parcels A2- Middle important parcels B3- Less important parcels C I can't run dissolve + clip as need to keep the overlapping information to be 'listconcatenated' so decided to use a Sorter (alphabetical order) to obtain the desired order but isn't working 😞 as there's areas where the parcels C are on top of the parcels B. Below an example where the overlap in the middle between 2 parcels (B + C) should be assigned to B but for some reason is CThere must be a way to tell FME please write parcel A on top of parcels B and then parcels B on top of parcels C and parcels A on top parcels C. A>B>C Thanks a lot in advanced 🙂

1603

1 year ago

limoSupporter

asked in Data

How to get geometry from bridge modul in citygml?

Hi, we have a citygml file that contains a bridge. The validation by "citydoctor " showed no errors. Now we wanna extract the geometry. FME can read the file without error. But only a core element is shown and I cannot get the geometry!By the way we got the same result with the template bridge from the university (KIT)! Does anyone have any ideas or tipps for me?Thanks in advance.

162

1 year ago

koenvdwContributor

asked in Transformers

I have a XYZ point cloud. I need to simplify the point cloud in such a way that I have a point every meter.

So the result should be a point cloud that has points in a grid of 1m x 1m. Personally I would make a DEM with cell size 1m, but that's not what they want. So I have a boundary of the project area. I make a 2dgrid with cell size 1 meter. I clip the grid, because it's made on the hull of the project area and not the project area itself. Then I use the grid to make points in the center of each cell and also use the grid to clip my point cloud. I use the pointcloudstatisticscalculator to get the mean of the z values within one cell of the grid. So I can use the X en Y from the center point and have to add the Z from the statisticscalculator. I merge the data together based on the counter I added. Then I use the vertexcreator to make points with the correct X, Y en Z. If I inspect these, everything looks good. In the data inspector we see that the points have the correct X, Y en Z.The problem is that I can not write the data as point cloud. Not as xyz file and not as las file. I

1202

1 year ago

galigisEnthusiast

asked in General

PointOnAreaOverlayer Help - One Point shared between two polygons

Hi Community, Classic issue with the PointOnAreaOverlaye where I have got one location where the same centroid is shared between two parcels and want to bring the information from point to area. Attached two screenshots that explain the situation. In theory...by creating a list and exploding should work but doesn't give me what I want as the output contains 2 parcels overlaps where there're two points Example 1) I need to bring the assign the point info to each of the parcels. As you can notice the point on the left is shared between two parcels.Example 2) Also, I need to bring the assign the point info to each of the parcels. As you can notice the point on the right is shared between two parcels.I have tried to 'Generate List on output Area' and then explode but the 'element_index' and '_overlap' are different so can't use a tester to filter the list.I have also tried NeighborFinder to filter only those centroids at the middle of the parcel . Thanks

264

1 year ago

aaronContributor

asked in Data

How to include layer/table ID for a feature type in ArcGIS Server Feature Service reader

I am trying to add an ArcGIS Server Feature Service reader to my workspace. I just need one of the layers from the service. Several of the layers have the same name but are differentiated by their parent layer (which are scale dependencies). FME Desktop Help claims it shouldn't be a problem, stating "The reader resolves ambiguity by appending the layer ID to the end of feature types if multiple layers share the same name. If a layer ID is present in the feature type, the ID takes precedence over the name." That doesn't appear to be happening because I receive the following when I select my desired layer and try to add it: "ArcGIS Feature Service Reader: Found multiple layers/tables that match the feature type 'Stations, PNM (4)'. They are: 'Stations (4), Stations (10), Stations (16), Stations (22), Stations (28), Stations (34), Stations (40)'. Resolve the ambiguity by specifying the layer/table ID in the feature type." Ok, but how? I do so in

3611

1 year ago

albinepro

asked in Transformers

Using @CurrentAttribute in condition definition

I have encountered a problem when formating a datetime. A log is raising a warning when the value is null. In order to avoid warnings in log I try to setup a condition in AttributeManager. I would like to reuse (copy/paste) the condition definition so I try to use "@CurrentAttribute". It's working as expected in Attribute Value part, but not in the test condition (see attached image).If I use @CurrentAttribute() ATTRIBUTE_HAS_A_VALUEI get <null> results despite the attribute has a value. Any suggestion how to set up the condition for current attribute correctly?

18410

1 year ago

lifalin2016Contributor

asked in General

FME cannot handle mixed-Z node in a single feature ?

Hi all.An I correct in assuming, that FME cannot handle non-point geometries, i.e. with multiple nodes, when some nodes have Z values, and some don't ?I'm seeing that GeometryReplacer adds dummy Z values (0) where they're missing when importing from WKT og GeoJSON.Is this a problem with the transformer only, or a more general problem with the handling of Z values ?In a system we're running on FME Server, I need to replace any missing Z values with an official fixed value: -99. This is done using the 3DForcer. But if I can't control missing Z values during import, things are very problematic.I made a small test workspace, and ran it in 2020.2 and 2022.2, and both exhibited the same behaviour.Cheers

104

1 year ago

lifalin2016Contributor

asked in Automation

Triggering automations after multiple other automations are all done ?

Hi all.I have two sets of automations, where all automations in set 1 needs to be all done before initaiting all automations in set 2.I'm wondering what the best practice is for this scenario ?I tried to include an active wait mechanism in the set 2 automations, but then they just got started first, blocking the set 1 automations.I'm starting all set 1 automations with a single (topic) trigger, as they may run in parallel, and I can start all set 2 automations with another single trigger. But all set 2 need to wait for all set 1 to finish, and that I can't do with triggers as far as I know.All help and suggestions are appreciated.Cheers

Run trigger with hstore function on writing

I would like to insert to a Postgres table where ther is set up an trigger event with hstore function to write to another table. While running in common SQL client with "public" search_path, there is no problem.I can't make it run in FME workspace, always getting an error:ERROR: function hstore(vfk.par) does not existwhere "vfk.par" is the table I'm writing to. I have tried to add search_path "public" setup in "SQL To Run Before Write" but with no luck. Any hints, please?-------EDIT: In another workspace with another schemas but with similar tasks it runs without errors as expected. The triggers with its functions are almost identical.

151

1 year ago

redgeographicsCelebrity

asked in Security

FME Hub items and security

I'm wondering to what degree items uploaded to FME Hub are checked? Are they considered "safe to download" or "use at your own risk"? Imagine a wild scenario where I would upload a custom transformer with a SystemCaller in it that formats the c drive, will that get flagged or not? (and what if I password-protect it?)

Filecopy renaming source file

Hello I’m new to FME. How do you rename a source_file (MapInfo.Tab) and copy it to another folder using a Filecopy writer? I've seen similar questions to this but I still don't know how to do it. I managed to replicate the Filecopy following the instructions here: https://knowledge.safe.com/articles/How_To/Including-files-dynamically-in-a-data-download-result .However, I want to rename my MapInfo tab file (which I am copying with the Filecopy) and I’m not able to do this. This is what my process looks like: The source table is named Car_Parking.Tab and I want it to be CARPARKING.Tab in the output folder. Landmark is copying fine and I don’t need to change the name. These two are part of a bigger workbench which copies many files. For now Car_Parking.* is copying as Car_Parking.* to my output. I did try various things -changing the _filename_part in an attributecreator, Fanout options (I managed to create a CARPARKING folder )- Creating a Path and file name reader... etc-

895

1 year ago

gis.analystContributor

asked in Data

Reproject ARCs in DWG files problem form one coordinate system to another

Hi when I reproject dwg file from NAD27_MTM_zone_10 to NAD_1983_CSRS_MTM_10 using Csmapreprojector, it reprojects all elements of DWG files execpts Arcs. is there any setting that handle this issue?

1 year ago

lribot

asked in Transformers

How update a column in a table with Variable Setter- Variable Retriever ?

Hi community! I would like update a column in my table with a variable. For that, I put in a VariableSetter my value that I retrieve after a Tester and with a VariableRetriver I recall my variable, and I want to insert this value of this variable in all the lines of my Code_Comma column.But it's doesn't work.Someone can help me please ? Thanks

143

1 year ago

mow

asked in Transformers

How to make multiple layers export as multiple tabs in a .CSV

Hi All, I'm very new to FME so excuse my noobiness. I'm bring in a roughly 20 shapefiles and running them through a attribute filter to pull out the ones with a matching project number, from there i'm exporting them out as a .csv. As it currently stands all results are put into one spreadsheet. not ideal. i would like them all in one spreadsheet but as separate tabs for each individual layer. As a work around i've made each layer its own attribute filter running to its own .csv writer, then i'm copying them into a single spreedsheet.

935

1 year ago

katericondoContributor

asked in Transformers

Create raster of counted polylines

Is there a way to create a raster of polylines, showing the counts rather than density per area magnitude? I have 17,000 lines and I'm trying to recreate the below graphic/visualization:

185

1 year ago

vxn43Supporter

asked in General

List all Shapefiles in a Folder?

I have hundreds of shapefiles in different folders and subfolders. I would like to create an excel file that shows three columns: Col1 = Name of .shp fileCol2 = Geometry of .shp fileCol3 = Directory/Path of .shp file For Transformers, I think I need to start with Creator - FeatureReader, then I get stuck.

653

1 year ago

ireenContributor

asked in Transformers

Convert json-file to ESRI line feature class

I have a json-file (see attachment) that contains the coördinates of a circular route. It looks like this:{ "segments": [{ "geometry": { "type": "LineString", "coordinates": [ [50.814103, 4.521174], [50.81309, 4.521811], [50.80626, 4.536902], [50.80482, 4.538866], [50.80573, 4.541452], [50.80621, 4.543173], [50.80705, 4.545501], [50.80755, 4.546541], [50.80777, 4.546841], [50.80919, 4.547739], [50.8096, 4.548199], [50.81052, 4.550243], [50.810663, 4.551096] ] }, { "geometry": { "type": "LineString", "coordinates": [ [50.810663, 4.551096], [50.81065, 4.555264], [50.81071, 4.555622] ] },... I want to convert it to an ESRI line feature class, but I'm stuck. The geojsonreader gives no error, but also no result as reader. Json-fragmenter gives me the list of vertices in an attribute, but I can't fix it to convert these points to

How to change the name of a repository on FME server?

Is it possible to change the name of a repository on FME server (2022 to be specific)? If so how?

Suppress annoying WARN messages of AutoCAD FeatureReader?

Is there a possibility to suppress annoying WARN messages of the 'Autodesk AutoCAD RealDWG DWG/DXF' FeatureReader? Please see the following example:I use the AutoCAD reader to read features from an DWG file. I am only interested in the features of one specific layer (specified by a user parameter):Hence, the AutoCAD reader reads the file and skips all layers but the specified one. In the log, the reader starts writing which layers are skipped. These messages are written at 'Information' level. After writing the 10th skip message, it writes a message "Further instances of this message will be suppressed" on WARN level. -----As text:2023-03-23 14:17:38| 1.8| 0.0|INFORM|AutoCAD Reader: Successfully opened the 'Release2018' AutoCAD file '<SOME_PATH>'2023-03-23 14:17:38| 1.9| 0.1|INFORM|AutoCAD Reader: Features for feature type '0' will be skipped based on the feature types requested2023-03-23 14:17:38| 1.9| 0.0|INFORM|AutoCAD Read

896

1 year ago

Page 66 / 398

Badge winners

samammashhas earned the badge Welcome Back
tatyana12has earned the badge Student (Grey)
david.van.dalenhas earned the badge FME Form Basic Training
logan.petershas earned the badge Integrate Data with the FME Platform Training
ivanbakkerhas earned the badge Student (Grey)

Show all badges

30,426: 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.