Data Export Vantage 6.1 (Memo) Field

Epicor ERP 10
1

Looking for a way to export the Mfg Comments field from Bill of Materials table in Vantage 6.1 (Progress DB 9.1). This is the only Memo field that I can not get the contents from and is most likely due to one of the following

I had a similar issue with the purchase order memo field in the PO Detail table and was able to sort thru the 250 open PO’s one at a time until I found the offending records. I seemed to be related to one of the following;
Users copy and paste from Outlook or other
Line feed / carriage return

I have used Access, Crystal and Report Builder to try and extract this field and only RB was able to get a partial the others errors out with an ODBC Progress Driver has value exceeding its max length or precision. Any suggestion for how to find the offending entry or entries and remove them so the rest of the data can be extracted and moved to E10?

Thanks,

2

With a database dump and load kit. Just dump it and look the the txt.

Patrick Winter

3
  1. Request legacy KB 13116MPS on how to address the “exceeding max length or precision” error so you can access the data via ODBC.
  2. Complete an ASCII dump and load (only the dump phase). Epicor Support doesn’t actually have a 6.1 ASCII dump and load kit, only BINARY, so I am not sure that an ASCII would be possible with the 6.1 version of OpenEdge–it was before my time. You could request the 8.00 ASCII dump and load kit from Support and try it.
4

Nathan,
Thank you, I will get with support tonight.

5

You can use the attached progress program (as a template) and it will not only export the fields you need but also convert carriage returns and line feeds with ~ so when you open in Textpad or Notepad++, you can convert back to CR and LF and maintain the same layout. art-work-3.p (1.2 KB)

6

Matt,
Thanks. Although it didn’t completely solve the issue it got me going in the direction to get the data out.
I went back to my BAQ and reduced it down to only the key fields and the problem comments field.
PartNum, PartRev, MtlPartNum, MtlSeq, MfgComments
I was then able to export everything to a csv file and import that into an access database to further refine the records. The key was putting the MfgComments as the last field so it could grow as needed and not break with the CR/LF imbedded characters. After that I built a query with all the fields and added a 6th calculated field after the MfgComments field with custom text that would not appear in any comments anywhere (LastField: “ZZ-EOL”) and exported to csv.

Then it was a 3 step process in Notpad ++
Make sure Search mode is Extended
Open the file and do a find and replace \r\n with ~~
Find and replace ,“ZZ-EOL”~~ with \r\n Make sure to include the leading comma
Find and replace ~~ with (Space or nothing depending on your data)
Save the file

Merge the new edited comments with the existing BOM export and DMT into Epicor.