• Home
  • Forums
  • FME Form
  • General
  • I wonder why 2 fields out of 7 fields in total become empty when using writer, when there is information in the two fields when I am looking in the last transformer before writern.
Question

I wonder why 2 fields out of 7 fields in total become empty when using writer, when there is information in the two fields when I am looking in the last transformer before writern.

svante9
Rank
Badge +1

I get the data from two different databases, which contain a point layer, and a surface layer, I combine the two layers using a transformer called FeatureMerger, and it works fine. I write the result to a third database, where the layer is a surface layer. All the fields with data that I want are included, but when I send the data to an sde database in the writer, information is missing in two fields. In the writer, data type = char is set. The information that is missing is data type = text, the number of characters is correct when I look in the writer. What is it that is wrong? Why doesn't the information that is in the two fields come along?

11 replies

redgeographics
Rank
Userlevel 4
Badge +25

Check the attributes of your output feature type. If any are shown with a red triangle in front of them it means there's no input attribute associated with them. That may have a variety of reasons, but this would be the first place to start looking.

svante9
Rank
Badge +1

Hello

Thanks for your reply. On my output for the attribute data I'm sending out, there's a green arrow next to each field. When I then start the writer, I get a response that everything has been successful. When I then go into the database and look at what has come in, there are two fields that are empty of content, the other fields have information in them.

svante9
Rank
Badge +1

Hello

Thanks for your reply. On my output for the attribute data I'm sending out, there's a green arrow next to each field. When I then start the writer, I get a response that everything has been successful. When I then go into the database and look at what has come in, there are two fields that are empty of content, the other fields have information in them.

image

redgeographics
Rank
Userlevel 4
Badge +25

image

Are you sure there's data going in to those fields? You can check that by running the workspace with Feature caching on and inspecting the output of the transformer right before the data goes into the writer.

M
Badge +2

@svante9​ Check the output of the FeatureMerger to make sure your attributes are being merged correctly using feature caching as @Hans van der Maarel​ suggests. You might need to change the Attribute Accumulation.

svante9
Rank
Badge +1

Hi.

Thanks for suggestions on my problem. I have now done as you say to check what comes out after FeatureMerger by using feature caching. I get information in my two columns "object type" and "andamal!". I get the information with me all the way to the writer, as after I have run the writer, there is no information left in the fields/columns "object type" and "andamal1". I have looked that the data type is the same to the sde database that I am writing to.

image

redgeographics
Rank
Userlevel 4
Badge +25

Hi.

Thanks for suggestions on my problem. I have now done as you say to check what comes out after FeatureMerger by using feature caching. I get information in my two columns "object type" and "andamal!". I get the information with me all the way to the writer, as after I have run the writer, there is no information left in the fields/columns "object type" and "andamal1". I have looked that the data type is the same to the sde database that I am writing to.

image

Could you inspect the Merged output (assuming that that is what you are writing)?

svante9
Rank
Badge +1

Could you inspect the Merged output (assuming that that is what you are writing)?

That is absolutely right. It is the merged information that I want to output to an sde database. The strange thing is that when I review what has been sent out from the writer, the information is gone, sends a picture of it as well.

 

Picture of merged information:

image.png 

 

Picture of information from writer:

image 

 

M
Badge +2

Could you inspect the Merged output (assuming that that is what you are writing)?

@svante9​ The names are different - so I suspect that you have more than one connection to the Geodb Feature Type and that is why the input looks like it is mapped. Make sure you are renaming the attribute correctly on the output from the Merged port

svante9
Rank
Badge +1

Could you inspect the Merged output (assuming that that is what you are writing)?

I found an error that the column name was in lower case but in the layer that is in the sde database the column name was in upper case.

I have added a transformer "Attributerenamer" and there changed from lowercase to uppercase. The result after running the transforer "Attributenamer" was that the columns "Andamal" and "Object type" start with a capital letter, which is the same as for the layer in the sde database, and that there is data in each column.

image.png 

In the writer, the two columns are the same as last transfer "Attributerenamer" and the same as the layer in the sde database, but still I don't get any data in the two columns "Object type" and "Andamal", see picture below:

image.pngAnd in sde-database it looks like the image below:

image 

ebygomm
Rank
Userlevel 1
Badge +10

Could you inspect the Merged output (assuming that that is what you are writing)?

You say you used an attribute renamer to convert to uppercase? (In your screenshot you cannot see this as the attributes aren't shown in the attribute renamer), but you don't require uppercase you need titlecase

Reply


Community Stats

28,658
Posts
109,306
Replies
36,529
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.