Memento: I am trying to Import a file .CSV in a library...

[Tom DeF]

Memento:  I am trying to Import a file .CSV in a library with 11 fields, the first 9 fields are with the same name of both files. During the unsuccessfully Import operation Memento system is giving this:

null

Processed rows: 92
Added entries: 0
Errors: 92

My problem: HOW AND WHERE I CAN UNDERSTAND WHERE IS THE ERROR???

Thank You for help.

ToM

__________

PS: before to run the Import, the library contains already 4 records.

[Beth Dixon]

All fields must have the same name.  You say you have 11 fields and 9 have the same field name?  You must ensure that the other 2 also have the same matching field names.

- Beth

--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mementodataba...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/ac3021c9-0632-48ea-bfc9-fb5d5243db01n%40googlegroups.com.

[Bill Crews]

Having the same field name is a problem, at least for those using JavaScript. If you say entry().set("fieldName", 0), memento has to know which fieldName you want set. It'll pick one, but it may not be the one you intended.

I haven't done much of this in Memento, but in general, the first row of the CSV file contains the column names, generally all distinct from each other. The remaining rows contain the values that go into those columns. Text fields should have quoted values in the CSV file, while numeric fields' (like Integer, Real, & Currency) values do not need quotes.

--

[Tom DeF]

Thank You  Beth, Bill ...

After different ways trying, trying, trying,... due also to Yours ideas, I got those correct 92 records inside my Memento Database.

But sure I need to understand better the connections with this Memento Database, and I hope that Memento will be improved, to be better USER Friendly.
All the best.

ToM

__________

[Bill Crews]

I hope you identify the ways you feel it could be more user friendly and communicate them to the developer (wiki.MementoDatabase.com). Make sure he knows which edition you're telling him about -- mobile or desktop.

To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/7d560179-bd22-4f72-83e1-dfd970db62b6n%40googlegroups.com.