FME Form

Hi FME team I started on using FMEObjectsDotNet4.dll and started reading CHM helpand I started to write some simple code, and I'm stuck on mapping FMEReader GEOMETRY column to another GEOMETRY column in FMEWriter FMEReader is from shapefile but the target database oracle table has 2 columns and I want to directly update to 2nd column, and seems cannot find the right "keyword" in CHM help, also the samples is not really helping with this problem C:\\Program Files\\FME\\fmeobjects\\dotnet\\apidoc\\FMEObjectsDotNet4.chmC:\\Program Files\\FME\\FMEObjectsDotNet4.dll Also in IFMEOWriter seems lacking IsOpen method to check whether the connection still open or notso we can do something about it. Maybe like manually commit ..    on another topic:1) is there a NUGET feed from you for this library like Telerik nuget feed

I'm not sure what I'm doing wrong, but I'm trying to move data from a editing GDB environment to a production GDB. Everything else works fine, except when it comes to importing the relationship class for my attachments. I get the error:  "Unable to create table/feature class/relationship class of type 'geodb_invalid'. Creation of this type is not currently supported by FME, and must be done through Esri tools" Does this mean I can't import the relationship in FME and should be doing it in ArcGIS Pro? Thank you.

In a file geodatabase (GDB) to GDB translation, I am writing dynamically to a blank (unpopulated) template GBD that has relationship classes. From a source GDB I am reading features both from feature classes that participate in relationships and from the relationship feature classes themselves. I get the usual geodb_feature_has_relationships and geodb_oid format attributes on the participant features, and I get the usual geodb_type (= geodb_relationship in this case), geodb_rel_origin_oid, and geodb_rel_destination_oid format attributes on the relationship features; however, to keep the workspace generically dynamic and reusable, I need to determine--during translation--the names of the origin and destination feature classes for the relationship classes being read. Of course, I know what those feature classes are before runtime, but the dynamic, i.e., non-prescient, workspace does not. Is runtime determination of the origin and destination feature class name

Line:01020000A0E610000005000000E040A17B843554C0C987F51E7593414000000000000000006CDB4900853554C0AFD3A0F17893414000000000000000002D2683FB813554C0D677B1BD8E93414000000000000000005A484B8E7F3554C025457646AB9341400000000000000000C4B449797B3554C01A0A32C8AC9341400000000000000000 Using SQL the wkt converts to these 5 points:  -80.83621111628918 35.15201174725332 0,-80.83624274456605 35.15212841370464 0,-80.83605850036174 35.1527936092895 0,-80.83591039039439 35.15366440558345 0,-80.83566124151099 35.15371038859685 0 Lat and long are also reversed in the output. I would like to do this conversion in FME for spatial analysis of the full data base. Thank you,Matt 

I have this equation in Excel:=A2-($A$2-$G$2)*B4/SUM($B$4:$F$4)this A2 and B4 has to change every row. so that the value I just got from the current row calculation needs to be used in the next step.9.83,8.82,7.56,6.41,5.41,5minus0,1.01,1.26,1.14,0.99,0.4it starts with 9.83-0, then 9.83-1.01, then the result which is 8.81-1.26 and so on.how can I write this equation? or how can I get the result of previous row calculation in the current row?

Hi community, A client I am working for recently upgraded their FME Desktop/Server installation from version 2018.1 (20180717 - Build 18520) to 2021.1 (20210730 - Build 21619). I upgraded the workspaces and I am currently in the process of testing. I noticed that a workspace ("gdb2gml.fmw", attached to this thread) behaves differently in FME Desktop 2021.1. The purpose of this workspace is to read a File Geodatabase, map the attributes to a specific format and write to a GML. The output file (GML) is validated against an XSD file (XSD-file and input GDB also attached to this thread).  The validation in the GML writer should fail. The File Geodatabase contains an illegal feature (a multipart polygon) which is not allowed as a geometry for this feature class. In the GML writer, the setting 'validate output file' is set to Yes. In FME Desktop 2018, this multipart feature is detected by the validation and the workspace fails.

