Transformers

Hi there, I have installed the pandas library into my workstation using the following command:fme.exe python -m pip install <package_name> --target <package_destination_folder> and got following message:Successfully installed numpy-1.18.1 pandas-0.25.3 python-dateutil-2.8.1 pytz-2019.3 six-1.14.0 However, when in python Caller I tried to import pandas using the following command:import pandasand ran the transformation, it throws an error message:Python Exception <ModuleNotFoundError>: No module named 'pandas' Could anyone help me in fixing the error? 

Hello! Is it possible to extract coordinate pairs (lat/lon) that are within an actual shapefile boundary as opposed to using a bounding box of a shapefile? When I use the BoundsExtractor transformer I'm getting more points than warranted. Thanks.

I would like to change the table names of my citygml file. How can I realize that? I need it in order to transform my citygml to an imx file. thank you in advance.

I hope the title is already quite self explanatory.To illustrate the issue,I generated some (lowercase) text strings with 10 to 50 characters, using the methodology that was described by cwarren in the topic https://knowledge.safe.com/questions/88643/random-letter-generator.html.I first used a stringsearcher transformer with the pattern '.*?a.*'I then also used the FindRegEx stringfunction in an attributemanager for the same expression, with various combinations for configuring the optional parameterswhile including or excluding "" characters around the regex patternwhile including or excluding the ^ and $ anchors (for 'start of string' and 'end of string')I tried searching for only part of the string in the stringfunctionwhile also trying various combinations of greedy vs nongreedy searches.i.e. '.*?a' is a non greedy search to match 'zero or more' (i.e. '*') of 'any single character' (i.e. '.'), until the first

I have a data set with multiple repeated values such as thisADAADAADABentonCanyonCanyonDearbornDearbornDearbornDearborn and I want to increment a count every time the preceding value is different than the next value.so my 'count' would be like1 - ADA1  ADA1 - ADA2 - Benton3 - Canyon 3 - Canyon4 - Dearborn4 - Dearborn4 - Dearborn4 - Dearborn

Hello - I have a file geodatabase where most feature classes contains an attribute 'text_desc'. I would like to extract all unique values, and concatenate those into a single comma-separated attribute to generate a report. Due to slow gdb read times in FME, I would like to do this in PythonCaller for efficiency. Is this possible?

Hello, Is there a way to change the style of bullet points in a word written with fme? Thanking you in advance

I think bei Problem is to handle the traits and to attach them to the Objects.

I want to trigger a FEATUREREADER to run only if there are records that pass a tester. But I don't want to pass all the records to the FEATUREREADER, only trigger the reader to start. The passed tester records will be used in a different transformer but I also want to trigger the reader to start if there are any records that pass the tester. What is the best way to accomplish this? Thanks, David

I'm having an issue with the FeatureWriter where it writes to a database successfully but the features don't come out of the Output Port which I need to continue the transformation.  Why aren't the features coming out of the Output Port? In the screenshot, 3 records are written to the database but do not come out of the Output Port. Since I'm writing to an ArcSDE database and I can't control the GlobalID, I have to write to the database then re-read the features after the GlobalID have been written.

The counters have to all be on the detailed data. I have tried putting the attributes to group in the counter name but this second counter is restarting each time and I want it to be incremental - as per the attached.Both counters are set to Local and have different counter names.I'm sure its something very simple I am missing but I just cant work it out

How can I expose the raster feature information? Looking to expose the band values.

I have a DWG that I am trying to create a polygon from to represent the extents of the data.The polyline data doesn't seem to be able to be coerced to form a polygon and I am unsure why.I have tried to aggregate the polylines into a single feature, but no luck.

I'm trying to create 3D Buildings (Lod1) from shapefile, I extrude the buildings but I can't see the 3D models in FME (and inspector). While in FZK everything is OK, what am I doing wrong? PS. I use shape file from OSM

