How to import bank statements from dbase (.dbf) files in SAP B1

[dirkverheijke]

Our company gets bank statements in dbase (.dbf) files. We have to implement a solution to import these files in SAP B1. How can we do this?

Possible solutions I've in mind are:

* By making use of the SAP B1 Integration Framework.
* Writing a external application that reads the dbase files and create the bank statements in SAP B1 via the DI API.

I've searched already a couple of hours for a possible solution but does not find a topic that describes how to do it.

Who can give me some advise how to implement it?

Thanks in advance,

Dirk.

[Johan_H]

Hi Dirk,

Please also consider that your bank statements come from your bank, and that they would likely be happy to provide the data in a more common format like xml, csv or flat file. B1if should be able to read those format files.

I suspect your previous ERP system's database system was dbase, and that therefore you received files in that format. Are you using an operator (middle man) to transfer the files from your bank to you? If so, it is even likely that they are transforming the files from the bank into the dbase format. And if so, you can ask them to send the files without the transformation.

Regards,

Johan

[dirkverheijke]

Dear Johan,

Sorry for my slow respons but this is a project I'm working on when I've some spare time.

We get the files from a Russian bank and we tried already in the past to get the files in another format but without succes.

Our previous ERP system uses Access and SQL server databases, no dbase database.

As suggested by Huan, I tried to link the dbase file to SQL server but then I've a problem with some text fields that contain Cyrillic characters. The dbase file we receive from the bank does not contain the correct Language Driver Id.
I don't know yet how to solve this problem.

Anyhow, thanks for your help.

Regards,

Dirk.

[HuanYang]

Hello Dirk,

B1if doesn't support the direct connection to database file(.dbf) files.

You may attach your database file into a database system, and then to see how to connect this system.

Thanks

Huan

[dirkverheijke]

Hello Huan,

Thanks for the fast respons.

That is a pity, but your proposal to link the dbase file to the database seems promising.

I will let you know if it works.

Thanks,

Dirk.

[dirkverheijke]

Hello Huan,

Sorry that I did not replied earlier but I was busy with other tasks and the reading of the dbase files has landed in the background.

In our previous ERP system (.Net), the dbase file was accessed by means of the Visual FoxPro OLE DB Provider. The connection string looks like: "Provider=VFPOLEDB.1;Data Source=<file location>".

With a query, we could read the records from the file.

Can I implement something similar with the B1i?

Have a nice day.

Dirk.

[HuanYang]

Hello Dirk,

I'm not familiar with dbase (.dbf) files.

Could you please introduce how other application/language read data from such files?

i.e. how Java read *.dbf file

Thanks

Huan

[HuanYang]

Hello Dirk,

May I know the issue details?

You don't know how to use B1i to call DI API, or cannot find exact DI API?

Thanks

Huan

[dirkverheijke]

Hello Huan,

I've already developed a working scenario in B1i with the use of the DI API.

My question is related to the dbase (.dbf) files.
What are the possibilities in SAP B1 to read data from such files?

Thanks

Dirk.