Data

I am reading a google sheet and using emailer transformer to send email, everything work good on the desktop, but when published on the server it giving this error Google Sheets: A refresh token is required in order to access this serviceI did get the Client ID and the secret key from google consol, but still giving me the same error any Idea ?

I have a csv separated by semicolon. Some lines have too many semicolons (bad data). To clean up the data I have read the csv with a Text File Reader to read line-by-line and used an AttributeCreator to create an attribute for the number of semicolons in each line. Then I followed that up with a Tester to retrieve the lines with the correct number of semicolons (clean data). Now I have this text line data and need to write back to a csv. I cannot figure out how to write to a csv from the text line data.

Howdy,This question pertains to working with file name/feature class name & name alias for shape files & file geodatabase feature classes.My Question is: Where in FME can I modify the Name alias when writing to a shape file or file geodatabase feature class? I am not seeing this in the parameters or the Format Attributes.Note: This is not a question about a geodatabase field name alias, help on that can be found here: https://knowledge.safe.com/content/kbentry/22423/working-with-geodatabase-field-aliases.htmlHow this became an issue for me:Working with FME 2018.1 I noticed that when working in a workbench I noticed that an issue pops up when I get lazy and instead of adding a new writer feature type I do a quick copy and paste to create a new writer feature type that I then rename (Parameters &gt

Hi all, this may be quite similar to this Previous Question but I am just seeing if there is any update. The problem is trying to use the MongoDB reader to access a Replica set held in AWS. Outside of FME you would connect to the database using the following address (with username and password removed and some *):mongodb://user:pass@pro**-shard-00-00-lw***.mongodb.net:27017,pro**-shard-00-01-lw***.mongodb.net:27017,pro**-shard-00-02-lw***.mongodb.net:27017/admin?readPreference=primary&ssl;=true&replicaSet;=PROD0-shard-0FME seems happy to connect to a similar arrangement if the Replica Set is held in a MongoDB on an internal server. But not so happy on an external encrypted server. Does anybody know whether it is possible?ThanksMatt

Hi everyone, I'm currently doing my master thesis and transforming some data into IFC file... does anyone know how to apply the color parameters to an object ? when I use the appearanceSetter, everything goes well and the result is ok in the inspector... but it seems that the Ifc Writer doesn't know how to deal with this information because in the BIM Vision viewer the colors doesn't appears and if I check my IFC file, there is no line with "IFCSURFACESTYLERENDERING" which should exist to apply a color to an object

I am wondering if there is any way to overcome the 7 concurrent FME process limitation of WorkspaceRunner? I am processing 2800 LAS files into DEM's (using a slightly modified version of the excellent example here) using a WorkspaceRunner being fed by a Directory and File Pathnames reader).Our processing workstation has 16 cores and 64 gigs of ram... 7 concurrent instances of this workbench is only utilizing about 35-40% of my system resources, and it takes almost a day to get through all my files.  Is there any way (excluding upgrading to FME server for something that really doesn't need Server's capabilites) to get this running on more cores (or can someone help me figure out how to run it in a highly parallel fashion)?Thanks!

I am am trying to convert a IFC-file into a CityGML-file. For inspiration I am relying heavily on the intermediate guide for BIM to gis. Now when I am trying to convert the IFCDoors entities into CityGML doors i get the following error:CityGML Writer: The 'IFMEMultiCurve' geometry is invalid for the 'lod4MultiSurface' citygml_lod_name, valid geometries for 'lod4MultiSurface' are: {IFMEMultiSurface}, convertible geometries are {IFMETriangleFan, IFMEAggregate, IFMECompositeSurface, IFMEFace, IFMEMesh, IFMEDonut, IFMETriangleStrip, IFMERectangleFace, IFMEBox, IFMEBRepSolid, IFMEExtrusion, IFMEMultiSolid, IFMEMultiArea, IFMEEllipse, IFMEPolygon}.Storing feature(s) to FME feature store file `U:\Exjobb\FME BIMtoGIS my own\NyvångToCityGMLintermediat_log.ffs'++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Hi,I need to generate a single TIF file from multiple DTM files. Any advise please.Thank you

Hi all,This works in SQL Developer.Why does this not work in a SQL Executor/Creator?select to_date(736845 + to_char(to_date ('02-01-0001'),'J'),'J') t1,to_char(to_date ('02-01-0001'),'J') t0from dualoutput:T1 T031-05-18 1721425Fme executor insists `ORA-01843: not a valid month'which is totaly not true!  It appears that the 'J', julian format is not recognised.  Is this a error or am i missing something?Don't suggest out of sql solutions, i wan't it to be done in the executor. Be aware i will issue demerits !! ;)  SQL answers required. Greets an txia for your answers.

Hello everybody,I have met troubles with values in igds_snappable attribute of cells. In my source datafile (v7), insert point of cell is snappable, but elements of cell are not. When I open datafile in FME Data Inspector, it shows me that insert point and all elements are not snappable.If I change value of igds_snappable in Microstation for just 2 elements of cell, the insert point in FME Data Inspector is snappable, interesting...Is it bug or not? Have You ever met the same problem? I´m using FME Desktop 2017.1.2.1Thank You so much!Lubo

