FME Form

hi i have some features contain arabican numbers (۰۱۲۳۴۵۶۷۸۹), how to convert any arabic digit to english (0123456789)? for example all of ۱ converts to 1, or all of ۲ converts to 2 and so on thanks guys

Hello, I created a batch file and need to run it through a task schedular. The file gdb needs to change in this batch file on every run. I am not sure if is there a way to loop through a folder and select the current gdb from the folder.  "C:\\Program Files\\FME\\fme.exe" "D:\\Workspace_features\\Country_NEW_APM updates_FeaturesOnly.fmw" TRANSACTION_TYPE_GEODATABASE_SDE "VERSIONING" VERSION_GEODATABASE_SDE "DBO.SarahS_APM_edits_Country_006" geodb "G:\\APM_DOWNLOADS\\Country\\Country_Bulk_2022-05-01_22-43-59\\Country_Bulk_2022-05-01_22-43-59.gdb"PAUSE Any advice and suggestion would be greatly appreciated! Thanks, Sarah

Hallo FME Community, I am trying to convert ArcSDE to DWG file. A DWG template is available for this, which must be applied to the points (See picture 1).   in my file there is a column named autocad_block_name. this column defines which symbol in DWG template has to be applied to which point. one layer can contain two symbols. (See Picture 2)   Other column is autocad_layer sets the name of the layer in writer.   the DGW Template contains 250 layers and each layer contains a symbol. from these 250 symbols we only need 40 symbols. what problem is that my result contains all layers of DWG_Template and autocad_layer column. I want my result to only get the layers that are in my autocad_layer. 

Hi all, I'm trying to download a file from a secure url using MOVEIT platform. The URL for the file looks like: https://moveit.alleghenycounty.us/download?arg01=file859046970&arg02=124162592&arg03=b24db17e945a7f9aeee83c81d52cbc The site uses a secure login and I have username and password The first step in the workflow is to download a .xls file. Do I start the workflow with an HTTPCaller or do I need a reader first? Any help would be greatly appreciated! -Jason  

Hi All, the attached screenshot explains a lot so might want to check that out first. My problem is that I have successfully set up a homemade 'file watcher' where we can drop various files into one folder to be sorted and moved to their correct folders. All this is doing is saving a lot of manual drag and drops but there's a lot of them so it's quite useful (if I can get it to work).  As you can see in the screenshot, the first 4 files sorted just get copied back out and that works perfectly. The 5th, an xls file called 'covid vaccine data', needs to be read in and the records written back out as a csv before being copied elsewhere. You can see that I attempted to use a Feature Reader but the records come out blank so the writer at the end writes out 1,274 blank rows. Any idea how to make this work so I can get that file, read in the actual data, and write it back out? It feels like I'm close but it sure isn't working yet :) Thanks in advance,Ian

I have a series of fillable PDFs that are used by stakeholders to apply for a permit. Another form in the series is used by stakeholders to report back on the activities of that licence. Can FME transfer the information in these forms into a used database

I'm trying to move address points from essentially rooftoop locations to the curbside of the address automatically (working with about 10,000 points) I've got the polygon parcel data, the address point data (contains which side of road the point is located on, but is the only layer I have with this information), and the road polyline. I thought the best way to set this up would be to move the address points within its containing parcel to the closet edge of the parcel it's contained in. However I think there would be quite a few scenarios where it wouldnt move the point to curbside and so I'm trying to figure out if that is the cleanest approach and how I could set that up, or if theres a better idea. I've added a picture of the layers I'm working with and how I want the points to appear. Ideally I'd want the points moved to where the end of where I've drawn out the red line would be the ideal goal, however if I were to move points to closest edge of par

