Hi - I''m about to embark on a project where a client will upload a csv file of records (anywhere from 10-1000). Each record can have one or multiple files. I am reaching out to the community for some ideas on how to approach this. I''m wondering if I should have an ftp portion - where they ftp the files to a directory. Then have the app look in the directory and match according to csv records, iterate and upload/attach them. Also if I can''t support multiple files per record - that''s fine - one will have to do. Any tips or suggestions out there? -Adam O
Marnen Laibow-Koser
2009-Oct-11 19:53 UTC
Re: Suggestion for how to batch add records & photos
northband wrote:> Hi - > > I''m about to embark on a project where a client will upload a csv file > of records (anywhere from 10-1000). Each record can have one or > multiple files. I am reaching out to the community for some ideas on > how to approach this. > > I''m wondering if I should have an ftp portion - where they ftp the > files to a directory. Then have the app look in the directory and > match according to csv records, iterate and upload/attach them. Also > if I can''t support multiple files per record - that''s fine - one will > have to do. > > Any tips or suggestions out there?You already seem to know how to do this, unles I grossly misunderstand. What exactly are you asking for help on?> > -Adam OBest, -- Marnen Laibow-Koser http://www.marnen.org marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org -- Posted via http://www.ruby-forum.com/.
I''m basically looking for a general consensus that this is a feasible approach - before diving in and realizing that its ''doomed''. I''ll start this direction and see how it goes. Thanks! On Oct 11, 3:53 pm, Marnen Laibow-Koser <rails-mailing-l...@andreas- s.net> wrote:> northband wrote: > > Hi - > > > I''m about to embark on a project where a client will upload a csv file > > of records (anywhere from 10-1000). Each record can have one or > > multiple files. I am reaching out to the community for some ideas on > > how to approach this. > > > I''m wondering if I should have an ftp portion - where they ftp the > > files to a directory. Then have the app look in the directory and > > match according to csv records, iterate and upload/attach them. Also > > if I can''t support multiple files per record - that''s fine - one will > > have to do. > > > Any tips or suggestions out there? > > You already seem to know how to do this, unles I grossly misunderstand. > What exactly are you asking for help on? > > > > > -Adam O > > Best, > -- > Marnen Laibow-Koserhttp://www.marnen.org > mar...-sbuyVjPbboAdnm+yROfE0A@public.gmane.org > -- > Posted viahttp://www.ruby-forum.com/.
Parsing a CSV is certainly possible and very easy. I use FasterCSV If your client FTP''s the file, then you will need to somehow know that happened so you can parse it. Or if you provide file upload functionality, then you can parse it at the time of upload. On Oct 11, 6:59 pm, northband_101 <northb...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I''m basically looking for a general consensus that this is a feasible > approach - before diving in and realizing that its ''doomed''. I''ll > start this direction and see how it goes. > > Thanks! > > On Oct 11, 3:53 pm, Marnen Laibow-Koser <rails-mailing-l...@andreas- > > s.net> wrote: > > northband wrote: > > > Hi - > > > > I''m about to embark on a project where a client will upload a csv file > > > of records (anywhere from 10-1000). Each record can have one or > > > multiple files. I am reaching out to the community for some ideas on > > > how to approach this. > > > > I''m wondering if I should have an ftp portion - where they ftp the > > > files to a directory. Then have the app look in the directory and > > > match according to csv records, iterate and upload/attach them. Also > > > if I can''t support multiple files per record - that''s fine - one will > > > have to do. > > > > Any tips or suggestions out there? > > > You already seem to know how to do this, unles I grossly misunderstand. > > What exactly are you asking for help on? > > > > -Adam O > > > Best, > > -- > > Marnen Laibow-Koserhttp://www.marnen.org > > mar...-sbuyVjPbboAdnm+yROfE0A@public.gmane.org > > -- > > Posted viahttp://www.ruby-forum.com/.