createsql package action in umbraco 6

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

John Ligtenberg 53 posts 214 karma points

Mar 04, 2013 @ 23:05

Extending Umbraco

Does the CreateSql package action still work in Umbraco 6?

This is the relevant code from the package XML file:

<Actions>
    <Action runat="install" undo="false" alias="ExecuteSql"><![CDATA[
CREATE TABLE [adGroups](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [adGroupName] [nvarchar](100) NULL,
   [umbracoTypeName] [nvarchar](50) NULL,
    [sections] [nvarchar](max) NULL,
 CONSTRAINT [PK_adGroups] PRIMARY KEY CLUSTERED 
(
 [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

]]></Action>
  </Actions>

Copy Link

Richard Soeteman 4035 posts 12842 karma points MVP

Mar 05, 2013 @ 05:50

0

HI John,

It is still working in V6. There will be an updated version of the PackagAction Contrib in the not too far future that is targeted for V6 and will make use of the new DataLayer.

Hope this helps,

Richard

Copy Link
John Ligtenberg 53 posts 214 karma points

Mar 05, 2013 @ 10:53

0

Hello Richard,

I tested installing my package in an Umbraco 6 site in a virtual directory, and this did not work. Subsequently I set up another IIS instance with the Umbraco site in the root. Installing the package in this site gave no problems.

Thanks for your help.

John

Copy Link
Andreas Iseli 150 posts 427 karma points

Mar 06, 2013 @ 12:09

0

@Richard: Can you tell me more about the new PackageAction Contrib? I've currently created my own package actions for v6, but if there is a beta of the source I would have a look into it and perhaps distributing my own actions adding web services out of the umbraco BASE / REST context.

Copy Link
Richard Soeteman 4035 posts 12842 karma points MVP

Mar 06, 2013 @ 13:50

0

Hi Andreas,

It's still in planning phase but since V6 has some specific settings it would be nice to have a Contrib project targetting that version. If you have some V6 specific actions I would love to add those to the project if you like?

Cheers,

Richard

Copy Link
Michael Galloway 3 posts 23 karma points

Aug 02, 2013 @ 13:53

0

Is the new PackageAction contrib for version 6 available?

Copy Link
Richard Soeteman 4035 posts 12842 karma points MVP

Aug 03, 2013 @ 09:53

0

No not yet, development still has to start :-(

Copy Link
is working on a reply...

Please Sign in or register to post replies