FME Form

I have a workspace which reads rows from an excel file and writes the same rows to an other excel file using dynamic schema definition. Gets the schema from the excel file which is read. My problem is that the first row that is read is skipped in the writer. In the attached example the output will only contain the second row of TestExcelWriter.xlsx

I have a data that contains whitespaces at the beginning, between and at the end. I have used an attributetrimmer to trim out the spaces at the beginning and end, but I am left with the spaces in between. Please, does anyone have an idea of how I can go about it because I can't keep using a stringreplacer repeatedly for this large dataset?

I'm fairly new to FME Desktop. I have a FeatureWriter with three inputs. I'm creating an Excel file with three sheets. It works great except many of the column widths are much wider than the content. I have to open each sheet, select all columns and Auto Fit Column Width. Today I realized that if the data type is text(255) then the column width will be 255. If the data type is text(150) then the column width will be 150. My data source is an ArcGIS feature layer created from Survey123. The default length for a text field is 255 so, I have many columns that with a width of 255 in Excel. This doesn't seem like a great way to determine width. I'd rather go with the Excel default column width. In the User Attributes tab of the FeatureWriter parameters, I see that I can set the column width. I believe that I can use zero to auto fit the column width. The problem is that I have about 30 columns and 3 sheets so, I'd have to type '0' close to hundred times. Is there a better way? Thanks.

i have seen numerous posts about this but i cant get a good working solution. i have a user parameter that i want to limit a second user parameter based on the selection of the first. so far i can get a filter on the first parameter but how do you link the second parameter to the first in order to present the user with only the attributes that match the first parameter?

Hi, How could I assign a value to a polygon based on the value of most of the overlapping points? Thanks in advance.

FME Desktop: Attributes fails to be transferred to a file geodatabase, In the screenshot below, I wanted to write the result of the “geometry filter” into a file geodatabase having all fields transferred. However, the indicated fields are not transferred. What could be the issue here? The data and workbench are attached

I just would like to convert xml files to json keeping the structure. I give you an example of my problem : My xml files look like that : <Organisme id="pmi-25047-01" codeInsee="25047" dateMiseAJour="2019-04-19" pivotLocal="pmi"> <Nom>Centre de protection maternelle et infantile (PMI) - Baume-les-Dames</Nom> <EditeurSource>La Direction de l'information légale et administrative (Premier ministre)</EditeurSource> <Adresse type="géopostale"> <Ligne>2 rue des Frères-Grenier</Ligne> <CodePostal>25110</CodePostal> <NomCommune>Baume-les-Dames</NomCommune> <Localisation> <Latitude>47.3492012024</Latitude> <Longitude>6.36126995087</Longitude> <Précision>8</Précision> </Localisation> <Accessibilité type="ACC">rampe d'accès</Accessibilité> </Adresse> <CoordonnéesNum> <Téléphone>03 81 84 48 70</Téléphone> <Télécopie>03 81 84 48 80</Télécopie> <Email>cmsbaumelesdames@doubs.fr</Email> <Url>http://www.doubs.fr</Url> </CoordonnéesNum> <Ouverture> <PlageJ début="vendredi" fin="vendredi"> <PlageH début=

I'm trying to convert a CityGML file into a 3d model that I could open with Blender, I was able to use FME data inspector to convert it to .obj, but it doesn't come with any textures. How can I convert CityGML to .obj or other 3d format with textures included? EDIT: And by the way I have never used FME before, and I'm not planning to use it for anything else than converting CityGML to 3d models, so explaining the process step-by-step would be really helpful.

I am creating a connection to an Access DB. The database has a username and password, and when I do the connections for the DB in FME it only asks for a password. After i set the connection up, i create a Reader for it, but after the reader is created it asks me for the username and password for the MS access db again. How do i get this to stop? Cause it is going to ask me that information everytime i run this query, which will be automated.

