Best Answers

I have an Excel sheet that looks like this:I would like to be able to write out data to the table outlined in red.However, I do not know how many rows of data I will be writing out before I run the workbench. Sometimes it will be two rows of data, other times it will be 7000+ rows of data. In the instance that it will be more than the 7 rows that already exist in the template, I would like the table to expand so that I keep my formatting and I don't write over the data and tables that exist below. I have tried using named ranges as outlined here but I have not been successful at even getting it to write to the correct spot that way. Currently, these are the parameters for the Excel Writer that I have:But this will only start it writing out in the correct spot and then overwrite the rest of the sheet when there are more than 7 rows of records:I currently have a work around where my template has 10000 extra blank rows in the table and then I run an Excel macro to delete all the extra

I worked with one of our interns on developing a pretty simple workbench that queries records from a REST service using a project #, styling the popups and icons, and writes it out to a KML that is then downloaded from FME server using the data download service. I have exposed the attachment from ArcGIS Online and have the process worked out for converting them to base64. The next part that I'm needing help with (why I posted this) is determine the best way to embed the photos in the popup, which are varying content subtypes of image (image/png, image/jpeg, image/jpg, etc). I've attempted (unsuccessfully) to embed the base64 image in html, but it doesn't seem to load. I think the best way would be to save the images in a folder, and somehow reference the local image path in the kml popup... Both the KML and Images would be downloaded through the published data download service.

I have 2 shapefiles:roadway centerlineshouse points  is there a way to generate lines between each point and the nearest road centerline?

I am trying to follow the documentation listed here https://community.safe.com/s/article/json-transformations about making an HTTP call, flattening the JSON with JSONFlattener, and then pulling out the attributes with AttributeExposer.  The flattener even seems to show the flattened JSON feature information. But when I connect that to the attribute exposer, it seems like I can't choose anything out of the JSONFlattener as my attribute to expose in the attribute exposer. Importing isn't any better. It doesn't automatically find the features for me, and the import options seem to be only documents or URLs. A URL pointing at the API would work for this example, but not if I wanted to use an API with more stringent access policy. Am I missing a transformer or a JSON query in between the flattener and the Attribute Exposer? Is there a better workaround here?

I have a CSV file of attributes that I want to assign to a new CSV file and have been trying to use the FeatureMerger to assign the original attribute to the new attribute but it doesn't work, any suggestions?

I have a table that has almost 1000 rows, but these rows have a date field. I need to make a filter, which I can only use from today's date the previous 3 days ... however, I have some doubts on how to do a subtraction for example if today is 01/4/2021 (mm / dd / yyyy )

Hi,I have a set of points, and I wanna build lines between pairs of points whenever their separating distance is within a specified tolerance for example [3,4] meters

This morning I stumbled upon the Recorder and Player. After reading the documentation I was really eager to try them out in a workspace for storing temporary files. We also tested the performance by comparing with a FeatureReader / FeatureWriter and we didn't find any big differences when the compression-level of the Recorder was low. However when increasing the compression level, the performance was increasingly worse with the Recorder in comparison with the FeatureWriter. Is the only advantage of the Recorder in stead of the FeatureWriter that it can compress the data? When do you use the one or the other?Thanks for your thoughts!

Hi all,I want to make Uppercase the first string of word.For example: 12 tran Dai nghia >> 12 Tran Dai Nghia, 12/3 le dai hanh >> 12/3 Le Dai Hanh.Could you show me how to make to do it? Thank you

Hi, I have a huge data table where some cells have codes (e.g. ND, TR, TC, XX, etc.). This table gets updated all the time, and I read this data, and I want to get rid of these codes and just replace with zero. I have no idea how many codes are out there (a code may not be in the current table but may appear in an updated version). So, I just want to select any cell with a string and replace it zero. How can I do this? Maybe a conditional statement similar to the ISTEXT formula in Excel? Or a wildcard (*)? Thank you :-)

