Recently we had an opportunity to develop an Excel add-in to carry out custom export of data regarding the employees salary payments into a CBI (Customer to Business Interaction) format. This is a standard for the text flat file data formatting implemented by banks for batch data loading. More information could be found on www.cbi-org.eu
Continue reading CBI (Customer to Business Interaction) Excel data export
As a new Android user, I had to manage my contact list in Gmail.
I would like to give you some instructions in order to import all Facebook phonebook contacts into your Gmail account in few steps.
Brad Fitzpatrick wrote a GreaseMonkey script that automatically detect your phonebook and merge it in Gmail contacts. Script could be found at http://bradfitz.com/greasemonkey/facebook_phonebook_export.user.js
These are the few actions required:
- Install GreaseMonkey plug in for Firefox and import (click on the link above) the script into your GreaseMonkey.
- Go into your Facebook account and open your Friends Phonebook page
- Open Firefox Tools menu and select GreaseMonkey -> User script commands -> Export Facebook Phonebook
- Follow the instructions on video
That’s it, is it simple?
Hope this could help you.
today we would like to present you our new small and handy solution in which we provided a functionality to export Excel data into a fixed column width file format. This means that all your data columns in the file will have a fixed length.
This is an Excel add-in which can become usefull for those who have to work with integrated legacy systems where the input data format should be (or was configured to be) in this fixed column width format. This was actually our case when we had to work with some legacy system which contained some dozens of transformation rules that worked with this data format. In order not to change the system that already worked we just created this handy tool to simplify data export. 🙂
So, how does it work?! As soon as you activate it in the Tools/Add-in menu, you will find YellowRiver menu item with Export to fixed width file submenu which in turn contains (by now) one button of data export. 😉
This add-in is also supplied by a custom function to be used in Excel cells. It is used to determine the maximal text length in the selected range of cells. The function is situated in the Export2File function category and has a name MaxWidth.
Continue reading NEW data export from Excel