FME Form

Hi I have two datsetes containing gps time and I need to join but non based on distance but based on timeIn short I need to find the point A with the time more close to the time in table B can you help please ?thx Francesco 

I am trying to add an ArcGIS Server Feature Service reader to my workspace. I just need one of the layers from the service. Several of the layers have the same name but are differentiated by their parent layer (which are scale dependencies). FME Desktop Help claims it shouldn't be a problem, stating "The reader resolves ambiguity by appending the layer ID to the end of feature types if multiple layers share the same name. If a layer ID is present in the feature type, the ID takes precedence over the name." That doesn't appear to be happening because I receive the following when I select my desired layer and try to add it: "ArcGIS Feature Service Reader: Found multiple layers/tables that match the feature type 'Stations, PNM (4)'. They are: 'Stations (4), Stations (10), Stations (16), Stations (22), Stations (28), Stations (34), Stations (40)'. Resolve the ambiguity by specifying the layer/table ID in the feature type." Ok, but how? I do so in

I have encountered a problem when formating a datetime. A log is raising a warning when the value is null. In order to avoid warnings in log I try to setup a condition in AttributeManager. I would like to reuse (copy/paste) the condition definition so I try to use "@CurrentAttribute". It's working as expected in Attribute Value part, but not in the test condition (see attached image).If I use @CurrentAttribute() ATTRIBUTE_HAS_A_VALUEI get <null> results despite the attribute has a value. Any suggestion how to set up the condition for current attribute correctly? 

Hi all.An I correct in assuming, that FME cannot handle non-point geometries, i.e. with multiple nodes, when some nodes have Z values, and some don't ?I'm seeing that GeometryReplacer adds dummy Z values (0) where they're missing when importing from WKT og GeoJSON.Is this a problem with the transformer only, or a more general problem with the handling of Z values ?In a system we're running on FME Server, I need to replace any missing Z values with an official fixed value: -99. This is done using the 3DForcer. But if I can't control missing Z values during import, things are very problematic.I made a small test workspace, and ran it in 2020.2 and 2022.2, and both exhibited the same behaviour.Cheers

I would like to insert to a Postgres table where ther is set up an trigger event with hstore function to write to another table. While running in common SQL client with "public" search_path, there is no problem.I can't make it run in FME workspace, always getting an error:ERROR:  function hstore(vfk.par) does not existwhere "vfk.par" is the table I'm writing to. I have tried to add search_path "public" setup in "SQL To Run Before Write" but with no luck. Any hints, please?-------EDIT: In another workspace with another schemas but with similar tasks it runs without errors as expected. The triggers with its functions are almost identical.

I renamed a hosted feature service in ArcGIS Online and now need to update the name in a few FME workspaces (FME Desktop 2020.1.2.1 - Build 20624). But how? The feature service path is not editable under Parameters and neither Update nor Import Feature Types accomplishes the task from what I can see. It looks like I can do so using Find and Replace in a text editor but I'm not entirely comfortable with that solution. Is there a standard method I'm overlooking? And yes, I will be replacing the feature service name with the item id moving forward so this is no longer an issue. 🙂

Hi All, I was wondering if its possible to retrieve attachments from one feature service in portal and insert them into another table within a different feature service in portal. I am able to read the attachments however i dont understand how to write these attachments back to another table without using the arcpy interpreters.

I am using the clipper to clipp some polygons. It failed with the rejection for 3 features as INVALID_CLIPPEE_GEOMETRY. But when i run the same rejected features through GeometryValidator with issues to detect "all" the same features pass.  Resolution is in meter. Node 0 and 1 are almost identical which causes the rejection i believe. But how can I setup FME to catch this duplicate of nodes ? 0: 575677.0999999503, 7032470.9899999991: 575677.0999999512, 7032470.9900000012: 575683.7099999504, 7032482.7799999963: 575677.0999999503, 7032470.989999999

Hello I’m new to FME.  How do you rename a source_file  (MapInfo.Tab) and copy it to another folder using a Filecopy writer? I've seen similar questions to this but I still don't know how to do it. I managed to replicate the Filecopy following the instructions here: https://knowledge.safe.com/articles/How_To/Including-files-dynamically-in-a-data-download-result .However, I want to rename my MapInfo tab file (which I am copying with the Filecopy) and I’m not able to do this. This is what my process looks like:  The source table is named Car_Parking.Tab and I want it to be CARPARKING.Tab  in the output folder. Landmark is copying fine and I don’t need to change the name. These two are part of a bigger workbench which copies many files.  For now Car_Parking.* is copying as Car_Parking.* to my output. I did try various things -changing the _filename_part in an attributecreator, Fanout options (I managed to create a  CARPARKING folder )- Creating a Path and file name reader... etc-

Hi when I reproject dwg file from NAD27_MTM_zone_10 to NAD_1983_CSRS_MTM_10 using Csmapreprojector, it reprojects all elements of DWG files execpts Arcs. is there any setting that handle this issue?

Example: First user parameter is choice type with values is Provinces (Ha Noi, TP.HCM, Da Nang...)Secondary user parameter is also choice type with values is Districts (Hai Ba Trung, Dong Da, Ba Dinh,...)I select User Parameter 1 with a province and it'll filter and just show choice are districts of this provinceIf you know how to solve let's show me! Many thank! 

