Transformers

Hello,I have multiple invoice CSVs I pull in every month with about 300 records each. It eventually goes into a database table that is used as a lookup.The CSV has an invoice_date column and at first I thought the invoice dates were all the same format (M/D/YYYY >> 2/1/2020), however, some invoices have dates coming in the following format: (YYYY/MM/DD >> 2020/02/01).I was wondering if there was a way to standardize this so I don't get NULL date values in the translation when the date format I'm looking for isn't recognized. I'm having a hard time doing a condition because both the date type use the "/" character as a separator. If it was a "-" or something then I can use a condition to search out the special character and parse those dates using a particular format. Any help on this matter would be very helpful!Thank you.

When using a SQLCreator or Creator, I can't get the VariableRetriever to attach attributes to the created data. It works correctly with any other data but not the creator(s). Can anyone else replicate this behavior? FME 2020.1.0.0 (20200305 - Build 20510 - WIN64)  Works correctly with a shapefile input _value is left null for the creator and SQLCreator records

Trying to use the PointOnAreaOverlayer to merge points and bounding polygons. While I suspect some points may be outside the polygons most should be inside. The result I'm after is that each point will inherit the polygon attributes, but it seems that no matter how I configure the Transformer the Polygon attributes are always <null>. Any help or examples would be well appreciated.

Hello there, I tried to comment on content of post https://knowledge.safe.com/questions/52852/seperate-a-single-field-values-into-two-xml-elemen.html# but for some obscure reason wasn't able to do so.My question is a follow-up to the remark of @takashi in the other post concerning the tokenizer function:Note: <bnr:foreignKey> elements would not be created if fme:get-attribute($fkey) was empty.I ran into exactly that kind of situation. What would I do to avoid this?I'm thinking about an if then else conditional statement but fear I am not capable of doing that. Assuming that $anykey is empty - would such a construct work?{    if ( fme:get-attribute($anykey) ne "" ) then    {    for $k in fn:tokenize(fme:get-attribute($anykey), '#')    return         <mri:keyword>              <gco:CharacterString>{$k}</gco:CharacterString>         </mri:keyword>    }    else    {    return         <mri:keyword>              <gco:CharacterString/>        </mri

Hello:I created a workspace with a python caller to access a Zoom api endpoint. I copied the same python code from Zoom's code generator and the code runs fine. I copy the same code into a python caller and I receive the following errors. I have no proxy I am going through. I have very limited python experience. Any help would be appreciated.Errors:Python Exception <SSLCertVerificationError>: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1076)Error executing string `import<space>http.client<lf>import<space>fme<lf>import<space>fmeobjects<lf>#<space>Template...Factory proxy not initializedPythonCaller (PythonFactory): PythonFactory failed to process featureCode:import http.clientimport fmeimport fmeobjects# Template Function interface:# When using this function, make sure its name is set as the value of# the 'Class or Function to Process Features' transformer par

Hi Guys,Can any one guide me on how to perform "INPUT" I have to as "OUTPUT" I require...Input will be GDB object class tableOutput will be excel spreadsheet.Schema of the table will be dynamic as I will use different tables. I have provided spreadsheet as an example to understand better...Thank you

I have a tabfile that I want to migrate to a database. But first, I need to correct som geometryerrors. I have a polygon layer with some lines on polygon, please see picture below. I want to have them removed. One other thing that is weird is that when I use the transformer GeometryFilter the line object won't filter as lines. They will filter as areas.I Appreciate all the help I can get.

Hello, Currently I'm trying to get a 3d model out of a 2d drawing. Now when extruding different areas and clipping those with each other to get the right solids i encounter a problem. When the boundaries of the different polygons are overlapping (for example: walls and rooms) I encounter the problem that FME sees a very tiny difference between them which leaves me with this very small boundaries where the overlapping lines are.Is there a way of solving this problem? I have messed around with the clipper parameters but for now I didn't manage to get any success. I also thought about buffering the certain areas by a very small amount to just get over the edge but I don't really like that solution; as this makes the model inaccurate. Also I guess this has to do with the floating point problem? When extruding i don't get the exact length but something that differs 0.00000001.Do i have to use the topologybuilder in this case? If yes where do I put it in? I'm still search

