Data

Hi all, I'm hoping to use FME to replicate from our internal ESRI SDE (i.e. the FMW running as scheduled task sitting on our internal server) to a geodatabase that sits on a cloud server. To connect to the folder for the geodatabase I need to enter a Username and Password. As the task scheduler runs when I'm logged off the server the credentials need to be stored with the FMW rather than just a mapped network drive on Windows. Has anyone had any experience connecting to remote folders via FME or storing username/passwords within the writer properties? Some guidance would be great. I'm fairly new to FME. Thank you :)

Hello, I am FME beginner and non CAD drawing user. I have a task to convert point features in Excel spreadsheet to CAD drawing. The drawing should contain the attributes too. After viewing the tutorials, I am able to create the CAD drawings. The attributes can be viewed in Data Inspector, however it cannot be viewed in Autocad LT 2016. I am attaching the workspace for reference. Please review and let me know if I have missed any steps? Thanks in advance Regards Vidya

Hi why FME writes stroked Arcs (so there are many linepices) into DWG? I have a very simple translation. And if I insert an inspector right before the writer there are still arcs. But in the DWG are all arcs stroked. Why? Is there a parameter or setting to give? Thanks for your help.

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 thanks Thomas

Hello. I need to apply some formatting to an excel file (borders, fontstyle and so on). So far I use a template but the solution is not perfect because I don't know in advance some details like, for example, how many rows will be written. Can I run a macro written into the template to accomplish these tasks? A shutdown python script? Suggestions? TIA Roberto

Hi, I have a xml document (someName.conf) which is not valid. like: <?xml version="1.0" encoding="ISO-8859-1"?> <application name="...."> <component name="...."> <setting> <!-- any comment --> <name>Explorer.Service</name> <value></value> <enabled>false</enabled> </setting> <setting>.... and so on I have no xfmaps or other schemas. I used different readers (generic and xml) and used some transformers like xmlFlattener but can't find to extract xml element/item with attribute. output excel file should look like column a -> comment column b -> name column c -> value column d -> enabled I`m using FME Desktop 2015.1 Any hint? thanks

I have exposed the fme_feature_type attribute. I am then using the FeatureWriter to write this feature class (FGDB) to POSTGIS. Its new name in POSTGIS is @LowerCase(@Value(fme_feature_type))_load. My next transformer is the SQLExecutor where I am trying to find if the above table already exists but doesn't have the _load at the end and DROP that table if it does exist So for example. I am loading Cities_load but want to drop the existing Cities table if it exists and then RENAME the Cities_load to Cities. What would my SQLExecutor read? DROP TABLE IF EXISTS @ReplaceString(@Value(_feature_type{0}.name), '_load', ''); ALTER TABLE @Value(_feature_type{0}.name) RENAME TO @ReplaceString(@Value(_feature_type{0}.name), '_load', ''); The above SQL doesn't seem to work correctly...

I am attempting to connect to a SharePoint online site using the SharePoint reader For several days the sharepoint reader throws an '403 Client Error' with the same workbench which worked correclty a few days before. We are using SAML to authenticate and user and password is proved as up to date. error log: DEBUG: Microsoft SharePoint List Reader: {u'error': {u'message': {u'lang': u'de-DE', u'value': u'Zugriff verweigert. Sie haben keine Berechtigung, diesen Vorgang auszuf\\xfchren oder auf diese Ressource zuzugreifen.'}, u'code': u'-2147024891, System.UnauthorizedAccessException'}} Microsoft SharePoint List Reader: Client-side error: '403 Client Error: Forbidden' returned from SharePoint. Error message was: '%2' BADNEWS: A fatal error has occurred. Check the logfile above for details (dynaread.cpp:265) Has anyone any idea how to solve this issue? Thank you.

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 my example: C:\\data2\\dirB\\**\\ C:\\da

A RedLine (.rdl) is essentially an empty MicroStation file that references the DGN file. It's used to 'markup' a layer that appears on top of the contents of the DGN file without actually touching / changing the DGN file.

