Re: Model Generation for CSV, XLS Files

Hi I need Help On Thursday, November 26, 2020 at 11:54:51 PM UTC+5:30 muskan...@gmail.com wrote: > I would like to tackle this singularly first if possible, especially for > gsoc. Hope you understand I appreciate your offer > > > On Thu, 26 Nov, 2020, 9:25 pm Shoury Sharma, wrote: > >> Hel

Re: Model Generation for CSV, XLS Files

The CSV module in the Python standard library has solved the issues mentioned in this thread vis a vis format. No need to reinvent the wheel. There are options and flags for field names and delimiters. Before relying on a third party depencency, one must demonstrate the necessity. What edge cases d

Re: Model Generation for CSV, XLS Files

Alright Mariusz, (sorry for messing up your name) then I think that puts an end to this particular conversation, I appreciate your feedback and help, same goes for everyone. I'll try to make myself useful in some other way then! On Saturday, 28 November 2020 at 14:12:29 UTC+5:30 Mariusz Felisi

Re: Model Generation for CSV, XLS Files

> Russ pointed out the need for a standardized format in csv files, and in > turn Adam suggested that the first line begin the table name. I have a > slightly different suggestion. It is a well known convention to put the > column names as comma separated values in the first line of the csv fi

Re: Model Generation for CSV, XLS Files

Hi Markzus, Issue #5253 that you pointed me to was indeed very helpful. What I suggested is along the lines of what Adam suggested and tried to accomplish 12 years ago, which clearly shows that there has been space for its implementation for a

Re: Model Generation for CSV, XLS Files

On Fri, Nov 27, 2020 at 5:51 AM Muskan Vaswan wrote: > I want to know what functionality already exists that makes it easier to > directly load a large data set into a django model from a CSV file (going > with the simplest format or now). Hi Muskan, In PostgreSQL I use the COPY FROM to load a

Re: Model Generation for CSV, XLS Files

I recently developed a feature for my company that allows for mass upload of users and a few other core models. I did use Django-rest-framework for the core file upload piece which may not be in the scope of this group, but it was fairly simple and if you wanted to do it for DSoC it'd be pretty str

Re: Model Generation for CSV, XLS Files

Hi, Please take a look at existing ticket #5253 which was rejected. We should reach a strong consensus on the mailing list to reopen a closed ticket (see triaging guidelines with regards to wontfix tickets

Re: Model Generation for CSV, XLS Files

Django-import- export is along the lines of what I want to implement, this is how i eventually managed to import a csv file as a user there are drawbacks to the library, the biggest one being its not the easiest to use without admin integration, which isn't always possible in large projects.

Re: Model Generation for CSV, XLS Files

Is django-import-export at all along the lines of what you're looking for? https://github.com/django-import-export/django-import-export > django-import-export is a Django application and library for importing and exporting data with included admin integration. > ... > support multiple formats (Ex

Re: Model Generation for CSV, XLS Files

I would like to tackle this singularly first if possible, especially for gsoc. Hope you understand I appreciate your offer On Thu, 26 Nov, 2020, 9:25 pm Shoury Sharma, wrote: > Hello! > I'm also looking forward for GSOC'21. If you prefer we could try merging > this functionalities by submit

Re: Model Generation for CSV, XLS Files

Thank you all for your response, I really appreciate it. This seems to be a very active and helpful community already love django more! On Thursday, 26 November 2020 at 21:25:30 UTC+5:30 shan...@gmail.com wrote: > Hello! > I'm also looking forward for GSOC'21. If you prefer we could try merging

Re: Model Generation for CSV, XLS Files

Hello! I'm also looking forward for GSOC'21. If you prefer we could try merging this functionalities by submitting patches. Regards On Thu, 26 Nov, 2020, 1:22 am Muskan Vaswan, wrote: > Hi everyone, > I am Muskan and am very new to this community however not that new to > django itself. Contribu

Re: Model Generation for CSV, XLS Files

Hi Musksan, You need to implement some functionality to upload the CSV file and read it then upload data into into database in bulk. You can django has a way to add multiple objects using bulk_create. Here is a full example I hope it will help. https://github.com/pmutua/drf_csv_xlsx_file_upload

Re: Model Generation for CSV, XLS Files

Hi Muskan, There isn’t anything that directly lets you load a CSV and generate models for it as far as I know (I may be wrong). But check out the Django documentation’s HOWTO on integrating with legacy databases - https://docs.djangoproject.com/en/3.1/howto/legacy-databases/. One possible