Transformers

Hi,@takashi I have a list of data as the attached xls sheet. I need to extract specific attributes which come many times in the list. The list contains attributes with the value [name:(different names)] and under this one there are attributes start with the value (string:......). I need to loop through this list and extract the attribute which has the value (name:USED_DATA) with all attributes underneath it which start with (string:.....). The rest I don't need it. The list contains information about many objects. Each object has index starts with 0. So, each object has attributes which I need to extract. Unfortunately, the attribute with the value (name:USED_DATA) comes with different index (so not regular) and this is why I can't use an existing transformer in FME to do what I need or at least to my knowledge. Could you please guys help me with it. Maybe there is a trick to do so which I couldn't find. Looking forward to hear from you!Kind Regards,,, 

Hello all,I've come up with a difference between Regex editor and workspace run result.As you can see below I'm expecting to get 28 matches for the feature which has the value written in Test String box in its pdf_page_text attribute. However, the string searcher transformer returns none.Does anyone know what causes this situation?

Hi,    I have an XML document containing coordinate values having 3 decimal places: e.g. <X>259.042</X><Y>1521.734</Y>. My workspace transforms (X, Y) values to point geometries with 2DPointReplacer and writes those into a File Geodatabase with FILEGDB writer. Translation finished successfully, but when I confirmed the GDB with the Inspector, I noticed that the precision of coordinate values has been changed like this: Source XML: (259.042, 1521.734) Destination GDB: (259.0419921875,1521.73400878906)   In addition "XY Tolerence" parameter of the FILEGDB writer is set to default (i.e. blank), and the environment is: FME 2013 SP2 Build 13499 Win32.   When I wrote the same data into a shape file via the same workspace for comparison, such a change has not been occurred in the shape file. So I guess the FILEGDB writer caused the change. I can modify the precision using the CoordinateRounder after reading GDB, but ideally, of course, I want

I have and ESRI Geodatabase line feature containing a mixture of arcs and normal lines. I tried extracting the arcs using GeometryFilter but this doesn't work because although FME recognises that the segment is an arc, the geometry type is "line".How can I filter these arcs?

Hi, I have been successfully using the AGOL reader to download attachments, but would now like to use the FeatureReader transformer instead so I can feed in an SQL query (created earlier in the workbench) into the WHERE Clause, so it only reads new attachments. But there doesn't appear to be an 'include attachments' option like an a normal reader?Any ideas if it is possible to get attachments when using a FeatureReader transformer?Thanks

I'm given a location of files. I'm using the directory and files reader to get all the files in that directory. I then use the featureReader to get only the csv files. There are 181 attributes so instead of exposing them, I'm specifying a feature type to read. The csv files all have the same attributes, just in different orders. For instance one file could have attribute1,attribute2,attribute3 and another file would have attribute2,attribute1,attribute3. I'm using attributeManager to calculate some values and because all the files have the same attributes, I just used the order of the first csv so the order of the attributes leaving attributeManager is always attribute2,attribute1,attribute3.I am writing out csv based on the name from the path_rootname (to a different folder). The issue is that I need the output files to retain the same attribute order as the input csv. Because all features enter the AttributeManager, they all come out with the order from that transform

I have an issue where I am trying to create a PDF output but the data is not filling the objects defined. The data object is defined to fill the majority of the page but as seen below the output only fills a portion of the page.  Is there a way to force the data to fill the area defined? Here is the workspace that I am using -

I am trying to use SQLExecutor to either insert or update a record in a table stored in Oracle - please see sql below. It gave me the following error. any ideas why? declare counts int; begin select count(*) into counts FROM employee where emp_id = '@Value(empid)'; case when counts = 0 then INSERT INTO employee VALUES ('@Value(empid)','@Value(firstname)'); when counts = 1 then UPDATE employee SET firstname = '@Value(firstname)' WHERE emp_id = '@Value(empid)'; end case; end; An error occurred while accessing a table result for feature type `'; message was `Execution of statement '......did not succeed; error was `ORA-06550: line 7, column 14:PL/SQL: ORA-00933: SQL command not properly endedORA-06550: line 6, column 30:PL/SQL: SQL Statement ignoredORA-06550: line 9, column 4:PLS-00103: Encountered the symbol ";" when expecting one of the following:

