Re: [Dhis2-users] Analytics schedule

Jus to mention that the way we'll tackle this is to run analytics earlier on the tracker instance via the API and turn off the scheduled analytics run. Regards Ed From: Dhis2-users On Behalf Of Edward Robinson Sent: Monday, 05 November 2018 11:39 AM To: dhis2-users Subject: [Dhis2-users

[Dhis2-users] Ad blockers and DHIS2

Just a heads up to any users of uBlock Origin or other ad blockers, the "Easy List privacy" list by includes a blacklist entry for analytics.json as can be seen here: https://easylist.to/easylist/easyprivacy.txt This is included in uBlock Origin and may be included in others (Adblock, etc.).

Re: [Dhis2-users] Import/Export data between similar but distinct systems

yab...@gmail.com> Sent: Thursday, 05 April 2018 12:14 PM To: Edward Robinson <erobin...@projectbalance.com> Cc: Martin Van Aken <mar...@joyouscoding.com>; dhis2-users <dhis2-users@lists.launchpad.net> Subject: Re: [Dhis2-users] Import/Export data between similar but distinct

Re: [Dhis2-users] Import/Export data between similar but distinct systems

We’re currently working on something for this – a desktop app that runs on Windows / Mac / Linux that allows you to specify some parameters to ‘map’ from one side to the other and a shell app that runs on a Linux box and reads the config file created by the desktop app once a day to transfer

Re: [Dhis2-users] Indicator based on previous year's output

lohang <moekets...@yahoo.com> Cc: Edward Robinson <erobin...@projectbalance.com>; DHIS Users <dhis2-users@lists.launchpad.net> Subject: Re: [Dhis2-users] Indicator based on previous year's output Hi Edward, 1. You might consider using predictors. Define additional data element

Re: [Dhis2-users] Indicator based on previous year's output

initial mail, Regards Ed From: Tlohang <moekets...@yahoo.com> Sent: Wednesday, 28 March 2018 7:18 PM To: Edward Robinson <erobin...@projectbalance.com> Cc: DHIS Users <dhis2-users@lists.launchpad.net> Subject: Re: [Dhis2-users] Indicator based on previous year's output Hi Edward

Re: [Dhis2-users] Indicator based on previous year's output

nce@lists.launchpad.net> On Behalf Of Edward Robinson Sent: Wednesday, 28 March 2018 5:35 PM To: DHIS Users <dhis2-users@lists.launchpad.net> Subject: [Dhis2-users] Indicator based on previous year's output What's the best approach to creating an indicator that's based on a cumul

[Dhis2-users] Indicator based on previous year's output

What's the best approach to creating an indicator that's based on a cumulative total of a data element captured monthly, for a set timeframe? E.g. I have an indicator called "Number of patients" captured monthly. I need an indicator that will give me the total number of patients for the set

[Dhis2-users] Organisational unit by level via API

Is there a nice clean way of displaying organisational units by level using the API? Thanks in advance! ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users

Re: [Dhis2-users] HOW TO CREATE PROGRAM INDICATOR IN DHIS2 2.27 TO 2.28

Hi Stanley, have you looked at this? https://docs.dhis2.org/2.27/en/user/html/configure_program_indicator.html#create_program_indicator In version 2.27 and above It’s moved to Maintenance -> Indicator -> Program Indicator Regards Ed From: Dhis2-users

[Dhis2-users] Program Indicator values / Indicator values with API

Is there any way to view program indicator values or indicator values using the API, or is this something I'd have to have my app calculate dynamically based on the variables? Thanks! Ed ___ Mailing list: https://launchpad.net/~dhis2-users Post to

Re: [Dhis2-users] Android applications security risk

Thanks Marta, I appreciate the feedback and will look into those links. Regards Ed -Original Message- From: Marta Vila [mailto:martav...@gmail.com] Sent: Wednesday, 21 February 2018 11:23 AM To: Edward Robinson <erobin...@projectbalance.com> Cc: Ignacio Foche <nacho.fo...@

Re: [Dhis2-users] Android applications security risk

