FME Form

I tried using Appearance setter for KMLwriter but didnt able to get the result. Appearance setter worked for CityGML output but not for KML output.

I have the Geodatabase data with around 40 milions of records in it with huge size but want read this data in parts like 1 to 10000000 , next adding it to next slot 10000001 to 20000000 to get it written in SQL database. In reader, geodatabase i have Object ID as one field with count to follow as per records.How it can be acheived with giving parameters in reader itself with different slots creating to migrate the data in different FME workbences as per slots.

Hi, I have a (complete) road network containing all the "real" roads segments of the road network. I then have several "copies" of the road network but with different segments, these segments define attribute properties for the road segments. I want to split the "real" segments by multiple attribute segments.e.g.: Road 1 --------------------------------------------  5m                      10m  ---------|-----------------------------------  70km/h                 50km/h        70km/h --------------------|-------------|----------Desired output:5m           10m          10m          10m --------|-----------|-------------|---------- 70km        70km        50km/h       70km/h  Does anyone have a good solution for performing this in FME? 

I'm using a coordinate system that is not in FME’s Coordinate System Gallery. I added a custom coordinate system by creating a new .fme file and using the online tool. When I use it in my FME model it give me the message: "Invalid longitude value given for projection origin".My .fme file has this information:COORDINATE_SYSTEM_DEF PTRA08-UTM/ITRF93 \\  DESC_NM "PTRA08 / UTM zone 26N EPSG:5015" \\  GROUP EUROPE \\ EL_NAME GRS1980 \\  ORG_LAT 0 \\  PARM1 -27.0 \\  PROJ UTM \\  QUAD 1 \\  SCL_RED 0.9996000000 \\  SOURCE "https://www.dgterritorio.gov.pt/geodesia/sistemas-referencia/regioes-autonomas/PTRA08-UTM-ITRF93" \\  UNIT METER \\  X_OFF 500000 \\  Y_OFF 0 I think the error is in PARM1, but I think it's ok... -27

I have long believed FME can read any GIS files. But today look like it can't handle a single band rrd (reduced resolution dataset) raster. Any workaround? or I need to go back to ESRI model builder?

Hello FME'ers,Welcome to What's Up Wednesday The Community Café Goes LiveIt's less than a week now until the FME User Conference 2022 gets underway, and I'm certainly getting excited about this event. One part that I'm running is called the Community Café, which has a lot of different activities and giveaways for all community members. You can find them listed on the FME-powered Community Café website:  When you're actually at the conference and stop by the booth, you'll have access to all of the activities, including City Guesser, the Community Virtual Badge, the Scavenger Hunt code and much more. For now, you'll have to be content with exploring Tea and Coffee rituals from around the world, and browsing some ideas for Hackathon projects:  These are all ideas that I've made open for anyone to use. So if you plan on coming to the Hackathon, and you aren't sure of what to do, then here you might find some inspiration. On the topic of the User Conf

Hello, I need to geocode information related to permit applications from a shared Google Sheets file. This file is regularly updated and contains two different tabs that I need to retrieve the information to geocode using Bing geocoding services. The output file is a Geopackage which allowed the creation of a map representing the two types of permits.The purpose of this workflow is to update the GeoPackage file with the updated information from the shared Google Sheet file, so that each time if there are new records from the Google Sheet file, these are added in GeoPackage.Unfortunately, when I run my Workspace, I get the following error message:OGCGEOPACKAGE writer: Requested feature type 'chiens_ptdx_re_conditions2' does not exist. OGCGEOPACKAGE writer does not have the ability to create new feature types. Create the feature type on the dataset before writingOGCGEOPACKAGE writer: A fatal error has occurred. Check the logfile above for detailsAttributeManager_OUTPUT_-1_52_Play

Hi,I'm using the DGN styler to plot my data using RGB colours that I've pulled out of an mxd, I've set this to the FME colours and also tried RGB colours (multiplied the parts of the fme colour x 255) but neither seem to work. The data inspector does show the colours correctly.As a workaround I assigned my different coloured polygons to different CAD levels then set them the elements colour to 'by level' and importing a csv of by level colours. The problem is I now need to set all my elements on a single level so can only have a single colour.I've had success by assigning a colour index in the past but need to assign RGB in this instance.Any help would be much appreciated.

Hallo FME community,I have a line and there are vertices on it. I want to have vertex as point. (exactly a tool like "Feature Vertices To Points" in ArcGIS) I used Intersector and topologybuilder for this and they don't exactly give me the vertex. Attached you find the pictures.     

In print it is possible to visualize the line created, totally without logic, and in red what would be the appropriate route.

I have XML file that contains GEOMETRYCOLLECTION for each object and it might contain lines, points, areas. I have this GEOMETRYCOLLECTION already in attribute but how to create multiple features out of those text geometries?