I'm using a Clipper with a polygon feature to clip for features in a DGN file within a project boundary. For some reason it rejects the Clippee features. After looking at the Clippee features I'm seeing that there are NULL geometries in the file.Can anyone explain how the NULL causes the Clipper to fall over?Is Clipper the best way to clip for objects within a boundary? Workbench is attached without the geometry filter to filter out the NULL geometries.  

Hey,  <-- I saved the template with source data here I am currently using a trial licence to see if FME is what my organisation is looking for, so please bare with me as I am very new to FME and the terminology.The first task I am trying to achieve is converting a large CAD document for use in our GIS System (I see this is very common, and I have watched several youtube tutorials and a few Safe videos, so I understand the basic concept). I have created my first Project, it works for 90% of my data, its the last 10% I am stuck and needing advice on. As you can see i have my CAD input on the left, a few filters and the likes, and it outputs to my GIS tables on the right. It is the 'Annotation4_History' that is causing me grief, and I am unable to decipher the error message. I am sure it is telling me what is wrong, I just dont understand how to fix it.The input parameters on the cad document are (note: used Group By Geometry):If I disable the writer 'Annotation4_History&#3

gps coordinates and time stamps from aerial images

I have a parent workspace that successfully launches child workspaces via FMEServerJobSubmitter.These launch successfully and complete but then the parent workspace does not release the features to the next transformer.It's running on FME Server 2018.1.2 - Build 18590 - win64I have it to submit jobs in parallel and to wait for jobs to complete which are the settings required but it isn't releasing the features once the child workspace completes.Log file just hangs with the following lineFMEServerJobSubmitter_2(ServerFactory): http://******** - Running workspace '*******_Child.fmw' in repository '******** Child' in parallel...Names redacted for security reasons.As mentioned, child workspaces run successfully.Nothing in the log files or monitor log files to suggest anything strange is happening and this processed has run successfully before.Any thoughts? 

HiWhen I created my Reader, I can read all my data and especially my geometry column but this column doesn't display . I try different coordinate system but it does not match. Same issue.What's wrong with this Reader ?Thanks

I am trying to find duplicates in my xml data and from that I would like to apply condition.  here is my xml doc  <results>    <book>        <id>1</id> <status> published</status>    </book>    <book>        <id>1</id> <status> not published</status>    </book>    <book>        <id>2</id> <status> sold</status>    </book></results>From the above xml, I want to find book id where id's are repeated and the status is published then return .<book>  <id>1</id> <status> published</status> </book>using XQuery  . Could you please help me on this. Thanks in advance.

Hello,FME 2019.0.1 build 19253I noticed the JSONFragmenter raises an error if the specified file path contains spaces.JSONFragmenter (JSONQueryFactory): The clause 'FILEPATH_OR_URL folder name/test-geojson-structure.json' within 'FACTORY_DEF * JSONQueryFactory FACTORY_NAME JSONFragmenter INPUT FEATURE_TYPE Creator_CREATED MODE EXPLODE EXPLODE_FORMAT JSON REJECT_EMPTY_LISTS YES EXTRACT_ATTR No JSON_ATTR <Unused> READ_FROM_FILE YES FILEPATH_OR_URL folder name/test-geojson-structure.json OUTPUT_ATTRIBUTE _result EXPLODE_QUERY json<openbracket><quote>features<quote><closebracket><openbracket>*<closebracket> RECURSIVE_FLATTEN <Unused> OUTPUT EXPLODED FEATURE_TYPE JSONFragmenter_FRAGMENTS OUTPUT REJECTED FEATURE_TYPE JSONFragmenter_<REJECTED>' is incorrect.  The parameter to FILEPATH_OR_URL must be a constant value, a value-of (&) attribute, or an FME function callThe clause 'FILEPATH_OR_URL folder name/test-geojson-structure.json' wi