Hello,I have a workbench pulling features from a table in Dynamics CRM, using VertexCreater into a Geodatabase. Everything seems to be working fine, but when I look at the features in ArcGIS Pro, They seem to be in the right place when I zoom to them using the attribute table, but they are oddly not showing. Does anyone know what can be causing this?

I have a csv file that has 259200 rows. The first column CELL_ID has consecutive integers from 1 to 259200. When used this file in the CSV reader, its data type is automatically set to be uint16, which limits its max value to be 65535, consequently all other rows after 65535 are read as NULL. The data type can't be changed. I also notice other issues. For example, one column has many initial rows with a value of 0, so the CSV reader set its data type to be uint8. But this column has many rows with data type of double, and those end up as being read as null . It would be nice if all columns can be changed to be read as string so we don't miss anything. I would say the default settings are not correct in most cases. I have used the CSV reader for years, and this is the first time I notice the bad default settings.

I'm working on a project where I need wave models created in MatLab. I have download them but when reading I get rotated coordinates.For some reason, wave models operate with rotated coordinate systems as opposed to conventional ocean models (rlat, rlon). How can I manage to read and rotate this data with FME? 

Hi,I am writing out line geometry with a tagset to a Microstation DGN file. I can't work out how to change the level of the tagset to be different to the level of the line geometry to which it is connected. Is there a way to do this?Thanks,

Hi.I have a need for a single user/department to be able to activate a handful of workspaces on my FME server.I can build a Server App, but it's tied to a single workspace.Is there a way, apart from building a launch page externally, or making multiple server apps, to have a single FME Server App support multiple workspace activations ?Cheers

Hi everyone and thanks for your timeI've used HullReplacer in order to get my polygon, see attached - but is there a way to place it FLAT at the calculated lowest point of the object.Thank you

Looking for a single transformer solution on this question. I have an ordered list and I'd like to populate Col 2 (group) with values from Col 1 that start with '# '. Since the number of rows for each group is random and the categories are also dynamic I'd like to avoid hard coding the groups as conditional values.

I'm looking for a workflow that would combine Addresses/Attributes from a worksheet to either a 2D Shapefile of building footprints or a 3D fbx model (the FBX model is just the 2D shapefile building footprints extruded). I used geocoder to get address points from the excel sheet and need help moving onto the next steps of moving the attributes from the excel sheet to the 3d models they correspond to.

I need to create a csv to load into another application so I'm using a csv writer. That works perfectly but I get an error becauwe FME uses an "," as a delimter instead of a ";". Does anyone know how I can change this?

Hi All I feel like this should be a simple problem to solve but... I have a dataset containing hundreds of points which represent places which require a delivery. I want to divide these into X equal zones which minimise the amount of travel required for the delivery driver. Having done that, I'd then like to order the delivery points within the area so that they're roughly in order - this doesn't have to be very precise so I may just group and sort by postcode unless anyone has a better suggestion? Any advice appreciated - thanks!

Hey FME'ers, For the moment I am updating all my workbenches from Python 2.7 to Python 3.6+. While doing so I encountered a problem with the StatisticsCalculator. Giving me the error: ' ''<' not supported between instances of 'float' and 'str' '.As far as I understand this is because some of the data is numerical where the others are strings. To avoid the error I tried to force all data to a string but that did not do the trick. I suspect this has to do with the fact that Python 3+ uses UTF-8 as default. Note that I only want to calculate the 'Total Count Attribute'.In attachement a simple example of my problem. My workbench version is 2018.1 but I encountered the same problem in FME 2019Any suggestions?Thanks in advance!

If I have a workspace that deals with raster images, is there a way - maybe as a User Parameter - to get the person running the workspace to choose which raster image to use as the input for the workspace? For instance, User A might want to run with a .TIF file, and User B might want to process a .JPG

I want to replace attributes from Unicode to without accent.For example : Find âÂăĂđĐêÊôÔơƠưƯ --> Replace aAaAdDeEoOoOuUĂn >> AnĐô >> Do Could you tell me how to replace it by python or other way?Thank you

Thanks for any help!