FME Form

Hi - I'm trying to run a SQL query on a MS SQL Server database using a SQL Executor in an FME Desktop workbench. The SQL query executes successfully in SQL Server Management Studio but fails in workbench. I'd be grateful for any advice on this. The SQL Executor returns the following error: Provider error `(-2147467259) Unknown token received from SQL Server' The query is quite long so I wouldn't expect anyone to try and identify the exact problem but would be grateful for any ideas on where to start looking and an explanation of what the error basically means (i.e. what is an unknown token?). Thanks for any advice you can offer. 

I have followed the tutorial attached link to build a dashboard to report on 250,000 records in a html report. Unfortunately this is my only option since we don't have FME server 2020. I am spending far too long to work out a way to stop the html file crashing as it tries to load all 250,000 records in the table. I am trying to work out how to convert the table to an array or other in javascript but I believe htmlreportgenerator is not designed for this. If anyone has a solution I can insert in the custom html that would be great. <div id="myTable" >               <table class="table table-striped">                  <thead>                     <tr>                        <th>Document Number</th>                        <th>TASK ID</th>                        <th>Document Stage</th>                        <th>Document Version</th>                        <th>Date Completed</th>                        <t

Hi, I have a json string, which I have flattened to a bunch of attributes (about 30), all have values 0 or 1. I'd like to query each attribute and output the list of attributes which have value 1 only. All of the attributes may be 0 for some records.Any suggestions what's the best way to achieve this. I could use a stringConcatenator, and find whether 1 exists, but it wouldn't give me list of attributes

Hi,I've a polygon/square ( 4 corners). The leftside should be extended to 2 metres to the left/east. I tried offsetter, but it moves thecomplete polygon. I only need 2 points/coordinates).Is this somehow possible?

I'll start simple and add detail as necessary. I am working with the workspace runner. I have a table that I want to select unique values on and export as separate point feature classes (a simple iteration).I have four unique values on 200,000 ish records.I have set up a workspace runner and plugged it into a unique attribute logger that creates the four values I want to use to make feature classes.It is being so finnicky I don't know where to start. Usually, it will create the first feature class, but with not nearly enough records - and not make the other three. The log file usually will say a lock caused a crash.However, it works perfectly sometimes and I can't figure out why. At noon I thought I was in business, after a good run. By 5:00, I was stumped. I set 'wait for job to complete' to 'yes' and it seems like it made all four feature classes four times - way too many records and it took forever.Is there a way to control locking? I don't know why i

I need help with ideas on how to extract areas where the width >=1.1m within a polygon. I have attached a file (file geodatabase) here for anyone who wants to give it a shot. It is a long and skinny polygon reflecting sidewalks with curb and gutter all connected together in reality.I have a solution working okay for a small number of such polygons. But it is not working efficiently enough for a large number of records. I have a total of more than 20,000 records to be processed.Please share your thoughts.Thanks!

Hi all, I have two fields Lat and Long which are my geometry fields. From this is there a way to have two more fields that can show X & Y using this information in same table? Reason is when i publish lat and long to my arcgis map it seems to move by 5-10m from the actual point.

Hello,  I have an excel sheet with Lon Lat values and I'm trying to convert them to points and then place them on a map that is in EPSG3857, however, the points don't land where they should be. I write it to a shapefile. Any help would be much appreciated.  I've also tried the AttributeReprojector but what do I select for the Source Coordinate System if it's coming from Lon Lat values? I did not find GCS_WSG_1984.The LON values are displayed without the -, sample: 114.2563, how can I add a dash to makes it -114.2563? 

Hi. I want to transform data from Oracle spatial to PostGIS. There are over 100 classes to transform. That's why I go with the option "generate workspace". For the writer I choose a PostGIS connection. In the Parameters I have to click the option "lower case attributs name". The same I need for the table name. If the table name is in uppercase letter, I'm not able to open the PostGIS database anymore. If I manualy set it in lower case letter, it works. But there are over 100 writers. Is there a posiblitity to set that generaly? To choose the function "import feature tye" is no option. In this case there is a lower case table name, but reader and writer attributes doesn't finde eache other.

Hi, I do not understand what is happening here. For example, line 32 doesn't have the same ID, but its still passed. Why?

When I have a @ symbol in a POST mutipart upload value  FME displays the below error when I run the work bench. This FME edition does not recognize the `' function. Please ensure that the current platform supports this function, the function name is spelled correctly, and that you have installed all required plug-ins I have used a string replacer tranformer and encoded with %40 as a workaround in the past, but with the form email validation on CKAN it does not accept the %40 encoding and expects an @ symbol. Does anyone have any idea how to upload values with an @ symbol in the httpcaller?

