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.

Mapping FORTRAS BORD512 or similar flat file interfaces Options · View
voschl
Posted: Thursday, October 23, 2014 12:55:14 PM
Rank: Newbie

Joined: 5/2/2014
Posts: 3
Location: Germany
Did anybody try to map into/from the FORTRAS BORD512 interface? (perhaps not well known - it's an interface from the transportation/logistics world)

red colored text = record types
green colored text = counting up numbers corresponding to one consignment

@@PHBORD512 - only one time per file
A00 - only one time per file
B00001... - up to 2-5 times - start of first consignment
B00001...
B10001... - up to 9 times per B00
D00001... - up to 999 times
F00001... - up to 999 times per D00
F00001...
F00001...
G00001... - up to and so on
G99001...
H00001... - up to 4 times
H10001... - up to 9 times
B00002... - start of second consignment
B10002...
B10002...
B00002...
D00002...
F00002...
F00002...
G00002...
G99002...
H00002...
B00003... - next cons
B00003...
D00003...
F00003...
F00003...
G00003...
G99003...
H00003...
B00004... - next cons
B00004...
D00004...
F00004...
F00004...
G00004...
G99004...

Splitting of each record is not the problem. I have done it with FlexText, but how to deal afterwards with splitted records in MapForce? How is it possible to keep the data of one consignement in one data package?

In my trials there are no line breaks (only one after the first line). It's all in one big string. How can I create line breaks at the end of ervery record?

Thanks for your ideas. I hope you understand the description.
woltmann
Posted: Friday, December 5, 2014 8:50:37 PM
Rank: Newbie

Joined: 12/5/2014
Posts: 1
Location: Kassel
Hallo,

i need the same Format, do you have implement the BORD512 ?

jimsnowdon
Posted: Tuesday, October 15, 2019 10:34:41 AM
Rank: Newbie

Joined: 10/15/2019
Posts: 1
Location: UK
Hi,

A few years on from the post below I am facing the same issue. Has anyone managed to successfully map BORD512 ?
K101
Posted: Wednesday, October 16, 2019 7:27:23 AM
Rank: Advanced Member

Joined: 2/27/2009
Posts: 558
Altova doesn't offer any special FORTRAS support at this time, but it's likely possible to handle that format using either FlexText or some sort of recursive user-defined function which processes each letter and number combination into groups and sub-groups and sub-sub-groups and so on.
that
Posted: Wednesday, October 16, 2019 3:40:49 PM
Rank: Advanced Member

Joined: 6/16/2006
Posts: 486
Location: AT
It seems to be really hard to find specs for this format on the Internet (same as with many other EDI standards). But I guess some nesting of FlexText "Line starts with" blocks could do the job.
K101
Posted: Friday, October 18, 2019 8:26:54 AM
Rank: Advanced Member

Joined: 2/27/2009
Posts: 558
Hard to know exactly what you all need as output, but have a look at this demonstration, which tries to parse the file into consignments, then records grouped into type, subtype, and sub-subtype. The primary purposes is to parse structure into hierarchies.

At each level, we also write all the rows which are in that group, so you might see a row on both the type and subtype level (and the sub-subtype level as well, for that matter). You might be able to work further with this demonstration to get the exact results you want.

File Attachment(s):
example.png (292kb) downloaded 370 time(s).
example.zip (4kb) downloaded 136 time(s).


Users browsing this topic
guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

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