Skip to main content
  • EN

Unanswered questions

10000 Posts
kmc5678
Contributor
kmc5678Contributor
asked in Transformers
How do I spatially select polygons that have a set of points that fall within them, merge the attributes of the point and polygon datasets and then write out only the polygon features?

I have a large polygonal dataset and a point dataset with 178 records. I need to select the polygons that have a point within them, merge the attributes of the two and then write out a polygonal feature class to later be consumed in GIS project inside Arc Pro. I have tried Point On Area Overlay but the output Point data does not contain any attributes from the Polygonal dataset and vice versa. I have also tried Spatial Relator / Spatial Filter with no luck. Any suggestions greatly appreciated!

90
kmc5678
Contributor
1 year ago
jdh
Contributor
jdhContributor
asked in Data
Kakadu compatible JP2000

Has anyone encountered issues with 4-band jp2000 files written by FME Server crashing in Kakadu?  The error is:"A `jp2_channels' object indicates the presence of "      "more colour channels than the number which is associated with the "      "specified colour space. This may happen while reading a JP2-family "      "data source which contains an illegal channel definitions (cdef) "      "box, or it may happen while writing a JP2-family file if the "      "`jp2_channels' object has been incorrectly initialized." 

110
jdh
Contributor
1 year ago
J
josk
asked in Transformers
Why do I get 404 error when reading WMS?

I have a WMS that I can open in e.g. QGIS. Both the FeatureReader and the OGC WMS reader can show me the different selectable layers in "Properties". But when I start the translation, I get a 404 error saying it cannot be found. This is the WMS I'm trying to read: https://geodata.naturvardsverket.se/planeringsunderlag_o_strategier/wms?layers=Sannolikt_och_potentiell_kontinuitetsskog  Why and what can I do about it?

350
J
1 year ago
L
lking_gis
asked in Transformers
What are best practices for handling special characters that cause HTTPCaller to fail?

We are using HTTPCaller to batch geocode thousands of records, but we are running into an issue with special characters that are causing the HTTPCaller transformer to fail. As a workaround, we've been using multiple (20+ at this point) String Replacement transformers to catch and modify the special characters before going to HTTPCaller.  Geocoding the same input table using the Geocode Table wizard in ArcGIS Pro completes without issue.  Are there certain characters that HTTPCaller cannot handle, or is there a better or more robust workaround than using String Replacements? Can anyone offer insight into why the input table geocodes successfully in ArcGIS Pro without any data sanitization/cleansing in ArcGIS Pro, but fails in HTTPCaller?  Thanks in advance for any help you can over. @natalie_campos​ @acueva​ 

1120
L
1 year ago
kmc5678
Contributor
kmc5678Contributor
asked in Transformers
How do I compare the total record count of the same 4 feature classes in 2 file geodatabases and then send a notification email if the counts are exactly the same?

I'm currently using a file gdb reader, a statistics calculator to get the total counts, attribute manager to create fields called Today_Count and Yesterday_Count and then the conditional value in attribute manager to try and compare the two counts and return a 1 if they're exactly the same but I can't seem to get the comparison to happen. Also how do I set this up so that if the counts are exactly same I can send out an email notification?

260
kmc5678
Contributor
1 year ago
fmesafe.podpora
Contributor
fmesafe.podporaContributor
asked in Transformers
ACAD to SVG

Hello. I have a question please. I have a DWG resource that I need to transform to SVG. I managed to export the geometry, but I don't know how to bind the styles - line weight, transparency, etc. Can someone please advise? Thank you

800
fmesafe.podpora
Contributor
1 year ago
jaygrg111_
Contributor
jaygrg111_Contributor
asked in Transformers
Can AGOL Feature Service writer be used to write pdfs on AGOL?

Can AGOL Feature Service writer be used to write pdfs on AGOL?

50
jaygrg111_
Contributor
1 year ago
psprague
Contributor
pspragueContributor
asked in General
Select data from one table based on a filed from another table

I have two tables. One is a large ODBC table in which I only want to extract the data when the modification date is greater than the last date of another table. The SQL for what I want to achieve is simple ; SELECT * FROM table1WHERE modwhen > (SELECT MAX(modwhen1) FROM table2);Any help is appreciated.Thank you,  

30
psprague
Contributor
1 year ago
A
alex_rump
asked in Transformers
Raster to Vector flow creates only triangles

