Data

Hello, Whilst looking at ifc and revit files, I saw that some instances are written away as Geometry Definition and Geometry Instance.I was wondering how you do this in FME. I was looking at the GeometryPropertySetter but I dont' see any possibility to write away geometry definitions.I also looked at https://knowledge.safe.com/articles/54027/creating-and-using-geometry-instances.html#:~:text=A%20geometry%20definition%20is%20a,and%20a%203D%20affine%20matrix.&text=This%20is%20especially%20true%20if,is%20very%20large%20or%20detailed.But I could't really work it out myself.Anybody can point me in the right direction. Kind regards, Andreas 

Shape to kmz issue. Workbench runs and records getting written, But then the KMZ is 0 bytes.  

I want to create an automation in FME Server for a user to validate his data.He sends in an email with his data as attachement and the topic of the validation as part of the email subject.In the workbench, the email subject is parsed and the topic is kept as an attribute. At the end a logfile is written with the name: topic.log (I do this with a fanout in the writer).This logfile I want to send back to the sender of the email as an attachement. But to attach the file to the email, I have to fill in its path and I don't know the filename at this point. How can I pass the value of "topic" (=filename) as parameter to the Automation, so that I could use it in the "Email Details"?(I'm using FME Server 2019.0)Thanks, Vera

I have a workbench, which calls a REST API via HTTPCaller and get a Response in JSON Format. Then it writes the response via a FeatureWriter into a directory as a json-File. That works with no trouble in FME. But as soon I published it for FME Server and start the process there, it doesn't write no jsonfile into the directory. The workspace runs on the FME Server without problem. I testet with different workflows like AttributeFileWriter etc. It never writes a file......

Hi!I have a background map on DWG + a set of data. My workbench look for an error on the set and if it found it, a buffer is output.I would like to export the backgroud only when an error is found. Is it possible?Thanks!

I'm beginner user of FME Desktop. Transformation from shp to Citygml is working, but when i'm trying to export to CityGML a values that are in table (csv) i can't do it. I'm trying to move values from attribute code_citygml to attribut citygml_function, but i can't do connection and finally those values from code_citymgl are missing in final file. Could someone show me right transformation tool or place in model when this sholud be done?  Thanks.

Hi all!Has anyone else had the problem of doing an Upload with GoogleDriveConnector, and then getting <null> or <missing> in the attributes specified as 'Shareable Link' and 'Direct Download Link'? My colleague and I just noticed that one of our automated workbenches started leaving these blank some time in January. Perhaps Google made an API change around that time and this is no longer possible? The actual file upload goes through fine, so the transformer isn't actually failing, it's just not giving any values for these.

Using Build #19136 of FME Workbench 2019, and the first and last letters are getting cut off for some reason. Source dataset is in ArcGIS Server 10.6 (running on Oracle 12c). Anyone else having this issue?

Hi, I have a table that has 2 fields, one with the name of cities and the other with the date. Features with the name of the same city are repeated, but the dates do not. How can I make a filter to use only each city but with the most recent date?Eg. City | DateDC     20200621WD    20200619DC     20200620DC     20200619WD    20200618 Thank´s

Hi,I have spent most of the morning going down a rabbit hole and really am none the wiser. I am writing out some content to a feature class in SDE. When I run the full process with feature caching on or off I get a failure to write with a very unhelpful ESRI error: An error occurred while attempting to insert a row into the table 'DBO.xxxx' using a cursor. The error number from ArcObjects is: '-2147418113'. The error message from ArcObjects is: {}However if I run it with feature caching on, up to the last transformer and then run to the writer afterwards the content goes into the SDE, no error.If I write to a ffs file then push that to sde. It works. My suspicion is that I am using a feature reader, it seems like SDE doesnt recieve all the right info about the schema before FME tries to write to it, whereas it does when feature caching is enabled?Any ideas very much appreciated.ThanksOliver 

I have several GML files that I read via the FeatureReader, and format =«GML» and reading all feature types. An unknown amount of these GML files results in Nested Attributes. Nested Attributes is appearing in the workflow as lists with one to several sub-levels. So far so good. But the problem occurs when I want to use the jsonpacker to create json strings that I am able to write to a PostGis table. The jsonpacker demands that I declare what attribute to pack. But making a generic workflow to handle any GML files and then pack all the lists without knowing the names of the lists at forehand, makes this a difficult task. I need one json string for every list, and the name of the json attribute should be the top level name in every list. So in stort : I am creating a generic workspace that packs all lists individually to just as many unique json string attributes. Sorry for not posting any pictures of the workspace, but all I have is a generic reader of GML files that results in an unkn

I'm working on setting up a script that reads in an Excel file. I'm merging the spreadsheet with another based on a unique column and the owner doesn't want the formulas in one column to be disturbed. They still want access to view the formula. Is it possible to write to that sheet but still preserve the formula?

Hi,I'm trying to figure out a way to create a couple of paramaters in my workflow so that the user can select from a picklist of SDE Connection Files and available Versions to use in the various FeatureReader transformers in the workflow. Is there a way to do this without hard-coding all the values in ahead of time?? Thanks,