Hello,I have an Excel file with WKT format geometry in two separate columns (attributes, correct?) that I am struggling to encode without creating duplicate rows (features) or overwriting one or the other. Using GeometryReplacer, I can replace the geometry separately, but if I chain them together, only the last one is shown as it goes into 3D Coercer. If the GRs are in parallel, they create duplicate rows. It is important to keep the row structure intact.  Above, the Boundaries and Rep. Points transformers are the GeometryReplacers. Obviously, this is no good, but it is the only way I can see both attribute geometries. This what I want (but without the dupes):Ideally, it would be something like this, but it doesn't work:Per the "Go with the Flow" article, if the Workspace takes each feature(row) through the process before moving on, why does GeometryReplacer negate the first GR (Boundaries) and just encode the last (Rep. Points), even though the source attributes are

Hi, I'm using FME to parse a JSON file and eventually upload specific parts to an Oracle table.One concept I'm not sure how to approach is, what to do when the JSON has a nested list, that is always a different size?Would the JSONFragmenter be the best option in this case, or something like the JSONExtractor? When using the JSONFeature reader, I can only get one item of the list at a time. I've attached a snapshot of how the section of the JSON looks. 

I have a workspace that reads from non-SharePoint sources and writes to SharePoint. I am using a change detector along with fme_db_operation to insert, delete, or update accordingly. However, I recently noticed an error message that the updates were not updating and required a sharepoint_item_id.  1) Is there a way to update SharePoint without the sharepoint_item_id, perhaps on a separate unique attribute, or is sharepoint_item_id mandatory? 2) If 1) requires sharepoint_item_id, what is the best way to attach sharepoint_item_id to records. I can imagine a reader, then join, but wondering if there is a best practice for these cases. Thank you, Tyler

As the title says, I have a city limits boundary layer and a emergency service boundary layer. I want to ensure the city limit boundaries do NOT move but I want to adjust the the emergency service boundary that covers a city to match the city limit boundary if needed. Any ideas? I am going in circles looking and testing the various geometry validation and topology tools but am struggling with how to isolate the city limits layers from not moving in the process. Thanks in advance!

I have one problem with getting the right height of the polygons as shown here in CC.

Hello, just started FME a few days ago. Have an Excel file with 3 columns containing geometry in WKT format. How do I translate into readable geometry? Example: POINT (2648.81837074121 433.2500) Thanks

I want to translate my fbx mesh in local coordinates to a rectangle region in EPSG:4326. The mesh XY bounds has the same ratio as the rectangle region. I tried reprojecting the mesh from XY-M to EPSG:4326 and apply an offset to shift it to the rectangle center, but the reprojection doesn't seem to change the mesh vertex coordinates. How can I translate the fbx mesh in arbitrary coordinates to a point (or the origin) in EPSG:4326 coordinate system?

Hello. I am trying to make a transformation in the values of a certain field called Labeltxt in a feature type in a gdb. I change the value in the field. This succeeds, but when I need to write back into the gdb i have a problem: Either i use "drop and create" in the writer, but then the objectID field is re-written, which we use to relate to other tables.  Or i use the "update" "use existing", and then select "labeltxt", but then the field is not changed in the gdb that is written. Is there a way that I can retain the Object ID and also change the labeltxt value? Regards Rasmus

Hi, I'm experimenting with bit shifting in FME, and I do not get the expected results. In FME 2020.1.0.1 (see example workbench), (255 << 24) is transformed to a 64 bit integer, and gives me 4278190080. in Postgres database this operation gives the expected result of -16777216. I'm using Postgres as a reference since eventually the results of my FME script will be stored there and used by other applications. I don't understand what I'm doing wrong (or should do to achieve my expected result), and hope somebody can help me out. Thanks, Richard.  

I am trying to think of ways to use the newly available CurveFitter to speed up work processes. Could the resulting data be saved to a PostGIS database? It seems so from the documentation I have found, but the info is very vague. If PostGIS would not work, is there some other database format that would accept the curves/arcs? 

Hi, I've converted GDB file to 3d tiles via FME. These created titles are working fine. But,  i get the this warning at console:    This b3dm header is using the legacy format [batchTableJsonByteLength] [batchTableBinaryByteLength] [batchLength]. The new format is [featureTableJsonByteLength] [featureTableBinaryByteLength] [batchTableJsonByteLength] [batchTableBinaryByteLength]    This tile uses a lowercase refine "add". Instead use "ADD". Required property geometricError is undefined for this tile. Using parent's geometric error instead.  what could be the reason for this?