Jun 6, 2008

Spencer 2 posts

I should have mentioned that this was from a project export. So, it won’t solve the sync problem. Have you used the API? It got a lot of what I wanted, but certainly not all. I’m still surprised at how closed Basecamp is—I understand protecting against competition, but do it on features, not on hoarding my data. I used this because I had a project that we were ending and I don’t need a full license right now. After the experience of trying to archive all the data (files, writeboards, etc.), I’m not sure whether I will use Basecamp for a project like that again (short-term, lots of users, but no long-term need).

Jun 5, 2008

Earle 55 posts

Topic: when did full xml export appear?

At first glance I thought Spencer posted the magic xml I’m looking for. I would like to have whatever will allow me to sync (or at least download) all project data to my local servers. I’m kinda doing that now via the downloads which takes me pretty far. I’ve said before the I think BC does a great job at what they do, I just need more.

Jun 5, 2008

Spencer 2 posts

Topic: when did full xml export appear?

This isn’t comprehensive, but it may be helpful to someone. This will generate an html file with all the comments posted across all projects—just tweak it to your needs. Just save it as an xsl file and use your preferred processor to generate the html. Sorry for the formatting, but all the xsl tags wreak havoc with this forum setup…
<?xml version=”1.0” encoding=”UTF-8”?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:output encoding="UTF-8" omit-xml-declaration="yes" indent="yes" method="html" />

<xsl:key name="poster-name" use="id" match="person" /> <xsl:variable name="persons" select="/account/firm/people" /> <!~~-<xsl:variable name="persons" select="/account/firm[name = 'INSERT_NAME_OF_FIRM_HERE']/people" />~~->
<!~~-Use this to get all the people for just one firm -~~>
<xsl:template match="/">
<body>

Posts and Comments by Project

<xsl:apply-templates select="account/projects/project[status = 'active']" /> </body> </xsl:template> <xsl:template match="project[status = 'active']">

<xsl:value-of select="name" />

<xsl:apply-templates select="posts/post" /> </xsl:template> <xsl:template match="post">

<xsl:value-of select="title" />

<xsl:apply-templates select="author-id" /> <xsl:value-of select="body" />

<xsl:apply-templates select="comments/comment" /> </xsl:template> <xsl:template match="comment"> <xsl:variable name="auth-id" select="./author-id" />

<xsl:text>(</xsl:text> <xsl:apply-templates select="$persons"> <xsl:with-param name="curr-person" select="$auth-id" /> </xsl:apply-templates> <xsl:text>) </xsl:text> <xsl:value-of select="body" />

</xsl:template> <xsl:template match="author-id">

User: <xsl:variable name="auth-id" select="." /> <xsl:apply-templates select="$persons"> <xsl:with-param name="curr-person" select="$auth-id" /> </xsl:apply-templates>

</xsl:template> <xsl:template match="people"> <xsl:param name="curr-person" /> <xsl:value-of select="person[id = $curr-person]/first-name" /> <xsl:text> </xsl:text> <xsl:value-of select="person[id = $curr-person]/last-name" /> </xsl:template>
</xsl:stylesheet>

Apr 5, 2007

slapshotw 231 posts

Topic: when did full xml export appear?

The best thing to do would be for someone with xml styling ability to make it readable—someone with CSS or xsl knowledge perhaps.

Apr 5, 2007

Peter Mehit 5 posts

Topic: when did full xml export appear?

I have a question. What do I do with the XML file that gets created during the back up? How do I view the data. I know it’s ignorant, but I have absolutely no idea what to do with the file.

Apr 4, 2007

slapshotw 231 posts

Topic: when did full xml export appear?

XML export has been there for a while. Account (billing) has been there for a while but just had the name “Account.” Also changed is that inside projects, “permissions” is now a tab instead of a top right option.

Basecamp Customer Forum

Posts that othello is monitoring

Posts and Comments by Project

<xsl:value-of select="name" />

<xsl:value-of select="title" />

