FME Form

I'm trying to run a workspace in FME Server and I'm getting a message: "The workspace has Python Compatibility set to 'Esri ArcGIS Python 3.9' which requires ArcGIS Pro...." I have ArcGIS Pro installed. The workspace runs fine in FME Desktop.

Hi list.I have a dataset with mixed date/time formats in a single field.I want to create a cascade to transform these, i.e. "Try this format", and if it fails, "Try that format", etc.HOWEVER, when data are output on DateTimeConverter's rejected port (signalling a data error), the field value is cleared, rendering a cascaded approach impossible. Why is that ??Is there a way to avoid this unwarranted nulling of a possible valid field value ?Cheers.

Can anyone advise the most efficient way to bulk extract attribute string lengths?

I've used the AUTOCAD_OD Reader to get the table and Attribute Manager to add the column and this seems to work. I've even output to an Excel spreadsheet to see that the column has been added, but I can't figure out how to get the change back to the Original drawing. Any suggestions are appreciated.

I'm trying to create a conditional parameter value in a WorkspaceRunner, based on an attribute value. I can do this, as the WorkspaceRunner is allowing me to fill in conditional values for the parameters, however, every time I click OK and reopen my WorkspaceRunner, all these conditional values are reset and again replaced by their hard coded values, as read from the model that the WorkspaceRunner is calling.Is there a reason for this behaviour or is this just a bug?I'm using FME 2018.1 build 18547 WIN64.

Hello, I am looking for the equivalent to the "Append Fields" tool in Alteryx, where many rows from one table are replicated for each row of another table. For example:Table 1:Table 2:Target Table:I've searched and experimented, but can't seem to sort it out in FME. Any advice? Thanks!

I have an FTP Caller that keeps throwing the error: FTPCaller (FTPFactory): FTP info: Failure establishing ssh session: -43, Failed getting bannerFTPCaller (FTPFactory): FTP info: Closing connection 0FTPCaller (FTPFactory): HTTP/FTP transfer error: 'Failed initialization' I can access the file on the ftp site using other ftp clients, and I have tried different configurations of the FTPCaller but I can't get this to work and I can't find much info on the error. Has anyone seen this before? Thanks!

I have multiple tables and need to check if their schemas conform to specs which are specified in text files containing field names separated by line breaks. How can I compare if the field names are mapped correctly?

Hello!I have a challenging work to do. I have 3 differents vectors data (DataVector1, DataVector2 and DataVector3 ) which i've extracted from a pdf file. And, I have also from the same pdf file, the location of the three Datavectors (boundaries). The boundaries is also a vector data that i've extracted from the pdf. However, the boundaries boxes are smaller compared to the limit boundaries of the Datavectors. Now, I need to scale and shift all my 3 Datavectors into the boundaries boxes. How can i do this ? knowing that the coordinates are in local values ( fake coordinates from PDF). After that, I'll do a manual georeferencing, since I know real coordinates of 3 points over the whole 3 Datavectors.Anybody, have some hints ? Thank you in advance !

At first you get the warning: 2022-06-08 09:00:12|  1.4| 0.0|INFORM|Creating reader for format: Oracle Spatial Object2022-06-08 09:00:12|  1.5| 0.0|INFORM|Performing query against ORACLE_SPATIAL dataset ` ----'2022-06-08 09:00:12|  1.5| 0.0|INFORM|ORACLE Reader: Using Oracle Reader to read tables from database `', server type `ORACLE8i', server name `----', user name `----, password `***'2022-06-08 09:00:12|  1.5| 0.0|INFORM|ORACLE Reader: Using Rich geometry.2022-06-08 09:00:12|  1.5| 0.0|INFORM|Loaded module 'OCI' from file 'OCI.dll'2022-06-08 09:00:12|  1.6| 0.1|INFORM|Environment variable ORACLE_HOME is not set.2022-06-08 09:00:12|  1.6| 0.0|INFORM|Connecting to ORACLE database `----' with user name of `----' and password of `***'2022-06-08 09:00:13|  1.6| 0.1|WARN |Error connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'. (serverType=`ORACLE8i', serverName=`----', userName=`---

Hello,I have a georeferenced dwg file with lines, polygons and text that I'd like to convert to kml for view in Google Earth complete with the AutoCAD layers. I have been successful with creating a KML file that opens in Google Earth but still some problems. when viewing in FME Inspector everything except the text shows and the layers are missing. When I open the file in Google Earth only the points show and on the Places bar each object is shown on a long list, I want to see the layers like in Autocad and do not want to see the individual objetcsLooks very promising otherwise.Thanks

Hi,I'm using the TopologyBuilder to create relationships between water mains (the edges) and the valve furniture (the nodes). Our corporate GIS (Gwater, Oracle based) has an start and end node for each feature to show connectivity, but ARCGIS does not . These values do not exist and I have to create them to align the two GIS systems.So far the results have been good, as the corporate GIS feature can only connect to two other features. This doesn't happen in ArcGIS for one particular type of feature called a cross valve, which connects 4 mains pipes.I can find the 4 pipes a cross connects to, but not the direction in which they connect to create the east-west and south-north connectivity. There's nothing in the topologybuilder output which suggests this relationship:  I was wondering if I can use the spatial location of the pipes that the cross connects to to determine which one is easterly of the cross, westerly and so on:Any idea how this might be achieved? I can then use

I have set up a http caller with query string parameters. It would appear that the server throws a 500 error when its finished returning the records. Does not appear to affect results but would like to get rid of error.

I can not access views in my oracle DB neither with the oracle non-spatial reader nor with a SQLExecutor.Is there a workaround?The FME Help also talks uniquely about tables, never views.Oracle Non-Spatial Reader Parameters (safe.com)

Hello Sir / Madam,​I have many files (more than a hundred of files in .json format - text). I would like to extract certain text from each of the .json files and put all the text in a single text / csv file for further study.​I am just wondering if it is possible to do it on FME? Or what transformer I would use?​Here is what I really want to get for my report.​File name; errors number (spacing for "no error"; it could even better if I can output "no error" instead of spacing)​Output sample as follow:banana_report.json;102;203;204;303;305;306;307;a_report.json; ;​My .json file sample is uploaded for your reference. Basically, the information that I need is at the "all_errors: []"​Hope somebody would give me a hand on this issue. I am really appreciate that.​Thank you very much!​Zach

I have been trying to change a file extension from .bil into .flt based off this link https://community.safe.com/s/question/0D54Q000080hEslSAE/how-to-change-filename-extension-via-fmeBut I cant get the FeatureMerged to merge what am doing wrong?There will be other files and different file types in the same Folder so not sure yet, if this process/workflow will change the other files as this would not be desired.But for now I'm just trying to get the FeatureMerger to work.

Due to a number of custom coordinate systems used by the organization - I have to use ESRI Reprojector to set the CRS of some incoming data. So CoordinateSystemSetter is out of the question unfortunately. I used a PythonCaller and Arcpy to generate the string required, based on this help doc - in the format of ESRIWKT|<name>|<esriwkt> where <name> is the coordinate system name, and <esriwkt> is the WKT (Well-Known Text). sr = arcpy.SpatialReference(int(FME_MacroValues['EPSG']))str = 'ESRIWKT|{}|{}'.format(sr.name, sr.exportToString())feature.setAttribute('coordsys', str)But I'm getting this warning, (and the crs applied is not correct). the EPSG code I tested with was 5383.Datum definition SIRGAS-ROU98 does not exist.Ellipsoid definition wkt_auto_1 does not exist.Esri Reprojector: Specified geotransformation `' (forward) may be inappropriate for reprojection from `_FME_0' (GCS: `GCS_SIRGAS-ROU98') to `_FME_0' (GCS: `GCS_SIRGAS-ROU98') using the ESRI reprojection

