This portal is to open public enhancement requests against the products and services belonging to IBM Sustainability Software. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).
We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,
Post an idea.
Get feedback from the IBM team and other customers to refine your idea.
Follow the idea through the IBM Ideas process.
Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.
IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.
ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.
See this idea on ideas.ibm.com
Currently, the flat file custom connector requires a unique identifier to work correctly. Unfortunately, we can't ensure vendors will input a unique identifier in the file and creating one manually defeats the purpose of having a connector in the first place.
Flat file connectors should be enhanced and not require a unique identifier for each record going forward.
Idea priority | Medium |
Needed By | Month |
By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.
It seems I can't share files. An example would be for our railway data when, sometimes, multiple users get on the same train (same origin and destination at the same time) which caused a major issue.
Happy to share the sample file if there is a path? Perhaps through email?
Hi Daniel,
The flat file format was designed specifically to handle multiple account styles/data types, with multiple fields. To support this type of complexity the account style fields for each unique record had to be structured vertically down the page.
Due to this, a single record might be presented across multiple rows. The process uses a combination of the following fields to determine a unique record, where they are the same over multiple rows the account style field labels/values are loaded as a single record. If one of these fields changes, that triggers a new record to be identified.
Location
Location Reference
Account Style Link
Account Number
Record Start YYYY-MM-DD
Record End YYYY-MM-DD
Record Invoice Number
I would expect if a supplier is sharing data, the Location, Account Number and Record period would still offer uniqueness even if you do not have a distinct invoice number.
Can you please clarify further with a specific example of what kind of data or records you are loading to assist if needed?
There are other account loading processes that structure the data horizontally which may serve better for your purpose, however these are more restrictive in regards to the number of fields supported per account style, or the number of account styles.