if the data on the device is encrypted at rest? Regards Ed From: Ignacio Foche [mailto:nacho.fo...@gmail.com] Sent: Monday, 19 February 2018 3:36 AM To: Edward Robinson <erobin...@projectbalance.com> Cc: dhis2-users <dhis2-users@lists.launchpad.net> Subject: Re: [Dhis2-users] Android applicati

Re: [Dhis2-users] Tracker capture app for Android - OUs not showing up

Thanks Ignacio, I’ve just checked and I agree with what you’ve posted, Regards Ed From: Ignacio Foche [mailto:nacho.fo...@gmail.com] Sent: Monday, 19 February 2018 3:56 AM To: Edward Robinson <erobin...@projectbalance.com> Cc: Mike Johnson <mjohn...@pih.org>; dhis2-users

Re: [Dhis2-users] Tracker capture app for Android - OUs not showing up

Thanks Mike, that confirms my suspicions. I'll create a Jira ticket to suggest consistency with the OU selection behaviour. Cheers Ed From: Mike Johnson [mailto:mjohn...@pih.org] Sent: Friday, 16 February 2018 2:01 PM To: Edward Robinson <erobin...@projectbalance.com>; dhis2-users <dh

[Dhis2-users] Android applications security risk

Is there any way to sign out of the Android application? We're wanting to use it to track highly sensitive patient level data in the field but can't find a sign out option in the application. I'm concerned that if a field worker loses a phone this is a serious security risk. Am I missing

Re: [Dhis2-users] Tracker capture app for Android - OUs not showing up

not mistaken. Regards Ed From: Dhis2-users [mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] On Behalf Of Edward Robinson Sent: Friday, 16 February 2018 12:35 PM To: dhis2-users <dhis2-users@lists.launchpad.net> Subject: [Dhis2-users] Tracker capture app for Android

[Dhis2-users] Custom forms - disable / enable sections

Is it possible to hide or show certain sections (tabs) of custom forms by facility based on some facility property? We are trying to avoid having multiple forms for various services and present them on a single page with multiple tabs if possible, but we want to be able to hide tabs that are

[Dhis2-users] Organisational Unit subsets

What is the best way to approach cascading category option combinations? Facilities are assigned to organizational groups (there are 5 levels). Clients visit the facilities from their various locations and we need to collect those locations but only up to level 3 in the OU hierarchy. What is

Re: [Dhis2-users] Tracker programs and unique IDs

Thanks for the feedback Prosper, I’ll take a look at the Jira issue. @Thierry Octave<mailto:thierry_oct...@dai.com> Regards Ed From: Prosper BT [mailto:ptb3...@gmail.com] Sent: Friday, 17 November 2017 10:47 AM To: Stanley Kalyati <skaly...@gmail.com> Cc: Edward Robi

[Dhis2-users] Tracker programs and unique IDs

What strategies have others used to ensure that tracked entities have unique IDs in the absence of an existing unique identifier? For people, we're considering a combination of name, date of birth (or estimated date of birth), parent's names, place of birth, etc. We're also considering a

Re: [Dhis2-users] DHIS2.ORG is down

I can confirm this on my end too. Ed From: Dhis2-users [mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] On Behalf Of Barnabas Akumba Sent: Monday, 13 November 2017 10:23 AM To: dhis2-devs ; dhis2-users

Re: [Dhis2-users] [WISCENTDs] User role > Authorities

Given the sheer number of authorities, I think this kind of documentation would be super helpful. I’d love to know if something like this exists. Ed From: Dhis2-users [mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] On Behalf Of GROUT, Lise Sent: Wednesday, 08

Re: [Dhis2-users] Unable to view Data values in Data Entry screen

, 2017 at 2:09 PM, Edward Robinson <erobin...@projectbalance.com<mailto:erobin...@projectbalance.com>> wrote: I have been dealing with a similar issue after upgrade from 2.16 When the data is upgraded to 2.20 some of the category option combination codes are changed on t

Re: [Dhis2-users] Unable to view Data values in Data Entry screen

