A read-only category for lost FME Form topics. We hope to move them shortly.
Recently active
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.
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
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 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
I am setting up a WB dynamically to migrate data from one DB to another. Each feature types has a several hundred thousands of objects. Whilst developing the WB i dont want to read the entire content of the source tables and has therefore set the reader option "Features to Read" -> "MaxFeatures to Read Per Feature Type: 10. In that way I can Create the destination tables before I run the entire process which will take a while.But even if I have set it to read 10/feature type it only read the 10 first features of the first table. I was expecting it to read 10 features from each of my 30 tables?I can also see that it is readying the entire feature class but only processing the first 10. I am confused of this feature?
Hello,When I put a gdb file in my process with the reader, its works, the file is read. But when I put another gdb file with the same reader (thanks to a parameter) it isn't read if this file hasn't the same name field. Why ? Thanks you
I've created a workspace that updates (and truncates) an ArcGIS feature service. It works great! I'd like to run it once a day in the middle of the night like 3:00 AM. I have a floating FME Desktop license and don't have access to an FME Server. I use the floating license on my desktop and laptop computers, both run Windows 10. I think that this may be more of a Windows 10 question rather than an FME question. Can anyone recommend a way for me to run an FME workspace once a day at a specific time on my desktop machine? Because I have a floating license, I think that I'll need to make sure to FME Desktop on my laptop at the end of the day. Thanks.
When the workspace starts I have the user select a certain attribute. Depending on which attribute is chosen I want different user parameters to come up. So for example I have a list of six items. If they pick item 1 then the attribute manager calculates a number of values. I also want it to display different user parameters depending on which inital item is chosen I hope this makes sense? I'm just not sure if I can even do this in FME. I notice any user parameters I create always show up altogether at the beginning.
Hello FME Community,can someone tell me where i can find documentation format attributes of AutoCAD (autocad_*). Vielen Dank.
Uninstaller fails with "Error Code 2330", so going to have to manually clean it out looks like. An unfortunate consequence of our Corporate ICT policies setting the FME2018.1 package to automatically reinstall itself, even after the upgrade to FME2020.0 had just uninstalled it, and now I'm trying to repair the whole mess.
While configuring FME server with SSL certificate(with DNS entry) its working fine for localhost and server name. When i try to access it using DNS name it gives error site is not secure and certificate mismatch addresses.
When reader is for rvt file and writer is for gltf file, I get model dimensions enlarged 1000x,for example one dimension is 33.000m instead of 33m. Any suggestion how to correct that. Thanks
Hello, we have several 3D buildings that need to be extended downwards. That's why we applied the extruder in conjunction with the terrain model. After that we aggregated the two parts (aggregator). However, then when we turn on the contours, there is the undesirable effect that there is a line between the 3D building and the extruder building part. (see example, highlighted in yellow) How can we remove this line?Or is there another way to extend the buildings downwards?
How to customize error message in Server Apps ?
Hello FME Community, I have been working with batch files and all goes well when my reader and writter are in posgtresql but when my reader is in access(.mdb) file or excel it causes problems,it says that it cannt find the file where the file already exist and the strange things is that it worked once. When i created a new batch with same workflow and same file i get the following error. I seems a problem of url as the \\ are removed but i dont undarstand the cause of it. I'm attaching the .tcl files for the the workbench that works and doesnt work( they are exactly the same apart the name). The file that ends with 22 doesnt work and it has less code than the other one. Thanks in advance for your help.