Best Answers

Hi,I'm currently using FME 2017.1 Smallword Edition. My problem is that I'm trying to convert Collada data to Cesium 3D-tiles and I don't know how to specify the coordinates to separate the large input data into small tiles. The image is how I want to tile my dataset.Here's the Collada data.http://bit.ly/2DhOxIDIs there any solution?How to create 3D-Tile data in popular way?If anyone knows the answer, please let me know.Thank you very muchPA

I found an article about "insert images into an Excel spreadsheet" (https://knowledge.safe.com/articles/33588/writing-images-to-ms-excel-spreadsheets.html), this article was made with FME desktop 2016. I was wondering of it is possible to do the same action with fme desktop 2015? In fme desktop 2015 the "attributemanager" is not available, so i as wondering which transformers to use in fme desktop 2015 to make the same actions as with the "attributemanager" in the article!I hope anyone can help me!Peter

I'm using FME to read, modify and write data to a oracle database. My queries are working fine but the following error is popping up for every SQL query .  ERROR |BADNEWS: An error occurred while fetching from query OCI_NO_DATA StatusInfo *STFDB_OCIStatement::fetch(STK_UInt32, STK_UInt32 &)(foundation/framework/util/dbwrap/ocistmt.cpp:661) - StatusInfo *STFDB_OCIStatement::fetch(STK_UInt32, STK_UInt32 &)(foundation/framework/util/dbwrap/ocistmt.cpp:661)What is it complaining about ? instant client or oracle database ?version detailsUsing FME 2019.2.2.0 versionMac OS X VersionOracle database version is '12.1.0.2.0'instantclient_19_3 Any help on this would be appreciated.

Hi, I'm understanding slowly how to use XQuery but I have come across yet another stumbling block. I have an XMLUpdater and I want to replace the contents of the following path with some code:XML Path://group[@id=fme:get-attribute("CODE") @category=fme:get-attribute("CATEGORY")]I'm pretty sure that the above code is not the correct syntax for referencing two variables at once but I can't find any information on how to do this. Any ideas?Thanks,

Hello, I am in dire need of help, as I have been trying to parse an XML file for the last 5 hours. I have looked at the XML tutorial, in addition to many other posts on this forum, but I cannot figure this out. Can anyone help me?  I am interested in getting a Feature for each Task, with all its subelements as attributes.The XML file and fmw workbench are attached. Thank you, and have a great weekend! Edit: You might have to change the path to the XML file in the reader. 

Hi,I have lines and points near lines. I need to move point perpendicular (vertical) to line and break line at that point. Any ideas?

Hi all,  I try to redefine the outer boundaries of the red and green polygons. As you can see in the picture, they are not up-to-date anymore. However, I have tried different transformers, in different order like GeometryCoercer, LineOnLine Overlayer and a clipper, but the outcome is everytime a mess of lines criss-crossing (second picture), Basically I want to get rid of everything on the 'inside' and just keep the outer boundary of both red and green (or in-and outside of green ofcourse, but then I have another problem with different symbology on both sides...). I don't need any of the attributes, just the geometry will do. I am relatively new to FME, any help much appreciated!  Thanks.  

Only identify indicated yellow color values is possible or notNameIdentifyvenkat 25 rockvenkat 25 rockwinner 564 bufferwinner 564 bufferlock 57 fuzzylock 57 fuzzylime roadlime roadfantasy streetfantasy streetvennila roadvennila roadram nagar 56ram nagar 56ganga temple 90 ganga temple 90 suri nagar 45 suri nagar 45

i have output of transformer l , it looks like the above table. in the inspectori want to split this table automatically depends on the amount of cells in ID column .as here the table has only 4 rows but sometimes i got another output with different rows ,but any table has idso i want to divide the output of transformer to many seperated output and each output has his own id with his row bcs i want to do some actions later and connected seperately with some transformer .i need the output looks like the picture as down , but i want to create way automatically whatever the amount of ID ,get me the result output seperately .exactly , i have lines with different id and this is the output as shown above. Thanks for help 

how can i show user Attributes in Dgn Feature types  where is the missing tab user attributes ,how can i show it .my file is dgn v7thanks

Hello,Is there a way to filter "Start Time" field in Ascending / Descending order or any other fields for that matter.I have too many tasks scheduled and it's hard to find the right "start time" slot.On a different note (Not sure if it's the right place): My test/live site is now fully functional and FME Data driven including the HTML Outputs / Layers update... Notification service, which will soon be provided to residents, makes use of FirmStep but the delivery of the notification service is FME at its best!! The other bits rely on Open Source (PostGIS / QGIS...) Basemap = work in progresshttps://molevalley.cloudmappin.com/mmv/ (Not a molevalley.gov.uk domain name because of hosting issue due to time constraint) Thanks and hope you like it. I also take this opportunity to thank the community for their assistance as I've managed to complete my project (well almost).Kind Regards Sameer

