Thanks Georg. I am looking at a _huge_ table of entities, 900+ references to "Geo". I need to narrow it down but I don't really know what I am looking for.
I found this: On Mon, 26 Oct 2020 at 13:57, Dominic Amann <dominic.am...@gmail.com> wrote: > I can confirm that values were loaded from the relevant xml file for my > country. > > Beginning import from URL: > file:/var/www/apache-ofbiz-17.12.04/framework/common > /data/GeoData_CA.xml > 2020-10-26 17:27:43,384 |main |EntitySaxReader > |I| > Transaction Timeout set to 2 hours (7200 seconds) > 2020-10-26 17:27:43,424 |main |EntitySaxReader > |I| > Finished 26 values from > file:/var/www/apache-ofbiz-17.12.04/framework/common/da > ta/GeoData_CA.xml > > On Mon, 26 Oct 2020 at 13:25, Dominic Amann <dominic.am...@gmail.com> > wrote: > >> Yes, the data is there (in XML). I guess I need to go poking around in >> the database to find out if it got into there during setup? Or >> perhaps check the pages of output during the "./gradlew loadAll " step... >> I'll do the latter first. >> >> On Mon, 26 Oct 2020 at 13:11, Jason RJ <jason_of...@reast.net> wrote: >> >>> Hi Dominic, >>> >>> Province data and similar locality data is part of the seed data and >>> loaded from the /framework/common/data/Geo*.xml files you should be able >>> to spot that being loaded in your initial setup log output. It's been a >>> while since I've spun up a clean instance, but the data is certainly >>> there so it's just not being loaded for some reason. >>> >>> Hope that helps, >>> >>> Jason >>> >>> >>> On 26/10/2020 16:55, Dominic Amann wrote: >>> > I am attempting to setup OFBiz for my business. >>> > >>> > I am a Linux developer of many years experience. >>> > >>> > I wanted a secure (SSL) setup, and I thought I would use Mariadb as I >>> > already use that for other software, and I would avoid duplication with >>> > another database. I stretched this further by wanting to have no demo >>> data. >>> > >>> > I found it very difficult to accomplish all this. Much more difficult >>> than >>> > I might have expected for a major apache project. However, I >>> persevered, >>> > and after a whole weekend of work, I got it working to a first order. I >>> > have documented each step I took. >>> > >>> > HOWEVER: >>> > >>> > I CANNOT ADD A PARTY MAILING ADDRESS. There are no provinces listed for >>> > Canada. There are no states listed for the USA. I don't know other >>> > countries intimately, so I can't speak for them. As a result of being >>> > incomplete, I cannot add addresses at all. >>> > >>> > I initially thought this must be because I did not use the demo data. >>> So, I >>> > repeated my work, but left the demo data in place. SAME PROBLEM. >>> > >>> > Then I thought that perhaps I should do the migration (to Mysql) AFTER >>> > setting up the initial data. That was BROKEN and wouldn't complete on >>> > import, and the resulting website wouldn't display properly. >>> > >>> > Then I thought it might be the database - perhaps it doesn't work with >>> > mysql. I would just do the straightforward install, and work with that. >>> > SAME PROBLEM. >>> > >>> > So here we are: 3 full days and I can't enter my first employee, even >>> with >>> > the simplest install with default settings. Of course there is one >>> > fundamental lesson here: never just believe that something works just >>> > because it is from a reputable project that has been out there for >>> years. I >>> > should have known better. >>> > >>> >> >> >> -- >> >> >> Dominic Amann >> >> M 416-270-4587 >> > > > -- > > > Dominic Amann > > M 416-270-4587 > -- Dominic Amann M 416-270-4587