Using readers and writers to extract and load data.
Recently active
I have a number of lidar files in LAS format that I want to convert to one compressed LAZ file. I can read the LAS files with one reader, but when I use the ASPRS Lidar Data Exchange writer to write, it writes multiple LAZ files. This is true even if I set the Compress Files parameter to Yes. How can I get just one LAZ file? Thanks
Hi , I have a featureclass stored in a SDE Geodatabase. How would I go about witing a txt file with one column containing the features geometry in Oracel (MYSYS.SDO_GEOMETRY) format? I assumed I would use Geometry Extractor, but there doesn't seem to be an oracle geomtery encoder included? Would I need to write the feature to another Oracle Spatial database then extract the information from that? Many THanks Bkicker22
Is there any way to determine the width (in coordinate units) of AutoCAD multiline text output? I need to offset the text to the left for callout tags where the leader line leans to the left of the item they are describing (subtract width amount from x coordinate) - but I have yet to figure a way to extract the "rendered" width of the longest line to do so.
Hi FME-ers, With Desktop 2013, is anyone familiar with a workflow I can use within FME to populate two attribute fields (in a stormwater pipes layer), with corresponding IDs from a connected stormwater pits layer which is snapped to the start and end of each pipe. The pipe layer is digitised in direction of flow so I would be looking to populate the corresponding upstream and downstream pit attributes to reflect this. Note: ESRI used to have a VB Script which did this but it is no longer supported in 10.1. thanks!!!
I am running a workflow using various transformers on data (eg. BulkAttributeRenamer, AttributeCreator etc) is there a smart way to retain the feature data types through to the writer? When connecting the writer, I copy attibutes from the previous transformer and it lists all columns as "text" "200". I do not want to have to manually change the type in User Attributes. Cheers!
HI All, How to send an output from a workspace to fmeserverjobsubmitter. For Instance I am having a workspace which checks if a field exists in a feature class if not then notify the user. If I publish this workspace in the server and use it using fmeserverjobsubmitter how can I access the output How can I achieve this ? Thanks
As I have to run the same script for many shapefiles I wonder if there is a way/transformer to name the newly generated output shapefiles (dynamic) automatically the same way as the input shapefiles. I am new to FME and appreciate an answer which I can follow easily.. Thanks a lot!
Can anybody explain the workaround for when FME runs but reads the previous Writer that was there. Explained: I have .MIF files that I download from a GPS and input into FME every week. FME is reading my last weeks file count when it should be reading the new file? Even when I erase and re-add the new writer, it still reads my old ? The features have the same name but I thought FME should recongnize it is a new Writer (because I erase all files in FME and re-add NEW) and thus have different feature counts. Is their a CACHE somewhere in the workspace where I can empty to solve this issue?
Hi, Is there a way to compare schema between ArcSDE Feature Class and File Geodatabase Feature Class . Schema(Any format) works for file geodatabase feature classes but not for ArcSDE Feature Class . Can anyone tell me if there is a FME approach for this ? Thanks and Happy Christmas to all
This question is related to the last question I asked regarding the date and time seperation issue- https://safecommunity.force.com/CommunityAnswers?id=906a0000000d6Yi Now, I have a column Date in my table which is having different dates, and the number of datasets in large amount. I just want, if the user runs the WB from 'Prompt and Run Translation', he can select valid dates from the respective input colum. Suppose there are dates from 1/1/2014 to 1/2/2014 (DMY), he should be able to selelct from and to dates according to his needs and the output should show only those section of dates and other related columns also. Please feel free to ask questions if i am unable to explain !!!
Hi. I’m having some problems with the 3D-bufferer. When I run the 3D-bufferer on some of my data sets I get the log error shown below. The data sets consist of 2D lines created from coordinates through the vertex creator (the 2nd picture shows an example from the inspector). Some data sets work with the 3D-bufferer but many don’t. Any ideas what input could be causing these issues? Is it limited by a large number of features? 3DBufferer error message 2D Lines before 3DBufferer Workspace with coordinate vertex creator in red box.
Hi All, I look for a method that can add a blank line between field names and data into CSV Writer. Any idea? Thanks an advance. FarFar
Hello to all, I am trying to use a 'generic' reader because I want an input for a workspace to be either an ESRI shapefile or a file geodatabase. I am supposing this is the best reader type to use for this purpose. When using the generic reader, features are read from the input destination but upon inspection it seems that the imported features have no attributes. A message is displayed in the Data Inspector table view: 'Empty Table - No Schema Available'. I can't seem to find a case like this on the FME community forum, is there anyone who can help me finding out how I can import attributes together with geometry with the generic reader? Or is this impossible (which would not make much sense to me) ? I can't seem to figure it out by myself. I am using FME 2014 SP4 Thanks in advance for any help ;)
Hi, Are there controls for the spacing of each character when using a process which involves labeller and text stroker? For example I have a string "CA" , I would like to be able to set the distance between each character e.g 1.5m or 1m distance. Thanks.
I am running FME 2014 SP4 and am having trouble when transforming data between Oracle Spatial Object to MapInfo TAB file. The transformation is very easy: I am simply stripping out a few attributes from a parcel dataset and then writing to TAB file. When I compare the output TAB file to the original data there is quite a bit of offset. It seems that almost every parcel has at least one vertex added or removed that changes the shape. It seems that coincident boundaries are preserved. My original thought was that there was a problem with the Arcs in the data so I introduced the "ArcStroker" transformer and no matter what the settings, the data comes out looking similar. There are large gaps and slivers(>4 feet(1+ meter)) being taken away or added to many parcels. I need the data to be accurate as it will be used to digitize other features based on property lines. I work for a large metropolitan city of more than a million people so if the data is not accurate then this cou
Hello! My goal is to enable a FME user to select certain trajectories of waterways, on basis of attribute values, prior to executing the Workspace for the selected trajectories. I accomplished to define a User Parameter that has as type "Choice (Multiple)". By importing the input file I could also select all the (unique) attribute values to take them into account as a valid choice. Using a Tester I make a simple Test Clause to select the trajectory by setting it equal to the User Parameter. If I now select a single trajectory, the Workspace is successfully executed. If I however select multiple trajectories as User Parameter, no trajectories will pass the Test Clause and the FME Workspace will not be executed accordingly. My guess is that the User Parameter stores the trajectories as a list, and that the Test Clause for some reason is not selecting the trajectories individually but attempts to find trajectories equal to the the list of trajectories. Does anyone have a
Hi all, I would like to write a CityGML file which only contains buildings. Hoewever, I need to write for each building their walls and roofs. I know how to use the CiytGML writer to write lod0Footprint or Lod1Solid, but not how to create objects with higher semantic information. Do you have any hints? Best regards
This has me stumped. I thought I had resolved this last week (I posted this in another question and thought it was resolved). The solution I thought would work was me clicking the buttons in Excel regarding Read Formulas and Read Hyperlinks. That doesn't work. I can't post the actual Excel file itself because it has information not allowed outside the company. But I've reviewed the field over and over and over again ... and there is nothing wrong with the field. For example, there are no hyperlinks or formulas in the field. The GIS ID is actually a text field because some GIS ID's have a letter in them. Like you might have 08786651 or you could have 08786677a01, 08786677a02, 08786677a03 for example. I'm attaching an image of the Reader parameters this time so you can see that the Reader does show column CF (GIS ID) in the Preview pane. But you can clearly see that a blank field is present for CF directly under CE (Lease Grid#) in the Attributes pane. Like it's t
Hello, I am converting shape files to variuos formats. Input shape file has been created by non-ESRI tool. When the shape file contains NULL attribute values for all features; that particular attribute is not in target format. e.g. Shape file with attributes ID, NAME, URL, REMARKS with URL and REMARKS for all features is NULL. In this case output format there are only 2 attributes ID and NAME rest two are missing from output file. I also observed that in "User Attributes" tab in "Feature Type Properties" dialog of a shape reader, I am not able to see these attributes i.e. in ablove case REMARKS and URL. Is this behavior as expected? How can force FME to write out all attributes even if it's NULL. Cheers, John
Hi there, I'm trying to create a pdf file to visually represent some basic shape files I have. Using the Adobe geospatial PDF writer, everything seems to be fine. Until you zoom in a bit, then you see this: The red lines are some simple boudary polygons, that aren't normally as spikey and those green "pie charts?" are roads, standard roads. These exact layers display perfectly fine in ArcMap, so I'm very confused as to where these strange geometrical anomalies come from. At this point I'm not even using any transformers, so it's a basic reader to writer translation. Any tips on what I might need to fix this, or even a suggestion on an alternative output format that's good for display purposes? Kind Regards,
Hi, I am working on Win7 Machine with 8Gb RAM. While creating an XML from a shapefile, comments are being generated automatically which I want to remove. Tried XMLFormatter and StringReplacer, but didn't get the desired output. Can someone help me with that (: (The rows inside the box are automaticallygenerated and should be removed)
There's no rhyme or reason to this issue. No matter where I move a certain field in my Excel file (I've moved the row to the beginning, middle, and end) the Excel Reader simply ignores it. When you click Parameters on the Add Reader dialog ... You can see the field listed in the Preview pane under Parameters. But it is not present in the Attributes pane under Parameters. When I say OK on the Parameters and then OK on the Reader it adds the Reader to my FME job but the field is missing. Even when I expose the attribute it shows up as null in an Inpsector. Has anyone encountered this? Any ideas on how to get it to recognize the field or why it doesn't recognize it? FYI: I've even put in the range of the data in the Parameters and it still doesn't pick up the field. For example: Field Names Row: 3 Cell Range (e.g. B2:G9): A4:CF16430
Hi, I have a list of filenames that are located within a specific directory. The list of filenames is generated within the FME workbench. What is the best way to get the Reader to read in only the files within the larger directory? Note: the files that I want to read in are within a number of sub-directories, which I don't know what they are. I only know the root directory. Thanks,
Hello, I would like to do a jp2000 file with a tif. My conditions : 1- the tif is black on white so i want my jp2 black on white 2- the siz of the jp2 must be less than the tif Using rasterpalletremover my jp2 is 500Ko big but i need to specify nodata=0 in Qgis to see it in black on white instead of white on black.. See joined files (fil and jp2 500 Ko). I test many ways like rasterpaletteresolver and the viewing is ok but the files is three times bigger!!!(2.9Mo). If anyone can help me thanks, dowload my file here : https://drive.google.com/file/d/0B90n7rx5ph0ZMXFUUUtvbVplUXM/view?usp=sharing PS : si vous parlez français dites le moi!!
Hi, when I reproject a tiff file it sets as black those areas that incure due to rotation of original file. Is there a way to set them in other color. Of course, using raster cell replacer you can. But that will change all black colors in photo which I'd like to preserve since they were there in original file.