FME Form

 Value in Source Data:DWGNAME,OLDHANDLE,NEWHANDLE,X1,Y1,TYPE,NEW_IDBDCV.dwg,3F7,16354,2181887.040872167,12004078.93869873,ROUTE,1233345The String replacer is defined like $(DrawPath)@Value(DWGNAME)Output from transformer:If DrawPath Parameter=C:\\ClientMaps\\C:\\ClientMaps DEFAULT_MACRO FME_DATA_REPOSITORYBDCV.dwgif DrawPath Parameter=C:\\ClientMapsC:\\ClientMapsBDCV.dwg I need the output to be C\\ClientMaps\\BDCV.dwgThanks

I'm using the HTMLReportGenerator to display a map with points. In the "Label Attribute" setting I've combined several attributes. I want the points that contains a certain word to be in a certain color. In my example I have two different words that should determine the color, "KFF" and "SBF". The label attribute is a long string containing these and some other values ("Example: {3553} KFF). Is there a way you can achieve this with StringReplacer? If feature.properties.name contains KFF than set the color to red else set the color to green.

Hi all,I have an excel file. They have id, photo fields.The photo field include multiple url image. If I use ImageFetcher, I can't download the attribute include multiple link. Could you share to me how to fix it? Thank you  

I want to copy files from one folder to another in BIM360/ACC with AutodeskBIM360DocsConnector, and in BIM360/ACC there is a Default Attribute column for Description. And when I copy them in FME the Description does not come with.  In AutodeskBIM360DocsConnector there is no option in Attributes to Add called Description.  Any suggestions for how I can get the Description in the copy process? 🙂 

Im trying to change the crs of a shapefile. It needs to be in the same as below:When using the Reprojector transformer Im getting an error Transformer parameter:After running the workspace Im getting the following error:Reprojector (TeeFactory): Reprojector: Reproject: Could not reproject the geometry of the preceding feature: Unknown coordinate system 'EPSG4326' specified - abortingReprojector: Reproject: Could not reproject the geometry of the preceding feature: Unknown coordinate system 'EPSG4326' specified - abortingTranslation FAILED with 4803 error(s) and 2 warning(s) (0 feature(s) output) When using the EsriReprojector transformer the workspace runs succesful but the srs is a

EDIT:I have created a text parameter with value contractor_log and used that as the layer name in both, this seems to have fixed the problem (not fully tested yet). This seems to be more of  a hack than a proper solution. Is there a 'more correct' way I should be doing this? Hey, I have a workbench that manipulates some input data, then it checks an arcgis online table (contractor_log) to see if this particular mobile number exists in the AGOL table. I need the AGOL table to be UPDATED if the mobile number exists in the table, but if it is new (non existent in the AGOL table) I need FME to INSERT a row into this AGOL table, which is a dozen field to insert. I have inserted the AGOL WRITER into my workspace, setup my UPDATE writer which works perfectly, I now wish to duplicate this writer to setup my INSERT, but when I create a copy of this it must contain a unique layer (table) name, which is not ideal, as I want both writers connecting to t

I'm processing a point feature class (21 million approx points) I'm fanning them out into shapefiles, smaller than the 2G limit. It produces shapefiles, missing the .prj file. Any thoughts on why ?

Hello, I would like to ask how to solve this problem,that there are several databases. In line, polygon, point and text formats. The question is whether it is possible to create an excel file that contains all database names, as well as what attributes are there as well as attribute names and alias names. In addition to this, what are the results in the attribute table and the corresponding domain names.And export it to xlsThanks in advance

Hello everyone, I searched a lot about this topic but nothing matched the same problem. I have a functionnal ftps URL that return the good file in filezila. But when using it with the FTPCaller, it return a timeout. Whatever the parameters are.But if I declare the URL as a SFTP, it does the job.  It work here because the server do accept the query with sftp but if not, I am afraid I'll be block with the ftps only.Does someone face the same problem ? Did you find why and how counter it ? Thanks in advance ! Have a good day.

I have tried a bunch of different coordinate combinations to find one that may work. Using the one that I have always used the objects translate in the correct location, but the scaling is incorrect. Other coordinate systems the text is the correct scale but not in the correct location. I am translating from NAD27 mm to NAD27 ft. looking for an answer so we can move forward with a software upgrade. See below for coordinate info that I am using. # KB 01/11/2013 - SRP database projectionCOORDINATE_SYSTEM_DEF SRP_AZ_Central_mm               \\ DESC_NM     "SRP Arizona Central NAD27 millemetre"  \\ SOURCE     "SRP GIS"                 \\ DT_NAME     NAD27                   \\ PROJ      TM                    \\ UNIT      MILLIMETER                \\ PARM1      -111.9166666666667            \\ ORG_LAT     31                    \\ SCL_RED     0.9999                  \\ X_OFF      152400

I have an Excel file (table). How do I prevent it from reading the 1st row of the table?

Hi, I have a parameter in my workbench that I want to lock down to expect a 10 digit phone number. Here in Australia they all start with 04, so I am hoping to make my parameter restricted to between 0400000000 and 0499999999. It doesn't work if I use integer, because it drops the leading zero. Does anyone have any tips on how I can achieve this? Ultimately this will be published to server and be a web form input field. I am hoping the user cannot press submit until the mobile number is in the range I mention above. Cheers

I am reading in an ESRI File GDB, and using several attribute transformers to populate existing fields. Everything is working the way that I want it to (looking at the inspector), however the changes are not being committed to the tables when the translation completes.  Do I need to have a writer in place to commit the attribute changes to the table? Is there something else that I need to add to tell the process it is complete, and the changes can be committed?  I am not looking to create any outputs just update the attributes that I have targeted.

I see this new UPSERT functionality...Where can I find help docs for upserting to file geodatabase gdb?  Thank you, TylerSAFE FME 2022.1

I could make a simple workspace that can convert from shape file to kml, but it is only allow to covert one specific shape file, due to the Name/attribute value differences for each shape files. Therefore, I would like to make a workspace to available to convert various shape file having different Name/attrbute value that can automatically read/extract each file attribute values, beyonds files and allows to select to show in output Kml file. i.e.) set varrious attirbute value available in Kml property setter. I'm very beginner, so my question is bit silly, but if you have some suggestions, idea, method, that would be really helpful. Thank you for your reading.

