Repository navigation
Catalog upload #34
Description
Hi,
I installed ogdi for test purpose. For now, I put the information that is available from datahub. But each csv file has an error...
"Failed to process entity.
Entity Start:
Name = 'EntityId' Value = '80ee7cda-9871-4ce6-88d2-68bf9f98e645'
Name = 'DATE' Value = '1970-01-01'
Name = 'VALUE' Value = '55.8'
Name = 'RdfSnippet' Value = '<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:ogdi="ogdiUrl">rdf:Description<ogdi:date rdf:datatype="xs:string">1970-01-01/ogdi:date<ogdi:value rdf:datatype="xs:double">55.8/ogdi:value/rdf:Description/rdf:RDF'
Entity End
Value cannot be null.
Parameter name: field
Failed to process entity."
Ok, some of these files, regardless to the errors,was successfully uploaded.
Can someone explain what's going on? Of course, I used DataLoaderGuiApp...
Activity
nikg commentedon Oct 25, 2012
Typically something like this happens when the fields contain data type different from what was configured, i.e. string in a numeric field, or double in the integer / int32 field.
It's difficult to troubleshoot without knowing the specifics of your .CFG file and the data you're loading.
MiroJ commentedon Nov 5, 2012
Also, have in mind that the rows that had errors are not uploaded so you will be missing data.
You need to find the problematic records before uploading a production DB.
mmiladinovicrs commentedon Nov 18, 2012
Can someone to upload a valid csv file to try? In my case always appears the same error...
nikg commentedon Nov 19, 2012
sure:
https://github.com/openlab/OpenDataInstaller/blob/master/blob%20files/BurlingtonParks.csv
and the .cfg:
https://github.com/openlab/OpenDataInstaller/blob/master/blob%20files/BurlingtonParks.cfg
end result:
http://datadotgc2.cloudapp.net/DataBrowser/Hack%20OpenData/BurlingtonParks
mmiladinovicrs commentedon Jan 23, 2013
There is definitely a problem. Look at attached image.
I used csv in posted above.
nikg commentedon Jan 25, 2013
did you use the attached CSV AND .cfg ?
mmiladinovicrs commentedon Jan 25, 2013
I used posted csv file above. Copy/Paste in new file and than upload using DataLoader. Also, I tried to download file from http://datadotgc2.cloudapp.net/DataBrowser/Hack%20OpenData/BurlingtonParks . I don't see any other way.
mmiladinovicrs commentedon Jan 28, 2013
Hi Nik,
can you tell me what is the problem, so I know where I made mistake?
nikg commentedon Feb 5, 2013
Hi - sorry for the delay, maybe we're miscommunicating. The CSV is one part of the DataLoader. CFG that's created by the DataLoader is another part. If you are using your (custom CFG) created by the DataLoader, delete the CFG file in the same folder as the .CSV and then try to download / lolad the CFG from here https://github.com/openlab/OpenDataInstaller/blob/master/blob%20files/BurlingtonParks.cfg
LMK if this makes sense.