Skip to main content
  • EN

Best Answers

10390 Posts
dszarka
Contributor
dszarkaContributor
asked in Transformers
Why are all my attributes not being transformed

I'm trying to map levels names from one MicroSation DGN file into different level names in another DGN file. Most of the levels are being mapped correctly but some features are not being mapped at all. Not sure why that is happening. Has anyone else had this problem?

45
daveatsafe
Safer
G
giseng
asked in Data
Can't get invert elevations when translating from Civil 3D to shape

When converting Autodesk Civil 3D data (specifically pipes and structure for creating water, storm and sanitary features in shape or geodatabase) with FME, I am not getting any invert elevations. The newly converted features have some AutoCAD attributes in HEX (assumed) format, but non of them make sense as invert elevation when converted to decimal. The export LandXML file from the same Civil 3D does have those invert elevation that could be read as part of structure description, so it is there, just can't get it out into GIS. I really wanted to avoid the process of manual entry of those invert elevations every time I need to add new developments to the infrastructure features. Any help on that?

892
G
ciarab
Contributor
ciarabContributor
asked in Authoring
Data Download FME Server- JavaScript error- run if geometry is not drawn

Are there any javascript experts out there? I have created a data download web application where you draw a polygon and return some data. I have done this primarily from some samples made available on the knowledge base. It looks ok I have customized it a bit and added some extra functionality/background mapping.This is all working very well when I draw my polygon and submit the request it goes to Server and my data returns.Problem is I want to run the workspace even if a polygon is not defined/drawn - as in I have another parameter option to input x,y min and max values. I would like the workspace to submit without the polygon geometry part being drawn.  But when I try to do this I get the following error stating it can not read lengthmapinfo.js:175 Uncaught TypeError: Cannot read property 'length' of undefinedat processClip (mapinfo.js:175)at HTMLInputElement.onclick (mapinfo.html:1)  Can anyone tell me how I could get around this basically if its null ignore or something sim

52
ciarab
Contributor
O
oshkosh_gis
asked in Data
FME Cloud Access To on Premise Server

Can FME Cloud be configured to access my local network drives? For example, could I read something from ArcGIS Online and write it to a shapefile or FGDB on one of my on premise servers?

92
O
P
pavelpostnov
asked in Transformers
HTML parsing

Hello,Can you please help me with HTML parsing. Which settings I should using (css selector and etc) into HTMLExtractor that I can get only value of data-title attribute ?Regards, Pavel.

738
G
F
fluusha
asked in Transformers
Rasterband Issue

Picture 1: Picture 2: I want to do a Raster Mosaik so i need to make sure that the Rasterbands of the two Pictures are the same.why has the picture nr 2 behind the channels "#"? Never saw a Raster with the Band behind the Channel.

61
david_r
Celebrity
jugoslaviaa
Enthusiast
jugoslaviaaEnthusiast
asked in Transformers
Extracting Min and Max Extents from output of 2DGridAccumulator

Hi all,I am using 2DGridAccumulator, which works perfectly fine. I would like to write also the bbox coordinates of each grid to my final output. I can see those values in the inspector but I don't know how I can extract those attributes so that i can write it. Any idea how i can do it? thanks in advance.  

1711
ebygomm
Influencer
alex_p
alex_p
asked in Transformers
RabbitMQ JMS Client configuration

Hello FME users,I am trying to configure the RabbitMQ JMS client for FME Server, without success. I copied the client files and dependencies directly in "FMEServer\\Server\\lib\\jms". Next, I configured a JMS subscriber to send message to my RabbibMQ Server :- Protocol : JMS- Provider Type Or Context : com.rabbitmq.jms.admin.RMQObjectFactory- Provider URL : server-name:5672- Connection Factory : com.rabbitmq.jms.admin.RMQConnectionFactoryUsername and password : OKDestination: a queue nameWhen I confirm my configuration the following error message appears : "Unable to find provider named com.rabbitmq.jms.admin.RMQObjectFactory. Ensure that the appropriate libraries are available and the correct provider is selected."What I am missing? Any help will be really appreciatedThank youAlex

4599
david_r
Celebrity
navaneet
navaneet
asked in Authoring
Is there FME equivalent function like Oracle Decode?

Is there any function exists in FEM equivalent to oracle function decode. DECODE(supplying_code, 1, 'Oracle', 2, 'FME', 3, 'ArcGIS', 'GIS') result

82
david_r
Celebrity
A
andrew.t
asked in Data
Transforming csv data

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

186
takashi
Celebrity
deanhowell
Influencer
deanhowellInfluencer
asked in Authoring
Scaling AutoCAD Annotative Block

Hello again,We have a DWG that contains blocks that have been drawn in model space and then displayed in paper space using annotative scale. The block in paper space is scaled to the correct size based on the annotative scale but when I send the output to TIFF / PDF the blocks are the wrong size. TIFF Image above, DWG below. I know I need to scale the block, probably using the Scaler transformer, but how do I figure out the annotative scale used in the drawing associated with the paper space scale.There are AutoCAD references to the annotation scale but not sure how to find that scale out in FME as I can't seem to find in through exposing various attributes.  Sample drawing attached :

1103
deanhowell
Influencer
freddy17
Contributor
freddy17Contributor
asked in Data
3D View from CAD to .svg

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

853
daveatsafe
Safer
P
phoolish_one
asked in Transformers
Electric Migration workspace for Electric Asset Package V3.2 Translation Failure