Hi,I'm after creating a series of profiles / cross-sections using a mapinfo table containing the lines to be driven through a DEM of the LAS point cloud. The output txt file should contain x, y, z, and chainage (from the zero point of the profile, (which should increase at 0.5m spacing)), and profile_ID (derived from the mapinfo table).Any guidance on how to achieve this would be much apprieciated.

Hello beautifull people, i have to make onversion from buildings from CityGML lod2 to IFC . but i get a the end of conversion in the Data inspector NO Geometry !!! i need your help how can i do it and why does not go ? Thank you

In the doc: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/citygml/citygml.htm?Highlight=citygmlThe part where the limitations are listed:The CityGML reader reads all parts of the Thematic and Appearance CityGML models with the exception of the Digital Terrain Models (DTMs) ImplicitGeometry and xlink:href resolution.is not really clear. Is there a comma after '(DTMs)'? Or do ImplicitGeometry are not read? (They are, I just tested!). Same for XLinks, they seem to be resolved (at least those internal to the file). So I'd like to know the limitations, if any.

Hello I am Looking to export the Geodatabase schema ( manay tables) without the data to an excel sheetcolumn 1: table nameColumn2: attribute nameColumn 3: attribute typeColumn 4:width

I'm trying to upload a file from a folder with name luleå but FME change the character å with \\xE5 in the folder path and FME cant find the file and terminate the workbench.Is there something to do so fme does not change the character?

Hello,I've installed FME Desktop 2018.0 Database Edition.When I open an existing FME Workspace with a AGOL Reader I get the following error when I run it:ArcGIS Online Feature Service Reader: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='www.arcgis.com', port=443): Max retries exceeded with url: /sharing/generateToken?f=json (Caused by ProxyError('Cannot connect to proxy.', error('Tunnel connection failed: 407 Proxy Authentication Required',)))'A fatal error has occurred. Check the logfile above for detailsIf I try to add a Web Connection to my AGOL Account; after I enter my authentication details I get a error I am going through a proxy server.Any ideas?Thanks Helen

Hello,I am having an issue with OSM values (in a FeatureReader). For some reason, there are level and layer values set to 0.5. Even if it is quite unconventional, "there is an ongoing discussion on usage of fractional values". Thing is, it seems that FME does not handle this case, I get the following error :|FATAL |Feature Type: `waysStringFormatter_OUTPUT'|FATAL |Attribute(encoded: UTF-16LE): `bridge' has value `yes'|FATAL |Attribute(string)           : `fme_feature_type' has value `highway'|FATAL |Attribute(string)           : `fme_geometry' has value `fme_line'|FATAL |Attribute(entangled: string): `fme_type' has value `fme_line'|FATAL |          entangled to [xml_type]|FATAL |Attribute(encoded: UTF-16LE): `highway' has val

I have a pipe-delimited text file for inputThere is no header line of column names. Data starts on the first line.How do I set column/attribute names?I tried AttributeRenamer, but FME gives column names drawn from the first line of data. I receive a new input dataset each month, and the first line of data will change. I want to be able to assign column names based upon their order, not upon the first line of data. I need this process to be repeatable with a new input dataset.

I receive a driver not found error using the URI and when I point to the derbyclient.jar file

Hello everybody,I'm using this template https://hub.safe.com/templates/citygml-create-solitaryvegetationobject-with-implicit-representation to create a CityGML file that contains trees as SolitaryVegetationObjects with implicit representation. The template works fine but doesn’t serve my purpose as I want to use the data in the 3DCityDB which doesn't support MultiGeometry features. Is there a way to change the gml_geometry?Thank you for your help.

Hi, I'm trying to get the links from this URL using the CSV reader but it does not work: https://data.geo.admin.ch/ch.swisstopo-vd.amtliche-vermessung/meta.txt Using an HTTP Caller did not work either. If I paste the link in a browser it works fine. Any idea what I am doing wrong? Thank you for your help!

Hi,I would like to know how I can call an FMW file from my clients website.Thanks

FME 2018 seems to have removed my two preferred methods of using bookmarks: 1) Without a filled background - it's too distracting to be always on; 2) No description anymore. Much neater and compact than annotation and the 2018 examples still waste too much space. Can we please have these back as an optional behaviour? I can't even edit workspaces with description anymore!All you are encouraging me to do is to STOP using bookmarks!

I have a problem with writing the multiple sheet output to excel but keeping only the attributes that are relevant to each sheet. For example (as you will see on the image) SAC_NAME should only be in the sheet named Special Areas of Conservation and should not be present in the sheet Wood Pasture and Parkland... and vice versa the PRIHABTXT attribute should not appear in the sheet Special Areas of Conservation... What I get now are columns of empty attributes.I tried to use PythonCaller to remove the empty attributes but it did not work, since the writing actually happens in the writer and PythingCaller is before the fan-out happens (I imagine that before fanout all is in one sheet and none of the columns is entirely empty).

Hi, was wondering whether there is an option to read all the features from a feature class in a SQL Server geodatabase or SQL Server spatial table before they get written to an ArcGIS Online (AGOL) feature layer when I click the run button in the toolbar. The problem I'm running into in our environment is that part way through writing to AGOL I get an error like the following "Microsoft SQL Server Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `[no query]'. Provider error `(-2147467259) TCP Provider: An existing connection was forcibly closed by the remote host.".Thanks.