Hi Gerald,
You can use the (insert if not exists) query to insert your data. But
unlike the COPY function which allows bulk insert, you have to write an
insert statement for each data value you intend to insert.
Regards,
Seid,
On Saturday, January 28, 2017, Bob Jolliffe wrote:
> where does t
where does the data come from that you try to import?
On 28 January 2017 at 19:55, gerald thomas wrote:
> Funnily I Bob I only copied a section of the log, I have various
> dataelements ids & period ids which are sending those errors.
> So I am worried where are these errors coming from now.
>
>
Funnily I Bob I only copied a section of the log, I have various
dataelements ids & period ids which are sending those errors.
So I am worried where are these errors coming from now.
On Jan 28, 2017 7:31 PM, "Bob Jolliffe" wrote:
Gerald the clue is in your error message:
Detail: Key (dataelemen
Gerald the clue is in your error message:
Detail: Key (dataelementid, periodid, sourceid,categoryoptioncomboid,
attributeoptioncomboid)=(1973, 2784149, 301,13, 13) already exists.
This usually means you have duplicates among the datavalues you are trying
to import. ie. more than one row with the
Seid,
Thanks for your help but how can i identify those dataelements:
So I suggest you either to use the web API and import through the
import/export module or find out which of the metadata IDs is
duplicate and correct it.
On 1/28/17, Seid Hussein wrote:
> Hi Gerald,
>
> I believe you're trying
Hi Gerald,
I believe you're trying to import through the database rather than the API
which is a better option because of you've duplicate there the most
probable action ta update rather than a duplicate error.
Most probably what happened is you have duplicate metadata. Each data value
shall have
Hi Calle,
The issue was the umlaut that remained in RIPDA in the word naive and it
seemed that 1st and 2nd was somehow superscripted on other elements.
Once we corrected those the dataset report downloaded fine in excel and pdf.
Elmarie
On 28 Jan 2017 03:36, "Calle Hedberg" wrote:
> Elmarie,
7 matches
Mail list logo