Hey everyone,

I am trying to create an specific document within umbraco via the database directly. It is one of those things we have no choice but to do, no API or other method is going to solve this one.

Any way, my route for this was to run SQL Trace and create my document in admin center in the normal fashion. I then painstakingly when through the trace data and create a stored procedure that did the exact same thing for a new document. It appears to work but the page does not show up in the xml data and it is not being seen as published. The procedure inserts into the following tables:

UmbracoNode
cmsContent
cmsContentVersion
cmsPropertyData * 3 (one for each of my properties)
cmsDocument
-- then again for published version
cmsContentVersion
cmsPropertyData * 3 (one for each of my properties)
cmsDocument
cmsContentXml

All looks perfect but in the admin center the document in the tree shows the icon correctly as if it is published yet when I save it in the admin center it goes to unpublished.

I must be missing a table somewhere.

Any help would be appreciated as it has been 9 hours of work on this and the grey matter is getting a little tired.

Cheers
Keith

Keith,

What is the issue that is preventing document creation via api? Doing this directly via db is asking for trouble.

Regards

Ismail

---

Level 2 certified. If it aint broke dont fix.

I'd have to second Ismail and say that manipulating the DB directly is asking for trouble.

This model is subject to change as Umbraco versions are released.

When you don't have the ability to access the API using C# and .net I'd suggest looking at the webservices.

http://yourhost/umbraco/webservices/api/DocumentService.asmx

You need to enable them, but they should do what you want.

---

Darren Ferguson - Umbraco level 2 certified
www.darren-ferguson.com - www.fergusonmoriyama.com

I find it amusing that everyone is saying not to do option A and proposing many other options when there is no knowledge of the landscape in play. There are times when the only point of contact is the database depending on an organizations I.T topologies and security implementations. This is not to say that the my current project has these limitations but I have worked on many where the ability to http requests to an external site within the same organization is forbidden, this is often true within government organizations or on secure networks.

As for the idea of upgrades, in my experience the probability of an upgrade being implemented within a clients environment is less than 0. When development is done in house by an organization you will then see planned upgrades take place.

Thanks for the input everyone but all I was asking was if anyone new if I was missing a table insert/update?

I find it amusing that anyone would insist working with the DB directly when experienced umbraco users say it's a no go'er.

If it's any help I say
"Don't use the db directly as the umbraco api's does more than simply update db tables. They also ensure cache sync and content state in the application. A part from accessing the db directly probably won't work as intended, chances are huge - maybe even guaranteed - that it'll break with even minor updates and you won't get any warnings in upgrade instructions.".

With that quote in mind combined with the fact that it's from the core team, I'm sure that any CIO in your organization would applaud using the API instead of direct SQL. It's simply not best practice.

---

Jeeeez, did I really start this :-)