FME Form

I used fme desktop 2019my source data is fgdb with 104,073,607 (104 million +)featuresorg table shows 104073607 but only 80,900,000 records processed.there is no transformers between , reader is fgdb and writer is oracle spatial data. dont know , where was the issue. This is a silent failure of fme.no error msg. after writing the checked the counts, it was less. then i splitted the fgdb files into two part(using arcmap)then im fine. how to fix this issue? Please  

I tried to use TwilioSMSSender to send a web link text message to my mobile. The text message was http://qgsp.maps.arcgis.com/apps/webappviewer/index.html?id=56fc6ae6f9cb4d5b8aaa554126cc50e0&find=260819MKY1 . However, the text message was always cut off by the ampersand “&”, which means my text message received was http://qgsp.maps.arcgis.com/apps/webappviewer/index.html?id=56fc6ae6f9cb4d5b8aaa554126cc50e0 .Any suggestions will be appreciated. Thank you.

Hi experts,I want to read the TAB file but with WHERE statement to filter the number of records that I want. It could not perform and run into errors like below. Could you help to indicate where I did wrong. THanks. I had tried without "" for the fields name, treating the values like string and not string.Performing query against MAPINFO_EXTENDED dataset `C:\\QV\\MapData\\PARCEL.tab'UniversalReader: Unable to emulate search type 'fme_all_features' because fme_where is requestedFeatureReader_2 (QueryFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details

Hi! Hope someone can help me out with this: I'm trying to create some sort of dynamic way to filter specific set of Attributes. Since the AttributeKeeper needs this input: AttributeName1,AttributeName2,AttributeName3,etc input, I was wandering if I can use a AttriubuteValue for this..but this is where I got lost;) I've created an attribute with concatenated list of Attributes I want to keep. But what would be a good approche to use this value to keep specific set of Attributes? cheers,ronald 

Hey community!How can I merge des points from a line into one line?I have a lot of "points lines" that I create with the transformer "Iterative Snipper" to chop that every meter in the lines. And now I want to merge every points in lines with color from points (attached picture). Tnkx a lot!

Hi all, I feel like I'm asking a well-trod question, but I'm having trouble with blank PDFs being output and am going a bit mad with the PDFStyler, PDFPageFormatter and TableAdder. Basically, I need to create multiple PDFs, grouped by username, from input Excel files. So far, with very little luck, other than the fanout naming (of these usernames). With the TableAdder I end up getting everything squashed into blocks of unreadable text, despite trying different values.  I wasn't sure if I was missing anything obvious, or if there was an easier way to start this process. Thanks

I created the grid, but I don't know which transfo I should use to clip the objects (clipper doesn't seem to be the correct one). Thanks in advance!

FME 2016 Build 16494 I want to automatically filter each info field value and the workspace will run them one by one. It's like:ThenandAnybody help me ! pls ....

i would like to merge the output pdf that include image to put directly inside sheet file at excel file . Do we have method to do that inside FME workbench ? or is there a method by using python in workbench to do that?thanks in advance .FME 2018

I have a line that I try to divide in smaller parts of 5 m each. The line is is from a shapefile. When I try to use the chopper it divides the line in random parts, varying in length from 7 to 113 meter, but in not a single case in 5 meter. Am I doing something wrong or is this a bug in the transformer?Hope someone can help.

Is it possible to save temp to DFS when declaring environment variable for FME_Temp? We currently would like to seperate the temp data that gets created when running a work space to hit DFS, which resides on premium SSDs, as well as benefiting from deduplication. Is it possible to do this via DFS going across the network, it sees the location specified within the user environment variable pointing to it's respective location on DFS. It also creates the folders on DFS, however it still writes to the C volume of the session host being ran on going to C:\\users\\users\\username\\appdata\\roaming\\safe software\\fme. Or is this only possible if I added an additional hard drive to our virtual machine, then brought online and provisioned, and changed user environment variable for fme temp to point there? I'm new to the application, and if anyone is able to assist, it would be vastly appreciated. Thanks!

I am reading in a complex CAD file from our engineering team. The DGN has multiple reference files, but the only information I need is the annotation layer. Specifically, the callout boxes and the leading arrows. When I read in the DGN as a Microstation v8 file in FME Data Inspector, the callout boxes are shifted in the wrong spot and the arrows are missing. Any ideas of what could be wrong and how to fix it?

When creating Areas from Lines using Areabuilder some areas are lost in the process. One example in the attached workspace, data and images is an area with "externid" "0381>NYNÄS>1:7>2". Not sure how many others are missing.

Hi,I am trying to create a map in a raster format and write it to MSWord ( using MSWordStyler) however I seem not to be able to create a legend for my map. ( a table holing the name of the attributes visualised on the map and their symbology on the next column) in my case the symbology is easy. just colored circles.Does any one have an experience with this orhave an idea what transformer to use in order to get this result? the part of my work space that creates the raster map:

Hello colleagues @Takashi Iijima​ . For the third day I have been trying to figure out how to configure Xmltemplate, but my programming skills are not enough((. Help to configure the Xml template to create a working xml file.Here is a sample of the result, all the pictures are arranged in their own groups<?xml version="1.0" encoding="utf-8"?><BlocksExchange version="3.2"> <Block> <Name>Block_223-32</Name> <Photogroups> <Photogroup> <Name>Photogroup 100_NS</Name> <ImageDimensions> <Width>31580</Width> <Height>13904</Height> </ImageDimensions> <CameraModelType>Perspective</CameraModelType> <CameraModelBand>Visible</CameraModelBand> <FocalLength>149.842</FocalLength> <SensorSize>118.741</SensorSize> <C

I'm probably wrong somewhere  

Access stores the Date/Time data type as a double-precision, floating-point number up to 15 decimal places. It stores dates before December 30, 1899 as negative numbers...Is it the conversion issue from FME date definition to Access definition? Seems like it only supports positive numbers (later than 30.12.1899)?

My question is a rather generic one as I´m still a beginner in understanding how to work with CAD and 3D formats, and not being a CAD user. I come from a GIS related education and now learning 3D, 3D visualization, city model administration with a hands on aproach.  We have LOD2/LOD2,5 building models stored in DWG format. When viewing these files with a CAD program like Draftsight (or imported to sketchup/ArcGIS Pro) a majority of the faces appear as rectangles. But when viewing the files in FME Datainspector all the rectangular faces consist of triangles. If i run a "original" DWG file through FME saving it as a new DWG file using available writers ( AutoCAD DWG/DXF, AutoCAD Map3D Object Data, AutoCAD RealDWG) the faces consist of triangles even when opend with CAD software. Based on googling and older forum thread (* link at bottom ) I come to the conclusion that the faces which appear rectangular actually consist of triangles but the inner l

Hi, I'm using StringCaseChanger but I'd first like to test if a attribute string is all caps. I'm using tester with Regex [A-Z\\s]+ and Case Sensitive mode but I'm not getting the expected results. Any ideas on how I can tester for attributes with all caps? These are paragraphs that might contain numbers and other symbols as well.

i would like to locate some text in excel file and also add lines that i have created with creator and add them in excel file at specific location .FME 2018Thanks in advance

Anyway, we are a team at the Federal Administration for Geodetic and Real Property Affairs in Sarajevo, Bosnia and Herzegovina. We have a license for FME software (2019.1 version), and we would like to have an opportunity for advanced training in FME that will have certain certification after completion of training.  I would be grateful if you can contact me for all the other details. My email is jasmin.catic16@gmail.com. Thank you in advance.

It's Wednesday, my dudes! Time for an FME weekly recap. FME and MetadataIt's metadata week, I guess, because a blog article about the subject was just posted, and we have a webinar tomorrow (23rd September, 8:00 am Pacific). FME is a great platform to use because it allows metadata control to be automated, like this:  Here an FME Server automation is used to keep metadata up to date and to keep end-users informed about th

I have a dynamic workspace with a dynamic file geodatabase reader. I want to update some of the feature classes in the file geodatabase. When I use a normal (=not dynamic) writer, it works. However, I would like to use a dynamic writer. But with the dynamic writer, I always get an error: "Geodatabase Writer: Feature Class or Table 'd_y_n' must exist when Table Handling is set to 'Use Existing'" - I don't know where the 'd_y_n' comes from.  What am I doing wrong?  

I have tried the StringReplacer but I'm struggling to remove everything I need to, without also removing part or all of the email as well. Any help would be appreciated, thank you.

I got a dilemma Iam trying to solve, but after 2 days of constant hacking I cant figure out how to do it. The script should run on fme serverUser adds an excel-file that constantly changes, the column names containing the coordinates can be named whatever, the sheet can also have different types of coordinates.Vertex creator to create points from coordinates so the workspace need to handle those scenarios. I tried adding two published user parameters where the user needs to type in the exact name of x or lat column and y or lon column. So my idea was to get the values from those columns and then clean the coordinates, replace . with , and other things. But the problem is I dont know how to get the values inside those columns. I know fme cant know what attributes the file has but in this case the user already specified 2 columns so that should work? Any ideas on how I can solve this pro