IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Profile: Stewart Murray
About
User Name: Stewart Murray
Forum Rank: Newbie
Real Name:
Location United Kingdom
Occupation:
Interests:
Gender: None Specified
Statistics
Joined: Friday, August 7, 2020
Last Visit: Thursday, May 12, 2022 11:00:43 AM
Number of Posts: 4
[0.02% of all post / 0.00 posts per day]
Avatar
Last 10 Posts
Topic: Structuring FLF file
Posted: Thursday, May 12, 2022 10:59:52 AM
Hi,

I haven't taken it to Altova support as yet.

I have attached the file and flextext as it currently stands
Topic: Structuring FLF file
Posted: Thursday, May 12, 2022 6:10:25 AM
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".

Topic: CSV to XML
Posted: Wednesday, August 12, 2020 7:51:33 AM
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?
Topic: CSV to XML
Posted: Friday, August 7, 2020 8:52:14 AM
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>

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.