@takashiGreetings FME sensei, good to see you're still around! I had a question about a Python script I'm using as a Private Parameter linked to two published parameters to generate log file folders that include the local user and date in the folder name, then generates time/date stamped log files within those folders.Here's the script:# Scripted (Python) Parameter Example # Create log file path with time stamp. import fme, time, os d = FME_MacroValues['Log_File_Dir'] # directory path w = FME_MacroValues['User_Name'] # workspace name t = time.strftime('%Y%m%d%H%M%S') # time stamp f = FME_MacroValues['Folder_Name_Date'] # date in folder name # If the workspace name ends with ".fmw", remove it. if w.endswith('.fmw'): w = w[:-4]  # Create a new folder which has the name of the workspace. dir = os.path.join(d, w, f) if not os.path.exists(dir): os.mkdir(dir)  # If the expected path conflicts with an existing file, # append sequen

I have the following that worksSDE DATA => Test Filter (Name = Point) > XMLFramenter > Rest works as expected 1 feature coming throughI want to remove the Test Filter and and put an SQL Where clause at the SDE Data level ( Name = Point ) the SQL is valid and 1 feature comes through however the XMLFramenter fails.Looking at the data in both cases for the field that contains the XML data is identical yet it fails in one case and not the other, any ideas?

Folks,I need to scour some file shares with a python script to identify any data files. I would like to exclude 'non data' files and it occurs to me that one way of doing this would be to compare file extensions with a list of format-specific file extensions that are used by FME Readers...The Knowledge Base does list file formats (https://www.safe.com/fme/formats-matrix/ ) but doesn't specify the associated file extensions.Does anyone know if there is a matrix that lists the file extensions associated with each FME Reader?Many Thanks, Graham

Hi All, I have a workspace published to FME server with a few MI tab readers, nothing special. (read several MI tab files-> manipulate attributes -> extract coordinates -> output to CSV). For whatever reason when the job runs per its scheduled time, It fails with the following error in the log:MITAB Reader: Failed to open and parse file 'E:\\ProgramData\\Safe Software\\FME Server\\repositories\\Workspaces\\SSALocator\\RUR_ADS_PROPNUM.TAB'. Make sure that the file exists and is valid  The tab file is located on a network share so i'm not sure why its referencing the location above? Theres no files here other than a copy of the workspace. It doesn't have a long path name (>260) If i manually click resubmit job, it works fine so i don't believe its file access(I used the full UNC path for the readers). Any suggestions are appreciated.

Hi,We have an issue with backups on our acceptance FME Server 2019.2 build 19801 We use IIS Application Request Routing and have https: configured with a certificate. We are getting the error: Unable to retrieve backup from FME Server `https://fmeserverurl:433' Please ensure that the credentials are correct and that user `admin' has fmesuperuser role. The error was: Couldn't connect to server.'We are logged in as admin on the server. Has anyone experienced this before?Annette Full log file:54HTTPCaller (HTTPFactory): HTTP/FTP transfer error: 'Couldn't connect to server'55HTTPCaller (HTTPFactory): Please ensure that your network connection is properly set up56HTTPCaller (HTTPFactory): No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered57The below feature caused the translation to be terminated58Storing feature(s) to FME feature store file `F:\\Apps\\Safe Software\\FME

hello,i am confused a little bit ,how can i use FeatureMerger correctly.I have two excel on my workspace ,Excel A : has three rows but one of them is duplicate from Excel B ,and two rows not .Excel B has 50 rowsi want to merge Excel A with Excel Band if we have any duplicate row (i mean the one of Excel A) ,remove the duplicates and keep the rest of rows .so As a result,i need to have Excel that contains 52 rows .i read alot the Documentation but iam still confused in adjust properties of Featuremerger ,i will be thankful if someone help me .thanks 

FME 2018.1.1.2 Is this expected behaviour? I've set 2 Lists to be removed from the WorkBench features by AttributeManager. Opening the Partial Results of the Output Port in Data Inspector, they are indeed removed.Yet, in the very next Transformer (happens to be TopologyBuilder) the 2 Lists reappear again on the Features when the Output Port is inspected in Data Inspector, complete with the original list values? Not only that, but trying to remove them with a subsequent AttributeManager, AttributeKeeper etc. does not work, because these Transformers don't think that either of the Lists exist anymore in the Schema and hence won't appear in the selection of Attributes/Lists available to modify! These Lists continue down the Workflow in the Partial Results but remain invisible in the Schema. Further, if I replace the AttributeManager with an AttributeKeeper, the Lists stay removed (and I guess is a workaround?). I'm guessing this may be a bug in how AttributeManager tries

I have built a workbench that takes a shapefile (which isn't one file) as an input. I've published it to FME Server. How do I upload a shapefile(s) so that FME Server will process it?

I have a series of feature readers that read data and schema from a postGIS DB and writes to a GDB using a dynamic writer and the schema feature generated from the Feature reader (see image). For some data I have empty tables and FME does not seem to write the corresponding feature class in GDB if no features are found. Now, what I would like to achieve is to force FME to write every feature class (corresponding to a table in the DB) even if the table does not contain any data. Ideally I would need an empty feature class with one row and empty data but also an empty feature class is fine, as long as there is the schema, that would be the requirement. Is it easily possible to achieve in FME desktop?

I am getting the following error message when I try to connect a reader to a read-only Arc SDE connection "Unable to read from the table/feature class 'GDM.GasValve'. If 'GDM.GasValve' contains a class extension, make sure it is registered on this computer"I would appreciate if i can get any help with getting round this.

Hello, i'm pretty sure it's a simple problem, but somehow i'm not able to write a 3D shapefile. Every time I look at the feature information in the Data Inspector, I get "2D" as the dimension. But I need "3D" as dimension. As a test, I have written the script below. After I have created a "test point", I create an attribute with a height, which I write into the Z-value using the 3DForcer. When exporting I want to write a 3D shapefile, but I have some kind of error and I can't see the forest in front of the trees anymore. Thanks a lot for the help 

We have 12 engines in our FME server. I can see engine9 and engine9@39899, thus having 13 engines.What is this?

I would like to use an attribute value for a new attribute name using the Attribute Creator transformer, but this just not working. The new attribute is not created even if we can parameter the Attribute Creator to do so:I am using FME 2018.1.0.1 64bitsI have found this old question with the same issue. According to the accepted answer, the issue was suppose to be fixed in FME 2017. So is the problem fixed or not?

Since upgrading to FME Desktop 2019.2.2.0, when I run FME workbenches with excel readers I get the warning:"Excel Reader: Sheet 'mysheetname' has invalid value '' for parameter 'xlsx_start_row'. Parameter will be ignored""Excel Reader: Sheet 'mysheetname' has invalid value '' for parameter 'xlsx_end_row'. Parameter will be ignored" I never got this before, previously i was running 2019.1.3.1. What does it mean and is it a problem?