I build a .kml polygon from information contained in a .pdf file we receive for utility location planning print requests. The polygon has attributes with contact info, start date, bounding box long/lat coordinates, etc... I also have a utility locate app in ArcGIS Online that contains a survey 123 form, a webmap, and a dashboard for tracking the requests. I would like to auto populate the survey123 form with the data from the .kml including the polygon bounding box if possible. It sounds like it should be doable from this: https://support.esri.com/en/technical-article/000017982 Could an httpcaller put transformer send the custom url to survey 123? Thanks for any insight you care to share.

Hi, is it possible to use the LineOnAreaOverlayer transformer to test all lines in an area against all areas step by step. That means i have 10000 areas and all should be testest one by one against the 15000 lines in the line port. As a result I need a list which shows me what lines are in every single area. And yes, the same line will be in more than one area. Maybe i colud use a second workspace and use the workspacerunner to bring the data in, but i hope there will be a smarter solution for that.

Create polygon from point

Hello Dears, Im new to FME. I would like to convert SHP to TopoJSON. Is there any special transformers to use for this process or any customization required. I tried with simple attribute manager but the converted data is just a line. could you please help anyone SC attached

In QGIS there is a useful tool that generates Random points on lines. It snaps the points to the lines whilst keeping an even spacing between all points. It also has a setting of points per line. Any ideas on how to achieve the same result in FME? Description of the function in QGIS: This algorithm creates a point layer, with points placed randomly on the lines of the Input line layer. The default behaviour is that the generated point features inherit the attributes of the line feature on which they were was generated. Parameters / options: For each feature in the Input line layer, the algorithm attempts to add the specified Number of points for each feature to the output layer. A Minimum distance between points and a Global minimum distance between points can be specified. A point will not be added if there is an already generated point within this (Euclidean) distance from the generated location. With Minimum distance between points, only points on the same line feature are considere

Desktop version 2020.2.0.0 Build 20787, FME Server version 2020.2 Build 20787. When the workbench is run in Desktop, the result is: > FMEServerNotifier: Sent notification to topic ... on FME Server And the second workbench in FME Server gets triggered as expected. However, when it is run in FME Server, the result is: > FMEServerNotifier: Failed to send notification to topic ... on FME Server >FMEServerNotifier: Reason - unable to connect to FME Server Some things that have been attempted: + ensuring 64 bit desktop upload to 64 bit Server + using a different connection + trying to verify topic and connection credentials with admin person + verified the Topic can be run directly within FME Server, which triggers the other workbench correctly + Desktop and FME Server versions appear to be the same ie 2020 + adjusted the python interpreter +adjusted the Notifier's preceding transformer to remove excess rejected data, such that the input into the notifier is purely a single celled table con

I'm running into a problem with the Google Sheets (V4) Writer. We have a Tableau Public Dashboard connected to a Google Sheets Document. Tableau Public will only daily update it's data when coming from Google Sheets. Other data formats are not supported. To keep our dashboard up to date I'm writing a selection of the last 24 months of data from our internal database to Sheets. About 1,5 million records. Using a 'truncate existing' mode. Only 1 column of data. All columns from B to Z have been removed from the sheet. Writer is set to end at column A . So no extra colums are created. When starting with an empty sheets this runs perfectly fine but after a week of daily truncates the sheet contains nearly 10 million rows. Only 1,5 million contain a value, the rest is empty. So not a real truncate, just a 'delete value' is performed. The next day my workspace crashed because the sheet will exceed 10 million cells... A drop and create won't work either because it will create columns B to Z.

Due to a company merge, need to change the network domain for the entire infrastructure. What is the best way to handle FME server migration to the new domain? Is it possible to do an in-place migration, rather than building a new FME server?

I have some problems using data made from FME. The workflow is basically from excel statistics data combined with feature joiner with shape polygon and after that through attribute manager to shape writer. I'm doing calculations based on both data sources attribute information in attribute manager (arithmetic editor) which I guess changes the data to text with point separator. When I try to do thematic maps in other GIS applications the data cannot be read even though it is there and looks good on the surface and contains both calculated data and polygons. I suspect the reason is that attribute manager changes the information to text after calculations. Even if I manually change the data type to double in shape writer this doesn't help. Any tips? Also possible reason is the use of point separator (most often I use comma). I haven't updated all the transformers lately. (The error I'm getting from ArcGIS when I try to do maps from data is that layer doesn't contain any field types that c