I have been dealing with a similar issue after upgrade from 2.16 When the data is upgraded to 2.20 some of the category option combination codes are changed on the data entry form. There are a number of category option combinations named ‘default’ and the system assigned a different ‘default’

Re: [Dhis2-users] Data integrity question

Great, thanks for the explanation. I’ll submit the docs pull request / Jira today. Regards Ed From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: Wednesday, 25 October 2017 10:26 AM To: Edward Robinson <erobin...@projectbalance.com> Cc: Nayeem Al Mifthah <n.mift...@gmail.c

Re: [Dhis2-users] Data integrity question

Thanks Nayeem, Lars and team, could you weigh in on this? Thank you Ed From: Nayeem Al Mifthah [mailto:n.mift...@gmail.com] Sent: Tuesday, 24 October 2017 7:14 PM To: Edward Robinson <erobin...@projectbalance.com> Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net> Subject: Re:

Re: [Dhis2-users] Data integrity question

Apologies, I mean since 2.20 and possibly before… Regards Ed From: Edward Robinson Sent: Tuesday, 24 October 2017 3:55 PM To: 'Nayeem Al Mifthah' <n.mift...@gmail.com> Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net> Subject: RE: [Dhis2-users] Data integrity ques

[Dhis2-users] Data integrity question

>From the manual: >https://docs.dhis2.org/2.26/en/user/html/dataAdmin_dataIntegrity.html 19.1.2. Data elements without groups Some Data Elements have been allocated to several Data Element Groups. This is currently not allowed, because it will result in duplication of linked data records in the

[Dhis2-users] Tracker and integration with an aggregate level national system

I have a few questions regarding setting up multiple tracker programs when an existing national system is implemented. What is the general consensus with setting up tracker programs in a national level environment - is it preferable to set them up on separate instances? What about aggregation of

Re: [Dhis2-users] Issue with empty analytics for certain data elements after upgrade to 2.26

resource tables as well. Regards Ed From: Alex Tumwesigye [mailto:atumwesi...@gmail.com] Sent: Tuesday, 17 October 2017 7:30 AM To: Edward Robinson <erobin...@projectbalance.com> Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net> Subject: Re: [Dhis2-users] Issue with empty analy

Re: [Dhis2-users] Issue with empty analytics for certain data elements after upgrade to 2.26

=projectbalance@lists.launchpad.net] On Behalf Of Edward Robinson Sent: Friday, 13 October 2017 2:17 PM To: DHIS 2 Users list <dhis2-users@lists.launchpad.net> Subject: [Dhis2-users] Issue with empty analytics for certain data elements after upgrade to 2.26 As mentioned a few times in this for

[Dhis2-users] Issue with empty analytics for certain data elements after upgrade to 2.26

As mentioned a few times in this forum, we recently upgraded a national level installation from 2.16 to 2.26 and have had a few minor issues that we have managed to resolve easily. One issue that I'm struggling a little with is certain data elements are no longer being aggregated and included

Re: [Dhis2-users] Standard approach for recording age at the time of diagnosis when date of birth is unknown

That’s neat, nice. From: Abyot Asalefew Gizaw [mailto:ab...@dhis2.org] Sent: Wednesday, 11 October 2017 3:02 PM To: TIMIMI, Hazim Bakir <timi...@who.int> Cc: Edward Robinson <erobin...@projectbalance.com>; dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Standard approach f

Re: [Dhis2-users] Standard approach for recording age at the time of diagnosis when date of birth is unknown

What we've done in the past with other systems is have a field for estimated age at time of registration - only completed if the DOB is not known. DOB is then auto-populated based on the entered age, and an additional YES/NO field is updated to note that the DOB is estimated and not exact. Ed

Re: [Dhis2-users] Ambiguity in upgrade instructions

: Knut Staring [mailto:knu...@gmail.com] Sent: Thursday, 14 September 2017 2:18 PM To: Edward Robinson <erobin...@projectbalance.com> Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net> Subject: Re: [Dhis2-users] Ambiguity in upgrade instructions I think hibernate.propert

Re: [Dhis2-users] See dashboards assigned to users using psql

