Transformers

I have a workbench where I use a python shutdown script. This script is printing some results to the translation log window.I would like to the see the text that the python shutdown script is printing to the translation log window in a different color than black. I used some suggestions from the internet but they are not working as the translation log is not a "real" python terminal.I tried a few things without installing any library to python though. As I will be sharing the workbench with colleagues who will run the wb locally, I would prefer if it's not necessary to install a library.Another question is if it is possible to print emojis to the translation window using a python shutdown script? I know it is possible in python e.g. print("\\U0001f600") but this print statement is not working when printing it to the translation log window. Thanks.

I'm trying to build a workspace that will allow users to select a file, identify X and Y attribute names using published parameters and have it be translated AND transformed. I found the Easy Translator demo, which covers the translated part of what I'm trying to do (and is broken - I submitted an issue on GitHub). Now I'm getting stuck on the transformation part as the attribute names are read in as a feature, and the actual attribute names are coming through as col0 ... col5, etc.I need to get to a point where I can either identify what column number that the attribute names are that they listed in the published parameters, or ideally rename the col0 attribute to the actual name that it is.

As you see, value is null so it gets ORA-01449(null).So, How can I setting value collumn ?

When reading in a zip file with three text files, it results in garbled data. Any ways to fix this?

 FME 2020: How to get all the layers automatically selected when the dwg file is selected as a source file in the reader? I found out that each time a dwg file is selected (as per the screenshot below), the “select all” option is not checked by default.  How this option can automatically be checked as any dwg is selected as a source?                   

add variable in json reader from user parameter like this;

Hello FME users. I can't solve the problem of passing all the points along the shortest path. I can't make a cycle with sorting. Please help me.

I am noticing that the number of features and feature types between the Merged Feature and Individual Feature mode are quite different. My expectation was that when you select "Read All Elements", it would...read all elements, regardless if merged or individual. I compared two different files and both had more features and feature types in Merged mode. I am not specifying a view and reading geometry as non-spatial. One had 5 more FeatureTypes, the other had 13 more! Why?  Thanks,@larue​    

for an example:why is the result not is 1 but 4

coordinates of given type extract coordinates and type

I have a column in a table with names and I want to find the ones with alphanumeric string and replace it with a null value. Apparently this is erroneous data in the table.  Sample Data in the column NAME:GREEN-BROWN TREES --> Leave as isFORT/STRONG -> Leave as isPEACE RIVER --> Leave as is3T7H8HF54FD --> This is the data I want to find and replace with Null Greatly appreciated. Thank you.  

When running "my" workspace I get an error at the end of the translation, after writing the output, with the message: "Error running translation." No further errors are given. The tail of the output:==============================================================================Total Features Written                                                      32=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Translation was SUCCESSFUL with 773 warning(s) (32 feature(s) output)FME Session Duration: 1 minute 10.3 seconds. (CPU: 40.2s user, 6.5s system)END - ProcessID: 1680, peak process memory usage: 320516 kB, current process memory usage: 172000 kBError running translation. The workspace converts a DWG to GML. It uses an Excel sheet for some mapping rules/lookup tables. Other DWGs do not have this problem, only two DWGs cause this. The DWGs are not corrupt, at least AutoCAD complain that these DWGs should be recovered. Furthermore, the `AUDIT` command in AutoCAD do

I know this can be done, but can not find the right way:How can I add the current Date and Time in the name of the Log file?Preferred format is: YYYYMMDDH24MIAny help is appreciated.

Hey,Since a day or two I can no longer read my data. I always get the same error, even when I try it in another workspace. Does anyone know what it could be?I use FME 2021.0 and i'm trying to read a postgis table. ThxNathalie

Below is an example JSON response body for a single feature. What I want to do is extract all of the "points" elements (in bold) as a list. Which transformer should I use?How would I write the syntax to extract the detail in bold through a JSON query?Can it be parsed as an attribute? If so, how? {  "id" : "feature1",  "name" : "Feature 1",  "length" : "5,000 km",  "points" : [   {     "id" : "loc1",     "name" : "Location 1",     "country" : "CountryA",     "is_tbd" : null   },   {     "id" : "loc2",     "name" : "Location 2",     "country" : "CountryB",     "is_tbd" : null   }  ],  "notes1" : "test",  "notes2" : null}

Hello there, So I have two attributes: "Floor" and "Purpose". Floor Purpose1 Lobby2 Restaurant3 Swimming pool So I want to verify the dataset. If the "Floor" is 1, "Purpose" must be lobby. May I ask what kind of transformer I should use? Thank you very much.

As input I have a csv file. The column names are dates. I use python to download it from an ftp and then merge with a spatial dataset to create polygons. I usually update an AGOL service but I don't know how to update an AGOL service if my column names (attributes) are changing daily. This would require to delete and republish, but FME cannot publish a service, can just do an update. Any help is greatly appreciated!

the ultimate goal is to have two outputs, the selected line or lines based on an attribute value and the neighbouring/adjacent lines within a 100m buffer. So am wondering what would be the best way to loop through the million records selecting features by attribute value then run the process and then the next batch so on ...? any help in decoding this will be highly appreciated.

Hi! For the transformation of a big data set I used the tiler. I now want to run the translation by picking one tile after another (run them sequential) but write the tiles into the same writer after the calculation,is there a tool I can use to fix this?

Dear Community, I would have a few questions for CityGML building.  I have a SHP file with building polygons (roof, wall, groundbase), and I would like to build a proper cityGML file. I read over the whole forum and also CityGML specification, but there is no description, WHICH attributes MUST be defined in case to have a proper CityGML output WITH geometry. In some of the forum topics here, there were good spots, and sample workspaces, which can be used to build simple buildings, but to build from SHP polygons, it's seems though for me. I'm trying to build a LOD 2 model. I have my walls, roof, ground, and the whole thing aggregated together (So I have the exterior shell and parts separately) They all have unique parent ID per building, set LOD name, feature role, geometry type and other attributes, which I found set inside related questions in this forum. But when I run the translation, I always receive a data set with no geometry inside, if I try to build a proper building mo

Upgrade: If we're only upgrading from 2021.2.0.1 (21789) to 2021.2.1.0 (21797), do I still have to have my DBA wipe out the tables and create new?

I have a shape file which has several names in it. These names comes under 6 departments. So i want to create an attribute named as department. I have the csv file where it is mention which name comes under which department.

Overall goal: Pair-up respective wall lines from a CAD drawing floor plan.Challenge: NeighborFinder will return most wall lines properly, but if there is a condition of 4 equidistant lines, the interior ones will be picked twice, one on each side. I want to have 2 discreet pairs: For context:After trying FeatureMerger in various ways, I think that a loop is my only option. Here is what I have so far:What am I missing? Thanks,@larue​   

I am able to create separate Excel files for each data source processed in the batch routine (consecutively), but can't figure out how to append the output of each translation into one file. The schema is the same throughout. Thanks, @larue

Hello!I'm trying to use the following to find the position of a character/string in one of my attributes:@FindString(@Value(ColumnName),TEXT,1,caseSensitive=TRUE)When I replace TEXT with the text I am searching for, this works as expected, except for when the text to be found is a parenthesis, i.e. ( or ). In that case, the function interprets the parenthesis as the start or end of the function's arguments. I tried to escape the parenthesis using a forward slash (as suggested by the FindString() documentation to escape a quotation mark) as well as by surrounding it with quotation marks (as suggested by the FindString() documentation to escape a comma), but neither of these work.How can I properly escape ( and ) inside the function arguments?Thank you!