80192022-6-6 16:37:01 | Unable to flush the cursor for the feature class 'BCNCAR' because the spatial index is too small. Increase the spatial index on 'BCNCAR' and retry80202022-6-6 16:37:01 | GEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for details Weekly we download all .000 Electronic Charts, run them through a workbench which writes to Oracle. The workbench runs but throws this errors, so were not getting as many records as we should. Attached is the workbench.  FME Server 2021.2.5Build 21816 - win64Oracle 19CArcmap 10.8.1 with 64 geoprocessing extension

Hello FME'ers,A slightly late What's Up Wednesday because of the webinar I was in yesterday. But it's still packed full of fun and useful content... FME Community WebinarOur FME Community webinar was yesterday. If you're interested, you can find the recording on our website or on YouTube. We also have a blog about it too.  We showed how to use FME to crowdsource data for an ArcGIS Online map (even if it did get a bit slow at times), and we played a City Guesser game that was pretty cool. Dale and I managed to describe and demonstrate the FeatureTypeFilter transformer (picked at random by a marble race) and the FME Scavenger Hunt was launched. Oh, and everyone got a free lunch on us. And afterwards... well, these are the bits that got cut out of the official recording! Enjoy. FME Scavenger HuntThe FME scavenger hunt is up and running.   So far we have 37 players, making up 9 teams, including our first company team, "Team Abley" from New Zealand. There are currently 5 missions to complet

Im a very beginner with FME. I've a polygon (gpkg) file, which has several attr. columns. 3 of these column contents should be under one column. I prob. need to create new column where to put contents of these 3 separate columns, right? How? Thanks!

I'm attempting to transform the input Rain Gauge data set to the desired output as shown in the above inserted image but I'm at a loss on how to proceed? The important factors are:The time period is defined by the user, in this example 01/01/2022 - 10/01/2022 and the output table needs to include all days in that range.The input Rain Gauge data only contains data for when it rained so not all dates are included.I need to some how produce a column per Rain Gauge reference, then look up the associated rain fall value for each of the days and populate the new table structure.The number of rain gauges can vary. I have completed the process of creating a list of all dates for the requested time period. I can't begin to fathom how to manipulate the data as shown and explained above.If completing this in Excel I would have created a pivot to produce the table below:  Any help will be gratefully received! Thank you.

Note: only change exact word not combination words .it posible change exact multiple words in StringReplacer and StringPaireReplacerrock=Star  nove=9     RAW sourceNormalized nove9correctnovember9mberincorrectrockStarcorrectrockstarStarstarincorrect

In my attribute table, I have a field named "City" and in this field we have differents cities except a city which is in 2 or 3 fields. But the transformer "Duplicate filter" doesn't display this information and displays cities which are uniques. So I think it doesn't work. What is the problem?  Thanks for helping

Hi everybody, I have a seemingly trivial problem that I can't solve: I would like the name of a file inside the zipfile produced by FME Server data download service to be the same as the one produced by FME Desktop (maybe statically defined or by some parameters/attribute values) instead of a random meaningless name. Any advice? Thanks

So far I can only see a writer for Presagis .flt (OPENFLIGHT), I'm assuming this in nothing like the ESRI binary format