Of Edward Robinson Sent: Monday, 02 October 2017 2:20 PM To: DHIS 2 Users list <dhis2-users@lists.launchpad.net> Subject: [Dhis2-users] See dashboards assigned to users using psql Is there a simple way to see the dashboards assigned to or shared with a particular user in the database tables?

Re: [Dhis2-users] No dashboards visible to new user

This problem has been resolved. It seems the user was in fact not part of the group, but was assigned a role with an identical name - obviously not the same thing. Thanks! From: Dhis2-users [mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] On Behalf Of Edward

[Dhis2-users] No dashboards visible to new user

On the system I have just upgraded from 2.16 to 2.26, I have a newly created user who belongs to a group that has two dashboards assigned to it. The newly created user does not see those dashboards (read only access) - is there something I'm forgetting or missing here? Any idea how I can get

[Dhis2-users] See dashboards assigned to users using psql

Is there a simple way to see the dashboards assigned to or shared with a particular user in the database tables? Which tables should I be investigating? Thanks! ___ Mailing list: https://launchpad.net/~dhis2-users Post to :

[Dhis2-users] Analytics logs

Where can I see a log file detailing the analytics table generation? Looking at scheduling section of data administration, it's clear that they haven't run for some time but I'd like to see a log to determine why. Thanks! Ed ___ Mailing list:

[Dhis2-users] Ambiguity in upgrade instructions

In the 2.22 upgrade instructions it says: "The DHIS 2 configuration file is now called dhis.conf and has a range of new and renamed properties. The hibernate.properties configuration file is deprecated. Consult the installation guide for details." In 2.25 it says: "- The system will no longer

[Dhis2-users] Tomcat 8.5

Is there any reason I shouldn't use Tomcat 8.x with DHIS 2.26 or higher DHIS2? I see even the 2.27 setup instructions specify Tomcat 7. Thanks Ed ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net

Re: [Dhis2-users] Online Academies

point in time, though I may be misunderstanding the purpose (e.g. if they include real-time coaching). Regards Ed From: Knut Staring [mailto:knu...@gmail.com] Sent: Wednesday, 30 August 2017 9:55 PM To: Edward Robinson <erobin...@projectbalance.com> Cc: DHIS 2 Users list <dh

Re: [Dhis2-users] Database being cleared after Tomcat shutdown

To: Edward Robinson <erobin...@projectbalance.com> Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net> Subject: Re: [Dhis2-users] Database being cleared after Tomcat shutdown Hi again, If you upgrade from 2.16 to 2.22 or above 2.22, you have to change the configuration file from hibernat

Re: [Dhis2-users] Online Academies

Excellent, thanks for this Knut, I’ll take a look, Cheers Ed From: Knut Staring [mailto:knu...@gmail.com] Sent: Wednesday, 30 August 2017 9:55 PM To: Edward Robinson <erobin...@projectbalance.com> Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net> Subject: Re: [Dhis2-users] Onli

[Dhis2-users] Online Academies

do in South Africa), it would be a major cost saving and allow projects to have more staff certified - something I believe would benefit the community immensely. Ed Edward Robinson Technical Director Project Balance www.projectbalance.com<h

Re: [Dhis2-users] OAuth & Single-Sign-on / CAS with DHIS2

This is old (2014) but still an interesting slide deck on OpenID Connect http://wiki.openid.net/w/file/fetch/80030063/OpenID_Connect_Overview_May_5_2014.pdf Ed From: Dhis2-users [mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] On Behalf Of Edward Robinson Sent

Re: [Dhis2-users] OAuth & Single-Sign-on / CAS with DHIS2

Just adding my 5c – OpenID has been superseded by OpenID connect These may be interesting reading too: http://lightstep.com/blog/everything-I-wish-I-knew-about-enterprise-sso/ https://developers.google.com/identity/protocols/OpenIDConnect Cheers Ed From:

Re: [Dhis2-users] Upgrading from 2.16

You are a lifesaver, thank you! I would love to buy you that beer / coffee – direct mail sent!  Cheers! Ed From: Em Le Hong [mailto:em.hispviet...@gmail.com] Sent: Monday, 07 August 2017 8:59 AM To: Edward Robinson <erobin...@projectbalance.com> Cc: dhis2-users <dhis2-users@lists.laun