Hi, In FME Workbench 2020.2.1 I'm trying to create a new web service from the service named "safe.google-sheets.Google Sheets" (Google Sheet API v.4), but, unlike other web services, seems not to be possible: this service isn't listed in the list of choices. Could it be a bug? Thanks!

Hi, Encountering Error 'The arc collinear feature error(ORA-13346: the coordinates defining an arc are collinear)'. while inserting data into Oracle spatial. Please advice.

I have one input and only one output like below  there doesn't have any complication to run but i have nearly 1k+ repeated tasks.https://i.stack.imgur.com/vehJK.png

HiI have 2 feature class, I want to add the attributes from (the green polygons to the other feature class the red polygon) based on the location (Spatial join), is there any way to do this? 

When reading an Arcgis online feature layer I get this message. It has worked before and there are no problem with other feature layers: Python Exception <JSONDecodeError>: Expecting ',' delimiter: line 1 column 10367918 (char 10367917)

I'm trying to extract the Creation Date of an IFC file. It is usually located under IfcProject in viewers like Solibri, but I can't seem to find it.I want to read a folder containing a bunch of IFC files, and create a list of when the files were last created.

I'm writing features to a 12dXML file and I'm looking for some more documentation around the writer. All I found so far is the information here. I can see the reader creates the meta_data and project_attributes elements but it seems they can't be written properly. If I do create those as feature types in the writer, FME gives me below warnings and renames my output feature types. These outputs will then be interpreted as models instead (and will be contained in the model table as 'metadata' and 'projectattributes')TwelveDXML Writer: Warning, unsanitized name 'meta_data' will be renamed to 'metadata' following 12d Model naming rulesTwelveDXML Writer: Warning, unsanitized name 'project_attributes' will be renamed to 'projectattributes' following 12d Model naming rulesInterestingly, the project attributes and metadata I am writing into my project_attributes and meta_data feature classes will be contained in my written file, regardless. But still, I get models called 'projectattributes' an

Dear community, I've been scratching my head for a while and I know the solution should be a simple one but I can't seem to figure it out.  I have one source containing a lot of geometry. Each ID can have multiple polygon records. I have a list of specific IDs that I want to filter out. However the feature merger will only take the first record and leave out any 'duplicate'.  Short example: Project|Geometry|Ab1|1Ab1|2|Ac3|1|Ac3|2|Ac3|3|Ak1|1|Ak1|2| Desired result: Ac3 & Ak1Ac3|1|Ac3|2|Ac3|3|Ak1|1|Ak1|2| Is there an easy way to do this?  

The error number from ArcObjects is: '-2147220944'. The error message from ArcObjects is: {This version of the Geodatabase client is incompatible with the dataset and cannot open it. i am using an arcpro of 2.7.3 and fme 2020.2 64bit versions.

I have a SQL statement that contains a regexp_contains.  It works fine in BigQuery SQL Editor, but FME chokes on it before it even executes it in BiqQuery.  Even if I comment out the statement it still throws the same error unless I remove it completely.regexp_contains(table1.col1, '^[[:digit:]]+$')Do I have to escape this somehow? Error :Using Java Reader Interface Version 2.0 (Oct 31, 2000) with module GOOGLEBIGQUERY to read dataGoogle BigQuery: Using billing project xxxjava.lang.IllegalArgumentException: Illegal group reference

Hi,I am able to use iCloud as data provider in the FME AR app, but when I try to open the same file in Google Drive the file is greyed out.Does anyone else have the same problem? Read More ( vietnamese languae ) : thay pin iphone 11 and more sửa iPhone hcm

I am new for FME actually. I have FME case C657637 generated. but is any support to open the case? it is about dissolving line segments.

I want to filter out duplicate points from two point feature classes, however, every SpatialFilter configuration I have tried returns the duplicate points as failing all predicate test. Am I missing a configuration step?

Hello,Every time a run workbench I get this error near the end. Postgres doesn't print any errors in the logs. AttributeManager_2_OUTPUT Feature Counter -1 17 (TeeFactory): Cloned 60483 input feature(s) into 60483 output feature(s)Error executing SQL command ('COMMIT'): 'Error connecting to database'POSTGIS writer: A fatal error has occurred. Check the logfile above for detailsFeatureWriter_2 (WriterFactory): POSTGIS writer: A fatal error has occurred. Check the logfile above for details Any idea of what is going wrong?