Data

Tried to copy feature classes from a Microsoft SQL database to a postgresql database using SDE Connection files. The workbenche does fine on FME Desktop 2017 but on the fme Server 2017.1 i get following error: "Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155644'. The error message from ArcObjects is: {Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly.} "

Hello, I'm working with some IFC files for a project. As part of the project I need to change the GeoLocation of some of these files to better match the final model that I'm making. I'm doing the final model in Infraworks and the IFC are exports from Revit.

Hi,I'm trying to export my data to excel. My workbench was working fine and suddenly I can't even run it.I'm having the following error and I don't know what could be the issue.I restart my computer and I close all the excel files on my computer but the issue persists.XLSX Writer: Saving changes to dataset 'folder_name'XLSX Writer: Failed to save changes to the spreadsheet 'folder_name'. Check that you have write permission to the file, it has no password protection and is not opened by another application. Error message is 'Permission denied.'A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ...Note that folder_name is the localisation path where I want to export the data.Thanks

Has something changed within the JP2 reader between FME2014 SP4, and FME2017? I'm using a simple workbench to convert from JP2 to Geotiff, which worked fine in 2014. I'm getting a message in 2017 that I do not get in 2014, "JPEG2000 reader: Mercator projection should not define both StdParallel1 and ScaleatNatOrigin. Using StdParallel1 and ignoring ScaleatNatOrigin." The resulting geotiff does not seem to retain the coordinate system.

we have configured our Active Directory with FME server and some active directory user already added to access and run FME workspace.But when I try to add new user then its asking to set password. we no need to set password. User can use there AD default password.

I am converting Sketchup file to City Gml v2.0 , I want to give seperarate layer names for Building, Lift , door,park and lift ? Can anyone suggest me a the way to follow?

Hi all,I seem not able to rotate text objects written to a png file.They are rotated, rotationfield has correct value when arriving at the writer.Even using gif_text_rotation or fme_rotation...nothing seems to make the png have the text rotated .Anyone know this issue and maybe what I'm missing here? (please answer in relation to png writer if possible...;))

Hi all,I need to create a .mdb access file from excel file which have informations about field name, width and type datal. Could you tell me how to make it from FME workbench?This is my excel data (input). I want to make 4 columns in .mdb with type, width data the same here.

Hello,In the Text_File writer I cannot select an attribute I've just created How can I solve that?Best,Harmen

Regarding this thread: https://knowledge.safe.com/questions/43262/png-text-rotation.htmlCould somebody from Safe reach out to Gio? I don't know if he actually filed a support case regarding this, but it seems the only answer he's willing to accept is that it doesn't work.

I am using an AutoDesk Revit Reader to transfer an RVZ file to a Feature Class in an ESRI GEoDatabase (ArcObjects). When using the 2DForcer to transform the 3D RVZ data to 2D data the translation fails and there error I get is 'Cannot write a non-area feature to an area feature class.' I am using a Geometry Filter which has the solid and area options checked, followed by a GeometryValidator with all options checked. and the output feature class type is set to polygon.

. but not getting desired results

To get an xml file automatically we are currently storing all attribute table of sql server DB into a enterprise GDB in sql server, which is creating a trouble that everytime it is taking the primary key field as OBJECTID and changing the name of the field. So we want now to have the attribute table as it is in a non-spatial database, and want to read it's table name, field names and datatype into an xml file. But I cannot read the field names and data type as a list thus I can use it inside our own schema. Can anyone please guide me.?

I have a Geotiff file where the colour (a real number) represents the elevation. I wish to generate contours form this data and can not see how to get the data into the contour generator in an appropriate way. What other transformers do I need and how do i use them?

