Best Answers

Dear All , We have a line with two vertices , we try to to shorten the line from the beginning to 10 meter using choper by length but not effect , Can someone help us archive this . Thanks ,

For example, I would like to add 40 meters to the current absolute value height.

I've heard that there are some users out there doing really cool things with python scripted parameters to help move workspaces between different FME Desktop installs and FME Server as well!!I'd love to know what FME users have been up to on this front! Please share your solutions.

Hello, I have a bit of a problem that I can't find a solution to. I have a list of directories and sub directories. Some contain shapefiles. Some contain tables, gdbs etc. Eg: S:\\NEW\\170530\\test.shpS:\\NEW\\170529\\NewData\\NewTest.shpS:\\OLD\\170428\\test.xlsxS:\\OLD\\170428\\MoreData\\MoreTest.shpThere are more folders within those dated directories. The root drive is always the same "S:\\"The root data directories (eg, OLD, NEW) will be provided by users as a user parameter. There won't be any navigating to those specific directories. How can I have a workbench that reads all the shapefiles nested in all those different directories, once the root data directory has been passed to it? Everything from the PATH reader up to the FeatureReader only specifies up to the dated directory based on user input. Eg:S:\\NEW\\170530I saved the directory path and passing the following to the FeatureReader: S:\\NEW\\170530\\**Now it works.. but with a couple of drawbacks. For on

I have set up my Geodatabase Writer but can’t write to it. The log file gives me this message: “Geodatabase Error (-2147024894): The system cannot find the file specified.” even though I’m creating a new file geodatabase within my workflow.

I have a route and clip it against areas....but i need the result in order of the flow direction of the route.....which parameter sorts me that because now the result is in no order and when i put a count on it it is no logical order.So please help me... i think its no t abig problem for u guysThx Franco

Hi,I have a simple workspace. I read a file (interlis2) and have 4 parallel transformers attached (GeometryReplacers, followed by GeometryFilter and AttributeRenamer).When I run the workspace it crashes at exactly the same data row in my input file without any further error message except "fme has stopped working". Nothing in log file either.If I disable two of the four parallel transformers and run the workspace and afterwards disable them and enable the two remaing ones all data is read and written (Autodesk sdf3).Memory is no issue - FME just uses 500 MB, there is plenty left.Any ideas why that happens? I would like to run the workspace in one go.Thank you, Rob

