This project I am working on requires the loading of almost 400,000 customers. We are doing these imports on small machines remotely so obviously speed is not a friend. I am running into a lot of problems and having run this procedure multiple times I have found tricks and tips that may help out to the world. Here is my list of what I have found
Continue reading
Just a quick finding that I just ran across. We have some columns that are of type “Search” and we store the values ( strings ) in them. When you run the GenerateModel() process, it creates the X classes as Integers no matter what. There is a class called FieldType and the isID() method returns true for search and table reference types. Guess I have to change my reference keys.
We have been under a hosted environment for quite some time now, but we have recently decided to go on our own and with that, we had to take a fresh copy of the Compiere 3.6.2 source code and do everything from scratch. I have been familiar with the source code so it was not a huge deal, but what was lurking in the unknown of a new set of source code and unsupported set up, so who knows how this thing would run. I am in the data load stage right now and ran into my first hurdle.
I have been using the Compiere web services since they first came out. They are based on the Amazon web services and provide a platform independent and secure way to access the Compiere system. I was forced to use them in my project because there were other parties developing against my clients new system and they needed a way to place orders, grab customer information, etc. The multi-channel aspect of this project meant the customer needed the web site, phone call center, and retail stores to access compiere in a unified way and of course each channel was being developed in Microsoft’s .Net platform so building on top of Compiere was not going to happen and the high powers ( at the time before being acquired by Consona ) made it very clear to my client that doing any direct access to Compiere was bad and it had to be done through the web services. That hurt. I was then forced to use these web services, that were soo buggy and feature thin that I just wanted to go away and cry. Of course the documentation was there to help me………..or not. I ended up having to work with the author of the web services to make the damn thing work with .Net ( I had no .Net experience when starting this project, so I was working with soo many new things my head was hating me ). After, what seemed like forever ( it was more like 6 months of back and forth and getting special builds of the web services and even got them to make views accessible through them ), I got it working. They seemed impressed and even asked if I could contribute my code to be available and I did give it up to them. It was a major task, but I have to report that I have designed a developed a whole phone call center in ASP.Net accessing Compiere through the web services and built the APIs to help the web site developers integrate Compiere into MediaChase’s G5 platform.