I’m back! Such late! Apology again!
Last month, I was heavily engaged in providing couple WebEx demos on Format Definition – a new add-on tool released in 2007 A/B (I’m planning to write some blogs on this topic), just couldn’t get my hands on this blog, sorry for that!
To close this series of demo database revamping blogs (some people might be getting bored on this long-lasting topic), I enumerate some experience, tips&tricks, and lesson learnt on my using of DTW through the project.
1. To support double-bytes characters, save the Excels to Unicode *.txt format. If you’re dealing with data files containing content in language other than English, such as Japanese, it’s necessary to save it as Unicode *.txt format.
Hint is, DTW program user interface doesn’t support Unicode display, so if you try doing data preview, you probably be ended up with a number of “???????” strings. But that’s okay, as long as data files are imported into Business One, check the data content from client application, text display shall be fine since Business One supports Unicode by nature
2. DI API version check. DTW fundamentally relys on DI API. Once your Business One is upgraded to a new release or a patch level, always remember to upgrade the DI API as well. Because sometime, outdated DI API can cause DTW unable to connect to database.
3. Install SDK online help. You can always refer to SDK online help when you need to find out what a table/field is for, what valid values are allowed for certain fields.
5. Trouble shooting tips – have to say using DTW isn’t a work that you can sit back, sip your coffee and watch the progress bar goes to 100%. You need decent understanding of DTW templates; you need to know Business One database structures. Sometimes, the data files you prepared just won’t get through the importing process, and you need to do some trouble shootings! For instance, only import the first record of a number of Sales Deliveries, see if it goes smoothly.
6. Use the How-to Guide of DTW, which addresses many common questions on using DTW. If you don’t have it, just grab a copy from Channel Partner Portal->Business One->Solution Overview->Document Resource Center. Here’s the direct link for 2005 version.
7. Where to ask for help? Apparently, you can log support message or call SAP Support on DTW issues. Meanwhile, you can also check our SAP Business One Application, I kept seeing many DTW questioned were posted and answered. Searching SAP Notes on component SBO-DTW is recommended too.