Hi everyone, I'm currently trying to decrease the size of different file consisting of line and polygon geojson. After reducing the number of attribute and the name to a minimum, I'm looking to reduce the coordinate lenght of the those file.  I used the generalizer to decrease the number of coordinate being ouput by the line and polygon features. The other thing that would really help is to reduce the number precision or lenght of the number. I've tried to use the coordinaterounder transformer, but it those not remove the number itself.  From what I've read, only a python caller could round element in a list. If I choose this way, would I have to use a jsontemplater to format my geojson.  First, would it be possible to round the coordinate output directly in the geojson writer? Second, what would be the script to add in python caller. I'm very new to python.   

I sometimes use a FeatureJoiner to correct data fed into the Left port. I use a StringConcatenator and JSONFragementer to generate the corrections, which are fed into the Right port. The FeatureJoiner's Join Mode is set to "Inner"; Join On specifies an Attribute from each feed that match each other 1:1; Attribute Conflict Resolution is set to "Use Right". What I find is that conflict resolution is NOT applied Feature-by-Feature; it's applied to the entire set of joined Features. So, if none of my correction Features correct a particular Attribute in the Left feed, all of the Left Attributes bearing that name are passed through intact. But if even one of my correction Features corrects a particular Left Attribute, the remaining correction Features will replace the value of their corresponding Left Attribute with "<missing>". To avoid this, I have to add that Left Attribute - corrected or not - to every Feature in the StringConcatenator; what a

I already came quite far with the following post (I hope and think) https://community.safe.com/s/question/0D54Q000080hHLnSAM/dgn-to-dwg-conversion especially with the post of lenaatsafe. I think there are probably two important main steps to do: 1) Create a template file which is needed for converting the shared cells to autocad block (in my case I try to make a template file based on a cell dgn library)2) the actual translation between the source data (a dgn file with cells) and a dwg writer.  Based on her post, I think I managed to create a nautocad template file based on the dgn cell library. See below image in how I have created the template file. I think the template file has blocks, since next to the autocad_block_name that I have defined in the attributemanager, the autocad_block_number is added automatically added in output template dwg file (see image below) and for example 27 (as in the image below) for all the autocad lines that define water. However when I use this template

I am not able to connect to a SFTP server from the application. I can putty into my FME server and connect to the SFTP server, but I am not able to connect from the FTP caller within a workbench. I am trying to connect using ssh in both scenarios, but from the workbench I get a "login denied" error.Version 2017.0

While reading data from Smallworld, FME translation is terminated abruptly by throwing error "Error running translation." in the translation log. Generally if there is any issue with source, data then FME writes an error, skips the record and move forward. But here in this case after the error translation is stopped with error message. If the data come out of reader, we would be able to handle it by some logic. However, in this case data is not coming out of reader. Are there any settings in FME such that we ignore such records and move forward? I have already tried setting Continue translation in Rejected Features handling. It dis not work. Any ideas on this are highly appreciated. Kindly help ..  Thank youSiva Bulusu

Hi all,Just taking my first steps with FME. I am using the FTPCaller to download two .zip files that are provided on a weekly basis. When I specify an existing folder everything works fine. However, I'd actually like to download the .zips to a folder whose name is actually the date on which the download took place. However, when I try and incorporate this into the FTPCaller's 'Target File' path (e.g. C:\\Downloads\\@DateTimeFormat(@DateTimeNow(),%Y_%m_%d)\\@filename) the translation fails as the file is unable to be written.If the FTPCaller is unable to create a destination folder on the fly, how would I go about creating the folder?Any suggestions appreciated!Thanks!!

Hello, Could someone provide some information on how i would go about breaking apart a polygon based on the number of vertices the polygon has. It has to be similar to the ST_Subdivide postgis function. This function breaks the polygon into smaller polygons at right angles. @Takashi Iijima​ @davidmelanconasters​ 

Hi Team, I have a large map which has a route on it, I have buffered the section to widen the path and would like to know how to snip the map section out. Also how to adjust wider or smaller on the buffered route.

Which i then replace with regexp.How can i have it just yield following result? "amount" : 10000 I'd like to have it solved inthe Templater rather then resorting to regexp clean-up.  Tx in advance to all.

