Import Suppliers

In the mKsiegowa.pl program, you can import supplier data from CSV text files. You can prepare such files with the use of e.g. Excel. 
 

How to Import

You can import suppliers in the module Purchases. You need to provide the location of the text file containing suppliers data.

 

File format

The files should be prepared according to the following rules:

  • all numbers are in PLN
  • dates given in YYYY-MM-DD format
  • if the supplier isn't found in the supplier's file, he will be added to the file on the basis of data imported from the file. During data import, the program will search for him according to his number from the first column. 
  • fields must be separated by ;
  • text fields must be enclosed in apostrophes or quotation marks; you can select it on the import screen
  • blank lines are skipped
  • in the field Supplier Short Name, there is the supplier number

File format

No. Field Name Field Type Comments
1 numer dostawcy int(11) max. 11-digit unique supplier number
2 nazwa_dostawcy varchar(100) Supplier name. Used when the supplier wasn't previously on the file.
3 adres - nazwa miejscowości varchar(60) The first line of the supplier's address.
4 adres - kod pocztowy varchar(10) The second line of the supplier's address.
5 adres - ulica varchar(60) The third line of the supplier address.
6 Kod kraju varchar(2) The program sets the correct tax scheme, based on the country code: PL, European Union, and non-EU country
7 nie używane varchar(10) additional field
8 NIP varchar(25) Supplier's GST No. Used to identify the supplier.
9 nie używane varchar(10) additional field
10 nie używane varchar(10) additional field
11 nie używane varchar(10) additional field
12 nie używane varchar(10) additional field
13 nie używane varchar(10) additional field
 

Import files

After clicking Read file the program first checks if the file is correct and displays its contents on the screen.

The following messages appear in the right column:

  • information whether the supplier was found in the supplier file
  • information whether the supplier's data is correct

After clicking Data import the supplier data will be loaded.

 

Example of a file

Example of a supplier file:

Vendor;Name 1;City;PostalCode;Street;Ctry;;VAT Registration No.;;;;;
232;Przykładowa firma;Warszawa;00-113;ul. Emilli Plater 1;PL;;PL1234567890;;;;;