Good morning,I have a lot of files to convert from .idgn (Bentley) format to .sp (Synchro Pro) file format.To do that in microstation, there is a specific plugin from Synchro to do that.I am looking a way to do that automatically for a lot of files at the same time, so I was thinking FME.I am not a FME expert but do you think it is possible to configure that ?Thank you.Best regards,

Hello all,I have the experience is that a FME workbench will never update or truncate the data of a writer after that a fault condition has raised in a FME workbench.I would like to know if this is the way an FME workbench works to be sure that our data will never be changed after a fault condition in a FME workbench.Could you inform us if my experience is correct? Thank you for your answer. 

I need help with FME Data Streaming Service. I am having trouble serving up a pdf file in a browser. I am using the DataFile writer to write my pdf because my pdf comes in binary form. It all works in workbench, but when I try it in FME Server as a Data Stream it downloads the pdf with the workbench name and a .fmw as the extension. If I change the extension to .pdf my pdf is there and I can open this. I would think that FME should serve up the pdf with the file name I specified in the writer. Any help would be greatly appreciated. 

I am using a Google Drive transformer for my project, but I was considering to make the URL I use to connect to my spreadsheet, public. So, there is no need to provide my credentials or any other person credentials in the process. Is it possible to do that?

I am working with many autocad files and trying to extract data from paper space objects. The objects i am trying to extract are mtext object (of type autocad_multi_text) I am trying to match up objects that start with a specific string to objects just below them. to do this i want to use the autocad alignment_x and ycoordinates. I have enabled the feature type format attributesneeded and do see many of the attributes populated in the visual preview.but not the ones i need. I can get the coordinates using a coordinate extractor but those are the lower left and will not help me select the adjacent below text that i need. 

Hello to all, I have created with FME 2019 a CityGML file with the UtilityNetwork ADE extension. Some of the ADE feature types I am using are: Cable, ProtectiveElement, ConnectorComponent or PowerTransformer. These features have their own attributes according to the ADE specification but also, I added to them some generic attributes like: <gen:stringAttribute name="CableType"><gen:value>MT</gen:value></gen:stringAttribute>After that, I want to convert this CityGML files to other formats. To do this, I am trying to add a reader for this CityGML file (with the ADE extension), but it doesn’t recognize the generic attributes. In the CityGML reader, I have specified the parameters like that: And I I get all the feature types lo load: But when looking at the attributes of Cable for instance, I don’t see the generic ones on the list. I only see the ones from the ADE Specification: I also have tried to add a Generic reader, but the problem here is that it only identifie

I got a workspace that I run and as an output it creates one row with statistics.If I run the workspace the output is correct both with inspector and the row written to postgres.If I use another workspace with a workspace runner to run the workspace for multiple areas, one of my column values is 0 in every row.Any thoughts?

Hello everybody, FME Server 2020 establishes a successful connection to the Active Directory. User and password input from AD unsuccessful when SSO is activated. If SSO is deactivated, the login is successful. However, the use of SSO is incorrect. The following entry is in the log:INFORM RequestHandler thread 401831: Accepted new client connection from /127.0.0.1 on port 7071 The service account is configured with SPN on the FQDNThe service account is also used successfully for the Active Directroy connection. Settings in TomCat Properties are also made (Enable SSO URL) best regardsMartin

I have autocad drawings with mtext. however one group of text is not one mtext feature.They also are center justified. so in order for me to get a common x coordinate for all the rows in a group i had to make the reader explode mtext objects.1. now my first difficulty was to get the autocad_alignment_x. After exploding the mtext i now have this value.2. I need to collect only the text that is the same height, font and vicinity of the first text. (there are standard strings that i can use to get the first line).3. iterate through and separate each row of text into a separate attribute. then use the file name to merge that feature with another on the name of the file.no problem right?My idea is to get the x coord of the first text. then find the next text down by subtracting from the y coord. and so on until i have found all 12 pieces of the information. then i will have to send each value out to populate attributes.

I'm uploading objects to my S3 bucket using the S3Connector (Action: Upload) and I see that I can add metadata but it looks like I can't add any tags for my new object. The lifecycle rules in my bucket depend on my objects being properly tagged. Is there any way to achieve this?

I'm pulling my hair out trying to get filecopy writer to work. What I want to do is copy a folder (and it's sub-folders) to a new location and to rename the copied folder. I'm using user-parameters to prompt for the new folder name but I can't get the file copy to work properly. I've combed through old forums but haven't found anything helpful. I think I can do the renaming with a system caller but I still cant get the filecopy to work... Any help is much appreciated.  I feel like this is fairly straight-forward, I'm still quite new to FME.

when try to read a table (attribute data only no geometry field ) using Esri ArcGIS Server Feature Service reader i get this error ArcGIS Feature Service Reader: Encountered an unexpected error. The error code from the server was '-2147220652' and the message was: 'Failed to execute query.'. Details: '' A fatal error has occurred. Check the logfile above for details