Data

I wanted to transform a shapefile of lines to a wavefront .obj file. In the resulted file test_obj.obj, I did not get a list of vertices and a line starting with "l" to represent a line.Below are three images. The first one shows shapefile "test" with a line. The second image shows how I configured in FME to get an obj file of the line. The third image shows the resulted obj file, which is "empty".Can anybody help me?

I am writing out to excel and need to have the top row have different colors. Is there a way to just color top row? When I assign a color in the writer it applies it to the whole column.

I have a 12c Oracle database that has a line feature class and a point feature class that contains geometries , i want to know how i convert to OGC wkt and extract to a .csv file, i have tried to use the Geometry extractor and write to CSV , but when i view the file within the data inspector , no geomtry is present and no values to depcit the geomtry are present either, is there something that I am missing in my workbench ?

I have a fme process that runs daily that updates records in a geodatabase table. Every couple of days I get an error after the process attempts to reconcile the version. The version is dedicated soley for this process. The process fails after it can not successfully reconcile the version. I am getting the below error:  "Conflicts were found when reconciling version 'GAS.FMEPROD' with target version 'SDE.DEFAULT'. Conflicts were found in the table(s): GAS.gValve. These conflicts must be manually resolved. The reconcile operation will be undone and none of the changes will be saved"  I am not sure if anyone has had this issue before. Any solution or information that can be provided would be helpful.  Thanks.

I have an Oracle table full of polygons, I'd like to split them into the arcs and line segments they're composed of.Is there any way I can do this? The closest I've found is setting a Chopper to split every 2 vertices, but this has the effect of turning any arc segment into several straight line segments, which is unwanted.

Hello There I am reading a large file GDB , using the FeatureReader , but the where clause is disabled, when I user normal reader this option is enabled ?? andy reason for that  the goal is to increase the performance when reading the featuresThanks 

Is there to read in the formatting of the excel? I need to find all the records that are filled in red and exclude them. I tried fme_fill_color and fme_color but those weren't it. Thanks!

So today I learned about how to use webservices and connect to a SharePoint online list using my organization credentials.Regular old SAML wasn't cutting it so I had to use the WebService feature of FME.I created a new template by replacing the [tenant] with the subdomain to which I was trying to connect.  And everything went swell, I authenticated successfully and the connection saved.Then I went and created a new workspace with a new reader for the SharePoint reader.The good news is that the authentication went successfully.The bad news is that when I then clicked on the ellipsis to select the list, it didn't work. Updating access token for 'NewConnectionFromWebServiceTemplate'Microsoft SharePoint List Reader: Client-side error: '401 Client Error: Unauthorized for url: https://subdomain.sharepoint.com/sites/subSite/_api/web/Lists?%24select=Title%2CId&%24filter=Hidden+eq+false' returned from SharePoint. Error message was: ''OK Fine I've permissions to authenticate against the site

Hi,i have to read an Excel-file from a Sharepoint-Site. The Authentication Method is Kerbeos. Any suggestions ?Barbara

I have 1900 tables inside a single schema inside a PostGIS database. I need to convert each table into a KML folder and then have all folders placed inside one giant KML parent folder and viewed in Google Earth. Additionally, I have 5 syle colors classes I need to apply to the tables as well.

Hi,I would like to set the default filename for the PDF which is opened in my Data Streaming service (using the PDF2D Writer). I can't work out how to do this. I have seen the following post which mentions setting the MIME Type, but I'm not sure how to do this..https://knowledge.safe.com/questions/85804/fme-server-data-stream-datafile-writer-pdfs.html Thanks!

Hi, I need to write the results of multiple files (let´s say raster data like .jpg) from multiple folders including subfolders into their source directory/folder...I can´t get it working with the proposed solution from this similar question here: https://knowledge.safe.com/questions/108973/write-file-in-the-same-directory-where-source-file.html. It seems that it does not work if I am recursing through subfolders.  Does anyone have a solution?

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,