Transformers

I'm trying to migrate from dwf's to GIS. When I inspect the dwf in inspector, none of the attributes that I really need and can see in Autodesks design review are even listed in the available columns under table view schema. Is this a known issue or is this due to my limited experience with FME?

Can somebody explain met the different encoding options for JPEG2000? Normally we convert our TIFFS to ECW with a nice result and the converting is very fast. Arcmap server needs an additional license to use ECW's, so I was thinking to use JPEG2000 instead.The image quality is a tiny bit better and the file size is smaller, but the convertion took so long...I used the standard FME writer options. Encoding profile 1 that is.What is the difference between all those profiles? There is very little documentation about it or I cant find any.  ThxKoen

Hi I'm wanting to use window functions in the Inline querier. For example, ROW_NUMBER() OVER (PARTITION BY .. ORDER BY). I see that SQLite version 3.25 onwards supports window functions. However, when I tried to write a query in the inline querier it was unable to execute the query. I'm using FME 2018.1.1.2. Does anyone know what version of SQLite the inline querier uses for FME 2018.1.1.2?

With the attached Workspace I am trying to match up to adjacent boxes that slightly overlap. I was hoping MRF2DCleaner would do this and remove the overlap. However, it doesn't seem to read areas at all.Problem.png shows the overlap. ExpectedResult.png shows what I want to achieve. Any ideas?

I'm creating an attribute for storing start date/time of processing with AttributeCreator and I'm having a hard time removing the decimal of a second. @DateTimeFormat(@DateTimeNow(local),%a %b %d %H:%M:%S PST %Y) OutputThu Jan 31 11:16:20.9415159 PST 2019 WantThu Jan 31 11:16:20 PST 2019

 Hi,I need to reproject data using FME and am wondering if FME's NAD27_to_NAD83_Canada_FME (Reversed) is the same as NAD_1927_To_NAD_1983_NTv2_Canada? 

FME Server 2018.1 - Build 18520 - linux-x64 (on FME Cloud)Workspaces loaded with FME Desktop 2018.1.0.1 (20180730 - Build 18528 - WIN64)Python Compatibility Scripting : Pyton 3.4+Apologies for the way the question is elaborated but I really do not known where this error in FME server is coming from and how to describe it (I googled it and I can't seem to find any reference)It is incosistent, it appears on workspace execution and the job fails (at the end) but if the job is rerun (same workspace) everthing works fine, then it may appear and disappear again. It appears in workspaces that do not have any python transformer neither start-up shut-down scripts.Could anyone help?Thanks

I have two datasets . Both of them consist of linestring. One data set is street centerline and the second one is the left and righ side of the street. I would like to find the lines in second dataset where they intersect with lines in the first dataset.It is pretty straight forward. I can do it in QGIS with help of spatial query. However, I am not able to identfy those lines correctly. Both Spatial Relator and Spatial Filter find some of the disjoint lines as intersected. I do not know what I am doing wrongly.I would be very happy, if someone could help me. Thanks in advance.Here is the snapshot how my two datasets look like. I would like to find the intersection as marked in the pic. This is how the workbench and spatial filter parameter lok   Here one can see the lines that are detected as intersected however they are not even touching each other.  Those lines are however identfy correctly as intersected.

When I move feature classes from file geodatabase to ArcSDE using FME, all the embedded metadata in feature classes disappear once they are moved to ArcSDE. Metadata is in the description of feature classes. Please advise what do I need to do to retain metadata?

I'm trying to map the header from my json so i dont have to manually paste them into the json extractor. So far i have two https callers one for the response body and the other for metadata. I create a list from the metadata for the header. This works fine! I next use attributeexposer but it just adds the list as an attribute. How do i get the list to become the header?

If I have a 2018.1 FME Server can I use FME Desktop 2017? What if I have FME Server 2017 and FME Desktop 2018.1?

HiI am extracting multiple hrefs. There are some irregular CSS tags that are being rejected. I have corrected the spaces by using a stringreplacer but there are a couple I cannot figure out. one being "Unsupported or invalid CSS selector: "democratic-republic-of-congo-(kinshasa)"I need to remove the parenthesis, there are also ones with the word "the" at the end of the CCS href. I only have about 12 of these, so is there a way to replace an entire href with another and I will just create 12 transformers? any ideas?

Hello, new user here.I try to make a geospatial pdf from multiple shapefile as source. I use Mapnikrasterizer for the style of each layer, but when I try to save the file, my layer are well stored but the transparency turn black. Thanks in advance for your advice.

I have an unconventional excel spreadsheet where the first column is a work order number and the subsequent columns are employee names. Below each employee name are the hours they spent on each work order. See below:  The goal is not only to use the value of an attribute column but also the attribute name (in this case the employee name) in a httpcaller without transposing/pivoting. So in theory the Request URL in a HTTPCaller would have the following format:https://***BaseAddress***/addcost?data={"WorkOrderID":@Value(Work Order ID),"Employee":"AttributeName","Hours": AttributeValue} I've yet found a function to extract the attribute name. The text editor only allows me to extract the value of the attribute. I'm unsure how to accomplish this. Any recommendations is greatly appreciated.

I have one reader with buildings (areas), and one with parcels (also areas, having 2 attributes: parcel_no, parcel_id). I would like to output an Excel file of every building, with the parcel or parcels where it is located, separated with a "/". For example:Building_no Parcel_no Parcel_id 1 1051/1052 P0356684/P0356685 2 1053/1054 P0264568/P0258934 3 1102 P0256425 4 1173 P0546742 Parcel_no and parcel_id have to be in the same order.What should I use (SpatialRelator or AreaOnAreaOverlayer)? What options should I select?And then, how can I aggregate the fields in one field (ListRangeExtractor, Aggregator, other...)?Additionnal question: can I list only the parcels where the building occupies more than 5 square meters (to avoid parcels that are juste a little bit on the edge)?

I am making a spatial relationship where there are several blocks for the same property, each lot of the same property has a unique value for the block column. If there is a spatial relationship of another file with one or more blocks, all blocks with the same block should appear as if there is a relationship. How to do this?

I want to execute a .sql file through FME. Is there any method to call a sql file before running FME translation? I think it is not possible through sql creator or executor. Is there any other way?

Hello!As you see on the picture, I have lines connected to object (topological). They have differents orientations.I would like to extract the orientation of the line that intersect the blue object and force it to have the first vertex (start) intersecting this object.Then I would like to force the orientation of all the lines connected and all the ramifications to be like this firt line, like a waterway network.I tried differents transformer like NetworkFlowOrientor, PathBuilder/PointOnLineOverlayer but without success. Do you have any idea? Maybe I need a loop or something like that?Thank you in advance!

My client is asking for a report of the mapping schema I used to import data into my database from his Salesforce. For example, he has fields a, b, c, in his salesforce and they relate to my fields. x, r, e, in my database. I use the attribute manager to do the mappings. He basically wants to see that I: mapped a to r, b to e, and c to x. Is it possible to do this?  If that doesn't make sense then see below. I am trying to explain to my client what field on the left ended up being map to which field on the right.

I have not found this case in forum.I have spatial point dataset from which I want make lines depends on some break attribute. I aggregated points based on this break value, and I received for example 3 set of points. From each of this set I want get Line.When I use LineBuilder, I get wrong result - each point connect which each point. I want situation when second point connect first, third connect second etc. ...For example by order of incoming points (remembering about break attribute).

I created the oracle connection inside named connection window. and tested, its good. But when i use the same connection for sql executor i am getting the following error Connecting to ORACLE database `EGIS_T' with user name of `EGIS' and password of `***'Error connecting to Oracle database: message was `ORA-12154: TNS:could not resolve the connect identifier specified'. (serverType=`ORACLE8i', serverName=`EGIS_T', userName=`EGIS', password=`***', dbname=`')ORACLE Reader: Using Oracle Reader to read tables from database `', server type `ORACLE8i', server name `EGIS_T', user name `EGIS', password `***'ORACLE Reader:fme is not mapping the connection name to connection object.where is the problem ? 