Hi, I am working on two excel-files that I wanted to merge with address. Unfortunately I am struggling to merge with the address since they are formatted differently for each excel file. For example: Alex Olssons Road 50 - Alex Olssons road 50 There are more strange cases where there are lower and upper case letters between each spaces. I wanted change the attribute for addresses in both files so that all the letters are in uppercase and all spaces are removed to make it easier to merge. For example: ALEXOLSSONSROAD50 Any ideas what transformer I should use?      

I need to revisit this answer, that I find to be a limited work-around, not a proper solution.The offending and unsupported type "mediumint" is not from the MS/SQL database, where data are sourced, so it has to be something that FME itself generates on the fly. Aka a bug.The database table has a field named ID, which is an "int" (32 bit), and it uses an identity value.This is how the schema feature sees the field:I really cannot understand, why FME cannot transfer this to a table in a Geopackage. The very same schema

With FME upgrade to 2021.2.0.1 my workbenches are failing . I have used aggregator and geometry Validator . Also it gives application error if I try to run it from Command prompt.

Greetings,I am finding the settings...AutoCAD Reader > Parameters Tab> General Section > Layer Name field, Allowed Geometries field.....greyed out. How can I access and change these settings? Thank you,Tyler FME 2022.1

Currently reading in e57s, filtering the geometries to point cloud and raster. Running some routines on the point cloud to reduce the number of points and would like to combine the original rasters back into the e57 writer. So far, point cloud comes out fine, but no images. Thanks

Greetings,What is the best way to duplicate a writer? Using copy/paste only duplicates the annotation. Thank you. TylerFME 2022.1

Hey everybody,I have a huge csv file with the attribute field "modify_date" and the date is in "Timestamp" - format (so for example 746841600000).I would like to have it in ISO Date format (1993-09-01 02:00:00).Is there any transformer which can do that? The Date/Time Converter is not able to do that... Thanks in advance.Cheers,Fabian

This question comes just after a question about lines snapping I asked: https://community.safe.com/s/question/0D5Dm000005KcrfKAC/linecombiner-with-attribute-not-working Input data are snapped and combined lines, which form a whole network. Each lines being snapped before, there should not be small holes between these. In order to have a proper network and edges and nodes relationship, I use the TopologyBuilder.From 3935 lines as input, it creates 3935 edges and 3502 nodes. But in these nodes, there are a few duplicates with a distance of 10e-6 meters... Even if before that, the lines have been snapped with 1 meter value.The location of these duplicates is often at nodes where the touching lines come from different datasources (Po

I have an issue with a httpcaller trying to call an app server. It makes the same call for a number of times for different customers replacing only the custumer name in the URL. For most calls it is working but for at least one call I get the error HTTP transfer error: Server returned nothing (no headers, no data) after exactly two minutes. On the app server it processes the call for about 8 minutes before returning an answer. However it seems the httpcaller has already "given up" by this point. Timeout is set to 1200 seconds.  It seems to be an issue with FME or the workbench of some kind, but I just can't figure it out. I hope somebody can help.  Regards Rasmus

I have troubles in using the LineCombiner, with 2 different datasources as input. The first is fme_line from Postgis (MultiLineString, but deaggregated) and the second is fme_line from Shapefile. Both have the same projection system, are in 2D, and have the same attribute schema: only "troncon_id" as string which should be used as merging attribute. I would like to join common line between the two datasources and produce a unique dataset. Hower, the resulting data a correctly merged when coming from the same datasource, but not merged for lines with the same troncon_id and common point (Qgis snapping option). They do not overlap or intersect.Here are the parameters used:An example of not combined lines :

How do I convert .osm data into shapefile using FME?

Can FME server run multiple jobs at same time?I found FME server can run a job at a time. Others are in queue. Can we set FME server to run multiple jobs at same time? such as 2-3 jobs a time?

