FME Form

I would like to be able to use FME to bulk upload data to salesforce. We currently manually upload csv files with awareness that there is a limit of 50,000 rows per file (salesforce import wizard). I have seen it should be possible to automate this using the salesforce reader/writer. I have the API credentials for salesforce and I can see all the table objects available in FME. The issue is that the object we are trying to write to appears to have different fields than expected when read (these look to be metadata fields) - see image. When we run the process to manually import using the wizard the attributes are those in the csv uploaded (see image). Both of these tables are the custom table 'property(_c)', the saleforce URL indicates that this is the case. Do you need to change permissions on the object salesforce side or do anything specific with the reader/writer in FME to get this working? Kind regards,  Antony

Greetings, I have tried several formulae, but no convert metric to DD??Any suggestions appreciated.@Value(_inside_x)(@CoordSys(EPSG:4326)) @Value(_inside_x(@CoordSys(EPSG:4326))ThanksClive

I would like to output an excel template with one of the columns having cells containing values from a pick list.  From my understanding I don't think FME is able to output the picklist, but a possible solution is to have the pick list already defined in the excel template.  However, even if I have the cell defined, I do not know how to have it replicated for each row that is outputted from the FME template. Do I have to just fill the entire column with the picklist and than delete the extra rows after the fme template is run or is there a more elegant solution. Thanks

Dear All, I would like to read an excel ''configuration input file'' which contains the values that will be used to set the ''User parameters'' (2 columns table : first column giving the variable name, second column the value that the variable should take). Is it possible to that ? Can the ExcelReader parameter ''Read Form Control as Cell Value'' be used for this purpose ? What does this parameter ? I found no information about it in the help and tried a lot of things without success... Any help would be welcome !

Hello ,i need to convert from EsrI Database Arcsde Geodb to write into Geodatabase (File Geodb Open Api)Feature reader :to read all feature classes in Arcsde feature write :file geodatabase my target to write specific feature classes that belongs to one Feature dataset from Esri Arcsde into file geodatabase i need exactly sample of feature dataset to test in ArcGis pro .  FME 2021 Thanks in advance

I have points in WGS84, collected with a gps on one single point (static). I would like to determine the median of these points. Or the one point with the less deviation.Thank you for your comment.

One of them is:WARN MessageCould not load module 'C:\\Program Files\\FME\\2022\\plugins/MAPINFO.dll' : 'The specified module could not be found'Could not load module 'C:\\Program Files\\FME\\2022\\MAPINFO.dll' : 'The specified module could not be found' Translation is successful (Desktop or Server)

We have recently implemented a new version of the ESRI ArcGIS platform and are running the old geodatabase with the new one as well. Is there any functionality in FME to sync the old geodatabase with the new one. As of right now the two are out sync.

Hello all, I was planning to do a small workshop on FME Data Express... While preparing this, I found shockingly little information on the specific parameters I could use to interact with some specific phone-app functionality. This ... was the most informative post, noting 'We are still working on our documentation.' two years ago. How do I make the app ask for a QR-code?Can I somehow consume a picture?I seem to be able to get the location of the device with a specially named text-parameter. Are there more of those? Please, give this app some tender love and care in the documentation. Give it a technical blog-post and some example workspaces one can upload to ones own server as a startingpoint.. Martin

I have a CAD layer of control points which have two labels around it. I'm trying to extract the neighboring labels and add them as attributes in the final geodatabase. I have tried using NeighborFinder but it captures the nearest label only. I have tried to use a Tester to differentiate between the two labels and then run NeighborFinder but it leads to multiple records. The red circled is the control point and orange circled are the labels.  How can I capture the attributes and have 5 points in the output rather than duplicating them? 

Hello every one,I have a cad file with lines and block on to on them.The block have some attributes, and one of the is Length.for some reason, there are a lot of blocks that instead of having the length properly, it have #### marks.I tried to fixit of course with FME, I managed to recover the length from the line which the block is belonging to, but- when i'm writing it to dwg, it is get mess again!I tried to use Attribute Output in the writer definition, 'Inserts' or 'Limited' got the right length number, but they destroy a lot of other definitions in the cad file.can someone please help me?I'm attaching here small sample..Thanks!

Hi, I am trying to asses assets that are in CAD and not in GIS. Using the Spatial filter or the SpatialRelator i am getting results of one to many. I.e. the results are relating one candidate to many filters. What transformer can i use that only spatial joins one candidate to only one filter? Please help!

Hi,  I want to separately identify missing, null and empty values in a data array.I tried with the TestFilter, the sorting does not seem to be done correctly.Because, my file contains null and missing values but here all data exits in one place. Do you have a solution ? Thanking you in advance   

I'm using HTTP Caller for geocoding adresses, but somehow I'm getting randomly lot of 400 responses - e.g. 2 of 12 calls are succesfull. If I copy paste the URL from error log to browser I'll get the result correctly.I'll share the worspace template temporarily including the API key of Geoapify. I don't know why I'm getting 400 (bad request).

I am trying to select a polygon located in between other polygons. All polygons are saved in the same layer. Either NeighborFinder or AreaOnAreaOverlayer do not provide the result I am after.

Hi, I'm encountering issues to connect to an sFTP server through a proxy.With my ftp client I'm able to connect with the following configuration.But I don't know how to configure my FME Desktop environnment and FTPCaller transformer to access to it.Here is how I tested it.Configure proxy settings on Windows Configure FME Desktop environnementConfigure FTP CallerI have the following error See log file attached.I alswo tried with pythonCaller but I didn't yet figure it out. Any tips to solve my case ?Thank you,

Please appreciate if you could let me know in details  

I have made a script that writes data to Oracle database, using FeatureWriter.Before I write data, I use FeatureReader to read number of records. At the end of the script I want to know how many records there are now.I also use FeatureReader for this. The results are always the same as before and after the transactions. It seems that the 2nd FeatureReader has already started before the transactions have been processed. I have tried with Oracle Reader, 2nd connection parameter, SQLExecutor.The results are always the same as before and after the transactions.Also using Triggerer and Decelarator. Something has to happen that the 2nd FeatureReader will 're-read' the table. Anyone has a suggestion ? Thank you in advance ! 

Dear Safers,I am trying to create this network using the 'From' and 'To' columns.So, the number in 'From' is connected to 'To', and then find this 'To' number in 'From' and find it's corresponding 'To', and again find the second 'To' in next 'From' and get it's corresponding value in 'To'.The catch is, the value in 'To' has to be greater than 'From'.I can think of a go to solution in SQL, but can't think of something using transformers.Thank you for the support.

Hi everyone, I am new to FME, please help me with the following issue. I am reading an excel file using FME. The name of the attributes (columns) is not right, and its in row 5 of the file. I was wondering how I can assign values in that row (5) as attribute names. I know that I can use a tool like AttributeManager to rename the attributes, but its too many attributes/columns (>100). I need a way that could assign the values from row to attribute name.Thanks

Using FME Desktop 2022: When attempting to write to pdf the following error occurs 'PDFWriter: Unable to successfully read the font from 'C:\\Windows\\Fonts/._TravelingTypewriter.ttf'. This font will not be available. Internal error code was '2'' FME has reading rights to this directory and the file exists. I haven't selected this particular font in the preceding PDFStyler-transformer. Any ideas why this occurs? 

Hi i convert IFC to cityjson using FME. in FME everythink is ok like below:  But when i open this cityjson file using Qgis, iit cant work like below: anybody can help me?tqvm

I have a set of features, all with IFMELine geometry, where some are closed and others are not. The closed ones vary between 2D and 3D closure. I can inspect these features and see the Closed propery right there in the Feature Information:(The straight line to the lower left of highlighted box has Closed = No, as one would expect.) So, for every line in the set, Closed is visible in the Feature Information window and has a value of Closed In 2D, Closed In 3D, or No; however, when I then run this set of features through a GeometryPropertyExtractor, all features are Rejected with the MISSING_GEOMETRY_PROPERTY error. The setup for this transformer in my workspace looks as follows:The transformer was working yesterday. Today, it isn't, and I swear I haven't changed anything. (OK, yes, apparently I did, but I can't for the life of me think what.) Am I missing something simple here? (Feels like a "facepalm" situation, for sure.) Thanks, All.

 Please refer snapshot, creating texture Atlas using CITYGML data FME 2022.1.2 version

I am trying to connect to my Smallworld 5 database with FME 2022. I can connect successfully with 2021. I have FME Smallworld edition and have copied the needed connection files to the installation folder. What have changed between the two versions? It says 'This FME edition does not recognize the 'SWORLDSWAF' reader.