Hello.I have two excel files (1) and (2) that contain a column of addresses.The "House number" column in the excel file (1) and the "Houseno" column in the excel file (2)How could I compare the two columns and notice the similarities and differences.Thank you very much! 

HiSituationWe have a quite simple FME Workbench, loading CSV data from an URL, and writing it's data to a MSSQL database. The workbench works fine, writes all data and terminates with "Translation was successful". ProblemSometimes (actually mostly) the workbench doesn't stop right after it logs "Translation was successful", as it's supposed to do. Everything's done, all records have been inserted, but the workbench keeps running. Sometimes it takes 5min or 10min, sometimes it takes days until the workbench stops.The screenshot shows the situation. In this case it was a time lag of 5 min. FactsFME 2018.1MSSQL 2016; it's on the same machineWith PostgreSQL or Oracle we never experienced the same issue Any ideas

I'm trying to Create 3d polygon with a center polygon and a buffer around it, I need to have an incline of 1.2 percent from the center polygon towards the edge of the "buffer". Hope someone can help, and thanks in advance. I've come this far, but I'm missing something:

Hello. Is it possible to create straight labels along curved lines with MapTextLabeller? Usually this transformer creates curved labels spread out to every single letter that I do not want. Lukas

This is the error I am getting when I trying to upgrade the pip --version in the base image and build a new fmeserverengine image:Step 2/45 : RUN python3 -m pip install --upgrade pip ---> Running in 95e4bf57b3f0Fatal Python error: Py_Initialize: Unable to get the locale encodingModuleNotFoundError: No module named 'encodings'Current thread 0x00007f43b515f740 (most recent call first):Aborted (core dumped)Fatal Python error: Py_Initialize: Unable to get the locale encodingModuleNotFoundError: No module named 'encodings'Current thread 0x00007f43b515f740 (most recent call first):Aborted (core dumped)Service 'fmeserverengine' failed to build: The command '/bin/sh -c python3 -m pip install --upgrade pip' returned a non-zero code: 134 The base image which I took it from :/quay.io/repository/safesoftware/fmeserver-engine:20632 

I need to run approx 10K zipped LAS ASPRS files and generate an xyz file with 5 m grid using ground values. Looking for a workflow to do this.

Hi, After using the NDVI calculator I would like to get the image indices that vary between -1 and 1. How can I do this in FME? Thank´s

Hallo , i have lines data and I have only start point and end point of line .but I would like to get all geometry of points from start till end point.,so I have used chopper to convert lines to points but my problem .I am not sure ,how could i add all geometry of points from start till end point in new attribute for the same id of line .FME 2021Thanks for help .

Hi I am trying to connect to a public S3 bucket and have tried multiple times to connect and download files in the bucket. I just keep getting an error message. I'm probably entering something wrong but I've tried multiple different things and no luck so hoping for some guidance here. S3Connector: There was an error connecting to Amazon S3: 'Parameter validation failed:Invalid bucket name "shaking-layers/": Bucket name must match the regex "^[a-zA-Z0-9.\\-_]{1,255}$" or be an ARN matching the regex "^arn:(aws).*:s3:[a-z\\-0-9]+:[0-9]{12}:accesspoint[/:][a-zA-Z0-9\\-]{1,63}$|^arn:(aws).*:s3-outpo...'. Confirm that your credentials and region settings are correct. Some regions are not publicly available - contact AWS for more information. I have attached a screenshot of what I am entering in the S3 Connector.