I have a xml file which has the following structure: <Alignement ObjectId="9a8ed34d-2da9-4f37-9d5c-6569f665ce4f" Naam="R-HAVEN SP.701" Status="onbekend" RevisieNummer="0" GroepId="b885abb4-e34d-40d0-a752-362869bf8667" Lengte="2134.04431" Start="0" Type="Alignement" IsSubcomponentenDoorgerekend="true"> <CombiPuntenHorVer> <SpoorasInfoPunt ObjectId="0c131e39-de81-4244-905f-e7f27057566d" GroepId="7e1bd81b-0ce3-4144-947b-b095b5020b53" offset="0" Spoorzijde="Links" Bulgefactor="0" z_verkanting="0" dY_verkanting="0" factor="0" hoek_XY="0" hoek_YZ="0" Min_R_Horizontaal="0" Metrering="0"> <Geometrie> <CoordinaatSysteem> <Locatie KeuzeCSType="Rijksdriehoek" X="145146.355" Y="345251.230" Z="3.5"/> </CoordinaatSysteem> </Geometrie> </SpoorasInfoPunt> <SpoorasInfoPunt ObjectId="9021e8e2-4599-45c6-9b16-9f3418545aab" GroepId="7e1bd81b-0ce3-4144-947b-b095b5020b53" offset="0" Spoorzijde="Links" Bulgefactor="0" z_verkanting="0" dY_verkanting="0" factor="0" hoek_XY="0" hoek_YZ="0" Min_R_Horizontaal="0"

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

Hi All, I have an xls spreadsheet, lots of rows, each row is an individual record with various data in each column. I also have a folder of jpgs, each jpg named to match 1 value in a column. I am looking to produce a single pdf for each xls row and its associated photo. I am still learning my way around FME but I've tried an Excel Reader and Jpeg Reader joined by jpg filename/column attribute, then put into PDFPageformatter then fanned out by joined attribute but for the life of me I can't work out why the xls does not show on the PDF, just blank. Photo will show though. Am I missing a step? Would really appreciate any advice? Many thanks in advance, Amgaad

I have Oracle Readers and Writers in my workspace and the translation successfully completes. But in the log I see this message: Oracle database version could not be determined; assuming version of '10.2.0' My Oracle database version is not 10.2.0. Why does FME assume this version?

Hi, Which are all options to create a new version on arcsde (oracle12c)? I am running fmeserver FME 2014 SP4 (20141022 - Build 14433 - WIN32) and have managed to create the version with arcpy :), but the client does not want to change the default python interpreter :(. So i am trying to find another method to create a version of an SDE (oracle12c) dataset. I have already tryied slqexecutor but i cannot connect to this oracle12c (just oracle8)! Any clue? Thanks a lot in advance!

We use the same datasets on a number of projects. These are sourced from the following site http://environment.data.gov.uk/ds/catalogue/index.jsp#/catalogue, currently via download and manual management. We would like to build a process where users can set a tool running to download and manage the data. My thought is along the lines of: 1. Go to the website 2. Tick the WFS box for the layers you want on your project 3. As you do this the WFS URL changes at the top of the page 4. Copy this and paste it into a pre-made workbench 5. Define the MBR of the project within the reader so only the relevant data is included – this part could be done by a clipper and a specific polygon in the workbench but then we would have to access the entire WFS. The thought is specifying an MBR in the reader moves the extent query to their server greatly reducing the data we have to download and the speed to run the final tool 6. Run the workbench. It would create a File Geodatabase or any other format based

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)?

Any particular reason why I cannot find search envelope parameters for the FeatureReader when pulling in a WFS stream? Any assistance would be helpful :) Thanks.

I have got a shapefile (left picture) where the donuts have been included as part of the polygon. I need to try to get the outcome of the right picture, which is the correct polygon of the site and which will allow to calculate the correct area of the site. Is there an easy way of adding a transformer that fixes that?

Folks I have an An autocad_surface that is listed as a fme_aggregate. Want to convert it to a surface via something like numericrasterizer. However its only doing the line edges of the triangles - and not the flat surfaces. Any thoughts? Should i run through deaggregator first ?

i want point cloud generation code and algorithm

I have a GeoDatabase in which roofs and façades are defined by different appearance styles (diffuse color). I used the AppearanceExtractor and AttributeFilter to filter the data. I'd like to produce a CityGML file with the appropriate semantics, but if I connect the AttributeFilter output to the Writer the produced file does not contain any geometry but just the other GDB attributes. Any hints? Thanks

Hi, When I check my data in FME Data Inspector I have all my rows, but when I write the data to an Excel spreadsheet I have a lot of empty rows and some rows populated. Does any one face the same situation ? Thanks. Jacob

Hi, I have 100,000+ points I would like to group into a fixed number of members as spatially optimal as possible. The data comes delivered to me in either text or csv containing a variety of attributes including postcode. I have geo-referenced each row to the nominal centre of each postcode using OS Code Point. This gives me the easting and northing for each row. I have tried to convert this to an xyz to then follow the suggestions in this post https://knowledge.safe.com/questions/24064/cluster-points-based-on-location-k-means-method.html. However, I suspect due to my limited working knowledge of FME, I'm struggling to create the correct workflow. I have tried another approach in FME creating voronoi polygons from the points and then using PointOnAreaOverlayer to add the overlap/count of points in the polygons. I thought I could then look to dissolve the polygons based on nearest neighbour locations until the desired count is reached. Can anyone provide any advice, tips or instructions