Re: [Dhis2-users] Upgrading from 2.16

nks! From: Em Le Hong [mailto:em.hispviet...@gmail.com] Sent: Thursday, 03 August 2017 1:51 PM To: Edward Robinson <erobin...@projectbalance.com> Cc: dhis2-users <dhis2-users@lists.launchpad.net> Subject: Re: [Dhis2-users] Upgrading from 2.16 You can read the upgrade notes from the link

[Dhis2-users] User rights

Is there a document that comprehensively describes all the 'Authorities' that can be assigned under user roles? E.g. if one wanted to allow a role to create and populate their own dashboards but not public dashboards, what are the appropriate authorities to assign? Regards Ed

Re: [Dhis2-users] Hazelcast instance not active

For reference, this is my setup according to the 'about DHIS2' page: [cid:image001.jpg@01D30798.6AB24DD0] From: Dhis2-users [mailto:dhis2-users-bounces+erobinson=projectbalance@lists.launchpad.net] On Behalf Of Edward Robinson Sent: Friday, 28 July 2017 11:48 AM To: dhis2-users <dhis2-us

[Dhis2-users] Hazelcast instance not active

For the past two days I've woken up to this after logging in to DHIS2 (2.16) on Windows: HTTP Status 500 - Hazelcast instance is not active! I'm not sure what's causing it and I need to investigate the logs but I wondered if anything obvious comes to mind from the user group - has anyone else

[Dhis2-users] JRE_HOME vs JAVA_HOME

I assume the JAVA_HOME variable mentioned in most install guides specifically refers to the Tomcat requirement as opposed to a DHIS2 requirement. I ask since I imagine JRE is good enough and the JAVA_HOME variable should be substituted for JRE_HOME in cases without JDK. I just want to make sure

Re: [Dhis2-users] Quick way to edit users per role?

Perfect! That will do it, thanks a ton! From: Knut Staring [mailto:knu...@gmail.com] Sent: Wednesday, 19 July 2017 5:56 PM To: Edward Robinson <erobin...@projectbalance.com> Cc: dhis2-users <dhis2-users@lists.launchpad.net> Subject: Re: [Dhis2-users] Quick way to edit users per ro

Re: [Dhis2-users] Linode.com - anyone using them for hosting?

