FME Form

i want to create excel is group by complexFolder name same (complex Folder) value have each excel

Hi, It's been a while that I couldn't Add Web Connection for using GoogleBigQueryConnector. Previously it's working well, but after re-install my FME desktop, it's always return Error 401: disabled_client when I try to add web connection using my google account.Error 401: disabled_client Sign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In. Request DetailsThe content in this section has been provided by the app developer. This content has not been reviewed or verified by Google.Could some one help me what's wrong here? 

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

We noticed that the speed of data writing to the DGN format depends on the type of objects. If we set the cell object at the beginning the writing was fast, then at the end, the speed slowed down several times. And the question is, is it a writer's trait or an object's trait?

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.

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

Good morningI want to generate a json file that accompanies a photograph and I want the name of the json file to be the name of the photo which is contained in a 'Photo' attributeI also want as many json files named with the name of the photo as there are photos in my source directory.I tested in the json output to put the Photo attribute in the entity name but it doesn't work.Thanks

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 🙂

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.

 However, I would like to directly read the same file from a URL.Therefore, i have changed the published parameter accordingly (see screenshot attached). The following error messages is produced:Emptying factory pipelinehttps://www.opengeodata.nrw.de/produkte/geobasis/hm/dgm1_xyz/dgm1_xyz/dgm1_32_372_5714_1_nw.xyz.gzPython Exception <FileNotFoundError>: [Errno 2] No such file or directory: 'https://www.opengeodata.nrw.de/produkte/geobasis/hm/dgm1_xyz/dgm1_xyz/dgm1_32_372_5714_1_nw.xyz.gz'Traceback (most recent call last): File "<string>", line 24, in input File "gzip.py", line 58, in open File "gzip.py", line 174, in __init__FileNotFoundError: [Errno 2] No such file or directory: 'https://www.opengeodata.nrw.de/produkte/geobasis/hm/dgm1_xyz/dgm1_xyz/dgm1_32_372_5714_1_nw.xyz.gz'Error encountered while calling method `input'PythonCaller_3 (PythonFactory): PythonFactory failed to process featureAn error has occurred. Check the

Hi,Does anyone know why a shapefile generated in FME would not work in lastools? I am using lastools to clip a point cloud using a buffer from FME but it can't read the shapefile. I don't know why it is invalid, only that my command line has the following errorAny help would be appreciatedThanks

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

There are many FME transformers that allow you to select one or more attributes for analysis. In this case, I have about 350 attributes in a CRCCalculator and I would like to select about half of them. It would be much easier if could select them in a group rather than individually. Is this possible? I've tried using the standard shift-click - clicking the first checkbox and then doing a shift-click somewhere down the list on another checkbox to grab everything in between - but no luck. Is it done another way? I'm using FME 2020.1.2.1 (Build 20624).

Hello everyone, I need help with the graphs below. I need to maintain the original structure for the graphs. Using the line builder changed the output structure, as you see below. I have an extensive dataset, some lines are correct, but some created their structure and direction. IMG 1.0 and IMG 2.0 are the original graphs. Some lines have around 500 vertices each, but I used a generalizer and changed from 500 to 2 vertices per line. I don't want them to reduce that much. I am looking at around 200 vertices maximum for each without changing the original graph formats. Which transformer can solve this? Thank you so much.

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

Hi I have two datsetes containing gps time and I need to join but non based on distance but based on timeIn short I need to find the point A with the time more close to the time in table B can you help please ?thx Francesco 

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

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? 

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

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.

I renamed a hosted feature service in ArcGIS Online and now need to update the name in a few FME workspaces (FME Desktop 2020.1.2.1 - Build 20624). But how? The feature service path is not editable under Parameters and neither Update nor Import Feature Types accomplishes the task from what I can see. It looks like I can do so using Find and Replace in a text editor but I'm not entirely comfortable with that solution. Is there a standard method I'm overlooking? And yes, I will be replacing the feature service name with the item id moving forward so this is no longer an issue. 🙂

Hi All, I was wondering if its possible to retrieve attachments from one feature service in portal and insert them into another table within a different feature service in portal. I am able to read the attachments however i dont understand how to write these attachments back to another table without using the arcpy interpreters.

I am using the clipper to clipp some polygons. It failed with the rejection for 3 features as INVALID_CLIPPEE_GEOMETRY. But when i run the same rejected features through GeometryValidator with issues to detect "all" the same features pass.  Resolution is in meter. Node 0 and 1 are almost identical which causes the rejection i believe. But how can I setup FME to catch this duplicate of nodes ? 0: 575677.0999999503, 7032470.9899999991: 575677.0999999512, 7032470.9900000012: 575683.7099999504, 7032482.7799999963: 575677.0999999503, 7032470.989999999

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-

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?