Transformers

Hey everyone,I have an interesting dilemma, I hope can be solved. I have an interior building spaces that have polygons for rooms. In between each room polygon is a gap that represents the wall. My objective is to somehow push the polygon edges towards one another in order to eliminate the gaps. I have tried numerous ways, including Densifier + Anchored Snapping (which works somewhat, but the polygons look funky), Generalizer + Anchored Snapping (again room polygons look funky) . Below is a screen shot of what it looks like. Any assistance/thoughts would be greatly appreciated!

Hello, I apologize for my somewhat elementary question here, but I am a relatively new user to FME software. I was wondering if someone could explain to me the difference between some of the options for running a workbench. When you right click on the work bench, and choose Run > you got a few options, (run just contained, run from contained, and run to contained).However for some of the workbenches there is only one option available, and with searching online I cannot find any helpful/simple explanations to what each do, or the right one to choose in a given scenario. We are swapping CAD base drawings, and implementing them into a GIS Database. Any help appreciated - Thank you!

Hi, Another small but annoying problem is that when I put the visual preview on a different screen and I accidentally close it with the cross, I cannot retrieve it in any way, the checkmark remains under views, windows next to it. The only way to get it back is to save and close the workspace and then reopen it . De window then appears in miniature somewhere at the top.Are there still people having this? Nathalie 

I am using Anchored Snapper to improve network quality for huge amount of objects (1,1 million). End point snapping is performed on 1 cm snapping distance and Group By option is also used.My problem is that log file of this workbench has 4 million lines and is more than 600 MB big. Since I am using this workbench in a Jenkins job, I have constant issue with memory size when displaying full log in Jenkins Pipeline. 99,9% of the log entries are of no interest for snapping processDoes anybody have a tip how I can reduce number of log entries for this transformer?

Please explain what are the tools need to use & rectify this ?

I'm having an issue with unexpected results in the dissolverThe geometry is validated prior to dissolving but there's a reasonable likelihood of a duff input polygon possibly arc(the shape not the program) related. If i put polygon with count 13 only through an ArcStroker and then dissolve with the rest the output is as expected. But i've not found a way to highlight that this polygon is the problem. I've attached a template file if anyone wants to take a look, I'm still using 2018 so perhaps this doesn't occur in 2019...

Hello,I'm new in practicing FME and didn't find any answer to my question.I'm using FME version 2017.1 and I want to make a FULL JOIN between 2 tables resulting of the transformation of PostgreSQL (Postgis) database tables.FeatureJoiner transformer would be the one I need but only avalaible since version 2018. I heard about others transformers but joining only from common columns (inner join,....).Any idea ? Thank you !

Hi I have a workspace which does a bunch of queries and inserts and updates an SDE polygon feature class. The workspace is run every 2 minutes.I have written a shutdown script to rebuilt the indexes using arcpy.RebuildIndexes_managementThis command however takes over 2 minutes to run, hence I would like to only run it once a month, say one the first of the month between 12 and 12:30 am.Any suggestions ?

Hi, I am using TextEncoder transformer to transform string into URL coded text. String is UTF-8 and have some Balkan letters (?, ž, ?, š) and this is where problems start. For example word Kolašin TextEncoder translates into Kola%C3%85%C2%A1in but right way is Kola%C5%A1in. Is this some bug in TextEncoder or I am doing something wrong?  TextEncoder is set to encoding type URL(Percent encoding). Maybe TextEncoder is not what I need at all so any suggest would be appreciated.      

I have a workbench that creates a html-file with a table. In one field, there's a hyperlink. I write the file with a feature-writer and copy it to our webserver with a filecopy-writer.To make the link clickable, I also use a StringPairReplacer, replacing this: < < > >This works fine, as long as I run the workbench in FME-Desktop.When I put the workbench on FME-Server and run it, the line with the link in the html looks like this:<td><a href="https://www.xy.com">Text</a></td> instead of<td><a href="https://www.xy.com">Text</a></td> in the browser, the address of the hyperlink is:(value of filecopy_dest_filename)https://www.xy.com, so the user gets an error... How can I get FME-Server to write the link correctly? It would be great, if the same syntax would be valid for desktop and FME-Server...Thanks, Vera

Hi,I have some data in the following format:Job Raised Closed 1 20190715 20190825 2 20190611 20190825 3 20190614 20190825  I want to get a summary table, about for each month, how many jobs I had open. So for the above data it would be: Month Raised Closed Open June 2019 2 0 2 July 2019 1 0 3 August 2019 0 3 0  I can do the raised and closed, but am struggling with the open. I tried using a testfilter, with a lot of if statements, which works, but then I not sure how to export that into a format that i can use the data.  Help :)  

