Not enough memory to create a database

This forum is for eXpress++ general support.
Message
Author
User avatar
Eugene Lutsenko
Posts: 1649
Joined: Sat Feb 04, 2012 2:23 am
Location: Russia, Southern federal district, city of Krasnodar
Contact:

Re: Not enough memory to create a database

#21 Post by Eugene Lutsenko »

rdonnay wrote:
When a CSV file is very large (for example, 4 million records), it just crashes from memory
That is probably correct.
I do not have an answer for you.

You could possibly break it into multiple files.
You would use FOpen(), FCreate(), FRead() and FWrite() to do this.
use newfile.dbf
append from mycsvfile.csv deliMITED

Is processed correctly and QUICKLY. But not always correctly...

Victorio
Posts: 621
Joined: Sun Jan 18, 2015 11:43 am
Location: Slovakia

Re: Not enough memory to create a database

#22 Post by Victorio »

maybe this is not your problem, but I had this problem several days ago :
when generate tasklist to csv file, and after it read this csv to array, work fine. but on one PC not, this PC have Windows 10 france version.
when debugging, i saw , that to array read only 3 columns from CSV.
Problem was with diacritics or. umlauts.
see here
Windows 10 eng. version
Image Name;PID;Session Name;Session#;Mem Usage;Status;User Name;CPU Time;Window Title
Windows 10 fra version
"Nom de l'image","PID","Nom de la session","Numro de session","Utilisation mmoire","tat","Nom d'utilisateur","Temps processeur","Titre de la fenetre"

maybe also in your csv was some special character , that cause problems. look

I have solved it with ignore first row in csv and generate own correct header for csv

PS: because here not show correct some character problematic csv attached.

User avatar
Eugene Lutsenko
Posts: 1649
Joined: Sat Feb 04, 2012 2:23 am
Location: Russia, Southern federal district, city of Krasnodar
Contact:

Re: Not enough memory to create a database

#23 Post by Eugene Lutsenko »

Victorio! It seems that You are right!

Post Reply