on 05-06-2016 8:12 AM
Hello All
Im trying to get IBIP to work, but im missing template files both the flatfiles and if theres is someone who has a Excell template that would be very helpfull.
Examples of creating FLOCS and EQ's are also very welcome!
Kind regards
Christian
Hi Christian,
You can refer IBIP structure and prepare excel tempalte files yourself. It wont take much time.
If you need ready templates, please drop an email. You can get my email ID from my profile information.
Regards,
Amol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello all again.
I now got IBIP to work, but i get warning message: "superior functional location goes against the generic name or structure" If I look in the help settings it says that i can ignore this but pressing continue - BUT Where is the Continue? I have tryed everythiong. Any body?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm afraid I don't, and I've never used this IBIP Excel tool either.
As suggested above you can easily create a template, take the IBIP structure for the object, in the top row show the field name and the row below show the field length. This will help you understand the field widths. When creating data through IBIP you need to ensure you have the next field starting at the correct position as the file you prepare has to be a FIXED WIDTH file.
MS Access is perhaps a better option to prepare the file for IBIP load. From Excel to flat file you will lose the extra spaces between two fields but MS Access will maintain the actual field widths hence, your data will load in to the correct fields as the text file will be fixed width. To achieve the same in Excel you can perhaps look for a Excel macro that creates a fixed width file, i.e. after each field it pads it out with extra spaces.
cheers,
K
User | Count |
---|---|
100 | |
11 | |
11 | |
6 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.