I'm trying to write a dataset and featuretype fanout to ArcGIS Portal. The desired behaviour is:Each feature service is determined by Attribute Column X (dataset fanout) A layer in each feature service is determined by Attribute Column Y (feature type fanout)  I have performed a few fanouts before on different writers and they seem to work, but I can't get Portal Feature Services to successfully produce a fanout. My workflow is similar to the fanout template here: https://knowledge.safe.com/articles/565/fanout-1.html (see Combination fanouts)A feature type fanout is successful, but a dataset fanout using this workflow generates the following error: https:\\portal.bluedot.global\\arcgis\\AttributeValue1' does not appear to be a valid domain  I have also tried specifying the feature service parameters:firstname.lastname/@Value(attribute_values) with the following error:The error code from the server was '400' and the message was: 'Item does not exist or is inacces

Hi all,Workspace A is uploaded to FME Server as a Data Download and Job Submitter Service. Several files are written in the workspace (excel, sdf, json, txt) and -logically- they appear in the output .zip package of the data download service.   Problem: A FileCopy writer is used to copy a .dwg file to the output folder. Because the files for the .zip package of the download service are stored an a temporary folder on FME Server, it is not yet possible to have to .dwg also in the download package. The Job Submitter does its job and all my files are written correctly (including the .dwg file). The data download .zip-package does not have this .dwg file and that is my problem. I just need the URL or the location of where the files for the download package are temporarily stored on FME Server, so I could use this URL as a parameter for the output location in the FileCopy Writer.The documentation online told me this should be the 'FME_SERVER_DEST_DIR' parameter? But when I use this

Folks, I know I am missing something simple here. What I am trying to do is convert polygons from a shapefile to a dwg while conserving the attribution. The shapefiles are polygons and may or may not have multiparts and donut geometries. As such it seems a mpolygon is the best fit as an AutoCAD datatype.Something similar has been asked Here: Shape to AutoCAD with attributes by @lmerino but no answer I can get to work.I have the cad writer set to extend entity dataHowever when I look at the output in CAD the polygons are coming through as blocks. @Mark2AtSafe suggested using a Deaggregator transformer but I am not sure how this will help. I have done as @erik_jan suggested and added autocad_entity set to autocad_mpolygon via a AttributeManager and everything in the target drawing will then end up as a mpolygon as desired. However there is no attribution.Sample data: Edit: Seems that using a different writer such as Autodesk AutoCAD Map 3D Object Data ends up with the desired outpu

If I move my database to a windows to a linux machine is there any impact on FME users of this database other than updating database connections

Prologue: this suggestion puzzled me, but it's right: in 2016.0 (what I'm using) you can't point a Directory and File Reader at a zip file. You can with a FeatureReader though. Now read on!I'm retrieving the file properties out of a zip file with a FeatureReader with format 'Directory and File Pathnames' and 'retrieve file properties:' set to Yes. Workspace attached, .The file name and file size comes back correct, but all the dates, path_accessed_date, path_created_date and path_modified_date, get set to now. I think FME should be returning the dates the files have inside the zip.P.S. It looks like FME is actually unzipping the files to get at the info:path_windows (string) = d:\\temp\\ea_admin_boundaries.zip_1481293489605_5384\\AREAPF_EA_NE_010K_V1_3.shx...which explains the dates. Still not the right output to give, though, IMNSHO.

Hello Everybody, I am facing trouble to use a writer file (xml) as a Reader file for the second step. I am writing ESRI format metadata in a text_line and saved as a .xml extension. At the second step i want to use this xml file as a input file. Nothing is working , please see the attached imge. I have tried several ways like user parameter, feature to writer and so on,

Hi, I am trying to produce a GML 3.2.1 file with elements based on an xsd. Any suggestions ? Thanks in advance,Valantis

I'm Transforming georeferenced EsriShape to IFC4 the problem is that when I convert the buildings are in millimeters and when I use Scale to switch to meters the location is scale too so the position (georeference) change but the buildings in 3D are scale to Meter. I can not find how to use FME to set the corresponding parameters in ifcSIUnit and IfcCoordinateReferenceSystem have some one use FME and IFC4 ?