Transformers

Hi everyone,I’m struggling to change/update values of an IFC-file. Example:old PropertySetIfcPropertySet VolumePosition: 1Unit      : m3Quantity: 15  new PropertySetIfcPropertySet VolumePosition: 1Unit      : m3Quantity: 350 I used the GeometryPartExtractor to extract the IfcPropertySets from a IfcBuildingElementProxy geometry. Then I tried to adapt this https://community.safe.com/s/article/updating-ifc-example into my workspace. I used an AttributeCreator:ifc_property_set_name = VolumeQuantity = 350 After that I configured the GeometryPropertySetter and GeometryPropertyRemover. Unfortunately, the original PropertySet Volume will be deleted after writing. In the updated one, Position and Unit are missing. Is there a way how I can keep the traits of the original PropertySet and only change/update one specific value? thxNel 

Hi, I encountered something peculiar last week. I had to compare two datasets about chemical substances measured in groundwater.To compare the datasets, I used the ChangeDetector. While doing so, for one substance an update/change was found for the value of a CASnumber. However, when I look at the originalValue and the revisedValue, I don't see any difference. Also, when I perform a compare using (a plugin of) Notepad++, it also detects a difference in the two CASnumbers. So there seems to be a difference, I just can't seem to spot the difference ;) Maybe some people here can help take a look and provide an explanation? Any feedback is appreciated. The CASnumbers are:CASnumber_1 = '‎483-63-6'CASnumber_2 = '483-63-6' See also the screenshots below for a dummy workspace and the comparison using (a plugin of) Notepad++; 

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 need to choose one dataset from many dataset in geodatabse)

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?

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

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 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

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 am trying to use a colleague's web connection to truncate/load several SDE feature classes to AGOL using parameters for the feature classes and connection files. (Ultimately, I want to create a workspace for specific users to access to update any desired feature service)Everything works fine in FME Desktop. However, after publishing to FME Server, the web connection disappears. Once I reset the parameters the connection shows up but does not persist. How do I resolve this issue?Exhibits: 1a - published2a - after Reset

I want to convert a dgn file to a gdb. The information of the cell color and the line width and the style are lost in the process. For example the colur of the cells are suddenly white and the line style is different. Can I put a dgn seed file and a dgn cell library on the reader to keep the information?

HiI am passing a polygon dataset to the area on area overlayer and some of the features seem to be ignored completely and do not pass through the transformer. Surely all polygons sohould pass through with a count of 1 (or more if they intersect other features in the dataset)? Also is there a way to tell the transformer only to intersect with a second dataset and not itself?

I am trying to use the HTTP caller to post the zip file via FME server Rest API. If someone has any starting tips, I would appreciate it. Thanks

Hello, fellow FME-ers!  I have a question for you. When I use the HTTPCaller I want to send a request and then control the time out length before I receive an answer. From what my college and I can read in the documentation there is no way to do this?

I'm using a DatabaseJoiner to look up rows in an Excel file. This Excel file has about 6,000 rows and about 20 columns. I have an integer FME attribute that finds a matching field in a row in Excel. About 5 'Fields to Add' are concatenated into a new FME attribute. This works great!  I have 4 more FME attributes that contain 1 to 5 comma separated lookup values. One sample value looks like this: 13045,52136,38010. I need to look up a row in the Excel file (for each of the 3 values in this example), then cancatentate the 'Fields to Add' then cancatentate the three final strings into one big string. Do I have to expand "13045,52136,38010" into three new attributes then use each of them in the DatabaseJoiner and create a string attribute for each of them?  Since I have 4 FME attributes that contain 1 to 5 comma separated lookup values, this means that I'll need to add 20 (4*5) integer attributes for lookup and 20 (4*5) string attributes for output? That i

Hi everyone, I want to search for all Feature Classes in our SDE and list out only the ones that have a field name 'SDE_UPDATE' (date field) with a criteria that queries the ones that have been updated in past 10 days. Any example workbench to share?

We have done:Register an app and make sure the FME has permission to use the app.Make sure the user is allowed to access the data. 

The file gdb is a handy conversion template that avoids a lot of painful domain reformatting.

It is to identify the sum of which group. Otherwise, the result is a list of values (for sum) but not possible to identified which value is for each group of features.

Is it possible to generate a horizontal bar chart with the HTMLReportGenerator?

Hello to all, I'm stuck since yesterday on a problem I can't solve.I want to transfer the attributes of a 2D representation of the roofs of the buildings of a city to their 3D version.I have my 2D data in .gpkg and my 3D buildings in .dwg.According to my geometryfilter, the roofs are surfaces and the 2D data are areas.Everything seems to work on the first objects, my attribute replicates correctly on the concerned roofs, but I still get an error, when processing the 1145th object in my clipper. The error is "Attempted to access the value of an uninitialized optional object".I guess some of the geometries may have a problem, but even with GeometryValidators to filter my 2 data sources, nothing changes.What method would you recommend to fix this problem? Are there better ways than GeometryValidator for this kind of problem? Thank you in advance for your answers.

I am new to Json queries. I am trying to extract the details from a arcgis feature service as a spreadsheet for the ESRI living atlas requirements. I have gotten really close but I want my features and tables to be in their own column (second screenshot is what I want). What I am getting is the feature layer AFTER its attributes, and in the same column. I am hoping the resulting table can go into the corresponding feature layers metadata page, as they are manually updated at the moment. There is probably a way to do this using substring extractor, but I was hoping I could do it using json as I have to replicate this for 10 more data products.  

Dear readers, A strange thing occurs today. In an an AttributeManager, I changed the value of an output attribute, from a fixed string to using a user parameter, partly.The original string was: mkdir "Y:\\Basis\\Kunstwerken\\@Value(KWK)\\@Value(KW_CODE)" I substituted the part in bold with a user parameter (in bold, too): mkdir "$(Kunstwerkmappen)\\@Value(KWK)\\@Value(KW_CODE)" Now, here's the funny thing. If I provide the user parameter with the original string, the result is (one record as an example):copy "I:\\BEHEER\\Temp\\Ferdinand\\LM_fotos\\Pictures_LM249DrempelsZestienhoven\\061720122651.jpg" "Y:\\Basis\\Kunstwerken\\Gemalen\\KGM-231\\061720122651.jpg" All seems fine. But the idea is to be able to change the value of the user parameter. So I tried filling in "I:\\BEHEER\\Temp\\Ferdinand\\LM_fotos\\Kunstwerken" (without the quotes)I get this result: copy "I:\\BEHEER\\Temp\\Ferdinand\\LM_fotos\\Pictures_LM249DrempelsZest

Why isn't this easier in FME? I've tried lots of examples on the Hub, but can't get any of them to work. The Attribute Pivoter is difficult to use and never gives me the results I need. I can perform this very easily in SQL. I'm trying to turn my rows Vxx into columns with the value of Litres, grouped by all the other rows. Any idea how I can achieve this? Thanks in advance!