I would like to read a dwg layout and print it to dwf. Does somebody has an example how to fix that? :-)Thanks!

In Civil 3D I can add properties to objects by add Property sets. After that i can see this information in the Extended data tab. In the data inspector I can read those properties.I tried something with autocad_extended_data_list{}, but I can't read those properties from the dwg.Who can help me? :-)(How can I read the Pino.Pino-value "hallo hallo"?) 

Hi,  I'm trying to create a file which summarises my data, based on monthly counts. My data:Job1 Dogs 01-01-2018Job2 Dogs 14-01-2018Job3 Dogs 22-02-2018 etc..  My summary file is:Raised Jan-2018 2Raised Feb-2018 1 etc..  And I want to be able to run it for this month, and it append on the end "Raised Aug-2018 22" based on the count of this month.

Hi everyone. Hopefully there is a solution to this. I have some DWG files that have a custom projection. However they are not projecting in the correct position by a long way. I believe there is some kind of off set and or rotation applied to the model, that I can not seem to get FME to ignore. If I take the same dwg and put it in ARC Map and define to the projection, it sits fine. So appears ARC Map is ignoring what ever FME is not. Any help greatly appreciated. FME inspector (you can see its rotated to be straight)FME inspector (data in the green, in the ocean)Arc Map same data in same projection  

I'm completing a government return which will need to be sent daily and they require the file to be named as below:"File naming: CAZ-yyyy-mm-dd-XXXX-#.csv where:yyyy-mm-dd represents the date the file was generatedXXXX is the agreed identifier for each Licensing Authority (to be confirmed)# is the total number of records included in the file."The date is easy enough to solve, but I'm hitting a brick wall trying to insert the feature count into the file path. So far I've got:CAZ-@DateTimeFormat(@DateTimeNow(),%Y-%m-%d)-XXXX-#Could anyone help with the #?

I am working with kml file converting it to our database format and extracting some information along with the shapes. One of the attributes of kml has the info that I need. It looks like that (which seems to be html format):<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor='#E3E3F3'><th>AlertID</th><td>18112330</td></tr><tr bgcolor=''><th>DateTime</th><td>20181222124132.000</td></tr><tr bgcolor='#E3E3F3'><th>AlertRegionID</th><td>2111030</td></tr><tr bgcolor=''><th>RegionTypeID</th><td>1</td></tr></table></center> From that one attribute I'd like to extract the important info minus all the tags, brackets and formatting as separate attributes:AlertID 18112330DateTime 20181222124132.000AlertReg

I'm reading an Oracle Date field in my reader, and then using that date to update a Date field in another Oracle table using SQLExecutor, but I'm getting "`ORA-00932: inconsistent datatypes: expected DATE got NUMBER'." How is that possible?Any help and explanation will be much appreciated.

OK, there must be an easy way to do this, so sorry for asking. o_O;  I have 3D polylines with z-values only on the start and end node coordinates. Using the MeasureOrZvalueInterpolator I have calculated measures for the z-values for the intermediate vertices, and with the MeasureExtractor I have also turned these into a list attribute.  Now, my question is - How can I transfer these values to the z-coordinate values of my intermediate vertices, so that my lines will be in "full 3D" for all coordinates? 

Hi EveryoneI have .txt as attached, the first line is the schema and separated with "tab" space. I can open this is in excel like .csv however I want to read this in FME and create attribute for each schema at first row. I tried attributesplitter with "tab" as delimiter but it seem not as what I want. Can anyone show me how to do it?the input file Expected attribute to be in FME to processThanks.

Hi,  I'm looking for a way to read all the tables which are in one schema without having to select them manually.  I have to export all the table which are stored in one particular schema in spatialite. New tables can be added end old one deleted. That's why I need something automatic...   Does anyone have a clue ?   Thank's   

For example:I've got 4 solids all in dwg. I would like to combinate the layernames of the overlapping objects.So how can ik get the layernames in the green boxes? And I'm looking for a solution which als works if I have multiple flat solids (linke the blue and grey ones) Thanks!

HelloNot very familiar with raster. I have a Vector Polygon and two Tiff files, basically the Polygon has clipped these 2 tiff files from other application. Now when I try Inspect the data through fme both vector and raster are miles apart. The 2 tif file sits exactly on the same location and its coordinate system is unknown. I think the problem is with Tif file as it is not Georeferenced at the correct location. There are other support files in the same folder as tif which fme is not able to read(warning) I have tried lot of things (including manually assigning the coordinate system) but every time the two rasters are exactly at the same location and far from Polygon. As my knowledge with raster is very limited, can anyone help me load the tiff at correct location. ThanksZubair

I would like to create a dwf from dwg-layouts, but I can't fix that.Does anyone has a example workspace? Thanks a lot!