Hi All,I hope you are well and healthy! I wanted to drop a quick message to give you some updates on our move to a new community platform. As mentioned long ago (far too long -- sorry for the lack of updates!) we plan to migrate to a Salesforce-based platform and we've been working hard behind the scenes to make this happen.  We are getting close (estimated release date of June 15) so I wanted to start the conversation with you all on what might change and how you can be involved.Firstly, revamping the community means we can take a chance to highlight your efforts. I've been working with our design team to do just that. We should have some special recognition for you that will live publically on the community.  Secondly, we love for you to get a chance to see it firsthand before we go live. We'll look to allow some beta testing and we'll set up a private group for feedback.Lastly, I want to expand the program and add a few new members (we'll be reaching out to a few

We currently use a JMS service that we connect to as a client, via some simple Java code (a Solace JMS service, that we are not the administrators of).We are struggling to connect to the service using a JMSReceiver in FME Desktop. For simplicity, we have copied all of the relevant JAR files into the FME /plugins directory.If we specify the Username in the transformer property, it is not recognized by the initial context factory (the context class returns a "Username must be specified" error). Instead, we have to use the "Additional Provider Properties" and specify:java.naming.security.principal=myusernamejava.naming.security.credentials=mypasswordUsing my network traffic monitoring tool of choice (Wireshark), I can see the initial connection to the URL. However, the server returns a "The username or password is incorrect".Questions:What is the JMSReceiver doing with the Username and Password fields?Is this the correct format for Additional Provider Properties? The documentation is not 

Is there a way to reject or fail all features containing same value? Right now I would ideally like a way to route all features containing same value to failed port. Currently, for example, if I clone 1 record 3-time, two features fail and one feature pass. How do I route all features that have non-unique values to failed port?

Hi everybody,I have problems to show geometry after SQL statement.Inputs:-PostGIS public database: geometry (polygons) & table I am using the SQLCreator transformer and my query (SQL Statement) works properly but in Data Inspector only the table result of my query is showed but not spatial elements.I´ve tried to use 'GeometryExtractor' in order to extract the geometry column, It does but neither shows spatial elements. Any idea? I don´t know what I am doing wrong?Thanks,Juanjo

Hi,  I try to make lines from points to the nearest polygon. I used Counter as unique ID for the points, and a geometry remover because I thought is necessary to obtain points from the vertex creator. However, it still does create lines. Also the result I want (LineBuilder) are obviously weird. Whats going wrong here?  Thanks! 

Hi.I originally had some issues with 2019.0 om my home pc with a home license. It crashed every time I added a Tester or a TestFilter transformer: https://knowledge.safe.com/questions/90340/fme-20190-problems.html These problems were solved in later builds, and neither 2019.2 nor 2020.0 crashes like this anymore. However, I just accidently ran into other similar problems with both 2019.2 and 2020.0 (and even 2018.1) on the same pc.Now it's the transformers AttributeFilter and AttributeValueMapper that makes FME crash immidiatedly.And I noticed that the Sorter transformer doesn't provide any attributes for the sort value either.Luckily both versions work on my office pc, but I would very much also like FME to work properly at home. Are there any information I can provide that'll help find the source of my problems ?I did check the "Improve FME by reporting ...", but I suspect it doesn't work when FME crashes.The pc in question is Windows 10 Pro version 1903 bui

I have a working pipe network where I know how many service connections are on each pipe saved as the attribute [_count] on each pipe.I'd like to count the number of connections upstream of each pipe segment and save it as an attribute on that pipe. Our goal is to prioritize emergency repairs based on the # of properties a particular pipe segment serves.Most of the examples and transformers are based on the shortest value (time, travel, length, etc). I kind of want the opposite. StreamOrderCalculator could work if I were allowed to 1) use an attribute instead of Stream Order Type, and 2) accumulate that attribute at nodes instead of checking which one is larger or if they are equal. Same with StreamPriorityCalculator. It's looking for shortest path, not longest.Any suggestions are appreciated.

Hi there,i am trying to calculate area of whole bunch of vertical standing free form 3d Polygons but somehow the calculated areas (sloped area) are not correct, for instance a polygon that suppose to have 35m2 area (calculated in autocad), gets here a 18m2 area in FME!i import a dwg with closed 3d polygons in FME and then i use "Area Calculator" with Sloped surface option and multiplication factor 1. the units area in meters...does it sound familiar to anyone and is there any solution to it? any help would be appreciated. 

I have a MapInfo table with attributes Species, GridRef, Year (such as 2020, 1999..). There may be many records where the Species and GridRef are the same, but I want to filter and retain only those with the most recent Year - so only the most recent record for a Species at each GridRef. There can also be many where Species, GridRef and Year are the same, but I just want one of those with the most recent year (it wouldn't matter which). I think by using a combination of Sorter and Sampler I should be able to sort by Name, GridRef, Year and group by these in the Sampler - so it should pick the first record in each group? I tried this but still seem to be getting duplicate Species and GridRefs in the result.I'd be very grateful if someone could at least point me to the right transformer. or give me details about the parameters I should be using in the Sampler.Many thanks, and keep safe,Jane

Hi There, I have polyline feature class (in GCS_WGS_1984) and I want to perform Generalize function (ArcGIS Link) on the layer for 10 meter treshold. I found this transformer Generalizer transformer that seems like right transformer to use but it has lot of options to choose from. I am trying to figure out the equivaent in FME world for ESRI's Generalize function. Appreciate any input.

Hi all, I was looking at this arcticle: https://knowledge.safe.com/articles/176/fme-temp-environment-variable.html  I have created FME_TEMP system variable to point to an drive with a lot of space (D drive) I have some big WBs which create a lot of temp files, but these still go into c:\\user\\...\\temp folder and sometimes space on C drive will run out and WB will fail. What is the problem here and how can I tell FME desktop to write temp files to D drive? Do I need to create the FME_TEMP per user and not per system? Something else?

Hi everyone,I have a workspace to create polygons from point with aixm 4.5 data (previous question here, thank you @takashi)Somes of the polygons contains arcs, and theirs direction clockwise (CWA) or anti-clock wise (CCA) matters, I don't know how to handle this in python, or with other transformer.Any ideas ? Thanks

I have created a fme workbench. It has creator transformer, python caller and S3 Uploader. The purpose of the workbench is to created a pdf (python script does it) and to upload that pdf to S3. Our FME is 2019.2.  I am using custom python3 installation. If I just run creator and python caller, all works fine. If I disable python caller, and run creator and uploader, all works fine as well. If all parts are connected, I am getting an error:Python Exception <ImportError>: cannot import name 'ssl' from 'urllib3.util.ssl_' (D:\Program Files\FME2019.2.3\python\urllib3\util\ssl_.py)PythonFactory failed to load python symbol `fmepy_amazons3.connector.S3Connector'Factory proxy not initializedS3Connector_CALLER (PythonFactory): PythonFactory failed to process featureA fatal error has occurred. Check the logfile above for detailsBridge failed to output feature on tag `PYOUTPUT'PythonCaller (PythonFactory): PythonFactory failed to process feature In all cases, python script creates output p

The revised dataset uses a sql executor and the value is 0.00001600. The value from the sde is 1.6e-5.When using a change detector always show as updated when the values have not actually changed. Can I fix this in the sde reader or is there a way to ensure that there is no conversion to scientific notation?

Hello guys,I´m new to FME and would need some help with the following problem:I want to create a gdb out of a dwg file. For this dwg a local coordinate system was used, but it is not set. Unfortunately, the only thing I´ve got is a sligthly complicated formula for a (similarity) tranformation to the underlying MGI (EPSG: 31256) including these paramaters: Offset dx[m], Offset dy[m], Center of rotation x0[m], Center of rotation y0[m], Rotation angle [rad]. Because Millimeters and the rotation center were used the formula for the new x´ and y´ looks like this:x´= x0 + (x/1000-x0) * cos(-rad) - (y/1000-y0) * sin(-rad) + dxy´= y0 + (x/1000-x0) * sin(-rad) - (y/1000-y0) * cos(-rad) + dyFirst, I tried a combination of CoordinateExtractor, Offsetter and Rotator, what didn´t bring a perfect result regarding the coordinates. Besides I had to aggregate all the features to one because otherwise the Offsetter changed the pattern of the lines.Then I tried the Affiner, but (thanks to my math skills)

Dear friends,Please help me to merge two databases in single MDB, merge MDB file for winter 2019-2020 to winters 2009-2020 mdb database. I tried few options and it did not help much.Also, I want to setup the system in task schedule. Thank you. Abzal

Hi, I am trying to generate a table with N columns and R rows as a layout page in a DWG file. I have this table defined as a template and the data is from different sources like shape files. I am creating a Multi-text for each field and using a VertexCreator with a fixed x,y position in the paper space to place them at each column. Everything works fine except that the rows are filled in the upward direction rather in the downward direction. Is there a way to auto calculate the position of next row ( x,y ) for multi-text or any other ways to auto fill the table ? any insights to set the rows automatically would be highly appreciated.