I am importing an AutoCAD DWG with multi-leader blocks for asset locations. The issue I am running into is that the value showing up in FME for the "TAGNUMBERS' is the Default value vs. the value that shows up in AutoCAD. From AutoCAD: I'm trying to extract the 'T9' text from the MLEADERs shown here: These are custom MLEADERS developed by the drafting department. After different attempts to explode blocks, expose attributes both in Model and Paper Space, different combinations of parameters, etc. I attempted 13 different combinations to import the DWG and now luck, I keep seeing this in FME: FME is only recognizing the 'Default' Tag Number. I've tried to bring in both Model and Paper Space in a single reader to match Entity Handles, but no luck. I also tried to leverage the multitude X/Y coordinates and came up with nothing. If I explode the MLEADERs in AutoCAD first, the 'T9' shows up in the 'autocad_text_string' attribute as expected. However, I feel I shouldn't have to go to such ex

Right now I have several parameters accepting a single attribute selection and a published user parameter that accepts multiple attributes (basically you select all the ones you selected above). I want to use a single duplicatefilter transformer to filter out duplicates of the several user parameters that have already been provided.

Dear FME users, I have the error: Error decrypting data. Most likely this is because the encryption key is incorrect. Please contact your administrator to retrieve the correct encryption key. System; Remote environment: Windows Server 2012 R2 machines with RDP (remote desktop) The workspace is managed by RES/Ivanti v10.2. with separate autorisation Environment variables for Oracle on server Path=C:\\ProgramData\\Oracle\\Java\\javapath;C:\\Windows\\system32;C:\\Windows;C:\\Windows\\System32\\Wbem;C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\;I:\\APP\\Oracle\\Client11g\\X32\\Client\\bin TNS_ADMIN=I:\\APP\\Oracle\\network\\admin and FME: PATH=I:\\APP\\Oracle\\client11g\\x64\\11.2.0\\client_1\\bin;%PATH% The netwokdisk "I" is mapped for every employee. Collegue: With 2 colleges we work with FME. In FME options we have the following in Default Path: Connection Data Directory : I:\\APPDATA\\FME\\FME_Conn Public key file : I:\\APPDATA\\FME\\FME_Conn\\fme_publicKey.jceks Private key file :

My input is contour lines, I want to convert to raster. How can I do this? I was thinking contour->vector->raster, but i am not sure how to convert contour to vector. Any help would be appreciated

Dear All, I have GML with various types features like building, stream, road etc. In building feature member there are sub types like representation_point, roof_outline , roof_surface. My task is to extract only representation_point from building feature member. Kindly advice which transformer I have to use or steps to achieve the task. I tried xmlflattener but ended up with failure.

I am struggling to read two geometry columns from this database. If I set Handle Multiple Spatial Columns to "No", it only gives me one of the two columns. If I set it to "Yes", then I get the above error. What does it mean to have a "Custom SQL SELECT statement"? Mine is nothing fancy: select building_id, floor_id, space_id, agency_code, space_type, space_category,usable_sq_ft, obj.objgeom, SDO_UTIL.interior_point (OBJ.objgeom) from esm.esmobject obj join esm.att_space ats on obj.IDOBJECT = ats.IDOBJECT where building_id = 'BD0303' and floor_id = '01' It was also difficult to retrieve data tables. I had to type in each one. Luckily there were only two. If I let FME search for tables, it errors: My connection seems fine. I am able to access all tables and do more complicated queries in SQL Developer. Any info is appreciated. Thanks, Loren

I've created a workspace server app which allows the user to select a projection from the list of FME coordinate systems and reproject their data. The desktop workbench has access to our FME server (e.g. \\\\A-FME\\FME\\CoordinateSystems) and is able to choose from the list of custom coordinate systems created by our survey department, but the server app does not list the custom coords. I've manually copied the custom files to the server (/a-fme/fmeserver/#/resources/browse/FME_SHAREDRESOURCE_ENGINE/CoordinateSystems?name=Engine) but it still doesn't list any of the coords. I've followed the instructions as stated here. Any ideas or suggestions will be much appreciated.