# Problem :convert to Values **URL:** \ **Category:** Forum\ **Tags:** EDI\ **Created:** [October 28, 2006, 11:57pm UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114 "2006-10-28T23:57:46Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\ **Post date:** [October 28, 2006, 11:57pm UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114/1 "2006-10-28T23:57:46Z")
Hi Friends, I am having a problem when converting the EDI to Flatfile as ConverToValues. The process is EnvelopProcess Loopover ISA loopover GS loopover ST getEDIString ConvertTovalues the problem is i am not able to fetch the first record after ST(ex:BEG or BCH). The version i am using is 6.5. When i try to execute the sample package which i create in 6.5 in 6.1 version. I am getting the result properly i.e i am able to fetch the first record. The problem is only when i am working in 6.5. Data and the mapping is right as it is being successfully executed in the 6.1 version. Can any one tell me where the problem is ? Thanks in Advance NaveenKumar ---
**Author:** ![spg](https://avatars.discourse-cdn.com/v4/letter/s/9dc877/32.png) [@spg](https://techcommunity.softwareag.com/u/spg)\ **Post date:** [November 1, 2006, 10:29pm UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114/2 "2006-11-01T22:29:42Z")
Naveen, Can you check if the required schemas are present in your 6.5 version. I think you should be looking for “wm.b2b.edi.EDIFFSchema:ICS4X12”. Shubhro ---
**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\ **Post date:** [November 5, 2006, 5:35pm UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114/3 "2006-11-05T17:35:51Z")
Hi Friends, I found out the problem is because the properties of the EDI doc field is set as Exponential. Is there any chance of changing the properties of the EDI document fields. Thanks Naveen ---
**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\ **Post date:** [November 5, 2006, 5:47pm UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114/4 "2006-11-05T17:47:39Z")
Hi spg, I have created schema using SEFParse service. While getting EDIString, it is showing the ST and BEG in the first line seperated by \n and the rest of records line by line. I am surprised why it is showing like that. Thanks, Naveen ---
**Author:** ![gupta\_r.17495](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gupta\_r.17495](https://techcommunity.softwareag.com/u/gupta_r.17495)\ **Post date:** [November 5, 2006, 10:37pm UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114/5 "2006-11-05T22:37:02Z")
Naveen, If you remember as discussed earlier its a delimiter issue in your edi file and if you correct it or tell your source team to send valid edidata with proper delimiters in the Envelope,ST level data to success in parsing the document.Are you still facing problems in 850/860 docs?? HTH, RMG ---
**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\ **Post date:** [November 6, 2006, 2:24pm UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114/6 "2006-11-06T14:24:55Z")
Hi RMG, Yes still i am getting the same problem (missing the first record). What exactly i have to ask my source team to change in the data. If u remembet the edi document which u have sent (on which u have made the changes ), getting the same problem with that also. But the same package is working fine in 6.1 version, If the problem is in the data, how can it works in this version. Previously i was using 6.1 version EDI module with 6.5 webMethods version. But as per u suggestion i have updated my EDI module to 6.5 also but still i am getting the same problem… Thanks, Naveen ---
**Author:** ![gupta\_r.17495](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gupta\_r.17495](https://techcommunity.softwareag.com/u/gupta_r.17495)\ **Post date:** [November 6, 2006, 7:54pm UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114/7 "2006-11-06T19:54:39Z")
The document which i have made changes is working perfectly and see my previous mails for changes,after i updated BEG datetime field and newline segment delimiter before end of ST.Ask your source team to send segment/record delimiters correctly.It should work for any wM IS/EDIversion HTH, RMG ---
**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\ **Post date:** [November 6, 2006, 8:38pm UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114/8 "2006-11-06T20:38:13Z")
Hi RMG, You said u have changed the newline segment delimeter at the end of ST. Can i know how to change so, i will try with other document from my side. One more thing , Can i change the properties of the Field in EDI documents. In MEA record the data is being stored in exponential format, can i turn it to normal numeric format.Do i have to make any changes for SEF file to do so. Thanks, Naveen ---
**Author:** ![gupta\_r.17495](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gupta\_r.17495](https://techcommunity.softwareag.com/u/gupta_r.17495)\ **Post date:** [November 6, 2006, 9:14pm UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114/9 "2006-11-06T21:14:45Z")
Basically the reason you are seeing the exponential format is Dictionary/Schema internally calls formatServices which are are stored in the WmEDI package.If you dont want to send exponential format then just remove the formatservice from the Dictionary in that particular MEA segment field.Save and retest it should work. HTH, RMG ---
**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\ **Post date:** [November 6, 2006, 9:25pm UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114/10 "2006-11-06T21:25:26Z")
Hi RMG, Once again same question, if there is a problem with the segment delimeter in the data , why it is working properly in 6.1 version. Thanks, Naveen ---
**Author:** ![reamon](https://avatars.discourse-cdn.com/v4/letter/r/b77776/32.png) [@reamon](https://techcommunity.softwareag.com/u/reamon)\ **Post date:** [November 7, 2006, 12:47am UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114/11 "2006-11-07T00:47:30Z")
You can modify the [IS]/packages/WmEDI/config/format.xml file to change the format string used. Exponential format isn’t “wrong” per se, just usually not expected and sometimes not handled correctly by some systems. ---
**Author:** ![gupta\_r.17495](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gupta\_r.17495](https://techcommunity.softwareag.com/u/gupta_r.17495)\ **Post date:** [November 7, 2006, 1:18am UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114/12 "2006-11-07T01:18:04Z")
What error are you getting in IS6.5 developer/logs? HTH, RMG ---
**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\ **Post date:** [November 10, 2006, 4:16pm UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114/13 "2006-11-10T16:16:42Z")
Hi Rmg, As i said earlier, It is not showing any error in the error log It is just missing the First reocrd after ST, in the Edivalues and showing the an error as bad data, and continuing from the next to Beg record. If u want i will send u printScreen for better understanding. Thanks, Naveen ---
**Author:** ![gupta\_r.17495](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gupta\_r.17495](https://techcommunity.softwareag.com/u/gupta_r.17495)\ **Post date:** [November 10, 2006, 7:20pm UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114/14 "2006-11-10T19:20:06Z")
Send me the screen shot…As i said if the file has correct delimiters and valid data and it is working in 6.1 it is supposed to work in 6.5 also. What is the exact error for the bad data??It would give u the errors list along with the Segment name in the pipeline results section. HTH, RMG ---
**Author:** ![Greatwhite](https://avatars.discourse-cdn.com/v4/letter/g/bbe5ce/32.png) [@Greatwhite](https://techcommunity.softwareag.com/u/Greatwhite)\ **Post date:** [April 5, 2007, 7:58am UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114/15 "2007-04-05T07:58:41Z")
hi all, 1. can somebody tell me how to find what different elemnts in various segments mean(refer to what type of data) to be able to map for eg from XMLpo to EDI… I m unable to find any resource that helps me i this… 2. how to create a IS doc type for the any segment in the segment mapping as shown in the webMethods samples? Thanks ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 2, 2021, 3:05pm UTC](https://techcommunity.softwareag.com/t/problem-convert-to-values/109114/16 "2021-04-02T15:05:32Z")