FME Form

Hey guys, https://community.safe.com/s/question/0D54Q000080hBYOSA2/reconcile-and-post-issue Just following this here to reconcile our versioned ArcSDE in a workspace. I have the basic flow set up: Creator --> AttributeCreator --> Writer and i've set the parameters based on the thread above. My question on the writer is what geometry type and row selection information I need to fill in to get it to trigger? I didn't see this addressed in the two threads on this I found searching.Thanks

Hello,I am trying to read multiple excel files that unfortunately don't come very clean, meaning that the headers are starting on the third row while the first two rows are mainly blank. So I used the "Directory and File Pathnames" reader to pull all the excel files that I need and then connected it to the Feature Reader but the "Attributes to Expose" doesn't work as I don't have headers on the first row. I attached a snip of how the .xls files look. Basically I would need to somehow skip/delete the first two rows and read from there. Not sure.  Can anyone advise on this one? Many thanks!

We have been asked to audit all of our systems to confirm whether JAVA is being used. We want to confirm that we are compliant in licensing regarding anything Java. Thanks!

Quick a simple question but one that has stumped me.I am trying to remove all of the data that has been pulled into FME from a shpfile on AGOL. The aim is to later replace this removed data with new data in same shpfile before reuploading this to AGOL. So I was wondering whether there was a tool that was able to be used just to remove the data while leaving the columns itself.

Hello,I'm very confused, I don't find how to remove the two last elements of a address list and concatenate the other words.I think it's quite easy but even with the ListElementCounter, I dont find the answer!Thank for your help.

I'm trying to extract data from the website https://www.tax.service.gov.uk/check-council-tax-band/search. After submitting a postcode (e.g. LS26 0AG) it returns a coded URL with results, which I want to extract. I've got the last part (extracting the results) working well but I can't figure out how to use HTTPCaller to submit a postcode and get the URL that is returned. The form name is "postcode" but when I set it up and run I get a "HTTP/1.1 400 Bad Request" error. Can anyone help please?

(i need to choose one dataset from many dataset in geodatabse)

I'm buffering a points shapefile, then using the resulting square polygons to clip a raster (vrt OS backdrop). The clipped rasters are then passed to a PDF PageFormatter to produce location maps for each point. My problem is the raster outputs once written to PDF seem to move - placed in relation to the location of the point. how can I force the rasters to be drawn in the same place on the page everytime?

Reference: Extracting a schema subset for dynamic schemas SCHEMASUBSET.zip contains 4 fds files, is there any difference each of them?All the 4 fds files when opened in FME Desktop, giving the below warning.@hollyatsafe​ 

Hello everyone, I have a shapefile with polygons (neighborhoods) and a shapefile with lines (waterways). Each polygon has a specific code attached to it. I want to provide each line with the code of the polygon it runs through. When the line runs through several polygons, it must get the code of the polygon through which the line runs the longest.  Does anyone know how I can best handle this? Regards Bas 

We have a large GeoJSON file, we need to "cut" it in multiple geojson files equal in "size", like each resulting file would be of 1200 meters X 1200 meters and named in a X,Y manner, like "1.5.geojson" and "2.7.GeoJSON". Is there'S a way to do this with FME ?

I am reading some data from a ESRI based web GIS and need to convert them to DWG. The data contains XYZ data, but the Z-values are missing when opening the DWG in CAD-software.  I got Z-values before writing: This is my workspace: AutoCAD: How can I make sure the file contains Z values?

Hello,I am struggling with what I am sure is a very simple thing but one that I cannot sort out. I am using Path to search for specific files in a directory which I then read with the Feature Reader. Thing is, I need part of the path_rootname as an attribute to use forward but I cannot seem to be able and extract it. I created "Year" as per the snips but I don't know how to use it forward. I only get the values from the Generic port but for "Year" I get <missing> for each row. I can see the "Year" attribute in the <Schema> port (and it shows up correctly) but I do not know how to pass it on to the next transformers. I tried connecting the <schema> port along with the <generic> one but it doesn't work. I also tried attribute exposer, attribute creator but no luck. Any ideas on why this isn't working? thank you!

