Using transformers to modify data.
Recently active
Hi all,I have 3 folder 2016, 2017, 2018. Each folder have 46 images .TIF format.In each folder, for one day have 3 images tif and split to _p1,_p2,_p3 and the date is same.My goal sort images in each folder and execute raster calculate the first image of each folder to other first folder and then create folder based on squence 1,2,3....I describe in here. Could you tell me how to the way make model ? Thank you
Hi,From the documentation on https://playground.fmeserver.com/ I have made a web interface where my goal is to initiate a workspace on the server and then use the json output in a javascript foldertree. I have one published parameter that specifies the ID of the webfolder I want to re-create as json. Everything works as can use the json output directly by saving it as a file set is a source in my foldertree but I can't get it to work when using the streaming service and using the the URL as source. I specifically tried using the streaming service as in the https://playground.fmeserver.com/javascript/data-visualization/mapbox/ example but the data isn't read from the foldertree javascript. I lack the basic programming insight but I suspect I will need to use jsonp to make this work? Or is there a better way to do this overall? Thanks! /Jacob
I'm running an FME Cloud with the Forgot Password option switched on. When a user uses that they get an email with a link to reset the password but when clicking that link they get a page saying "Could not connect to FME Core.Please ensure that it is running."And yes, it is in fact running just fine. Anybody else get this too? Did I maybe misconfigure it? The SMTP settings are good because the emails are being sent. The Public URL is set to https://[servername]-red-geographics.fmecloud.com/fmeserver
HI. I have a shapefile of Dissolved points and another shapefile of a polygon. Now I want to clip the polygon overlapping on the point file. Please note that the whole polygon area does not cover all the dissolved points.
Is it possible to create minimum bounding triangles for groups of points using FME desktop?
Hello,i have an issue with the creation of autocad blocks and object data.Everything has been created as i wanted: - correct autocad layer and correct OD tabelname.But every block itself receives also object data, i don't want this to happen.the workbench i use is very basic, just an attributevaluemapper to get a blockname for every attributevalue, so i fill in (autocad_entity = autocad_insert // autocad_block_name=<blockname from template>, autocad_color and autocad_layer)How can i prevent the "2nd OD" to be created? (on older workbenches i've done exactly the same but there this issue doesn't occur)Thanks,
Hi all/season greetings, I am trying to figure if this is best to use SQL or FME.I have two excel files which look like this below. I want to join the tables together and then produce a extra column based on the changes column. The join bit looks fine.The next step is the Extra column should be created based on if the changes column either contains a value or not. If it does then it spits a output and if it does not it also does. Only issue i am unable to how to get logic so when you join them based on the record number, you then base the 'extra column' on the changes column being populated with a value.Description of extra columnExtra Column Title = Status - will be the name of the column.It then should be able work out based on record number if the changes column has a value in it. If it is empty then the output to that column should be 'not completed' and if it does have a comment then it should come up as 'completed'. So far my flow is:Excel --> FeatureMe
Hi,I'm trying to combine two data streams based on keywords. (chain) How can I do this? Thanks, Ed
i dont know how do it, i see some discussion here but i dont know what i do wrong.the input the worckbench
Hi. I have a multipoint shape file of Dissolved points on the basis of locality. I want these points to be enveloped with the polygon on the basis of the locality.
Hi All, I am currently trying to extract links from an HTML page, but it has them embedded inside a javascript toggle. The current workflow I have used in the past uses the HTTPCaller, then uses the HTML extractor to pull out any links using: CCS Selector = a[href] and Tag Part/HTML Attribute = href. It then uses the ListExploder to put all the links into a table. The problem I am running into is that on this page the links I need to pull out are inside a link that is <a href="javascript:toggleObj.()>. When I look at the HTML after the caller it does not show any of the links that are inside of that toggle. Anyone have any ideas how to pull these out? I have attached a couple images to illustrate the problem. Thanks in advance! -Adrian Example of the link I need to pull out and concatenate: HTMLExtractor:
I would like to use the Tiler transformer to create 100x100m tiles. How do I specify this? They only size option I see is listed as "ground units".
i need transfomer to gdb with raster to ecw. and i need pass from RGB to Grey.
I have an AttributeCreator that is meant to create a new attribute called "regDate" with the value:@DateTimeParse(@Value(supByRegPlanDate), %Es) The output for regDate is the string: @DateTimeParse(1543293100000, %Es)However, I am expecting an output similar to: 20181127043140Any suggestions why the output is showing the expression that had obtained the value from the feature, but, not created a DateTime?
I'm working with CodePoint Polygons (areas for Postcodes) and have developed a Workspace to count addresses in each Postcode that are inside and outside a certain area. I'm using AreaOnAreaOverlayer to split the polygons into 2 where they cross the border of the other area. However, the consquence of this is that Vertical Street* polygons get merged (I think the Tolerance parameter is doing this), which causes one of the Postcodes to be lost. This means I don't get an address count for it.I've tried using Group By Postcode, but this crashes the process because there are too many unique Postcode values. A WorkspaceRunner to process each Postcode separately seems overkill. I can do it by Using Attributes From One Feature, creating a List of Postcodes, then using ListConcatenator etc to re-create the deleted polygons after AreaOnAreaOverlayer has merged them. But this seems a rather tortuous way of doing it.Any suggestions?* a Vertical Street is something like a tall
I am attempting to remove extra spaces and other characters from a attribute entries. I was able to find small script that does the job but in python. For Example:point_NAME (Before Processing)A B C Bank , DreamTownpoint_NAME (After Processing)ABC Bank, DreamTownI am able to detect the points which have these extra spaces and I am attempting to pass these on to pythoncaller transformer.I want to use this syntax in python caller. Can someone help me out? import restring4= "POI_Name"print (re.sub(' +', ' ',string4)) Thanks for all the help in advance!! :)@takashi @david_r @Mark2AtSafe @MarkAtSafe
Hi All,I'm trying to apply geotiff imagery to 3d roof geometry with the Top Down Georeferenced method (using Attribute Join within the transformer). The geometry is rejected and encoded with the MISSING_REFERENCEE_KEY string.Any help is much appreciated!Thanks,Charles
I have built a workbench where I do some processing on a set of features and then test the result. If the result is not what I want I would like to go back to the original feature and send it down a different path. How do I do this? I know how to find duplicates, set counters and such, but how can I compare the attributes from features in two separate "data streams" and then output one of those "streams"? Apologies in advance for what is probably a very simple answer, but my Google-Fu failed me this time.
Hi all, I need to build a nested Json structure similar to a folder structure. Is it possible to do with the JsonTemplater wihtout a lot of sub-templates? I want something more dynamic or alternatively I have to post-process the Json. Thanks! /Jacob
I am using a FeatureReader to connect to our SDE GDB. I want to add a query (WHERE Clause) to the FeatureReader so that I am only pulling in records within the Feature Class that were edited within the last month (or sometimes edited in the last 5 days).When I look at the SDE data via MS SQL Server Management Studio (SSMS) vs within FME's Data Inspector I see the data in different formats:Within SSMS - LAST_UPDATED field is a DATE field: last_updated (datetime2(7), null) 2018-12-01 16:23:56.0000000Within Data Inspector - LAST_UPDATED field is STRING field: last_updated (string) 20181128133118My questions:1) is there a way to specify which attributes I want to be brought in? Right now I am using an attribute manager to remove the unwanted attributes.2) How do I only at a WHERE Clause so that I only pull in the data I want within the specific time range? I have tried "last_updated" > '20180500000000' but this brings in nothing. I a
Hi all,I have a question a bout spatial join.I have 2 folder data. Folder 1(GA Folder) and Folder 2 (CHANGE REGION).I want to join spatial each file in folder 1 with a file in folder 2 which the same date.Actually, I can use testFilter for each date but it's manual. So I want to use other way to make it automatically. Could you show me how to the way to make it?Thank you
Hi,I am trying to flatten information stored in XML into a tabular structure. Some attributes can be repetitive (for instance a water area name can be provided in different languages or different alphabets). My guess is that the XMLXQueryExploder transformer should be able to play a role there or maybe simply a ListExploder. I guess using a XQuery would be more appropriate but I didn't figure out the appropriate syntax yet. Basically I would need to extract the name information from the attached XML and populate these into a tabular structure such as shp or gdb table. The desired layout would look like: FeatureIdNameTypeISOLanguageCodeLanguageCodePrimaryNameIsoScriptCodeNameTextNotationAlphabetGeoActionTypeGeoView93e05831-25b5-4df2-b264-179c9b7914b2StandardNameENGEnglishTRUELatnPersian GulfLatinRemoveZAL93e05831-25b5-4df2-b264-179c9b7914b2StandardNameENGEnglishTRUELatnArabian GulfLatinAddZAL93e05831-25b5-4df2-b264-179c9b7914b2StandardNameARAArabicFALSEArabاÙ?Ø®Ù?Ù?ج اÙ?عربÙ?A
Hi I am trying to run an SQL to select records in past 10 mins from OracleI have tried various methods in my sql, but none seem to workselect * from table name where updatedtime >= sysdate - interval '10' minute select * from table name where updatedtime >= to_char(sysdate - (10/24/60), 'DD-MON-YYYY HH24:MI:SS')I am thinking of setting a parameter to the required datetime and use it in SQL ServerCouple of queries:1) Is startup script best place to create this parameter2) Will SQLCreator query work with a parametere.g. select * from table name where updatedtime >= to_timestamp(fmeparameter, 'DD-MON-YYYY HH24:MI:SS')where fmeparameter ='14-DEC-2018 14:00:00'
I don't see any readers or writers for Mapbox datasets and was wondering how you can manipulate. Trying to manipulate the vector data in the map opposed to the Tiles. Any help would be great, thanks.
I have a mesh example which I'm trying to simplify with the MeshSimplifier. When using certain different Settings I get either a mesh or a rejection message. In the attached example the mesh passes when using 0.5 as the Relative simplification amount. When set to 0.2 I get an invalid mesh. Also when using the result form the MeshSimplifier.Can anyone tell if my mesh is invalid or if this is just FME behaving badly? If it is the mesh does anyone know if there is a way to fix it? Example: