Here is the demo "Company" in display - note that it is in CA (california state).
And here when I click Update, the State field is empty, and I cannot select a state. On Mon, 26 Oct 2020 at 14:21, Dominic Amann <dominic.am...@gmail.com> wrote: > 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 > -- Dominic Amann M 416-270-4587