Hello Everyone,I am trying to run the translation on the Electric Migration workspace for Electric Asset Package V3.2 (Electric Migration V3 2019_12_18.fmwt file) using FME Desktop version 2019.2.3.1. It fails because it is missing a file called "NapervilleElectric_2019_10_22.gdb.zip". Is the file available for download, and is the workspace supposed to produce an asset package that is ready to load into a Utility Network without further configuration?

131
M
lukas108
Contributor
lukas108Contributor
asked in Data
Write file in the same directory where source file is

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?

734
lukas108
Contributor
B
binabina
asked in Transformers
How can I calculate simple multiplications of 2 attributes and create a new column with the results?

Hey, I want to calculate values from 2 columns and get the results into a new column. Its only a multiplication: values of column a * values of column b = values in new column. Does anyone know how i could do this?

4602
B
deanhowell
Influencer
deanhowellInfluencer
asked in Data
DWG Scale Bar missing units

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? 

533
deanhowell
Influencer
kuanglee
Participant
kuangleeParticipant
asked in Data
SQL to Run After Writer in both SQL Spatial (JDBC) and SQL Non-Spatial writers

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 

994
kuanglee
Participant
dmerrick
Contributor
dmerrickContributor
asked in Transformers
Run part of FME Workspace based on day of the week or if date = X

Hi,I am trying to set up within an FME workspace a way to run select transformers within the workspace based on the day of the week, and other parts based on the month.I have various external datasets I want to refresh internally (SDE) by pulling them externally; some datasets are to be pulled every Tuesday, while others are on a quarterly basis (2/1,5/1,8/1,11/1). I would be running the workspace from FME server on a daily basis but have the coding within the workspace to refresh based on preset conditions.I am running FME 2018.1 build 18547

1303
dmerrick
Contributor
J
jvickrey656
asked in Transformers
Create a list of dates based on starting date and interval

Hello, I'm trying to download a series of excel files that are on a website. There is a starting date of 9/19/2005 (its hyperlinked for each excel file) and it increments by 7 days (so its a page fill of hyperlinked dates). I'm guessing I need to create a list of all dates starting from 9/19/2005 so that I can use httpcaller to download each file. I'm having trouble creating the starting date so that I can use DateTimeConverter to create the range (and consequently create the full url's to each file). I tried using AttrubuteCreator with a new value of DateTimeCreate(2005,09,19) but this expression errors.Thoughts on this and I'm all ears if there is a cleaner approach. Thanks in advance

2586
J
mmccart
Enthusiast
mmccartEnthusiast
asked in Data
Read only the 1st line of Text/CSV File

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

2692
mmccart
Enthusiast
fmelizard
Safer
fmelizardSafer
asked in Integration
In the FME Server Rest API what are the statuses that can be returned for GET /transformations/jobs/completed?

When I make a GET request to /transformations/jobs/completed there are two objects returned that both include a 'status' element; the Job and the Result object. What are the differences between these two?Second, what status values can be returned and how are they defined?

3121
H
kahramannkadirr
Participant
kahramannkadirrParticipant
asked in Transformers
How to simplify/purify a 3d solid?

Hello everyone.I have a .dwg file including substructure data of an area. I'm studying on creation a 3D city model with virtulacityPUBLISHER. To be able to create this, I'm transforming dwg file into a geojson file format via "bufferer" transformer (Buffer Type: Solid). But solid type creating a semi-sphere at the end of the line. And then, generating surfaces which consist of 6n^2 faces. If we think about an awful a lot details for all substructure details (e.g. gas or water tubes, cables etc.) it will be too much surfaces to publish (with a web browser interface) for a city model. So, how can i simplify the lines (especially end of the lines) which is using for creating goejson file types.Thanks.

1981
daveatsafe
Safer
E
edoh-alove
asked in Integration
How can I make a POST request send the Access-Control-Allow-Origin response header (job submit)

Hello community,I'm trying to call the REST API in ajax from another application. In this call, I do a POST request to submit a workspace. The call works fine in Postman and I get a job id in return. However in the response headers, I only get the following parameters: Content-Length, Content-Type and Date. For the purpose of my application, I also need the Access-Control-Allow-Origin in the response headers.Any idea how I can make that happen?version used: FME server 19.1 over https (port 8443)Thanks in advance

472
E
E
egaru
asked in Authoring
Generic dynamic reader: Attributes missing

Hi,  I am trying to build a workbench that performs certain checks irrespectively of the Input data. That means that it must accept data with different data types (.shp, .mdb...) and schemes (e.g. different attribute names and types). As far as I know, a generic dynamic reader is what I need. So I inserted one and tested it. Although this reader reads the (spatial) data and shows its polygons in the inspector, the attributes are lost. Instead of the original attributes, there is only one row in the table with the header <no schema>. In the feature information part of the inspector, however, the attributes are still listed. Since I want to write a log file including all the errors found by the checker, the attributes are important. What do I need to do, so that I can access the attributes of the generic dynamic reader?   Best regards André

1589
kimo
Contributor
A
aviveiro
asked in Transformers
Row Values to Columns

Hello,I have summary output coming from the StatisticsCalculator that I would like to rearrange such that row values become column headings with values for these coming from the statscalc count output (see input and end result images below). I've tried AttributePivoter, AttributeTransposer without success.Thanks.Tony

1283
A

Badge Winners

  • FME Certified Professional
    jonasverhas earned the badge FME Certified Professional
  • English Speaker
    lnicholson77has earned the badge English Speaker
  • French Speaker
    apichonhas earned the badge French Speaker
  • FME Form Advanced Training
    dnyandeobshindehas earned the badge FME Form Advanced Training
  • FME Form Advanced Training
    lauriadvhas earned the badge FME Form Advanced Training
Show all badges

Community Stats

31,819
Posts
120,866
Replies
39,454
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.