Data

I am creating a KML file with FME. Among other things, it creates popups in Google Earth. All is fine; except when I have multipart polygons, the popup window is displayed between polygons and not on one of the parts. Some users may prefer it that way. I am wondering whether that can be control with a setting in FME? That is that the KML popup windown is originating from one of the polygons.

Hi folks, New to the forum and FME, I'm hoping I can leach some knowledge. I have a csv file that imports into FME like this: I would like to manipulate it into the following format: Depending on which file is imported Costs 1, 2 & 3 may be there, or it may be a combination of 1 or 2 costs. All costs do share a common three characters at the left of their name. Is it possible to dynamically look at the cost columns and then transform the data into the format shown in the second pciture? Thanks in advance. Andrew

I am trying to convert JSON file to kml. I am inputting data from source file to Attribute creator and picked Latitude and longitude. This was connected Vortex creator then to Coordinate system setter. This was connected to Writer feature type. I ran the sequence, it generated an error that reads "The workspace may run slower because features are being recorded on all output ports. The below feature caused the translation to be terminated VertexCreator_ (TeeFactory): VertexCreator_: Termination Message: 'VertexCreator output a feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation'' VertexCreator_: Termination Message: 'VertexCreator output a feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation'&#

Hello,I am performing a simple translation that reads in a building DWG file, updates a single attribute (room number), and overwrites the same DWG it read in with the updated attribute. The issue i am having has nothing to do with the translation i am performing but the labels in the resulting DWG. Some of the labels are written out with a text size that is much larger than the original DWG. I have inspected the original drawings text size for these labels, and they are 0.38 but the resulting label text size jumps to 3.06. This only happens on labels that are surrounded by polygon inserts. The labels without these inserts come through just fine. See the attached image where the label for "CORR1" is just fine but "CORR4" is too large but has a polygon insert around it. I have also noticed that the resulting entity handle for this label changes after being written out. Also, when i redirect the writer to fme data inspector, everything appears just as it should.

