webERP Forum

Full Version: Data Import
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi,

Please has anyone imported large data from excel into weberp database before? If you have, please your help is needed.

We have decided to make a shift to Weberp but want to import our old data from excel sheets into weberp.

It will take "forever" if we had to do it manually.

Help is urgently required.


Thanks.
Hi Tim,

We simply have them in excel. I guess what is needed is for us to make them weberp database ready. if we have to get support, where can we get it and any ideas on price range costs?
Yes i got you, what i meant was we were not really using any system. Its simply entering daily transactions in a spreadsheet. Our data can be manipulated to fit weberp's structure. Something we have looks like this;

date, gl account number, amount, currency, description.

i think im clear now.

thanks for the prompt response. Appreciate it a lot.
ok.....but can you help fix this? any help please.
The data structure for debtortrans is what you are after I believe:

Code:
CREATE TABLE `debtortrans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transno` int(11) NOT NULL DEFAULT '0',
  `type` smallint(6) NOT NULL DEFAULT '0',
  `debtorno` varchar(10) NOT NULL DEFAULT '',
  `branchcode` varchar(10) NOT NULL DEFAULT '',
  `trandate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `inputdate` datetime NOT NULL,
  `prd` smallint(6) NOT NULL DEFAULT '0',
  `settled` tinyint(4) NOT NULL DEFAULT '0',
  `reference` varchar(20) NOT NULL DEFAULT '',
  `tpe` char(2) NOT NULL DEFAULT '',
  `order_` int(11) NOT NULL DEFAULT '0',
  `rate` double NOT NULL DEFAULT '0',
  `ovamount` double NOT NULL DEFAULT '0',
  `ovgst` double NOT NULL DEFAULT '0',
  `ovfreight` double NOT NULL DEFAULT '0',
  `ovdiscount` double NOT NULL DEFAULT '0',
  `diffonexch` double NOT NULL DEFAULT '0',
  `alloc` double NOT NULL DEFAULT '0',
  `invtext` text,
  `shipvia` int(11) NOT NULL DEFAULT '0',
  `edisent` tinyint(4) NOT NULL DEFAULT '0',
  `consignment` varchar(15) NOT NULL DEFAULT '',

If you have the transactions in this format then they are webERP ready
Thanks Phil,

But i assume that debtortrans handles customers, what about suppliers?

Thanks once again.
Thanks Tim. Did you mean you sent me a message? If you did, sorry i didnt get it.

It happens that we have already entered some data into weberp such as suppliers, clients, stock etc. Are these the base data you refer to as required before the import process can go ahead?

However, i just want us to get this thing done. Seriously, i don't see us entering data manually. Please, i really need your help.
The supptrans table is very similar to the debtortrans table:

Code:
`transno` int(11) NOT NULL DEFAULT '0',
  `type` smallint(6) NOT NULL DEFAULT '0',
  `supplierno` varchar(10) NOT NULL DEFAULT '',
  `suppreference` varchar(20) NOT NULL DEFAULT '',
  `trandate` date NOT NULL DEFAULT '0000-00-00',
  `duedate` date NOT NULL DEFAULT '0000-00-00',
  `inputdate` datetime NOT NULL,
  `settled` tinyint(4) NOT NULL DEFAULT '0',
  `rate` double NOT NULL DEFAULT '1',
  `ovamount` double NOT NULL DEFAULT '0',
  `ovgst` double NOT NULL DEFAULT '0',
  `diffonexch` double NOT NULL DEFAULT '0',
  `alloc` double NOT NULL DEFAULT '0',
  `transtext` text,
  `hold` tinyint(4) NOT NULL DEFAULT '0',

I agree with Tim though attempting to import transactions without a thorough understanding of the system - which I cannot explain without typing for a day - is a reciepe for trouble ... webERP is an integrated system and tables are updated all over the place when a transaction is entered.
Reference URL's