I receive datasets from users where some rows may have empty values for compulsory attributes.The AttributeValidator is testing for empty attributes. If I find any empty rows I want to reject all features. Any ideas? Somehow using a FeatureHolder?

Short version here for time: FME2021.2 64-bitArcSDE Geodb writer, truncating the SQL Server table in 10.x geodatabaseVersioned Edit Session to feature class that is registered as versionedFME log claims success and that all writes were saved. No errors, warnings or anything indicating an issue in the log at all.ArcCatalog and Pro report a blank tableSSMS business table has old data, deletes table has all features, add table is blank, inserts table has one featureConnection used to write has db_datawriter and db_ddladmin permissions to the database in question Any ideas on why this didn't quite work are appreciated. If it's as simple as non-FME solutions like post/reconcile or compressing to get things moving that's ok. I'm not an advanced SDE user in terms of versioning, a little better on archiving though. A workaround is in place and there's time to learn about this, and I have contacted my vendor but thought I'd try here as well. We could probably get aw

Hello guys we have a GDB with multiple layers, we need to generate sample data for each layer but with different rates for each layer, the problem I have is the sampler transformer will take only user parameter value not an attribute value how could we set the rate based on the attribute value ??Thanks

I'm currently using reading geotiffs(mosaics) generated from pix4d. And writing them backout again by removing the black band that is generated around them.  When I started publishing these out to arcgis image server I started to notice the projection was not aligning with points of the projected that have been collected. But the original generated by pix4d didn't have this alignment problem. All our mosaics created since 2021 are projected out in EPSG:6549 and when the geotiff is read through the feature reader it looks it's being detected as the following: Coordinate System Parameters CS_NAME: NSRS11.OH-NFDESC_NM: NSRS 2011 Ohio State Planes, North Zone, US FootDT_NAME: NSRS11EPSG_QD: 1GROUP: SPNSRS11FMAP_SCL: 1MAX_LAT: 42.55MAX_LNG: -79.98333333333333MIN_LAT: 39.88333333333333MIN_LNG: -85.31666666666666ORG_LAT: 39.666666666666664ORG_LNG: -82.5PARM1: 41.7PARM2: 40.43333333333333PROJ: LMQUAD: 1SCL_RED: 1SOURCE: CRS HARN/OH.OH-NF with datum modified to NSRS11UNIT: FOOTX_OFF: 1968500ZER

Hi,I am trying to make a flow where among other tasks I have to move some areas from one table to another and remove duplicates ID's for areas, but keep in 2 attributes a list of blocks (names and ID's) - like in pic attached.I thought I had a solution by using a Dissolver and put those values of ID's in a list, then using a ListConcatenator I could put them in desired new attributes. First issue I discovered is that the Dissolver didn't removed the duplicates (or not all of them) and BLOCKID and BLOCKNAME doesn't contain all values. Can you give me an idea on how to fix this issue? Thanks.Nicu 

Hi, Currently having 'fun' with the OnlineSharePointConnector transformer, this was correctly functioning on FME desktop and FME Server (both version 2021.1 ) for a me a week ago. Now the transformer none of the SharePoint sites I have access to appear and I'm getting the following error messages when attempting to connect to a site. Any assistance greatly appreciated.

Hello and welcome to What's Up WednesdayWe didn't get a post last week (sorry) so you can imagine that this one has a lot of items to mention! A Community Guide to FME Best PracticesLast week I tweeted a screenshot of a workspace I was working on and talked about how it was time to do some best practice on it:  Of course, Best Practice is more than just the style of a workspace; it's also about how you go about creating a workspace and testing/debugging what you have. Anyway, I suggested perhaps we should create an e-book or similar entitled "A Community Guide to FME Best Practices" and it seemed to be a popular idea with everyone. So I'm now determined to make this a reality and will reach out soon to those folks on Twitter and anyone else who would like to contribute.  I'm really excited to get this going and think it will be a great community project. FME 2022 NewsWe've all been waiting anxiously for news of when FME 2022 will be released, and now w