Hi.I have been assigned the task of importing 4000+ images from a remote service into a local Postgres database. An obvious FME task.Fetching the images with ImageFetcher runs smoothly, but here starts my problems:- I need to store the MIME type, but although ImageFetcher is set to auto-detect this, it never reveals it in the output. And no file extension is available, and no other transformer offers that service, so an improvement to ImageFetcher is warranted, I think.- I need to store the image in a text column in base64 format, but a combination of GeometryExtractor (FME Binary) + TextEncoder (Base64) doesn't really seems to work.The output should look like this: data:image/jpeg;base64,/9j/........Is there a better way to accomplish my task ?Cheers

What is the best way to count corn plants in a field? I have drone imagery, mostly infrared but some rgb.

I'm not sure what words to use, again, to find my answer so I'm just going to ask.  I'm new to Regular Expressions, and not an FME wizard by any means  I need to, inside a loop,  take text that looks like this: (i'd like to avoid using blocking transformers if possible at this stage in my workbench)OKC1D,790 [55559]|OKC1D, 791 [272]|OKC1D, 792|OKC1D, 796|XD, 4-6 [DEAD]And make it look like this:OKC1D,790 [5559]|OKC1D, 791 [272]|OKC1D, 792 [272]|OKC1D, 796 [272]|XD, 4-6 [DEAD] With string replacers and searches I can get this:OKC1D,790 [5559]|OKC1D, 791 [272]|OKC1D, 792|OKC1D, 796|I'm able to select what's in the brackets with: (?<=\[).*?(?=\]) but I get 5559 and 272,  I need a way to select the last matched group, 272, there are cases where it may be more than 2 match groups but I think that If I can just select the last one it should work  https://rubular.com/r/r2TsFBPPy19hFO   Any regex wizards out there that may be able to help me, OR suggest a better way in FME to do what I want

Established a workflow to convert address points .txt file to .dbf in order to add x,y point in ArcMap. Was able to do an expression fanout that would classify my address points by province (individual folders), but the output is not readable in ArcMap. Any clues? did I miss a step somewhere? Also, if I choose the reader as an .txt, (my file extension is .txt), the reader fails to read my file, I have to choose .csv instead.... also another thing I don't understand...