I have an application written in Visual Basic 6. There is an option to create a comma separated files for sales invoices that can then be imported into Sage (File, Import, Transactions). I want the ability to be able to write the data directly in to Sage without exporting and then importing.
I am looking for a solution, with source code, created in Visual Basic 6 (though I will consider other platforms) that I can integrate with my application.
Details for connecting to the Sage data set would need to be read from a text / ini file.
A sample .csv file is provided. Each transaction is listed on a separate line with the following format:
SI,,,0,,,,,,
Here is a small sample of data:
SI,CH,4000,0,28/04/2006,148,8 Ton DD 13/03/2006 41 HOUNDSFIELD ROAD herringthorpe ROTHERHAM,110,T1,19.25
SI,HABBIN,4000,0,28/04/2006,149,8 Ton 16/03/2006 CLIFTON CRES NORTH CLIFON ROTHERHAM,110,T1,19.25
SI,WIC,4000,0,28/04/2006,150,16 Ton 14/03/2006 WICKERSLEY SCHOOL BAWTRY ROAD WICKERSLEY,136.17,T1,23.83
SI,OUTRAM,4000,0,28/04/2006,151,8 Ton 23/03/2006 13 BELVEDERE PARADE BRAMLEY ROTHERHAM,110,T1,19.25
Only developers with experience of Sage development need bid; all other bids will be ignored.