Hi everybody, I have created a Dataport which runs every hour to create a *.txt file which is picked up by a mysql database. So far so good. In the Dataport I have one table (artikle) where I have selected the relevant fields. I want now add a second table (images) an will also select a few fields. Everything works fine BUT the data of the second file is places UNDER the data of the first one. I want to have them all in the same row => Partno. - Desc. - price - image… Is there somebody who can send the changes in the dataport ?? I thing this needs to be programmed and I have no idea to do thi in Navision [?][:(] Thank you all in advance Michael
Hello Michael, please check the property DataItemSeparator in your dataport. If you select all fields will be stored in the file without separation. Check the C/SIDE-Help for more informations. Andreas
Select your images table as the second data item and then use the Line as a separator …