I have portal that uses 3.x version of DNN and runs 4.3 version of XMOD,

Since upgrade to 5.x impossible due to critical and major bugs, i decided to implement the content to new 5.1.4 installation manually.

So far, i added articles to News Articles module.

Now i have some listings in XMOD, and want to transfer them and present them with Property Agent (which i know better and gets updated regularly)

I think i will need SQL queries a lot, i will also need a template.

Can someone with XMod experience take a look at portal with me and recommend what to do?

I can meet you via TeamViewer, or Windows Meeting Space. Please let me know, thanks.

I jut finished doing a similar task but I did not move from XMod, I moved data from a single table into PA.  I did this by writing a whole bunch of SQL in SQL Server Management Studio. It may have been a clunky way to do it, but I was working with the skills that I have.

Here is how I would do it (right or wrong):

1) Export your XMOD data into a single table.  I usually do this by making an Xmod template that is a simple HTML table with one Xmod field per column.  Run your template, copy and paste the table into Excel and import the new excel table into your SQL Server.

2) Create all you custom fields in Property Agent including and XmodID

3) Export all the rows to the PropertyAgent_Properties table making sure you are putting the XmodID into one of the fields so that you can make a relationship.

4) Find out your Custom Field IDs from the Property Agent table

5) Write a sql statement that will add all the records of one field into the Property Agent Data table

6) Repeat that sql statement adjusting the field names until you run out of fields.

7) now you have your data, it is time to make nice templates.

This being said, there is a module available on SnowCovered  that will import records into PA that could save you oodles of time, but I never tried it.

If this interests you, I think I have my sql statements someplace.