So, I have a little issue, that I cannot get to the ground of. Maybe someone can help. So, I have this TIF File, which I am trying to convert into a SHP file. This is how the TIF looks: And this is how my FME Flowchart looks like:  But... When I let it run I get a SHP file, yes, but it looks like this:  Lots of triangles instead of one solid block. Can someone tell me, what the issue is? What am I doing wrong?

140
A
1 year ago
proteve
Contributor
proteveContributor
asked in General
How to replace text in dwg with help of xls spreadsheet

How can I replace different texts in a dwg file with the help of pairs of search/replace data from 2 columns in an xls table?

1020
proteve
Contributor
1 year ago
pmcpherson
Contributor
pmcphersonContributor
asked in Transformers
Does the SchemaScanner add an extra character to the fme_varchar(n) attribute?

Does the SchemaScanner add an extra character to the fme_varchar(n) attribute?

90
pmcpherson
Contributor
1 year ago
M
mritunjay4code
asked in Architecture
Can I use non-prod license on prod server

Hello,I am upgrading my fme server on production. I want to spin up a new server on prod, can I use the non prod license on this new prod server for few moments in order to check if everything is working fine ? I'll switch to prod license once I confirm if everything is working.

230
M
1 year ago
C
clives_online
asked in Transformers
FGDB with 0 feature inside

Greetings,I have a weird issue where the ESRI FGDB writer runs with NO error messages.It writes out to an ESRI Shapefile, but the FGDB has 0 records???This is the FME output Total Features Read                                                      68587=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-                           Features Written Summary=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Hazards_3857_20230613_Geom                           11021Hazards_3857_20230613_NoGeom                         11021Hazards_3857_Geom                                    11021============================================================================Total Features Written                                                   33063   The output in the FGDB? Any assistance is appreciated, it is really frustrating. 

70
C
1 year ago
marias
Contributor
mariasContributor
asked in General
FME Flow error reading .shp.xml file

I am getting an error when run a workbench on FME Flow. The workbench supposed to extract shapefile from S3 bucket and write it to the database.The shapefile has very complicated and big area in it. Not sure if it matters. The total size is 300Mb. Log file has just this error: Job doesn't fail, it looks like it is stuck. It lasts for hours, more than 12 hours. I had to cancel it.  I thought that the problem is explicit with shp.xml file. But I checked previous uploads and there were successful ones. Even with this file.  Please advice.

520
marias
Contributor
1 year ago
E
ember168
asked in General
The FME exported obj model has no name attribute, it is all defaultobject, how to set it, I need to use cesium to design a simple query system to associate attributes through nodename

The FME exported obj model has no name attribute, it is all defaultobject, how to set it, I need to use cesium to design a simple query system to associate attributes through nodename

40
E
1 year ago
R
rdickins
asked in Automation
Automation not triggering via external calls (Survey123, Postman)

I have followed the instructions here. Step two doesn't function properly. I have submitted surveys to the webhook url, postman requests, but nothing has triggered the automation, the log is empty.  However, if use an http caller from a workbench, I can trigger the automation.

170
R
1 year ago
sunsilk11
Contributor
sunsilk11Contributor
asked in Transformers
Write to Raster dataset from asci files

Hi, I am reading a bunch of asci files and use a raster mosaicker and trying to write to a raster or mosaic dataset.I have trued seting creating new attributes geodb_raster_path set to fme_dataset and geodb_raster_type to 'Raster'. or 'Raster Catalog'I am getting error message: The raster type 'Raster Catalog' for mosaic dataset 'zzDataset' is not supported by the installed ArcGIS version 

180
sunsilk11
Contributor
1 year ago
G
gronan1
asked in Integration
Failure UPDATING existing versioned ArcPro sde table with Esri Geodatabase (ArcSDE Geodb) writer.

Currently trying to UPDATE isolated features within an existing Versioned sde table (ArcPro Only) using the Esri Geodatabase (ArcSDE Geodb) writer. Considerations: Schema has been Imported from DatasetTransaction Type has been set to: Versioned Edit SessionSuccessfully written to a TEST.gdbTable has been READ into workbench, joins and ETLs applied to data, then attempting to WRITE to same table back in SDEHave toggled Ignore Relationship Info to no availError Code:Error while updating feature in the table/feature class 'Addressing'. The error number from ArcObjects is: '-2147207389'. The error message from ArcObjects is: {}

750
G
1 year ago
fmesafe.podpora
Contributor
fmesafe.podporaContributor
asked in Transformers
Automatic value insertion