Hi community! I would like update a column in my table with a variable. For that, I put in a VariableSetter my value that I retrieve after a Tester and with a VariableRetriver I recall my variable, and I want to insert this value of this variable in all the lines of my Code_Comma column.But it's doesn't work.Someone can help me please ? Thanks    

Is there any guidance/documentation available on the best approach to take when upgrading an distributed installation of FME server based on the Azure marketplace images?

Hi all,I wish to extract some objects from GESW to Shp file. In this I want to extract some of objects which all present in the internal world in GESW.All the suggestions are welcome!Thank you in advance ! Regards,Saravanakumar.

I am using the FeatureReader to connect to an ESRI SDE. I have specified the features to read, and selected Output Ports: One per feature, BUT out put ports are not being created for the features I specified. In only the default ports are available.  I am having a similar issue with another FeatureReader that is pointed to a FGDB. I had to change the directory path for the FGDB and now all of the output ports are gone. I reset all of the "Features to Read" but like the above, I am not getting out put ports for the features I have specified.  In the above there are no Output ports for the features specified.in the above only some of the Output ports for the features specified are available.

The folder that should be containing the .fmeks file has .jceks files. Everything was working correctly before I upgraded to ArcMap 10.8.1. Error message is attached.

Hi All, I'm very new to FME so excuse my noobiness. I'm bring in a roughly 20 shapefiles and running them through a attribute filter to pull out the ones with a matching project number, from there i'm exporting them out as a .csv.  As it currently stands all results are put into one spreadsheet. not ideal. i would like them all in one spreadsheet but as separate tabs for each individual layer. As a work around i've made each layer its own attribute filter running to its own .csv writer, then i'm copying them into a single spreedsheet.

How do you setup an authenticated websocket? We have a websocket that we need to connect to and then transform the data in FME. The connection is an authenticated one, the behaviour is attempt connection to the destination and port, the socket server then expects an a string as authentication. How do we send this in FME?  Preference is to use a notification or an automation.  Don't want to use a transformer as tis requires an extra engine I believe.

I have a layer of assets in 1 layer and another layer of assets of ours in another layer. I need to find out which assets arent touching eachother. Spatial filter? use the failed ones that come through? how do i make a new layer of the failed ones?

Is there a way to create a raster of polylines, showing the counts rather than density per area magnitude? I have 17,000 lines and I'm trying to recreate the below graphic/visualization: 

I have hundreds of shapefiles in different folders and subfolders. I would like to create an excel file that shows three columns: ​Col1 = Name of .shp fileCol2 = Geometry of .shp fileCol3 = Directory/Path of .shp file For Transformers, I think I need to start with Creator - FeatureReader, then I get stuck.

We have a workspace on a FME Server that creates PDF files using Adobe Geospatial PDF Writer in FeautreWriter.The files are transported into another system via PDF.js. Apparently PDF.js can't transport tagged PDF-files (?). Can I somehow make the FeatureWriter creater non-tagged PDF-files?Or is there other ways to get around this issue?

Hello,I would like to creat a server app in version beta 2023 and I have some user parameters in my workspace that use the conditional visibility. After publishing the workspace in FME Server 2023, the order of user parameters get wrong (using conditional visibility, after selecting an option, the next parameter should be displayed under or after the first parameter but it displays before the first parameter and it is confusing)Do you have any idea how can I fix the order in FME Server? Thanks

Hi all, I try to use the ArcGISOnlineConnector to update an existing Survey123 Form item on ArcGIS Online, but no success this far.  When I choose Request type 'Update' and upload a zip-file with the same contents as downloaded via the 'Download' action I get the fme_rejection_message:"file must have AGOL item type 'Form'" and fme_rejection_code INVALID_FILE. When I slightly adjust the downloaded zip file by removing the folder 'esriinfo', leave its contents intact and zip these files again with the same file name, it still shows this rejection code. This latter file structure is actually the same as in a blog post by Esri that demonstrates how to use the AGOL REST API and update the item in a Python script. So I expect this to work:https://community.esri.com/groups/survey123/blog/2017/12/08/an-alternative-way-to-update-the-media-folder-of-a-survey123-form-item Any ideas on how I could get this working with the ArcGISOnlineConnector?

I have a json-file (see attachment) that contains the coördinates of a circular route. It looks like this:{ "segments": [{  "geometry": {   "type": "LineString",   "coordinates": [    [50.814103, 4.521174],    [50.81309, 4.521811],    [50.80626, 4.536902],    [50.80482, 4.538866],    [50.80573, 4.541452],    [50.80621, 4.543173],    [50.80705, 4.545501],    [50.80755, 4.546541],    [50.80777, 4.546841],    [50.80919, 4.547739],    [50.8096, 4.548199],    [50.81052, 4.550243],    [50.810663, 4.551096]   ]  },  {  "geometry": {   "type": "LineString",   "coordinates": [    [50.810663, 4.551096],    [50.81065, 4.555264],    [50.81071, 4.555622]   ]  },... I want to convert it to an ESRI line feature class, but I'm stuck. The geojsonreader gives no error, but also no result as reader.  Json-fragmenter gives me the list of vertices in an attribute, but I can't fix it to convert these points to