Question about Old Import/Export module

E-mail notifications

Dmitrij Jazel

Posted on 25/02/2013 09:29:02

Hej Guys,

I wanted to ask if there is any documentation, or good resources on old Import/Export module.

By meaning "old" I mean DW 7 Portal - 19.2.2.1 - Custom

And/Or maybe someone could tell how can I achieve this:

I have an XML file, and I have a custom table (table I made myself).

XML contains elements - each element has 3-5 sub elements. Simmilar to Parent-Child relation.

The SQL table contains the list relations between father and child.

each father and each child has a unique ID so basically the table looks something like this:

ParentID ChildID

P1 - C1

P1 - C2

P1 - C3

P2 - C6

P2 - C7

etc...

Eventually I can create scheduled task to call it and perform the import.

So all I need is to figure out the import process and make sure ParentID attribute or parent node will end up ParentID column in relation table.

Thanks alot for help.

Regards,

Dmitrij

Replies

Morten Snedker

Posted on 25/02/2013 09:40:20

Hi Dmitrij,

No, to both the documentation part and the "good ressources" part.

If you have the visual studio templates available at Developer, you may use that as a shell for creating your own import. For simplicity you may just perform you entire operation at the Open() section.

Best regards
Morten Snedker

Dmitrij Jazel

Posted on 25/02/2013 09:50:26

Hej Morten,

Thanks for quick reply :-)

Well, to my regret, I can see that this import/export module is already setup - and the problem is that I need to fix it somehow...

How you told (if I correctly understood) is that I must use my own custom module to connect to db, go through xml file and feed the whole thing to the database.Open(), right? in other words - just make a manual database insert.

I thought about this option, but that would be the last option.

Or if I am missing something could you somehow share some example files maybe? please? :-)

Regards,

Dmitrij

Morten Bengtson

Posted on 25/02/2013 18:58:12

This post has been marked as an answer

The Import/Export is neither flexible nor reliable. It's dead to me. I highly recommend that you ditch that old module and have a dance with the new and sexy Data Integration module instead.

With Import/Export you only have a small set of destinations that you can choose from and therefore you often end up developing your own custom import activities. You might as well implement an import in a separate .aspx page or notification subscriber, because there is very little benefit in using Import/Export.

With Data Integration you have many more options to choose from and you can achieve much more through configuration alone - no development needed. Imports based on standard activities from Import/Export should be fairly easy to migrate to Data Integration.

Whatever road you choose... good luck ;)

Votes for this answer: 1

Dmitrij Jazel

Posted on 26/02/2013 08:21:03

Hello Morten,

I totally agree about Import/Export module beying dead, and new Data Integration module is much better - no doubts about that...

But as I said, I am working with DW 7 Portal - 19.2.2.1 - Custom here...

now I am quite sure what I must do... just gonna do my own import activities :-)

Thanks for help so far,

kind regards,

Dmitrij

You must be logged in to post in the forum

Developer forum

Question about Old Import/Export module

Replies