We had very large PartOpr comments entered in our Vantage 6.1 progress db. We migrated the data out using ODBC and imported into E10 using DMT. Thought we were golden. On closer inspection after going live we’ve discovered that the comments aren’t complete. They are cut off. Using ODBC and even BAQ in Vantage cuts off the comments. I can create a Progress Report Builder report and display all the comments as a text file but the carriage returns in the comments cause line breaks in the “data” fields so it can’t be imported correctly using DMT.
Perhaps I’ve been looking at this too long but was hoping a fresh set of eyes could think of an idea on how to get the large comment fields out of the Progress DB and into the E10 db using DMT.
We converted a customer recently from 6.1 to E10 and had the same problem with Excel truncating comments. So we had to write a Progress program, just like you indicated. Now if I could remember my exact steps AFTER exporting the data, then I’d be doing good. If I recall, it required me to replace ~ with comma or something like that, and then the carriage returns and line feeds worked. See attached program as a reference.art-work-3.p (1.2 KB)
Another issue I had run in to was the width of the field in the Progress db. I ended up using DBTOOL to increase the SQL width of the fields (ran it against the entire db) and that resolved the problems with my ODBC queries. After that I was able to upload the comments and they came over completely. I was hoping I wouldn’t have to resort to a Progress program…it’s been years since I had done anything with that…but that was my next step if DBTOOL didn’t resolve it for me.