Best Answers

Dear FME community,I have a MapInfo text dataset and created polygons which are the bounding box around that text. The problem is that the polygons have different heights. What I want is that the height of the areas is the same. The length of the area can vary according to the text length. For example: The bbox of "NL Plauen" in the lower left should be as high as the bbox of "NL Zschopau" in the center (in the image it is slightly smaller). Or another one: The three areas of "Stadt Leipzig", "Stadt Chemnitz" and "Stadt Dresden" should be the same height. Because of the different sizes of the letters, the BoundingBoxReplacer creates different polygons.I already tried it with the bufferer, but this one increases the size at every side. I only want to increase the height, not the length.Any ideas of how this can be achieved?Kind regards and many thanksThomas

I'm trying to install FME desktop on a VM that's configured with a very small C:\\ drive which contains just the OS. All the program files are installed on the D:\\ drive. When prompted for installation folder I'm changing it to the D:\\ drive. I'm getting an error that there is not enough space on the drive, then I get an error 2755. I've tried installing it on my own workstation, on the C:\\ drive and it installs properly.

How can one expose table name parameter at a Postgis reader so that workspace runner can make use of ?Thanks.Jorge

Hello,I need to render texts onto a raster. The MapnikRasterizer (Text Symbolizer) works as expected in almost all cases, but if you set the Orientation parameter, the text will be rotated around the center of the text itself, not around the specified placement point.In this image, the red circle is the placement point and it illustrates the result that the same string "text ----- string" has been rotated with 0, 30, 60, and 90 degrees.The requirement is to rotate the text around the placement point - the red circle in the image above. How can I do that?

Hi,I am trying to convert a table with 5k rows and 115 columns of data into a long table. I have 5 columns to fix and then about 100 which I want to take the column name and put that into another column and then have the values of that column in a field called Regs.I've attached a sample excel file with what I'm wanting to do.ThanksMark