Converted ArcGIS Pro Annotation (geodb_pro_annotation) to Standard Annotation (geodb_annotation) with the help of Dynamic File Geodatabase reader and Dynamic File Geodatabase writer. Enclosed the developed FME workspace template for your reference. However, when opened the generated output Standard Annotation (geodb_annotation) feature class in ArcMap (version 10.8.1), getting an error saying "One or more layers failed to draw". Please refer to enclosed screenshot from ArcMap and help to advice how to handle this situation.  Found no issues with the output when used Static File Geodatabase reader. However in our case, need to use the Dynamic File Geodatabase reader only. Thank you..! Note: Enclosed FME workspace created using

Hi, We have a complex FME bat, compound of 3 FME schemas that we produced in 2019 and it works with 2019.2.3.2 FME version. It is true that it takes about 24 hours.  With the newer versions of FME, meaning everything that is newer than 2021 or even latest's versions from 2020 we get the 'Adjusting Memory Resources' message while performing PointOnArea. We tried different options currently available on FORUMS, try split the data even more without results and and we would like some more ideas.  Below is an extract of the log file. 2022-11-13 10:43:20|4389.2| 15.4|INFORM|PointOnAreaOverlayer (OverlayFactory): Computing relationships between 11770563 input areas and 23979 input points 2022-11-13 10:54:54|4554.8|165.6|INFORM|ResourceManager: Optimizing Memory Usage. Please wait... 2022-11-13 12:40:57|10158.7|5603.9|FATAL |Insufficient memory available -- error code was 2 - please read the FME Help section 'Adjusting

Hi, I am reading an Oracle spatial table (points) and i only want to write it to AGOL. I have 17624 records in the source. When the feature layer is created I only have 12.000 records. Or with another try I have 10.000 records. The table of the feature layer is also created and I see the atributes. In AGOL you get a thumbnail wich basically shows what you have created. That turns white so it looks like there is no geometry. When I open the layer the map is zooming to the right extend but also no points to view. i tried written the feature layer again with only one attribute in it. That went well. How can I solve this issue.FME desktop 2022.2.0.0. (build 22765)

I have a workspace that reads data from a long list of DWG files and writes specific features to a SHP file. The status the drawings could be anything, including corrupt so I have Rejected Feature Handling set to Continue Translation. When the workspace runs, I can see in the log that some DWG files are skipped for various reasons. A new problem occurs when it hits the attached DWG file. It is a Civil3d file and the log shows that FME finds a resource to read it, but then it just sits there and nothing happens for a few minutes until I get an error.  For now I have deleted the file from the list, but it would be better if the workspace would simply skip it and go on to the next file. How do I do this?

I have made a workbench that contains an Emailer. I did not notice this directly, but the Emailer is a Package. I saved the workbench to a network location so my colleagues can run the workbench as well. And wrapped it in a Workspace Runner workbench so the workbench is not open for editing when colleagues run the workbench. But since this year I notice that the WorkspaceRunner fails because the Emailer package is not installed. This Emailer is installed as soon as the Workbench containing the Emailer is opened. My workaround now is adding a Emailer Transformer to the WorkspaceRunner workbench so the Emailer is installed when this workbench is opened. Hope this helps others that use WorkspaceRunners and Packaged Transformers in there workbenches. 

Bulk copy failed on table 'tv.vagnat_framtida' using delimiter ':'. Error was 'ERROR:  invalid byte sequence for encoding "UTF8": 0xc3 0x3aCONTEXT:  COPY vagnat_framtida, line 33This error kept me busy for some hours exploring character encoding in shapefiles, FME and PostGIS. Which did not help. Not until I did some data digging and found the error.The data in a shapefile apparently comes from a qualified geodata store, and some long text fields have been truncated in the conversion to shape, leaving what appears to be incomplete character codes. And this causes PostGIS problems. The error message comes from deep within PostGIS. I have tried to cut a few bytes from the string with SubstringExtractor, but then the whole string became HEX. Very strange. Since it is invalid data, there seems to be no way of catching these characters with any of the FME string tools. And the error appears only in the Postgis writer, not before so it can