Skip to main content

I hope someone can help me further here.

I have a simple json file. I'm using FME Quick translator to transform Json into access.mdb format. The translation goes fine, no errors come during the transformation. But data is missing from the result file.

Any help will be received with great thanks!

_____________________________________________________________________________________________

1. The parameters

_____________________________________________________________________________________________

2. The process of translation

FME API version of module 'MDB_ADO' matches current internal version (3.8 20190621)

Microsoft Access Writer: Opening `C:\\Users\\SBP\\Desktop\\privat\\1085805.accdb' for write operation

Microsoft Access Writer: Read 2 DEF line(s). Found 36 attribute(s)

Emptying factory pipeline

Microsoft Access Writer: Closing `C:\\Users\\SBP\\Desktop\\privat\\1085805.accdb' . Write operation complete

_____________________________________________________________________________________________

It is quite possible that the Quick Translator is unable to guess how to translate the JSON to Access, you may want to look at using the FME Workbench for this.

The reason could be that each JSON may contain lists of further objects, sometimes even nested several levels deep. In your input JSON you can see this in action e.g. when looking at the Descriptions tag, which contains a list of elements. These sub-elements end up a lists in FME, and it may not be obvious to the Quick Translator what to do with those, as Access does not support lists directly (you'll probably have to normalize them to several tables with foreign keys etc).


Tanks Davis - can see what you mean and have no doubt that you are right.

But my skills probably aren't enough to build an individual translator in the workbench. I will take a closer look at what I have to do from here.

Thanks for your reply!


Reply