Jump to:

7935 Posts in 1536 Topics by 943 members

DataObjectManager Module

SilverStripe Forums » DataObjectManager Module » Bulk uploader on the front end

Discuss the DataObjectManager module, and the related ImageGallery module.

Moderators: martimiz, UncleCheese, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1 2 3 4
Go to End
Author Topic: 4532 Views
  • UncleCheese
    Avatar
    4085 Posts

    Re: Bulk uploader on the front end Link to this post

    Well CSV is pretty universal. I would just import it into your CalendarDateTime table. You may have to map the fields but that's easy. ICS is the standard format for calendars, though, so I'm surprised you're not using that.

  • orion
    Avatar
    Community Member
    20 Posts

    Re: Bulk uploader on the front end Link to this post

    Hi Uncle Cheese,

    Since it is a csv file, how do I import to the calendarDatetime table? Do I do it as the same procedure as an ICS file where I would drop ICS file into the import folder and then run it? or is it a completely different process?

    Thanks Again

  • UncleCheese
    Avatar
    4085 Posts

    Re: Bulk uploader on the front end Link to this post

    No, the import function looks for an ICS file. To import a CSV you'll have to write a script to map your fields in the CSV file to those in the CalendarDateTime table.. I usually just use Excel..

  • Silver
    Avatar
    Community Member
    12 Posts

    Re: Bulk uploader on the front end Link to this post

    I have a project where we are doing the same thing...calendar data is being exported using a csv file. When you say you usually use excel what does that mean? What are you using excel for? I am trying to understand the steps clearly here. I appreciate any help Uncle Cheese.

  • UncleCheese
    Avatar
    4085 Posts

    Re: Bulk uploader on the front end Link to this post

    You import the CSV into Excel, and then in a new column on the right, you build out insert statements, e.g..

    INSERT INTO .... FieldName = ' =A1 ', AnotherFieldName = ' =B1 ' etc...

    Then you can just copy them all the way down and it will build them out for you and you can just paste them in to your DB admin tool.

  • UncleCheese
    Avatar
    4085 Posts

    Re: Bulk uploader on the front end Link to this post

    The other thing you could try is setting up a ModelAdmin interface for CalendarDateTime and using the Import feature.

  • Silver
    Avatar
    Community Member
    12 Posts

    Re: Bulk uploader on the front end Link to this post

    Thank you. I will try this out and let you know.

  • Silver
    Avatar
    Community Member
    12 Posts

    Re: Bulk uploader on the front end Link to this post

    Oh I did not see this post. Would you be able to elaborate on this please? How would the model admin work?

    4532 Views
Page: 1 2 3 4
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.