[support] Support for Importing nodes from D5 to D7 using Feeds
Shai Gluskin
shai at content2zero.com
Tue Apr 10 16:20:04 UTC 2012
Hannan,
It's best to make a custom feed using Views (I'm almost certain you can do
that with Views 1 for Drupal 5).
The core feed created by Drupal requires "published" set to "on" (probably
not a problem) and "promote to front" set to "on" => which could very much
be a problem if nodes you want to migrate are not promoted to front. The
feed URL for this core-created feed, I believe, is: example.com/rss.xml
Creating a feed with Views you can set any parameters you want for which
nodes to grab.
I should also note that all this becomes even harder if you have custom
fields created with CCK. If you don't, it's a lot easier.
Shai
On Tue, Apr 10, 2012 at 12:09 PM, Jessica Hannan - Halo Digital Design <
Jessica at halodigitaldesign.com> wrote:
> I'm under the gun to get these nodes into the new site, so I'm probably
> not reading everything correctly, but what is my Feed's URL (on the D5
> site). I can't figure out where to find that.
>
> Thanks!
>
> Jessica Hannan
> 815-545-5541
> http://www.HaloDigitalDesign.com
> Join us on Facebook!!
> http://www.facebook.com/halodigitaldesign
>
>
>
>
>
> On Apr 10, 2012, at 1:33 AM, support-request at drupal.org wrote:
>
> > Send support mailing list submissions to
> > support at drupal.org
> >
> > To subscribe or unsubscribe via the World Wide Web, visit
> > http://lists.drupal.org/mailman/listinfo/support
> > or, via email, send a message with subject or body 'help' to
> > support-request at drupal.org
> >
> > You can reach the person managing the list at
> > support-owner at drupal.org
> >
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of support digest..."
> >
> >
> > Today's Topics:
> >
> > 1. Trouble with Relative Times and Filtering a View (Shai Gluskin)
> > 2. Re: Trouble with Relative Times and Filtering a View (Linda Romey)
> > 3. Importing ONLY nodes from D5 into D7 - Errors!!!
> > (Jessica Hannan - Halo Digital Design)
> > 4. Re: Trouble with Relative Times and Filtering a View
> > (Shai Gluskin)
> > 5. Re: Importing ONLY nodes from D5 into D7 - Errors!!!
> > (Shai Gluskin)
> > 6. Re: Uploading & Downloading Files via FTP
> > (damilarefagbemi at gmail.com)
> >
> >
> > ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Mon, 9 Apr 2012 16:13:41 -0700
> > From: Shai Gluskin <shai at content2zero.com>
> > Subject: [support] Trouble with Relative Times and Filtering a View
> > To: support at drupal.org
> > Message-ID:
> > <CAADUgB2kdp9AEqW1W+rabfpynqZ8nEsr9A=
> 8MnskrddT_3vqaQ at mail.gmail.com>
> > Content-Type: text/plain; charset="iso-8859-1"
> >
> > Client needs content published to a feed automatically, once every 24
> hours
> > at a particular time. The content has already been created for all future
> > posts.
> >
> > I set it up as follows:
> >
> > Content:
> >
> > Item A: Post date set to 4/9 6 PM
> > Item B: Post date set to 4/10 6 PM
> > Item C: Post date set to 4/11 6 PM
> > Item D: Post date set to 4/12 6 PM
> >
> > I've created the feed in a View.
> >
> > Number of items to display is: 1
> > Sort is ascending on Post date.
> > Filter is set to: Post date is greater than now - 24 hours.
> >
> > This does not work. With this configuration Item A only gets onto the
> feed
> > at 10:01 PM on 4/9.
> >
> > It seems to work right if I set the filter to: Post date is greater than
> > "now - 20 hours."
> >
> > Clearly this must have something to do with the fact that the site is in
> > "EDT" which is UTC - 400. The site uses Drupal 6.25 with Date 2.8. The
> site
> > time zone is set to "America/New York" and "user configurable times
> zones"
> > are "disabled."
> >
> > Though I seem to have it working, I'm still confused. Can anyone
> explain?
> >
> > Thanks,
> >
> > Shai
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> > URL:
> http://lists.drupal.org/pipermail/support/attachments/20120409/485cb59b/attachment-0001.html
> >
> > ------------------------------
> >
> > Message: 2
> > Date: Mon, 9 Apr 2012 19:30:04 -0400
> > From: Linda Romey <lromey at gmail.com>
> > Subject: Re: [support] Trouble with Relative Times and Filtering a
> > View
> > To: support at drupal.org
> > Message-ID:
> > <CAFqhcmLfNziT1+ZCQpx75bVntPL4YTWbCEMBdQPDo=
> fpa7O0Ag at mail.gmail.com>
> > Content-Type: text/plain; charset="iso-8859-1"
> >
> > Why do you have it filtered? Whatever now is, it will be 24 hours
> > difference. If you set the post time when you create the content (I
> assume
> > that's what you mean), you don't need the filter do you? The content will
> > post when it hits the time you set.
> >
> > On Mon, Apr 9, 2012 at 7:13 PM, Shai Gluskin <shai at content2zero.com>
> wrote:
> >
> >> Client needs content published to a feed automatically, once every 24
> >> hours at a particular time. The content has already been created for all
> >> future posts.
> >>
> >> I set it up as follows:
> >>
> >> Content:
> >>
> >> Item A: Post date set to 4/9 6 PM
> >> Item B: Post date set to 4/10 6 PM
> >> Item C: Post date set to 4/11 6 PM
> >> Item D: Post date set to 4/12 6 PM
> >>
> >> I've created the feed in a View.
> >>
> >> Number of items to display is: 1
> >> Sort is ascending on Post date.
> >> Filter is set to: Post date is greater than now - 24 hours.
> >>
> >> This does not work. With this configuration Item A only gets onto the
> feed
> >> at 10:01 PM on 4/9.
> >>
> >> It seems to work right if I set the filter to: Post date is greater than
> >> "now - 20 hours."
> >>
> >> Clearly this must have something to do with the fact that the site is in
> >> "EDT" which is UTC - 400. The site uses Drupal 6.25 with Date 2.8. The
> site
> >> time zone is set to "America/New York" and "user configurable times
> zones"
> >> are "disabled."
> >>
> >> Though I seem to have it working, I'm still confused. Can anyone
> explain?
> >>
> >> Thanks,
> >>
> >> Shai
> >>
> >> --
> >> [ Drupal support list | http://lists.drupal.org/ ]
> >>
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> > URL:
> http://lists.drupal.org/pipermail/support/attachments/20120409/2441b5ea/attachment-0001.html
> >
> > ------------------------------
> >
> > Message: 3
> > Date: Mon, 9 Apr 2012 19:51:27 -0500
> > From: Jessica Hannan - Halo Digital Design
> > <Jessica at HaloDigitalDesign.com>
> > Subject: [support] Importing ONLY nodes from D5 into D7 - Errors!!!
> > To: support at drupal.org
> > Message-ID:
> > <6AD50836-AEE0-4ED6-A0F9-4F8CF10086E0 at HaloDigitalDesign.com>
> > Content-Type: text/plain; charset=us-ascii
> >
> > I have a client that wanted to upgrade from D% to D7. Fortunately, they
> were ok with starting all over... but now that the website is ready, I need
> to move the nodes in.
> >
> > I exported the nodes into a sql file, imported them into the new
> database and although they show up in the new database, when I go back to
> the new website, it's giving me the following error.
> >
> > "PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column
> 'language' in 'where clause'...
> >
> > There is no column titled "language" in the nodes. I don't have a
> language or translation module loaded.
> >
> > I rolled the database back to get the website functional again, but I'd
> like to try to make this work as there are 207 nodes that I'd rather not
> add by hand!!
> >
> > Thanks!
> >
> > Jessica Hannan
> > 815-545-5541
> > http://www.HaloDigitalDesign.com
> > Join us on Facebook!!
> > http://www.facebook.com/halodigitaldesign
> >
> >
> >
> >
> >
> >
> >
> > ------------------------------
> >
> > Message: 4
> > Date: Mon, 9 Apr 2012 18:41:43 -0700
> > From: Shai Gluskin <shai at content2zero.com>
> > Subject: Re: [support] Trouble with Relative Times and Filtering a
> > View
> > To: support at drupal.org
> > Message-ID:
> > <CAADUgB2Bo091y=
> zWQ7+PLvX7ZqeDpgr+WXw8tHkg5rX9uAU8RA at mail.gmail.com>
> > Content-Type: text/plain; charset="iso-8859-1"
> >
> > @Linda wrote:
> >
> > If you set the post time when you create the content (I assume that's
> what
> >> you mean), you don't need the filter do you? The content will post when
> it
> >> hits the time you set.
> >>
> >
> > No, that isn't how it works. The "post date" has NO control over content
> > access; it is the "published" toggle in "publishing options" that
> controls
> > whether something is "published."
> >
> > In my example, all of the content is being added to the site *in
> advance*.
> > All of the nodes are "published" when they are added, even though they'll
> > have "post date" dates way into the future. The site owners know that
> > content, being published, will be accessible via Google, etc. even before
> > the show up in the RSS. They don't care. They have a MailChimp RSS to
> Email
> > feed and it is important that a new article goes out every day. That's
> all.
> >
> > So I *must* do some kind of filter based on "now." As an experiment, I
> > tried something which may be simpler, select content with "Post Date less
> > than now" and sort Desc. This also did not switch to the new article at
> > 6PM. But rather at 9 PM. For this to work I need to filter on Select
> > content with Post date less than now + 3 hours.
> >
> > I think what is going on is that "Now" is the server time (my server is
> in
> > LA) and the Post date is in Eastern time.
> >
> > Shai
> >
> > On Mon, Apr 9, 2012 at 4:30 PM, Linda Romey <lromey at gmail.com> wrote:
> >
> >> Why do you have it filtered? Whatever now is, it will be 24 hours
> >> difference. If you set the post time when you create the content (I
> assume
> >> that's what you mean), you don't need the filter do you? The content
> will
> >> post when it hits the time you set.
> >>
> >> On Mon, Apr 9, 2012 at 7:13 PM, Shai Gluskin <shai at content2zero.com
> >wrote:
> >>
> >>> Client needs content published to a feed automatically, once every 24
> >>> hours at a particular time. The content has already been created for
> all
> >>> future posts.
> >>>
> >>> I set it up as follows:
> >>>
> >>> Content:
> >>>
> >>> Item A: Post date set to 4/9 6 PM
> >>> Item B: Post date set to 4/10 6 PM
> >>> Item C: Post date set to 4/11 6 PM
> >>> Item D: Post date set to 4/12 6 PM
> >>>
> >>> I've created the feed in a View.
> >>>
> >>> Number of items to display is: 1
> >>> Sort is ascending on Post date.
> >>> Filter is set to: Post date is greater than now - 24 hours.
> >>>
> >>> This does not work. With this configuration Item A only gets onto the
> >>> feed at 10:01 PM on 4/9.
> >>>
> >>> It seems to work right if I set the filter to: Post date is greater
> than
> >>> "now - 20 hours."
> >>>
> >>> Clearly this must have something to do with the fact that the site is
> in
> >>> "EDT" which is UTC - 400. The site uses Drupal 6.25 with Date 2.8. The
> site
> >>> time zone is set to "America/New York" and "user configurable times
> zones"
> >>> are "disabled."
> >>>
> >>> Though I seem to have it working, I'm still confused. Can anyone
> explain?
> >>>
> >>> Thanks,
> >>>
> >>> Shai
> >>>
> >>> --
> >>> [ Drupal support list | http://lists.drupal.org/ ]
> >>>
> >>
> >>
> >> --
> >> [ Drupal support list | http://lists.drupal.org/ ]
> >>
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> > URL:
> http://lists.drupal.org/pipermail/support/attachments/20120409/ee84b547/attachment-0001.html
> >
> > ------------------------------
> >
> > Message: 5
> > Date: Mon, 9 Apr 2012 21:55:24 -0400
> > From: Shai Gluskin <shai at content2zero.com>
> > Subject: Re: [support] Importing ONLY nodes from D5 into D7 -
> > Errors!!!
> > To: support at drupal.org
> > Message-ID: <801967FA-E624-45C9-8304-310F7B95FFBA at content2zero.com>
> > Content-Type: text/plain; charset=us-ascii
> >
> > Jessica and all,
> >
> > On the D5 site set up an RSS feed which aggregates the nodes you want to
> export from the old site. Now on the Drupal 7 site, use the Feeds module to
> import the nodes. Both sites have to be up and running separately for this
> to work.
> >
> > There is a bit of a learning curve on the Feeds module, but it is a good
> way to go for your use-case.
> >
> > Shai
> >
> > On Apr 9, 2012, at 8:51 PM EDT, Jessica Hannan - Halo Digital Design
> wrote:
> >
> >> I have a client that wanted to upgrade from D% to D7. Fortunately, they
> were ok with starting all over... but now that the website is ready, I need
> to move the nodes in.
> >>
> >> I exported the nodes into a sql file, imported them into the new
> database and although they show up in the new database, when I go back to
> the new website, it's giving me the following error.
> >>
> >> "PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column
> 'language' in 'where clause'...
> >>
> >> There is no column titled "language" in the nodes. I don't have a
> language or translation module loaded.
> >>
> >> I rolled the database back to get the website functional again, but I'd
> like to try to make this work as there are 207 nodes that I'd rather not
> add by hand!!
> >>
> >> Thanks!
> >>
> >> Jessica Hannan
> >> 815-545-5541
> >> http://www.HaloDigitalDesign.com
> >> Join us on Facebook!!
> >> http://www.facebook.com/halodigitaldesign
> >>
> >>
> >>
> >>
> >>
> >> --
> >> [ Drupal support list | http://lists.drupal.org/ ]
> >
> >
> >
> > ------------------------------
> >
> > Message: 6
> > Date: Tue, 10 Apr 2012 06:33:45 +0000
> > From: damilarefagbemi at gmail.com
> > Subject: Re: [support] Uploading & Downloading Files via FTP
> > To: support at drupal.org,eboyd53sf at gmail.com
> > Message-ID:
> >
> <1563169286-1334039627-cardhu_decombobulator_blackberry.rim.net-190296522- at b27.c14.bise7.blackberry
> >
> >
> > Content-Type: text/plain
> >
> > Thanks for the response Earnie.
> > I have already implemented what you suggested and it works very well.
> >
> > However, my client wishes to utilize ftp for the purpose of uploading an
> downloading large files.
> >
> > How can I integrate ftp uploads and downloads into a drupal site?
> >
> > Dammy
> > ------Original Message------
> > From: Earnie Boyd
> > Sender: eboyd53sf at gmail.com
> > To: support at drupal.org
> > To: Damilare Fagbemi
> > Subject: Re: [support] Uploading & Downloading Files via FTP
> > Sent: Apr 9, 2012 12:47
> >
> > On Sun, Apr 8, 2012 at 11:41 AM, <damilarefagbemi at gmail.com> wrote:
> >> Hello Guys,
> >>
> >> I am developing a Drupal powered website for a client and they have
> requested ftp capabilities for certain document uploads and downloads.
> >>
> >> Is this possible in Drupal? If yes, how can I go about it?
> >
> > The ability to upload files is a core built-in module. There may be
> > other modules to help manage the uploaded files; see
> > drupal.org/project/modules and search for upload. You may want to
> > create a content type that contains a field (assuming you're using D7)
> > that allows for uploading the file and associate it to a node that
> > gives a description of the file.
> >
> > --
> > Earnie
> > -- https://sites.google.com/site/earnieboyd
> >
> >
> > Sent from my BlackBerry wireless device from MTN
> >
> > ------------------------------
> >
> > --
> > [ Drupal support list | http://lists.drupal.org/ ]
> >
> > End of support Digest, Vol 112, Issue 11
> > ****************************************
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20120410/b386fa6a/attachment-0001.html
More information about the support
mailing list