...and then also interpolate Z for every vetex. thanks! /Erik

Hello, I build a workspace which create an excel document. on the server.I build a Server App on the fme Server 2019.1 and it runs fine by calling the url and clicking the run button. But I want that the App starts automaticly with the url and not with clicking the run button. Is this possible?Thanks for your answers. Greetings from GermanyThomas

Hi there, I'm having trouble setting up NGINX with the windows version of FME server I have attempted to follow and adapt the instructions for Ubuntu here: https://github.com/safesoftware/fmeserver-nginxBut haven't had any luck yet, has anybody succesfully set NGINX on Windows FME Server that can help? In terms of my setup:I have FME server installed on one computer running Windows 10 and a docker install on a different machine of NGINX Proxy Manager on the same network which I have used for multiple NGINX installs. (https://nginxproxymanager.jc21.com/)Any help would be appreciatedMany thanksJoe

When using a Timestamper in Workbench, I get a result like:+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `Logger_LOGGED'Attribute(string): `dateOfSnapshot' has value `20190902163230.4600884+02:00'Attribute(string): `fme_feature_type' has value `Creator'Attribute(string): `fme_geometry' has value `fme_undefined'Attribute(string): `fme_type' has value `fme_no_geom'Coordinate System: `'Geometry Type: IFMENull===========================================================================So, it says 16:32:30, with UTC +2:00When running  on FME Cloud, the timestamps in the interface have the right values (16:31:55)522019-9-2 16:31:55 | +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++532019-9-2 16:31:55 | Feature Type: `Logger_LOGGED'542019-9-2 16:31:55 | Attribute(string): `dateOfSnapshot' has value `20190902143155.516446175+00:00'552019-9-2 16:31:55 | Attribute(string): `fme_feature_type' has value `Creator'562019-9-2 16:31:5

Hi, I would like to extract data from a web page coded. I already get the password. The url is :https://www.portail-nextgen-telecom.tdf.fr. I need to read the url , find the data : Document Contractuel. Read it. If there is a value , get it. i tried with htlm extractor but the response is a script. I need a value. yes or no the Document contractuel is here. Anyone can help me ?

Hello all, I need a help about how to iterate an entire workflow in such a way,so that once I change the inputs,it will provide me with the specific output

Hey there,with Feature Writer I try to adopt a schema from a bunch of different shape files.I tried the same workflow with a ESRI Geodatabase before and it worked. So I published the Shape Files as Workspace Resources and commit them within the Dynamic Schema Definition.Which works fine with the Geodatabase, failed (a bit) with the shape files.In fact the transformed shape files are using the schema, but some of the ESRI data types were changed, namly for example the "Short Integer" changed to "Long Integer" (and also the Precision value changed). Does someone knows why this could happen? Thanks and best regards,André 

I have a state boundary and I want to use a map scale as a parameter to calculate the Tile width and Tile height (ground units) as attributes for the Tiler.Given a coordinate system, how do I calculate that width and height of that bounding box at a scale of 1:100 using an Expression Evaluator? Then do it again for the next scales 1:500, 1:1000, etc. 

Hi,I have a 3d building citygml and I have converted into 3d tiles using FME. When i am loading 3D tile(size 6.6MB, containing buildings) , it is taking the loading time of 6.3 minutes to load on the cesium globe. When i upload the citygml data to generate 3d tile, the generated 3d tile is taking 12sec to load on the cesium globe.I am not able to find the reason for this. How to minimize the loading time of FME converted 3dtile. I have attached the images of 3D tile.   

Hello, I want to extract from a .txt file the size of an object, it looks like: Size: 1575200 . I am using StringSearcher to find it in the text file, the regular expression is like : Size: [\\s\\S]*$It works well, but I want toget only the value, so 1575200 and not like Size: 1575200Do you have any idea?