Excellent, thank you Peter and J. Paul, appreciate the feedback. Ed From: Peter D Lubambi [mailto:pluba...@gmail.com] Sent: Wednesday, 19 July 2017 10:36 AM To: Edward Robinson <erobin...@projectbalance.com> Cc: dhis2-users <dhis2-users@lists.launchpad.net> Subject: Re: [Dhis2-users

[Dhis2-users] Linode.com - anyone using them for hosting?

I'm considering linode.com for a DHIS2 server deployment. Has anyone used them and what has your experience been? The pricing is compelling. My experience has mostly been with Amazon AWS, Rackspace, IBM Softlayer and MS Azure. I have also used BAOSystems for DHIS2 specific hosting on

Re: [Dhis2-users] Major speed issue with pg_restore

Agree, the system has two independent disks, I hadn’t set up any mirroring or striping – I had basically just setup the OS in both cases and performed OS updates. Pretty much a vanilla config on both. My experience is that if the SATA channel drivers aren’t properly loaded, the disks will

Re: [Dhis2-users] DHIS2 Windows server

Thanks for the quick follow up Arvind, appreciate it! From: arvind chikne [mailto:arvind.chi...@gmail.com] Sent: Wednesday, 19 July 2017 1:02 AM To: Edward Robinson <erobin...@projectbalance.com> Cc: dhis2-users <dhis2-users@lists.launchpad.net> Subject: Re: [Dhis2-users] DHIS2 Window

[Dhis2-users] DHIS2 Windows server

I have a server with 16Gb RAM running Windows Server 2012 R2 and (currently) DHIS 2.16. Given that it is mostly dedicated to DHIS2, what would you suggest is the best way to split the RAM between Java/Tomcat and Postgres for optimal DHIS2 performance? Also, should I see anything under the

Re: [Dhis2-users] Major speed issue with pg_restore

Maybe, but 2 days vs 50 minutes is a pretty big difference… From: Bob Jolliffe [mailto:bobjolli...@gmail.com] Sent: Monday, 17 July 2017 2:33 PM To: Edward Robinson <erobin...@projectbalance.com> Cc: Lars Helge Øverland <l...@dhis2.org>; dhis2-users <dhis2-users@lists.launchpad.n

Re: [Dhis2-users] Major speed issue with pg_restore

for the support, Cheers Ed From: Lars Helge Øverland [mailto:l...@dhis2.org] Sent: Monday, 17 July 2017 8:41 AM To: Edward Robinson <erobin...@projectbalance.com> Cc: Bob Jolliffe <bobjolli...@gmail.com>; dhis2-users <dhis2-users@lists.launchpad.net> Subject: Re: [Dhis2-users]

Re: [Dhis2-users] Database version - how to tell

An update on this, it turns out the encryption.password setting in the hibernate.properties file was overwritten with an incorrect value. Fortunately someone on the team recalled what it was previously as the file had not been backed up along with the database. That accounts for the

[Dhis2-users] Database version - how to tell

Hi all, is there a way to tell what version the database is? I'm attempting to get an instance going that was running previously. I was told it was 2.16. Tomcat is having trouble firing up using the 2.16 .war and I notice an error in the stdout log that seems to indicate the app wants to

Re: [Dhis2-users] Major speed issue with pg_restore

...@gmail.com] Sent: Saturday, 15 July 2017 3:02 PM To: Edward Robinson <erobin...@projectbalance.com> Cc: Knut Staring <knu...@gmail.com>; dhis2-users <dhis2-users@lists.launchpad.net>; Hannan Khan <hann...@gmail.com> Subject: RE: [Dhis2-users] Major speed issue with pg_restor

Re: [Dhis2-users] Upgrading from 2.16

Some excellent tips, thank you Elmarie. Regards Ed From: Elmarie Claasen [mailto:elma...@hisp.org] Sent: Sunday, 16 July 2017 3:00 PM To: Edward Robinson <erobin...@projectbalance.com> Cc: DHIS 2 Users list <dhis2-users@lists.launchpad.net> Subject: Re: [Dhis2-users] Upgrading f

[Dhis2-users] Upgrading from 2.16

I have a couple of 2.16 installations that should probably be brought up to date. What are the major caveats I should be looking out for and what is the latest stable DHIS2 version that I should be aiming for? It's critical that service be maintained for the client, I will run the upgrades on

Re: [Dhis2-users] Major speed issue with pg_restore

Sorry for this slow response, time has not been on my side  Also, thanks Bob, Knut and Hannan for your responses. So to fill everyone in, I went through postgres.conf with a fine toothed comb. @ Bob, Shared buffers were set to 3200 though I'd set them to 1600 for the restore as per this

Re: [Dhis2-users] Major speed issue with pg_restore

these. I'll post my postgresql.conf and other details shortly. Thanks! -Original Message- From: Bob Jolliffe [mailto:bobjolli...@gmail.com] Sent: Friday, 14 July 2017 8:07 AM To: Edward Robinson <erobin...@projectbalance.com> Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2

Re: [Dhis2-users] Major speed issue with pg_restore

-on-ubuntu-16-04-7_171095.html Ed From: Knut Staring [mailto:knu...@gmail.com] Sent: Thursday, 13 July 2017 9:58 PM To: Edward Robinson <erobin...@projectbalance.com> Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Major speed issue with pg_restore Perhaps useful to also send this qu

[Dhis2-users] Major speed issue with pg_restore

I've setup a new Ubuntu 16.04 box with PostgreSQL 9.5.5 and I'm restoring a fairly large DHIS2 backup but having speed issues. It's a full pg_dump in custom format and about 650Gb compressed (a plain text dump produces a 7Gb file). I made sure inserts were turned off, so that's not the issue,