[support] Support for Importing nodes from D5 to D7 using Feeds
Jessica Hannan - Halo Digital Design
Jessica at HaloDigitalDesign.com
Tue Apr 10 16:09:53 UTC 2012
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
> ****************************************
More information about the support
mailing list