Skip to Content
avatar image
Former Member

Import Heirarchies and Expansions through DTW

Is there a way to Import Hierarchies and Expansions Price Lists through the Data Transfer Workbench? Please let me know the best way to import these, I don't want to have to enter 2,000 manually.

Thanks,

Sarah

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 11, 2007 at 01:22 AM

    Sarah,

    As far as I know I do not think there is DTW template for this. I will check on any other possibilities and come back

    Suda

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 11, 2007 at 03:33 AM

    Hello,

    You could import price using item_prices template and for hierarchy, try to use special price templates. The table is ospp. Check the table using query analyzer : select * from ospp after you try manually first to define H & E, and if success (there have been data in ospp), then use special price template (I use this in DTW 2004A).

    Rgds,

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I am still having problems. I am loading all three files and the card code is set to *1. However the *1 comes up as "no matching record found". Any suggestions?

  • avatar image
    Former Member
    Oct 21, 2007 at 02:36 AM

    Hi sarah,

    I also need to import hierarchies into SBO. My first thoughts were the DTW but i was unable to find a way to import them, not even with the Special Prices Template. All the relevant data like Whs's and BP's are in the system already. I have finally given up on the DTW. Have you or any1 else comeup with a solution to this import requirement or have managed to import data into Hierarchies and Expansions?

    Thanks

    Add comment
    10|10000 characters needed characters exceeded