Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
jugoslaviaa
Enthusiast
jugoslaviaaEnthusiast
asked in Integration
Tolopoly Builder wont break polygon

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 

744
joepk
Influencer
mlupien
Contributor
mlupienContributor
asked in Transformers
CSV content from SQL field to Features

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

596
mlupien
Contributor
scarter
Contributor
scarterContributor
asked in Authoring
HTTPCaller and 'bearer token' authentication method

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

7448
virtualcitymatt
Celebrity
nitinshahane
Contributor
nitinshahaneContributor
asked in Integration
Is it necessary to install Graphic card for using FME Form (Desktop)? How it impacts the performance?

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.

2512
liamfez
Influencer
lennertpronk
Contributor
lennertpronkContributor
asked in Transformers
maximum amount of non-neighbouring polygons

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.

412
lennertpronk
Contributor
fme_dr22_forum
Contributor
fme_dr22_forumContributor
asked in Transformers
looking for a transformer tool in FME to compare two GIS datasets

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.

2308
liamfez
Influencer
gisbradokla
Enthusiast
gisbradoklaEnthusiast
asked in Transformers
tester with wildcard for "only" any folder following

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 

1228
gisbradokla
Enthusiast
R
ruochen
asked in General
'Split Complex Annotations' when reading ArcGIS geodatabase annotations

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?

924
jar
Contributor
jar
Contributor
jarContributor
asked in Transformers
How do you Split Complex/Multi-Part Annotations while maintaining text geometry?

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 annotationsIs there a way to create or preserve the complex text geometry for these split records? The converted points seem to be causing an issue in a downstream program with the following error:Error from downstream program: “Err

560
jar
Contributor
K
kennysoe6450
asked in General
Hi, I am trying to convert some images stored in base64 format to .jpg images. I have uploaded data to canvas as Reader - .csv format, Transformer - TextDncoder Write - .jpg format Can someone help me out to set up the process Thanks Ke

 

5066
david_r
Celebrity
marias
Contributor
mariasContributor
asked in Data
How to replace FeatureReader transformer?

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?

631
liamfez
Influencer
jaygrg111_
Contributor
jaygrg111_Contributor
asked in General
Where to add feature index to reader?

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.

2984
kumudan
Contributor
dbaldacchino1
Enthusiast
dbaldacchino1Enthusiast
asked in Data
JSON Query - "size" & "type" not working

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 me, I cannot find any other documentation on this and am unable to get it working. I tried a similar example to the one described above ("columns" is an array) but I get the following error: The JSON query 'json["columns"].size' cannot be used to produce features. String expressions and pro

1107
dbaldacchino1
Enthusiast
jbradfor
Contributor
jbradforContributor
asked in Integration
Google BigQuery Connector and Auth

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?

1471
kailinatsafe
Safer
bruceharold
Supporter
bruceharoldSupporter
asked in Transformers
The S3Connector doesn't let me enter a bucket name manually, what's the trick?

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.

551
bruceharold
Supporter
salgardi
Contributor
salgardiContributor
asked in Transformers
Ascii to Shapefile -

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 

1082
salgardi
Contributor
chlaw2001
Participant
chlaw2001Participant
asked in Authoring
FME Message #706501

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!

460
chlaw2001
Participant
pearly1
Contributor
pearly1Contributor
asked in Data
Correctly reading table in CAD

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. 

721
daveatsafe
Safer
kersy
Contributor
kersyContributor
asked in Data
Value of attribute could not be converted to type 'timestamptz'.

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.  

1353
danminneyatsaf
Safer
jacklonsdale
Contributor
jacklonsdaleContributor
asked in Integration
FME bug causing failure in Workspace Runner, multiple datasets

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  

934
crystalatsafe
Safer
sar_copp
Contributor
sar_coppContributor
asked in Data
Transposing Using the postcode and question number as a pair, possibly a list?

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               1               0                      2Question 2     M19 4NY             5               

532
sar_copp
Contributor
liamfez
Influencer
liamfezInfluencer
asked in Authoring
Writing Geometries to an Attribute in MongoDB3

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:Referencing other community posts on related matters:After reviewing those other community posts I think I am going to need an alternative method to what I had started to develop. But I wanted to see if anyone had any ideas or experience with mongo writers to say otherwise.Thanks

362
txalaparta
Contributor
txalaparta
Contributor
txalapartaContributor
asked in Data
MongoDB writer with nested documents

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”,“tables” : [ “{“name”: “XXXX”,“num_rows” : 3423,“fields”: [         {“name”: “XXX”, “type”: “yyyy”} , ….     ]} “ , ….]Valid datatypes do not currently include arrays (of objects)  Is there any alternative or workarounds?         

422
liamfez
Influencer
olivier2
Contributor
olivier2Contributor
asked in Authoring
How to connect all the right points while not including the

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?

1085
jkr_wrk
Influencer
sshafiq
Participant
sshafiqParticipant
asked in Transformers
How to keep only one line when using aggregator

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?

553
redgeographics
Celebrity

Badge Winners

Show all badges

Community Stats

31,801
Posts
120,812
Replies
39,424
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.