Hi.I have the following .json file:{    "0": {        "0": {            "Group 1": {                "Sub 1": 0,                 "Sub 2": 70            },             "Group 2": {                "Sub 3": 0,                 "Sub 4": 29            },             "Group 3": {                "Sub 5": 136,                 "Sub 6": 120            }        },         "1": {            "Group 1": {                "Sub 1": 0,                 "Sub 2": 76            },             "Group 2": {                "Sub 3": 1,                 "Sub 4": 35            },             "Group 3": {                "Sub 5": 157,                 "Sub 6": 115            }        } },"1": {        "0": {            "Group 1": {                "Sub 1": 5,                 "Sub 2": 72            },             "Group 2": {                "Sub 3": 51,                 "Sub 4": 2            },             "Group 3": {                "Sub 5": 16,                 "Sub 6": 20            }        },         "1": {           

My desktop administrator has installed the FME on the PC with Esri ArcGIS desktop. I'm not the administrator of the PC. After FME desktop installed, the FME Data Interoperability is listed in the Esri ArcGIS desktop extension for the administrator. When I login, my ArcGIS extension list doesn't include the FME data Interoperability. I'm not the administrator on the PC. Thus I don't have right to install any software. How can I use the FME Data Interoperability installed by the administrator in the ArcGIS desktop? Thanks in advance.Helen

Hello Team,I want to extract a direction of driving between address points using the API from gogglemaps. First i have the Origin Point and i need to find the next address ( point b for example ) from xls file. After from the point B find the next address ( point C ) and repeat this process 10 times. I believe the best way to do this is a loop in python. Attached my template file.Thanks in Advance,Danilo

Every time I open Esri ArcCatalog, I noticed that it is pulling an FME License from my floating license pool - this is quickly using up all available licenses!

@DeanAtSafeI saw your article on using KMLTourBuilder linked below. It is very helpful however I'm getting stuck creating my tour. I would like my tour to orbit over a single point. I have created a buffer around my subject point and set my tour to follow the buffer circle. This seems to work but I need to adjust my heading as I work my way around the circle. Ideally this would be a heading adjustment of thoroughly 7 roughly 51 times (360 degrees) so my camera view (heading) is always facing the middle of the circle. http://fmepedia.safe.com/articles/Samples_and_Demos/Climbing-Sydney-Harbour-Bridge-with-FME

Hello, How do I automatically create a unique digital sequential value for each record, unrelated to the record number? Thank you

I would like to count the number of input files and return this number to be able to use it in an arithmetic calculations afterwards.To be more precise, I have X Excel files, each containing values that are regularly repeated, but each with a different frequency. I calculated how many times each value occurred in all the files (so I have 2 attributes: value and count), and now I would like to divide each count by X (number of files) to get the frequency as a 3rd attribute.I tried using Aggregator, Statistics Calculator and Counter to get the number of input files, but I get 'missing' or 'null' values when I try to save it as an attribute. How can I 'save' or return this number?

Hi All,  I'm starting to use FME server and notification service. I managed to publish a workspace notifying some information by email when it's completed (with a TextFile writter...). It works when I manually run the workspace from the FME server.  Now I would like to send the same notification when the workspace complete, but on a scheduled way. It seems to ignore notification information specified when publishing the workspace. And in the schedule parameters page you can define what Topic it should post to but not what data to post (and so you cannot specify that you want to post the output of the TextFile writter), it posts the standard information (job id, time infos, etc.).  Is there a way to solve this problem ? Maybe I missed something... Thank you!

I'm looking for a solution to make my workspace a lot more dynamic for my use. I'm working on a easy to set up workbench where MariaDB (MySQL-compatible) Spatial reader and writer are connected with an AttributeManager in between. I would like to add my fmw to the server with some parameters that can set the Table list as prompt input data. The SourceDataset_MYSQL is already a prompted parameter but i cannot find a way to set the Table list/table name as a parameter. Any idea how to set this?http://docs.safe.com/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/mysql/MYSQL_reader.htmConstraints -> Table List

Hi,We are building a data extraction tool based on FME Server. This application build a form dynamically based on the published parameters. It needs to work in french and in english. Since i18n isn't possible on parameters descriptions and alias, we need to rely on a custom format that we put in the descriptions. The application has an additionnal step of parsing the descriptions to get the french or the english names/descriptions depending on the current language of the user.Is there any plan to support i18n on parameter names and descriptions?Is there a different way to manage that then the one we use?Thanks!

Hi,  I cann't use the Adobe Geospatial PDF writer to output Chinese or Japanese text.  I have tried modify my font file's name and it's name show in FME's font window to non-Chinese; also flow the help's instruction to modify the fme_text_string to rich format, like "你好", and set the parameter of Writer "Text in Rich Text Format" to yes. But both failed.  If you can output some special non-English characters to PDF?  Thanks

Hi users,I have a script that create a route between two points ( start and end ) using library googlemaps.The return is going well to attribute in format JSON.The idea is extract the route information in 'html_instructions'. In PyCharm is work when i execute it:I configured my Workspace and execute ( attached template file), but it brings only the last route between two points.How can i get inside my Workspace all route and turn a attribute? Attached the JSON generated by request googlemaps and Workspace.Thanks in Advance,

I'm pretty new to FME so I may be missing something obvious, but here goes: I have two AutoCAD layers, a text layer and a line layer. I need to find which text entities have the same rotation as the line entities. Then I need to take these line & text entities that share the same rotation and find which among them are within X units of each other. I've found the rotation of the lines using the custom transformer AzimuthCalculator, but when I feed both the text and lines into a single tester to see if their rotations are equal, the tester passes nothing, even when the rotations are equal (as verified with the inspector). The text rotation is a 64 bit real and the line rotation is encoded as utf-8, but from what I gather that shouldn't matter. Why is the tester not passing anything? My plan if the tester would work as desired is to then GeometryFilter the passing tester results into line & text and feed them into a NeighborFinder.

How can I convert .shp to .csv and include Postal code as well as lat/long? I am able to make the conversion, but only Postal code is exposed in the .csvThe original shape file has x and y axis and is using EPSG 102015, the .csv would preferably convert to EPSG 4326 and include lat/long

Does anyone know if FME can write / read / interact with MongoDB?   

I would like to snap the blue line to the red line. End goal is to merge attributes. I tried using AnchoredSnapper, the problem is that as you can see in some cases especially where the line bends lines can be closer to the 'wrong' red line. Any advice would be greatly appreciated.

Folks,Still on that learning curve.I have a table where there are two filtering criteria based on two different columns in the source.Initially I thought to use two Attributefilters one for each criteria and then re-combine the result like a UNION for the output.However it's possible the criteria will allow the same record through twice. Once for each criteria.What is the best way to filter out data based on multiple criteria?I was thinking if I stuck with multiple parrallel Attributefilters I'd need some kind of Merger to eliminate the duplicate records.Advice apprciated.

Hello,I implemented a changed detection on oracle table.Now I would like to be able to create a json for each change per object. For instance, for an object where changes were detected on 5 attributs, below will be the json that I would like to obtain:{ "ATTRIBUT1": { "OLD_VALUE": "OLD1", "NEW_VALUE": "NEW1" }, "ATTRIBUT2": { "OLD_VALUE": "OLD2", "NEW_VALUE": "NEW2" }, "ATTRIBUT3": { "OLD_VALUE": "OLD3", "NEW_VALUE": "NEW3" }, "ATTRIBUT4": { "OLD_VALUE": "OLD4", "NEW_VALUE": "NEW4" }, "ATTRIBUT5": { "OLD_VALUE": "OLD5", "NEW_VALUE": "NEW5" }}How can I proceed to obtain this in fme?I was tinking of the agregator to group all the changes from the same object (based on an objectid) and then build the json but I don't know how to proceed.Please keep in mind that the number  and names of attributes will change from one object to another one.Thanks,