James Monroe
Active Member
We are on apps 9.0, tools 9.1.4.7.
We have a request to bring data in from a third party into our JDE system. This is for new vendors but the question here is pretty generic. We do many of these type of things and have a table conversion to bring in the data into the F0911Z or F0411Z depending on the requirement.
Typically we would have a file layout where the data is specified by position, or if its a comma delimited file then it can be mapped as needed in the JDE table conversion design aid.
The issue is that this third party is stating that the file we will be given will be comma delimited, and have multiple formats (Header, Address, Contact, etc). That is fine but they are stating that we actually need to read the headings to know what data is in any given element. For example, for Vendor Name, they cannot say that it will always be the sixth element in the Header type record. But we should read the headings, and if the heading 'Vendor Name' is the sixth element, then the vendor name will be the sixth element in the Header record. But it could be the fifth or seventh or whatever.
What I cannot see is how I can code this in JDE. The Table Conversion requires you to map the incoming fields but I don't see how I could do what they are asking, essentially not knowing what
Has anyone else had this requirement, to import a flat file with multiple formats and variable columns, where you have to look at the headings to determine what element a particular value is in. Any thoughts would be appreciated.
A sample file is attached also.
We have a request to bring data in from a third party into our JDE system. This is for new vendors but the question here is pretty generic. We do many of these type of things and have a table conversion to bring in the data into the F0911Z or F0411Z depending on the requirement.
Typically we would have a file layout where the data is specified by position, or if its a comma delimited file then it can be mapped as needed in the JDE table conversion design aid.
The issue is that this third party is stating that the file we will be given will be comma delimited, and have multiple formats (Header, Address, Contact, etc). That is fine but they are stating that we actually need to read the headings to know what data is in any given element. For example, for Vendor Name, they cannot say that it will always be the sixth element in the Header type record. But we should read the headings, and if the heading 'Vendor Name' is the sixth element, then the vendor name will be the sixth element in the Header record. But it could be the fifth or seventh or whatever.
What I cannot see is how I can code this in JDE. The Table Conversion requires you to map the incoming fields but I don't see how I could do what they are asking, essentially not knowing what
Has anyone else had this requirement, to import a flat file with multiple formats and variable columns, where you have to look at the headings to determine what element a particular value is in. Any thoughts would be appreciated.
A sample file is attached also.