Stewart Murray |
Newbie |
|
United Kingdom |
|
|
None Specified |
|
Friday, August 7, 2020 |
Thursday, May 12, 2022 11:00:43 AM |
4 [0.02% of all post / 0.00 posts per day] |
|
Hi,
I haven't taken it to Altova support as yet.
I have attached the file and flextext as it currently stands
|
Probably a straight forward solution to this but any help would be appreciated.
The file below is a fixed length text file that represents items stored in specific locations - in this case 19 items split across 9 locations. The number of items, locations and items per location is variable but I need to be able to split out each individual item and identify it's location. So for line 1 for example I would expect three files each containing the unique item number (FTAU1274562, PSSU0037356, PSSU0035590) and the location "640340".
|
Thanks for this K101
The batch number field within the csv file could be any value so I think it would need to split out based on the value of the line number? i.e. generate the additional sections only when the line number is the same value as the previous line?
|
Hi,
Hopefully someone can help, any guidance would be greatly appreciated
I'm mapping a csv extract to XML for an order confirmation routine and hitting a brick wall for line number information. I'm likely missing something simple though!
I need to be able to recognise when a line number from the csv is not unique and map additional information for that line
The csv comes our with one line per line of despatch -
10,SKU,Description,Qty,BatchNo 20,SKU,Description,Qty,BatchNo 30,SKU,Description,Qty,BatchNo
However if there is a split batch number, it will repeat the line number -
10,SKU,Description,Qty,BatchNo1 10,SKU,Description,Qty,BatchNo2 20,SKU,Description,Qty,BatchNo 30,SKU,Description,Qty,BatchNo
There could be any number of lines on an order and any number of repetitions of those line numbers depending on the stock picked.
The XML requires a unique line (POSNR) for each product line, and where there is a split batch number, add another section with the split details -
<E1EDL24> <POSNR>10</POSNR> <MATNR>SKU</MATNR> <LFIMG>Qty</LFIMG> <HIPOS>0</HIPOS> </E1EDL24> <E1EDL24> <POSNR>900001</POSNR> <MATNR>SKU</MATNR> <CHARG>Batch No1</CHARG> <LFIMG>36</LFIMG> <HIPOS>10</HIPOS> </E1EDL24> <E1EDL24> <POSNR>900002</POSNR> <MATNR>SKU</MATNR> <CHARG>Batch No2</CHARG> <LFIMG>36</LFIMG> <HIPOS>10</HIPOS> </E1EDL24> <E1EDL24> <POSNR>20</POSNR> <MATNR>SKU</MATNR> <CHARG>Batch No</CHARG> <LFIMG>72</LFIMG> <HIPOS>0</HIPOS> </E1EDL24> <E1EDL24> <POSNR>30</POSNR> <MATNR>SKU</MATNR> <CHARG>Batch No</CHARG> <LFIMG>72</LFIMG> <HIPOS>0</HIPOS> </E1EDL24>
|
|