Hi all,  According to the docs you have lots of wildcard options available in the"file and directory pathnames reader" ("add reader->Format: Directory and files pathnames). Including greedy searching all subdirectories recursively or fine-grained, hairsplitting controlled directory and file name searching.  http://docs.safe.com/fme/reader_writerPDF/path.pdf   So this kind of structure really should be a breeze: C:\\data2\\dirB\\dirB_1\\Newfeature.txt  C:\\data2\\dirB\\dirB_2\\Newfeature.txt C:\\data2\\dirB\\dirB_3\\Newfeature.txt (somewhat simplified).    So I set the source directory to C:\\data2\\dirB and fiddle with the Path filter syntacts.  **\\*  C:\\data2\\dirB\\**\\*  C:\\data2\\dirB\\dirB_?\\*   None of these work. No, I am not kidding. Go to the PDF I linked, scroll down to the heading Path filter. Then please explain me why.   What DOES work is moving most of those wildcard into the definition of the Source Directory. These definitions are valid for m

Hi,I wrote a very long workspace and at some point I want to extract a substring of the filename using the python caller and have it as a new attribute in my workspace.Then I tried to write a workspace with only that instruction (see attached) but I'm still having the same error:Python Exception <KeyError>: 'fme_basename'Error executing string `fme_basename=FME_MacroValues['fme_basename']def thm(fme_basename):    return fme_basename[4:]'Factory proxy not initializedPythonFactory failed to process featurePythonFactory failed to process featuretest.fmwAny idea of what could be the problem?Thanks

Hi,I have a line network (water pipes) that I need to cut only at certain points (valves).I first use the Aggregator to join the whole network into one single geometry, and then use the PointOnLineOverlayer to split the network with my designated points.However, the original aggregate isn't respected, so the resulting lines are divided many more places than defined by my cutting points. It seems like the aggregate is dissolved into its orginal parts prior to the cutting taking place.Is this "works as designed" ?If so, is there a way to keep the aggregated network intact while cutting it at certain points only ?I've attempted to have the Aggregator generate both a "Homogeneous" and a "Heterogeneous" collection, it makes no difference.CheersLars I.

Hello FME experts,I create an ORA table with in the format parameters:- spatial column GEOMETRIE- create spatial Index YES- drop existing Index YES- spatial index name TST_IDXI also need an index on the attribute ID so I use the SQL statement to Excecute after Translation:- CREATE INDEX table1_i ON table1 (ID)This works fine.Question: How can I create an other index on a different table also with a spatial index.I put an extra line into the SQL statement as follows:CREATE INDEX table1_i ON table1 (ID)  CREATE INDEX table2_i ON table 2 (ID)I have used seperations between the lines (; , ' ') but nothing seems to work error was `ORA-02158: ....How can I but indexes on different tables after I created an ORA-table?

How can I make a table of my attributes without geometrie and make a PDF. I found the tableadder, but how does it work right? Do I make lists first?

Hi all! I am new to FME. I am trying to find parent child connections within a network tree. For example, there are nodes or objects called "CP". All CP's are connected to "TX"s. I would like to find which CP is connected to which TX. Multiple CP's can be connected to a TX. I would like to export a table like the following: CP TX1 12 13 14 24 2Which suggests 3 CPs are connected to TX 1 and which ones. There is a whole network of lines connecting them. So I have to somehow trace those lines until a CP connects to a TX. Sometimes CP's are connected to TX's via multiple line segmentsI am looking at SpatialFilter, PointOnLineOverlayer or ShortestPathFinder. As I mentioned, I am quite new to FME and having a difficult time getting started. Any help would be greatly appreciated.

Hi All, This question stems from my previous question. I am choosing to ask another question as not to clutter that. QuestionI have a network of Customer Points (CPs) and Transformers (TXs) connected via secondary electrical cables (both underground and overhead). I would like to find which CP is connected to which TX. Multiple CP's can be connected to a TX. I would like to export a table like the following:CP TX1 12 13 14 24 2My Approach: Thanks to @david_r1) Topology Builder Transformer used to determine topological relationships within the line network (secondary underground cable and secondary overhead conductor)2) Network Topology Calculator to find connecting lines and add Network_ID to line3) Aggregate lines grouped by Network_ID4) Using SpatialFilter, find TX’s and CP’s that intersect with the same network and transfer TX id to CP as an attribute to generate csv (Using Feature Merger)Works great for isolated networks (Secondary Underground networks) shown in the imagePr

The version\\licence\\remaining days of the trail FME Server,  I have installed the trial version of FME Server. As I logged to the it, I couldn’t figure out how to check:  1. The version of the FME Server 2. The license of the FME Server 3. The remaining days for the trial version of the FME Server    Thank you  Best  Jamal

Hello,I have 4 feature types and i use the transformer PDFPageFormatter to configurate my PDF output.The problem is when write this Output ( attached ) the feature types didnt write exactly like FME DAta Inspector. How can i do this configurated well?The output wrong in PDF:Attached my template file.Thanks

Hi,I'm a reasonably novice with regard to handling rasters in FME, and has been given the task of converting 100 ERDAS Imagine files into a number of MapInfo tables containing polygons with the original pixel values as an attribute. The pixel value is a height-above-sea-level, and the data represents flooding estimation data.I'm using RasterToPolygonCoercer to generate the "pixel polygons", which works fine, but the pixel value is lost somewhere along the line.I'm discarding "NoData" values, but have "Preserving Attributes" turned on, so where did the pixel values go ??CheersLars I.

Where is the FME Engine install folder on a Mac?

If I run a model with FME Desktop, there are no issues. If I run the same model with the same input in FME Server, I get the following error:AreaCalculator(TeeFactory): AreaCalculator: Invalid parameter 'REJECTABLE'What does this error mean, and why is it occuring only in FME Server?

FME desktop application disappeared after upgrading Ubuntu 14.04 to 16.04. Reinstall FME 2016 on the new OS failed. Safe tech support confirmed that 16.04 had not been tested. If someone has had luck with Ubuntu 16.04, please share your installation procedure. Much appreciated!

How can I copy a  feature and its attributes(include geometry) in Python script within PythonCaller? The feature contains a list where the number of items in the list is in the attribute "counter". The idea is to copy the current feature when , change some the attribute values(not geometry), so I am afraid the ListExplode  is not what I need.def __init__(self):        self.feature_list = [] def input(self,feature):        total = feature.getAttribute('counter') # num of items in the list        from = feature.getAttribute('from')        to = feature.getAttribute('to')        for i in range(total):                # todo: copy feature?     if some_conditions = True:                new_feature = fmeobjects.FMEFeature()   # is this right?                # todo: copy all attributes into new_feature?                    # todo: change the attribute                # add to feature_list                self.feature_list.append(new_feature)def close(self):        for feature in self.feature_list:

I am considering using FME Cloud for a series of quite small jobs. Each would take only a few minutes to run, and they would be infrequent enough that I would want to pause the instance between jobs. I understand 1 hour is the minimum billing amount, but would each time the instance is started be billed for one hour's running time, or would the times be added up?For example, say you run one five-minute job every day for a week. Would that be billed for seven hours (seven start-ups) or 1 hour (35 min rounded up)?

I'm trying to set ORACLE_HOME for FME Server on Linux, but the FME Engine is not seeing it. I fetch it and print it in a workspace, but it's set to a value I definitely didn't set:/opt2/oracle8i/app/oracle/product/8.1.6How can I set ORACLE_HOME for the FME Engine?

Hello,I have hundreds of excel books to read one sheet of (they each have only one sheet) then write the data to a database table. I thought this would be simple using batch deploy, I then realized the excel sheet names are different and in the basic way I set up my batch deploy it expects a specific excel sheet name. Is there any way for FME to simply read any excel sheet in an excel book at run time? All the excel sheets have the same column structure.To be clear:Excel book= A xlsx fileExcel Sheet= A tab of a excel file Thanks

Hi!I am new to FME. I have a set of network data where the network is made of many segments of lines. I am trying to find a way to test the integrity of the network. I have to ensure that no segment of line intersects with itself. I tried SpatialFilter with the "intersect" and "touches" test. That proved positive for all lines. Then I realized it must be true as the lines connect end to end. I need to know which segment connects to itself. Then I tried GeometryValidator and tested of self-intersections in 2D. That can only detect lines that self intersect and crosses. The lines that self intersect on itself without crossing are not picked up. Can anyone help? Thanks!

Hi,I want to split one record in table2 into multiple records based on attribute value from table1. There is no geometry in both tables. The picture shows what I want to achieve:Thanks for helping.

How do I achieve this effect    http://img6.ph.126.net/IzlZ_KPRMTSKD29qP01ZQw==/6598239647028220276.jpg