Forum | Appery.io

Hi

I have a a csv file that i want to import into my DB but unfortunately you have a 4MB upload limit.

my file is approximately 10MB do you have a work around for this limitation?

Thanks,
Elle

Hi Elle,

Unfortunately you can't workaround this. The only way is to divide file on several parts...

Hi Katya,

And the upload individually, How do i then combine them into one collection?

Elle,

We'll search for a solution.

Hi Katya,

Thanks your commitment is highly appreciated.

Hello! Try to solve this problem programmatically. Split file into several files, upload a few collections, then using server code merge tables into one table. This link should help http://docs.appery.io/documentation/b...

Hi Maryna,

Thanks for the response this is actually what i'm trying now.

Hi Maryna,

Just a Update it worked here is how i did it in the end.

I ended up splitting my file into smaller files uploaded one then converted the rest from csv to JSON text file and used the following code to import

Collection.createObject("databaseID", "collectionName", {"fieldName":"value", ...})._id;

I managed about 26000 records per sccript at a ave time of 102896ms

Thanks again.

Hi Elle,

Glad you did it! Thank you for the update.