User: <xsl:variable name="auth-id" select="." /> <xsl:apply-templates select="$persons"> <xsl:with-param name="curr-person" select="$auth-id" /> </xsl:apply-templates>

othello's Monitored Topics

Jun 6, 2008 Spencer 2 posts	Topic: when did full xml export appear? I should have mentioned that this was from a project export. So, it won’t solve the sync problem. Have you used the API? It got a lot of what I wanted, but certainly not all. I’m still surprised at how closed Basecamp is—I understand protecting against competition, but do it on features, not on hoarding my data. I used this because I had a project that we were ending and I don’t need a full license right now. After the experience of trying to archive all the data (files, writeboards, etc.), I’m not sure whether I will use Basecamp for a project like that again (short-term, lots of users, but no long-term need).

Jun 5, 2008 Earle 55 posts	Topic: when did full xml export appear? At first glance I thought Spencer posted the magic xml I’m looking for. I would like to have whatever will allow me to sync (or at least download) all project data to my local servers. I’m kinda doing that now via the downloads which takes me pretty far. I’ve said before the I think BC does a great job at what they do, I just need more.

Jun 5, 2008 Spencer 2 posts	Topic: when did full xml export appear? This isn’t comprehensive, but it may be helpful to someone. This will generate an html file with all the comments posted across all projects—just tweak it to your needs. Just save it as an xsl file and use your preferred processor to generate the html. Sorry for the formatting, but all the xsl tags wreak havoc with this forum setup… <?xml version=”1.0” encoding=”UTF-8”?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:output encoding="UTF-8" omit-xml-declaration="yes" indent="yes" method="html" /> <xsl:key name="poster-name" use="id" match="person" /> <xsl:variable name="persons" select="/account/firm/people" /> <!~~-<xsl:variable name="persons" select="/account/firm[name = 'INSERT_NAME_OF_FIRM_HERE']/people" />~~-> <!~~-Use this to get all the people for just one firm -~~> <xsl:template match="/"> <body> Posts and Comments by Project <xsl:apply-templates select="account/projects/project[status = 'active']" /> </body> </xsl:template> <xsl:template match="project[status = 'active']"> <xsl:value-of select="name" /> <xsl:apply-templates select="posts/post" /> </xsl:template> <xsl:template match="post"> <xsl:value-of select="title" /> <xsl:apply-templates select="author-id" /> <xsl:value-of select="body" /> <xsl:apply-templates select="comments/comment" /> </xsl:template> <xsl:template match="comment"> <xsl:variable name="auth-id" select="./author-id" /> <xsl:text>(</xsl:text> <xsl:apply-templates select="$persons"> <xsl:with-param name="curr-person" select="$auth-id" /> </xsl:apply-templates> <xsl:text>) </xsl:text> <xsl:value-of select="body" /> </xsl:template> <xsl:template match="author-id"> User: <xsl:variable name="auth-id" select="." /> <xsl:apply-templates select="$persons"> <xsl:with-param name="curr-person" select="$auth-id" /> </xsl:apply-templates> </xsl:template> <xsl:template match="people"> <xsl:param name="curr-person" /> <xsl:value-of select="person[id = $curr-person]/first-name" /> <xsl:text> </xsl:text> <xsl:value-of select="person[id = $curr-person]/last-name" /> </xsl:template> </xsl:stylesheet>

Apr 5, 2007 slapshotw 231 posts	Topic: when did full xml export appear? The best thing to do would be for someone with xml styling ability to make it readable—someone with CSS or xsl knowledge perhaps.

Apr 5, 2007 Peter Mehit 5 posts	Topic: when did full xml export appear? I have a question. What do I do with the XML file that gets created during the back up? How do I view the data. I know it’s ignorant, but I have absolutely no idea what to do with the file.

Apr 4, 2007 slapshotw 231 posts	Topic: when did full xml export appear? XML export has been there for a while. Account (billing) has been there for a while but just had the name “Account.” Also changed is that inside projects, “permissions” is now a tab instead of a top right option.