Hello. I would like to ask. I have a workspace where, see the attachment, I have set a time filter (red frames). I would like to store various dates in this format in the database, for example the date for each specific month. Each cycle, a new date from the database would be automatically replaced by this filter based on the number of validly executed workspaces. Can this be solved somehow? I would probably solve the individual cycles with some kind of "counter" transformer, it will be more complicated to insert the date. Go in the direction of some parameterization? How do I ensure that the correct date is always set on the test filter? Thank you very much

60
fmesafe.podpora
Contributor
1 year ago
A
awieckowicz
asked in Automation
Execute a collection of jobs in parallel using an HTTP GET request with query string param.

I need to be able to trigger a collection of workbenches to run (preferably in parallel) using and HTTP GET request. I need to be able to pass the ArcSDE transactional version name as a parameter in the get request to an FME server process (automation or similar).  The client application an ArcGIS workflow manager step and it cannot make post requests.I have gotten this to work using a single published workspace using a GET request to the trigger service passing in the version name like so:protocol://<SERVER>/fmejobsubmitter/P1907/TRANS-VERSION-TEST.fmw?TRANSACTIONAL_VERSION=”owner.JOB_402” But this only works to trigger a single job. I also attempted a webhook and manual trigger automation that runs multiple job in parallel but it seems that you can only trigger these types of automations using POST requests and the client doesn’t support this.Are there any other options? Could I create a workbench that that acts as simple proxy and creates a post request to the manual trigger a

250
A
1 year ago
jamesb16
Contributor
jamesb16Contributor
asked in Transformers
I need to filter out CSV date by closed and within a specific time frame. I am able to find all closed items but when filtering out by DateTime Calculator, its getting rejected.

I am doing the completion date subtracted by number amount(200 days) using Subtract Interval or Interval between dates using the completion date - DateTimeNow. the FME rejection code is INVALID_INPUT. Any suggestions is greatly appreciated

9012
jamesb16
Contributor
1 year ago
nitinshahane
Contributor
nitinshahaneContributor
asked in Transformers
Can we migrate the data directly to Esri UN model geodatabase instead of migrating to Asset Package GDB, using FME Desktop?

Can we migrate the data directly to Esri UN model geodatabase instead of migrating to Asset Package GDB, using FME Desktop?

170
nitinshahane
Contributor
1 year ago
smclaugh1
Contributor
smclaugh1Contributor
asked in Data
How do I parse this kind of data?

I have a logfile I need to extract some info from but I'm not sure what to use. Here's an example of what I have.<Msg time="2023-06-05T19:55:23,511" type="INFO" code="9029" source="Rest" process="35236" thread="1" methodName="" 

60
smclaugh1
Contributor
1 year ago
paulot
Contributor
paulotContributor
asked in General
LogCount_func changed process locale and terminates workspace

Hi, just wondering if anyone can interpret this log message for me and tell me how to change the workspace encoding under Windows, if that will help. Thx! (am including all the software version details for reference) Starting translation...Current FME version: FME 2022.1.1.0 (20220728 - Build 22623 - WIN64)FME_HOME is 'C:\\Program Files\\FME\\'FME Desktop Smallworld Edition (floating)Permanent License.Machine host name is: FBC-19-0068lOS Locale Name   : en_USOS Locale Encoding : windows-1252Process Encoding  : UTF-8FME API version: '4.0 20220615'FME Configuration: FME_BASE is 'no'FME Configuration: FME_MF_DIR is 'I:\\GISSBX\\ELECTRIC\\FBC_010_CA_Dashboard\\MXD/'FME Configuration: FME_MF_NAME is 'Condition Assessment Dx.fmw'FME Configuration: FME_PRODUCT_NAME is 'FME(R) 2022.1.1.0'Operating System: Microsoft Windows 10 64-bit (Build 19044)...The workspace was authored with a system encoding of 'windows-1252'. This will be the encod

1770
paulot
Contributor
1 year ago
blackheart
blackheart
asked in Transformers
SQL SERVER Views to Create Snowflake Views

I have SQL SERVER DATA where ii need to migrate views only to Snowflake is there any way to create the views in FME and migarte data SQL Views to snwflake

341
blackheart
1 year ago

Badge winners

  • Welcome Back
    asmallhas earned the badge Welcome Back
  • Student (Grey)
    m.vlamingshas earned the badge Student (Grey)
  • Welcome Back
    davidmooneyhas earned the badge Welcome Back
  • Integrate Data with the FME Platform Training
    gertnerhas earned the badge Integrate Data with the FME Platform Training
  • Teacher (Grey)
    arild_fhas earned the badge Teacher (Grey)
Show all badges
30,171
Posts
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.