I am using FME Desktop 2021.2I pass my aws credentials to the s3connector through user parameters. The user parameters are all password type parameters.I am having no issue with the Access Key ID, or Secret Access Key but I am experiencing an issue with the Session Token.I'm finding that passing the session token as a password user parameter causes the following rejection:`fme_rejection_message' has value `S3Connector: There was an error connecting to Amazon S3: 'An error occurred (InvalidToken) when calling the GetObject operation: The provided token is malformed or otherwise invalid.'. Confirm that your credentials and region settings are correct. Some regions are not publicly available - contact AWS for more information'If I pass the session token as text type user parameter then I do not get this rejection and the workspace continues with the download from s3.   

I managed to create centerline (blue line) using suggestions by "@takashi" thanks for that., I would like to create additional lines (black line) inside the polygon, lines should be equally disturbed.  

Hello there I have a 20K features each feature has an attribute with Long text content each text with diffirent word count , we need to compare features to each other and extract the text features that have similarity ,Any way to do this with FME Thanks

Hello, I have a lot of attributes that need to be input into specfic cells in an excel template. Some of these cells are merged and some are not. How would i write each individual attribute into seperate cells based on the template? Many thanks,@Takashi Iijima​ @Mark Stoakes​ @nielsgerrits​  @ebygomm​  @jkr_da​ @mark2atsafe​ @jdh​ 

Hi everyone,Here's a post for sharing ideas and activities, for organizing social events, or for just passing on messages during the 2022 User Conference. Note: I can't guarantee to be monitoring this page. Best to tweet me on FMEEvangelist to get a more reliable response. Here's some information that I have: Things to Do In VancouverHere is a Safe webpage with some suggestions. This includes restaurants, activities, and similar. There is also the community page from 2017 that also has some suggestions. Official Event ActivitiesOfficial activities include: SoccerCyclingYogaFun RunHackathon"Rec Room" activities You can find full details on the conference website. MessagingThe EventMobi app has an Activity Feed where you can post messages:     ...and you can click on a user and send them a personal message too:  It doesn't look great for group chats, especially private ones. I recall most people used WhatsApp during the last conference.  So... I've created a

Hello everyone,I'm looking for an easy way to extract domain value from a gdb for validation.I know that you can use ArcGIS Pro to export a XML schema from a GDB, but I want to skip that step. I tried to use Schema Reader, but it doesn't give me the full domain values in the attributs.Anyone have an idea ? Thanks

I've an ArcGIS geodatabase feature class with some attributes. I do some attribute mapping and export data in a new geodatabase feature class.Everything works fine but some of the original attributes are not transferred in the output data. I don't know why......I've used the Attribute Manager to remove and rename some attributes, then I've used the Attribute Creator and the Attribute Keeper, the last step is with a final Schema Mapper and finally the new feature class: but there are some attributes (not interested by any transformation during the process) that are missing (the fields in yellow).Any idea? Thank you  

The obvious transformers (Rasterselector, RasterBandRemover, RasterBandKeeper) do not give the desired output. No errors are generated but all bands of the CSAR raster file are still present after processing. The bands seem to be hidden but I can not find a way to make them available for processing.

I have 2 different (postgis) writers (A and B), one of which is sometimes temporary not accessible. FME checks at the start if all writers (A and B) are accessible, and if not, fails to execute the workbench.So I wonder if it is possible (e.g. by the use of a parameter specifying which (only) writer to use) to bypass the "accessibility-check" of e.g. writer A so that only writer B is being used and the workbench is still being executed? I use this in a batch-script where I "ping" to A and B, and therefore know at the start whether A and/or B are accessible.

Is there a way to write custom key-value metadata to the output parquet files?

Hi I am trying to merge about 15 sets containing information about green infrastructure in to one singular dissolved, multipart polygon. In ArcGIS I would use the Merge geoprocessing tool to all the the layers into one, select all the features and merge them. Finally I would do a dissolve. In FME I have fed all the input layers into a Dissolve transformer (dropping attibutes), fed the area output port to an aggregator. I am unsure what to do with remnants - I have fed Unused Areas from the remnants port to the Aggregator but not interior lines (I presume these are the dividing lines that have been removed in the dissolve?) - is this correct? Many thanks

It's a simple workflow: connect to AGOL, check for data, copy the new features to a service on internal Portal. But it's tripping me up every which way. I got the basic workflow going nicely, but it fails when I try running it via a batch file through Task Scheduler. Keeps returning an error message that it can't find the service. Same thing happened with Python which is why I'm trying FME now.I'm connecting to Portal using a OAuth2.0 web service connection but it doesn't seem to like working through Scheduler.So I thought I'd try a different authentication (tokens) and found a recently released 'ESRI Portal Token Getter' but there's no documentation to really help.Anyone have any success with it?

I've been trying to work out how the light source definition is actually used within the SurfaceFootprointReplacer (with shadow mode set to perpendicular) transformer without luck. My end goal would be to extract an estimated surface of a 3D shape for a hydraulic radius calculation. If I know the shape's rotation from the horizontal axis, how does this get defined by the vector parameters?Defining a point along the face didn't appear to be the right answer, nor was offsetting a point... A simplified workflow showing a cube rotated 45° is attached to illustrate the issue.

Hello,Recently, we have installed FME Destkop 2022.1.We are aware of the fact that FME Desktop 2022 only supports Python 64-bit. On the same machine, ArcGIS Pro 2.8 is installed.Although Esri ArcIS Python 3.7 is selected as parameter and as preferred Python Interpreter, it seems to be impossible to use ArcPy. After many attempts, still the same error appears: "Python Exception <OSError>: [WinError 193] %1 is not a valid Win32 application." What could be wrong?  Kind regards,Pim van der Zwaag.