I m reading the data from Snowflake database and there is a date type in timestamp z (9) and when I tried to insert the data in MySQL is giving me the error Date/time string  Snowfleke Data Mysql Data Strcuture

I am generating a weekly Excel report and I wish to dynamically add a new column every week containing last week's data. Also, I need the column name to include today's date, for example - 'Outstanding work 04/10/22'. Is there a way to achieve this?

Hi everyone, I have a workspace where I am trying to test some element attributes to see if they match certain conditions/values. So kind of like: Location: Melbourne (fixed for all elements in file)Asset type: various (varies per element) I have around 80 of these attributes to test. The tests parameters are contained in an Excel file, i.e. I have a file that has the following columns: Attribute NameAttribute value (either has a value that I want to check against if Fixed)Attribute type (contains term 'fixed' or 'varies') Other than writing each individual rule into the Tester, is there a more efficient way to do this, particularly as the parameter spreadsheet may update and I want to avoid re-writting all the tests? Thanks in advance for your help! Amit

I have one table where id already there now what I want is when I push the new data it will generate an automatic id  for example the Table ID is 47 and when I push new data then that table insert from 48 in ID columns I use a counter to generate the ID from new data and then I use the static calculator from Table so it gives me a max number of 47 and when running that wS then it's not generate the ids

Hi! Is it possible to slice 3D objects at a specific height?  For example, I have a 3D model from a building, and I'd like to know what the exact outer bounds of the house are at +2m above ground level.  Thanks,Mark  

I want to test my GML file against a schema to make sure that it is valid. To do this, I am using an XMLValidator transformer. I am not sure how it works.When I add a reader for my GML file, it loads all the different feature types. I also selected my .xsd file containing my schema. Connecting these to the XMLValidator goes excruciatingly slowly and everything seems to fail anyway.If I select my GML file as the "XML Filename" parameter for the XMLValidator, and then my .xsd file as the Schema Location (Validation type "Syntax and Schema", and then unconnect the Feature Type readers, it seems to work, but I have inspectors connected to the "Passed" and "Failed" ports on the XMLValidator and nothing seems to go through either of them, even though the workbench runs successfully. Am I using it right? 

For example, I am splitting 'label' - TCY/D/N3000000. In this case, I only need the 'TCY' to be part of the list. I have multiple labels with different values instead of 'TCY'. I then need to display these as row names in Col A. upon writing to Excel as below: (Col B should count how many 'TCY' labels in the dataset. DA_List CountTCY 150BGS 20CUR 50

I am using Treesize to search company folders for GeoTiffs and want to add to a map to view coverage. I need to have a function to add these Geotiffs from the file path outputted by Treesize. 

Hello, I want to extract roof textures from an imagery raster. In input I have a raster and a polygon.In output I would like to have the image I could use to texture the polygon. Is there any transformer for that? Thanks!

I trying to insert the record on the Exiting table but it's giving me null values with successfully

I have a folder with multiple text files.I need every file to be read and parsed, then I need them to be put into an excel file. for every file there needs to be a sheet. Noteworthy is that I need to be able to do this in different folders. I don't always know how many files there is but it can be everything from 1-1000 (very unlikely that it is 1000 though).  I can't seem to find a good way to do this. I think its best if I just show you an example of the text file, images below. FME might not be well suited for this, I know I can do this in VBA in Excel, But I really want to do this in FME because it is way easier to share it with colleagues and more reusable.  This is what I have, this is how one text file looks like:1: I need the file name to be the sheet name.2: This is meta data, I need this to also be in th

I am working with 2 point datasets. My objective is to add two extra fields to the attribute table of the first set of points (red), containing the angle in degrees between this point and both it's two neighboring points (green). Each set of red and green points within the white constrainment share a unique Object-code so it is possible to use "group by". I have tried LineBuilder but I haven't succeeded in drawing 2 seperate lines from each red point to both green points. I have only been able to draw a line that starts at the red point and travels through green point 1, and the green point 2. I have tried Neigborfinder but i can't seem to get the correct information about the angle of the neighbors in relation to the base point. Regards Kilian