FME Form

I have two polygon datastets and i send them to the Topology Builder so that they will get break at the intersection. However it does not give the result I expected. My expectation would be a similar result to thearea on area overlay  my output looks. The overlapping area are not broken. Any idea what i may have been doing wrong 

Hi Community,I need to extract a CSV Style content from a SQL field of an SQL table.It is stored into a single field.The content looks like this:Classification,Fonction03-1,30003-2,301AA-10,C-1000AA-12,C-1000AA-15,C-1000AA-17,C-1000AA-20,C-1000AA-22,C-1000AA-25,C-1000AA-27,C-1000AA-30,C-1000As you can see, the first line gives me the Attributes names and the following lines gives me the valuesWhat would be the best way to turn this into multiple features using the first line as the Attributes names ?Thank you

Hello forum, I am working on a new API integration. I’ll be using HTTPCaller. The provider has said that their authentication method is ‘bearer token’ However the options in HTTPCaller are Basic, Digest, NTLM, Web Connection, Single Sign-On. Is one of the those options equivalent to bearer token? Thanks,Stuart

Shall we consider installing a Graphic card while preparing a machine for FME Form installation. How a Graphic Card impacts on the performance of 3D / 2D data processing.

Trying to find a  way to find the maximum amount (highest density) of polygons with the rulethe polygons must be non-neighbouring. Essentially selecting a polygon and jump to the next polygon which is not neighbouring and so fort and so on until you encounter a neighbouring one.See attached picture which I hand-picked.

Hello fellow FME-ers. I'm looking for a transformer to compare two GIS datasets and what has changed compared to each other. Actually, the Symmetrical Difference tool that is present in ArcGISPro. This transformer must be there in FME. Can anyone help me with this? Thanks in advance.

I have a test looking for many possible cases. one of the cases I want to find is Any folder inside of any folder that has some specific names. (BTW I am using directory and File Pathname reader to create a list) and then a tester to get all of the special cases.)I have a test line like path_directory_windows CONTAINS *\project_data\working\**\*I don’t get any errors with this syntax but it does not find the folders. Basically i am only wanting to find folders within any project_data\working folder that contain any files.If it doesn’t contain a file I am not concerned with it.Any help with a correct regex statement that would work, or the proper syntax for the contains statement are what i am needing.I have tried this regex unssuccessfullyproject_data\/working\/[^\/]+\/[^\/]+TIA 

I'm trying to read annotation feature class from ArcGIS file geodatabase. For further processing, I need to check 'Split Complex Annotation' and 'Split Multi-part Annotation' in the reader.The annotation in ArcMap looks like the above image. It's in vertical alignment: baseline, horizontal alignment: center.While after importing from FME reader, it becomes to:Any safer partner could explain how FME calculate the anchor point of spitted text? seems the anchor point set to right bottom corner. And will the split consider the ArcGIS alignment setting?

I’m trying to use FME to split out any “Complex” or “Multi-Part” annotations that exist in the dataset and have the “Complex” or “Multi-Part” deleted and insert the split records as new annotations.On my FeatureReader, I have both "Split Complex Annotations" and "Split Multi-Part Annotations" enabled and I am able to delete the old records and insert the new records. However, I’m running into an issue with the geometry of the newly inserted records.From another post it looks like FME splits complex annotations tries to preserve the location of the text but loses other text placement characteristics like the original complex text geometry (lines) and converts them to a point for each split text item.'Split Complex Annotations' when reading ArcGIS geodatabase annotations

I need to extract TAB or Shape file from S3 and read data from it including schema.I have discovered in this articlehttps://community.safe.com/data-7/how-to-extract-the-actual-shapefile-from-featurereader-geometry-and-attributes-14548?tid=14548&fid=7that FeatureReader apparently can’t read all attributes that are in the file, until I expose them. But what is I don’t know the list of all attributes? I don’t know what exactly will be uploaded by other people to S3 bucket, I just need to read the file.  Could you help, please, to identify the correct settings of FeatureReader or another way to extract data?

Hi, I am trying to make a simple WS (with only one transformer) to change the schema! Translation runs successfully but I dont see the final gdb . The error on the Inspector is showing that "failed to specify the feature index as constraints on the reader". What should I add and where? Both my reader and writer are File Geodb Open API.

In the JSON transformer documentation, there is a sub-section on JSON Query, which states: JSON Property ExpressionsA property expression is a structure expression as described above, followed by a . (dot) operator and a property name. Currently, the only supported properties are type and size. The type property returns the type of the JSON value referred to by the JSON structure expression. For example, if the outermost JSON element is an array, and the first element of the array is a string, then the expression json[0].type would have a value of string. The size property, which can only be applied to an array, returns the number of elements in the array. For the life of

