FME Form

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

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:

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 t

Hello everyone, Allow me to ask you because I would like to set up an alert system based on this urban furniture file.I create two filters one for the condition of the furniture and the second for the management department.It does send an email the problem is that if I have two entities it makes me two emails.  How can I transform to group my entities to send only one email?help, please =)

Is it possible to change the name of a repository on FME server (2022 to be specific)? If so how?

Is there a possibility to suppress annoying WARN messages of the 'Autodesk AutoCAD RealDWG DWG/DXF' FeatureReader? Please see the following example:I use the AutoCAD reader to read features from an DWG file. I am only interested in the features of one specific layer (specified by a user parameter):Hence, the AutoCAD reader reads the file and skips all layers but the specified one.  In the log, the reader starts writing which layers are skipped. These messages are written at 'Information' level. After writing the 10th skip message, it writes a message "Further instances of this message will be suppressed" on WARN level. -----As text:2023-03-23 14:17:38|  1.8| 0.0|INF

How do I Copy SHAPE column from an ESRI GDB feature class to a non spatial Postgres database?