Good day, I am just looking if someone can point me in the right direction. GoalIfc/Cad File to .svg The goal is to create .svg for PowerBi. By taking a view from a 3d File and saving the view to turn into a .svg file. Below a few screenshots how I have done it before. A .svg is imported into powerbi.   When clicking the .svg graphic in PowerBi, the PowerBi table changes to filter only that Column In this example the .svg has the following ID: <polygon id="M1" description="M1"  If this ID is found in the PowerBi Data, the column for "M1" is called. ( I have added an example of such an .svg file that I work with: SvgPowerBiExample.txt(saved as .txt file) FME QuestionIs it possible to save a "view" of an .ifc file or Cad file such as .dwg in 3d? Then Vectorize that View and save the internal surfaces as the polygon id needed for an .svg file.  For Example, a view in FME that I would like to save as .svg file:  My current WorkflowThe workflow is

Using a published parameter such as $(outputTableName) in a SQL writer to name a field.Taking the parameter value to name the identity field as in $(outputTableName)UKID resolves and creates the column no problem when using a standard SQL writer. So, setting the parameter value to "MyOutputTable" results in a field name of "MyOutputTableUKID".When attempting to do the same in a SQL FEATURE writer, the parameter will not resolve, and the column is created with the explicit string value '$(outputTableName)UKID'.Is this behaviour expected between the two varieties of writer?

Hello, I have las file in which some points after some manipulation produce separate cluster of points as shown on the image.How could I produce separate boundaries for each cluster?  

Hello, I need to write the resulting file to the same directory where my source file is, no matter where is the workspace. However, variables cannot be inserted into the writer's destination directory. Can anyone help?

We have a DWG that has a number of scale bars shown in paperspace. In the DWG the units are visibleBut when it is brought into FME the units are missing. My guess is that the units are dynamically generated in the DWG based on the viewport scale and as such are not really annotation but some attribute / tag associated with the line.Is there a way for FME to find the values so they can then be used to output to PDF.  Update 1:Here is a a sample DWG with the issue included. Update 2:What I have discovered is the scale bar is a 'block' and the text is a tag associated with the block. Is there a way to convert the 'tag' to text in FME? 

I have 2 dynamic writers in which data are coming from 2 readers (SQL Spatial and SQL non-spatial, respectively). Actually the readers are reading from the same database (A, for example) and the writers are writing out to the same database (B, for example). The reason why I have 2 readers is because there are spatial data and non-spatial tables in database A. I have a SQL script that can set ObjectID to Primary Key. It doesn't seem working properly when I put SQL script into the first writer (spatial). Therefore I had to put this SQL script into the second writer (non-spatial) to make it run properly. Any ideas? Thanks 

I have a CSV file where I need to read only the first line (or first column/line combo) of the file. Is there an easy way to do this with a reader? Or am I stuck reading the whole file? I've tried both the CSV reader and Text File reader. In both, I don't see anyway of isolating this first line of text/data. I'm forced to bring the entire table into the workspace. Thanks in advance!-Mark

I am trying to harmonise an average windspeed ShapeFile to INSPIRE GML.In the in EnergyResourcesCoverage application schema there is a RenewableAndWastePotentialCoverage feature type. However, I can't seem to add it as a writer. I only see the option of the RenewableAndWasteResource feature type. Does anybody else have experience with this? Or is there another way to create this INSPIRE GML?

How to create an index for a mongodb collection using a json templater ?Thank you

Is there a way to use FME to pull the stats for ArcGIS server and create a table or publish to a dashboard? I would like to pull these out and publish so management can see usage.

How could i convert oracle spatial data and non spatial to csv and read it again then use fme_feature_type in excel writer .  parameter tha t i did but i found after reader ,missing data ithat i gotand also after writer a few of my data has been written in temp.csv could someone explain me what should i do to convert from roacle to csv to excel writerThanks alot

I'm trying to read Feature Class from our Enterprise Geodatabase and because we have custom class extensions registered on all our our data.    I am not able to set the Reader to bypass the class extensions.  I get this warning in the log  "Unable to read from the table/feature class 'YK_SPATIAL.Buildings'. If 'YK_SPATIAL.Buildings' contains a class extension, make sure it is registered on this computer"  Thanks

I am trying to update 3 fields for all records in a SDE SQL GDB versioned Feature Class (where building id = bulding id). I have seen several posts and help files but am not having success with the reader + attribute manager + writer or the reader + SQL executer + writer combo. Can someone advise on how best to set this up? Many thanks,

Hello, I am a new FME user. im gonna store csv file in one folder daily. (ex. 20180914.csv)If it comes in daily, is there a way to read only today's csv file?Thanks in advanced.

Hi! I've tried looking for a solution for this but can't really get it to work.I have a folder with several PDF files that I just want to merge into one. Ideally I'm looking to specify that folder and then let FME do the job and spit out a Merged.pdf.Is there a simple way to do this? Tried a solution, but several attributes from the original PDF were lost in the translation. I want this to work with multipage input PDFs.I someone has a good solution to this and can give an example .fmw it would be appreciated! Thanks :)

I'm trying to read multiple spreadsheets and write one worksheet from each of them into a single output spreadsheet but am going round in circles...Input data: I have a parent directory with an unknown number( and names) of subfolders. Each subfolder has a spreadsheet, results.xls. Each spreadsheet has, say, 10 worksheets, ws1, ws2...ws10.Output: fme needs to search the parent folder to discover the subfolders. Then, for each subfolder, it needs to read the results.xls spreadsheet. A single spreadsheet needs to be written to disk containing worksheet ws5 from each discovered spreadsheet with each worksheet given the name of the subfolder that they came from.The FME excel reader seems to need to know the name of a spreadsheet in advance, so I used a Path reader to discover the subfolders but passing these to a featureReader doesn't seem to read in the spreadsheets properly.Any help would be appreciated.ThanksMacsmith

Hi all, This should be really simple, but I can't work out what I'm doing wrong in my workspace. Any help appreciated...I need to update a couple of attribute fields in a SDE feature class with values from an Excel table (attributes only, no geometry. Yet.). Using the Excel and 'ESRI Geodatabase (ArcSDE Geodb) readersI'm using the 'FeatureJoiner' transfomer to join the two readers together based on a unique identifier (ESRI Global ID field in the SDE feature class, which the person who created the Excel table also used to capture their new data), then put it through the 'Attribute Manager' transformer so I can map fields between the Attribute Manager and my writer (the columns in the Excel file and SDE feature class have slightly different names, but I know which ones correlate)I'm using the 'ESRI Geodatabase (ArcSDE Geodb) writer, settings:Feature operation: UpdateTable handling: use existing Update spatial columns: NoRow selection: Match column

I am trying to setup a job in FME that reads a CSV file where the filename changes daily. The filename looks like this HHSVENDORS_02242020.txt. The HHSVENDORDS_ is always the same, but then it has the date appended in the format MMDDYYYY. Is there a way to dynamically create/read the input filename on a CSV reader? So when the job runs each evening, it will pull the correct file.

Hello. So I'm currently having an issue with the excel reader and I'm not sure I'm missing something. If I drag and drop or add the dataset to the workspace and configure it, it will read correctly. In this case, I want it to start reading the data from row 6 (1 to 5 are the header) and go from there. This works for the initial file, but if I change the source data to pick up a different file with the exact same format, the settings are somehow reset and it starts reading from row 1, resulting in no attributes or features being read. I've tried updating the reader feature types and changing the Microsoft Excel Parameters for it, and while it works when inspecting the data, when I run it, it goes back to missing. What I need is to be able to feed different datasets into this reader but all with the same format, so there's no need for it to be dynamic. However I can't understand why the parameters only work for the first file it reads, despite it being fine when I

I have been provided with a set of dwgs which have autocad text in it and rotation values expressed in degrees e.g. '96d'. I need to read the value as '96', how do I do this? This is the first time I've seen the rotation units expressed this way. When I translate the dwgs the rotation values do not translate into text or numbers. I'm converting the CAD files into Esri fgdb feature classes and have AutoCAD 2019.