We have not been successful in setting up a web connection for our GCP environment.  Therefore, we use JSON key files.Has worked just fine via a PythonCaller to read the file and fill in GOOGLE_APPLICATION_CREDENTIALS.  If we had a need to write to a different GCP project we would change the project_id in the JSON file.However, we were contacted by billing recently saying that since we use the project in our JSON file that another area was getting billed instead of our ETL project.We tried to fully qualify using the project id and then the schema in the writer, but that did not work.  It always assumes that you are writing to the project in the JSON file.Is there a way around this issue?

I’m attempting to access an AWS marketplace free resource, NOAA’s bathymetry, but with Anonymous access if I enter us-east-1 as the region I cannot manually specify noaa-bathymetry-pds as the bucket and I cannot get a picker, or not that I can see.  Is there a trick?  Thanks.

Hi there,I have an Ascii grid file.The FME can read the file I have also added a Raster Cell Coercer transformer to create a shafile this simple workbench works fine. Issue - How the raster values can be displayed in the shapefile. The shapefile has no attribute data (cell values).I need to display the raster values in the shapefile. Any hints will be greatly appreciated.Thank you very much,Sebastian Algardi-CamusWorkbench Raster image 

Hi, as a newbie in FME, I am using a FME ISO8211 reader to expose some of the attributes for further transformers. However, if all records have to be read, a message “Message #706501 is not present in the message file: Parameters are >< and FME HOME is >C:\Program Files\FME\<” was prompted and the whole process was halted. The FME version I am using is FME2018. Thank you for the kind response!

I have an asbuilt with a table that has all the locations/names of  the structures.   The table layer name  is “text” and when i bring in  the drawing, the text layer is empty. Im sure its how i have my parameters set up so a little guidance on how to read this would be great. 

I am trying to upload ifc data through PostGIS Writer and while doing so, I want to generate and store the time of upload as well. However, it gives the following error: “Value of attribute 'begin_lifespan_version' could not be converted to type 'timestamptz'. Feature will be logged and skipped.” can someone help? I am a beginner in FME as well.  

Hi all, Since upgrading to FME 2021, I have found previous workspaces that were working in 2020 are now not working. This appears to be when multiple datasets are referenced in a WorkspaceRunner and through a user parameter. It concatenates the filepaths together and loses the double quotes and separation, causing the reader to fail. Any help would be appreciated. Kind regards,Jack  

Morning, I am trying to transpose some data from a survey, I want to sort of Pair up the Postcode and the Question Number, then have columns of Responses with counts. Ive attached images  and a fme workbench of the original data and the output I want. I have 36 questions, so want to know if there is a way to do this using a list? So I dont have to repeat this 36 times, I am not understanding how to do lists!I want to output the postcode as a column, then have a question number column. So each postcode will be repeated depending on the number of questions e.g.Question No    PostcodeQuestion 1      M19 4NYQuestion 2     M19 4NYQuestion 1      M4 7ATQuestion 2     M4 7AT Then I want the next columns to be counts of the answersQuestion No    Postcode  Strongly Agree      Agree      Neither    Disagree     Strongly DisagreeQuestion 1      M19 4NY             2                         3

I have a complicated collection of features stored in mongo db, where a given feature may have multiple unique geometries stored as individual arrays. I would like to use the “Put” Operation in the writer to replace specific features. However when I write to mongo I get two different results (see screenshots of dummy feature with just one example geometry).location.coordinates{} attribute type set to stringlocation.coordinates{} attribute type set to doubleThe desired outcome would look like this:Re

I am working with MongoDB trying to upsert nested MongoDB documents. The JSON format would be something like:{“name”: “XXX”,“tables” : [ {“name”: “XXXX”,“num_rows” : 3423,“fields”: [         {“name”: “XXX”, “type”: “yyyy”} , ….     ]}, ….] I have no problems when I use a JSON string attribute inserting a new document with Document Source”: Json Attribute” and Insert operation.But, I do need to UPDATE existing features.In this case, the nested dcouments (tables in the json above) are created as plain strings.  Which is a real inconvenience in my use-case.{“name”: “XXX”,

Dear, I want to link all the lightposts to the nearby road segment. I used a buffer around the road segments and then Neigborfinder to do this. Now I am afraid that some lightposts are not linked to the roadsegment but I am not eager to increase the buffer or neigborfinder because maybe lightposts that should not be linked will be included. Is there maybe another way to bypass this? Or some tips you could give me?

When I use the aggregator, the IFMELine becomes an IFMEMultiCurve.I don't want the IFMELine to become a IFMEMultiCurve. How can I prevent this?