Maximum upload file size: 4MB

[Elle Bolt]

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

[Kateryna Grynko]

Hi Elle,

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

[Elle Bolt]

Hi Katya,

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

[Kateryna Grynko]

Elle,

We'll search for a solution.

[Elle Bolt]

Hi Katya,

Thanks your commitment is highly appreciated.

[Maryna Brodina]

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...

[Elle Bolt]

Hi Maryna,

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

[Elle Bolt]

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.

[Kateryna Grynko]

Hi Elle,

Glad you did it! Thank you for the update.