Importing .CSV

[Daniel Levy]

Hello,

I am new to Memento and I’m trying to import a database that is saved in .CSV. I am getting this error message:

“No fields are found in the selected file”

Please help!

[Beth Dixon]

Hi Daniel, you need to create the same fields found in your csv file in your Memento library.  Are you on Android version or Desktop version?

For example:

Csv file has a field called Customer name.  Where is the data going to be imported to in Memento?  Next...create a text field in Memento and give it the field name Customer name.

To be clear... this is important when importing csv file into anything...even Outlook.  The field names must match.

If you are interested in the Desktop version please check out my YouTube channel.

https://www.youtube.com/channel/UCNCXfD6ABC596q84dwbgQ3Q

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/022a9881-dbef-44b0-b4c6-76cfc29e71f3n%40googlegroups.com.

- Beth

[Er Mo]

Hallo

Ein weiterer Stolperstein ist wenn KEIN Name eingegeben ist .Es wirte alles fehlerhaft wenn nur ein Name fehlt .

Hi
Another stumbling block is if NO name is entered. Everything will be wrong if only one name is missing.

Ernst

[Bill Crews]

I agree with Beth. In case someone sees the feature added to Memento in release 4.11.0 "Added ability to create a library from CSV directly. Where: menu > add library > import from csv", know that that method of creating a library requires that the 1st line of the CSV file contains column headings, which will be used as field names when the library is created. CSV files normally have this line but may not with some apps.

Also, the import knows nothing about data types and doesn't try to glean them from the formats of the data in the CSV file. Therefore, it creates the fields automatically all right, but then all you have is a library with the field names you want, but the data type of everything in all fields is Text. All but useless.

If I had continued after this to waste my time doing taking this further, I'd have to do as much work as would have been required to import the normal way -- the way Beth suggests.  I don't see the usefulness of that new feature -- if all you want is to display the values and never try to work with them, I guess.

To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/CACx3mG8s8JXmum1MgVv2QitWyS1q4%3DdeXagVkaEgAXi5qqJpXw%40mail.gmail.com.

[Troy Windhorst]

Ah! Glad I found this. My experience with other databases and spreadsheet apps would have field names automatically created based on the column headers in the .csv file. Now, those created fields would be plain, generic text, but I could then tweak the field types to my liking. I was struggling to figure out why I couldn’t import in Memento. 

The process with Memento is simply reversed. This reversed process might require a little more time from the user, but I don’t think it’s a significant amount. 

[Bill Crews]

Yes, add the library, define the fields the way you want them, and then use the 3-dot menu on the right (Android) to do the import. Then you'll be able to use numbers as numbers, dates as dates, and so on. 

To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/ba1e57ca-0dbc-4326-a09b-16e9370796d7n%40googlegroups.com.

[David Gilmore]

Also be aware that Memento is a little picky on how the data in the CSV file is formatted. Its very picky with Date field formatting.

After creating a library, I created a dummy record and then exported it. Examining the export file showed me how Memento wanted the import data to look like.