24 Aug
2011
24 Aug
'11
3:33 p.m.
Hello,
My company wants to migrate the content of an Oracle database into XWiki. This database
contains files (xls, doc, rtf etc...) stored in BLOB which are linked with text documents.
In order to migrate the text documents, I use the import in Xar format and it's OK,
the problem is the migration of the files. In my Wiki I chose the option to store the
attached files outside the database. I expected to put "metadatas attachment" in
the xml files and simply copy my files in the right directory but it doesn't work. Is
it a wrong idea ? What's the best way to do it ?
Thank you for help.
Françoise Cadin
24 Aug
24 Aug
3:40 p.m.
Whatever the way you store the attachment they are supposed to be part
of the exported xar.
On Wed, Aug 24, 2011 at 3:33 PM, Cadin Françoise
<francoise.cadin(a)insee.fr> wrote:
Hello,
My company wants to migrate the content of an Oracle database into XWiki. This database
contains files (xls, doc, rtf etc...) stored in BLOB which are linked with text documents.
In order to migrate the text documents, I use the import in Xar format and it's OK,
the problem is the migration of the files. In my Wiki I chose the option to store the
attached files outside the database. I expected to put "metadatas attachment" in
the xml files and simply copy my files in the right directory but it doesn't work. Is
it a wrong idea ? What's the best way to do it ?
Thank you for help.
Françoise Cadin
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Thomas Mortagne
4:04 p.m.
Hi Françoise,
in order to do this, you would need to export all attachments from you
Oracle DB and store them into a ZIP file for instance. Then you would need
to write a script that reads the contents of the ZIP file, creates a XWiki
document for each of them and attaches the file to the document.
I've seen such scripts in action, but unfortunately I cannot find it on
http://extensions.xwiki.org . If you're not a developer, they might be a bit
tough to create from scratch.
Guillaume
On Wed, Aug 24, 2011 at 3:40 PM, Thomas Mortagne
<thomas.mortagne(a)xwiki.com>wrote;wrote:
Whatever the way you store the attachment they are
supposed to be part
of the exported xar.
On Wed, Aug 24, 2011 at 3:33 PM, Cadin Françoise
<francoise.cadin(a)insee.fr> wrote:
Hello,
My company wants to migrate the content of an Oracle database into XWiki.
This
database contains files (xls, doc, rtf etc...) stored in BLOB which are
linked with text documents. In order to migrate the text documents, I use
the import in Xar format and it's OK, the problem is the migration of the
files. In my Wiki I chose the option to store the attached files outside the
database. I expected to put "metadatas attachment" in the xml files and
simply copy my files in the right directory but it doesn't work. Is it a
wrong idea ? What's the best way to do it ?
Thank you for help.
Françoise Cadin
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Thomas Mortagne
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
4:13 p.m.
Ha I tough you wanted to change the database used for XWiki.
First thing is to decide where you want to put theses files in XWiki
and to define a conversion rule you can then implements in a script.
You have several solution:
* use groovy inside a XWiki page since that's the easiest way to use
XWiki API to import and store the attachments in your wiki
* if you are not very confident with groovy (or java since groovy is
very close to java) you can also use the REST
(platform.xwiki.org/xwiki/bin/view/Features/XWikiRESTfulAPI) or XMLRPC
(http://platform.xwiki.org/xwiki/bin/view/Features/XMLRPC) or WebDAV
(http://platform.xwiki.org/xwiki/bin/view/Features/WebDAV) interfaces
provided by XWiki to upload the attachments in a whatever
script/program you know better
On Wed, Aug 24, 2011 at 4:04 PM, Guillaume Lerouge <guillaume(a)xwiki.com> wrote:
Hi Françoise,
in order to do this, you would need to export all attachments from you
Oracle DB and store them into a ZIP file for instance. Then you would need
to write a script that reads the contents of the ZIP file, creates a XWiki
document for each of them and attaches the file to the document.
I've seen such scripts in action, but unfortunately I cannot find it on
http://extensions.xwiki.org . If you're not a developer, they might be a bit
tough to create from scratch.
Guillaume
On Wed, Aug 24, 2011 at 3:40 PM, Thomas Mortagne
<thomas.mortagne(a)xwiki.com>wrote;wrote:
--
Thomas Mortagne
Whatever the way you store the attachment they
are supposed to be part
of the exported xar.
On Wed, Aug 24, 2011 at 3:33 PM, Cadin Françoise
<francoise.cadin(a)insee.fr> wrote:
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Hello,
My company wants to migrate the content of an Oracle database into XWiki.
This
database contains files (xls, doc, rtf etc...) stored in BLOB which are
linked with text documents. In order to migrate the text documents, I use
the import in Xar format and it's OK, the problem is the migration of the
files. In my Wiki I chose the option to store the attached files outside the
database. I expected to put "metadatas attachment" in the xml files and
simply copy my files in the right directory but it doesn't work. Is it a
wrong idea ? What's the best way to do it ?
Thank you for help.
Françoise Cadin
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Thomas Mortagne
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
5:51 p.m.
Thank you very much, I didn't want to start developpement before being sure I
can't avoid it.
Françoise
-----Message d'origine-----
De : users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] De la part de Thomas
Mortagne
Envoyé : mercredi 24 août 2011 16:14
À : XWiki Users
Objet : Re: [xwiki-users] Importing attached files in Xwiki
Ha I tough you wanted to change the database used for XWiki.
First thing is to decide where you want to put theses files in XWiki and to define a
conversion rule you can then implements in a script.
You have several solution:
* use groovy inside a XWiki page since that's the easiest way to use XWiki API to
import and store the attachments in your wiki
* if you are not very confident with groovy (or java since groovy is very close to java)
you can also use the REST
(platform.xwiki.org/xwiki/bin/view/Features/XWikiRESTfulAPI) or XMLRPC
(http://platform.xwiki.org/xwiki/bin/view/Features/XMLRPC) or WebDAV
(http://platform.xwiki.org/xwiki/bin/view/Features/WebDAV) interfaces provided by XWiki to
upload the attachments in a whatever script/program you know better
On Wed, Aug 24, 2011 at 4:04 PM, Guillaume Lerouge <guillaume(a)xwiki.com> wrote:
Hi Françoise,
in order to do this, you would need to export all attachments from you
Oracle DB and store them into a ZIP file for instance. Then you would
need to write a script that reads the contents of the ZIP file,
creates a XWiki document for each of them and attaches the file to the document.
I've seen such scripts in action, but unfortunately I cannot find it
on http://extensions.xwiki.org . If you're not a developer, they might
be a bit tough to create from scratch.
Guillaume
On Wed, Aug 24, 2011 at 3:40 PM, Thomas Mortagne
<thomas.mortagne(a)xwiki.com>wrote;wrote:
--
Thomas Mortagne
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Whatever the way you store the attachment they
are supposed to be
part of the exported xar.
On Wed, Aug 24, 2011 at 3:33 PM, Cadin Françoise
<francoise.cadin(a)insee.fr> wrote:
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Hello,
My company wants to migrate the content of an Oracle database into XWiki.
This
database contains files (xls, doc, rtf etc...) stored in BLOB
which are linked with text documents. In order to migrate the text
documents, I use the import in Xar format and it's OK, the problem is
the migration of the files. In my Wiki I chose the option to store
the attached files outside the database. I expected to put "metadatas
attachment" in the xml files and simply copy my files in the right
directory but it doesn't work. Is it a wrong idea ? What's the best way to do it
?
Thank you for help.
Françoise Cadin
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Thomas Mortagne
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
25 Aug
25 Aug
8:32 a.m.
Howdy Françoise,
The way I would approach this project is to use an external script and pull all of the
attachments
out to the filesystem then push them into XWiki. It is true that with FS attachments,
XWiki stores
the attachments as plain old files on the filesystem but each one has accompanying data in
the database
and that is difficult to replicate so I recommend just sending the attachments in through
the "front door".
A search of oracle blob to file turns up plenty of relevant results.
This looks promising: http://www.idevelopment.info/data/Oracle/DBA_tips/LOBs/LOBS_10.shtml
Once the files are exported to the filesystem, I would use a shell script to push them to
the wiki.
Here's a simple script which pushes files through the webdav system, you should be
able to modify this
to meet your requirements.
#!/bin/bash
# usage: upload.sh <document> <file>
# uploads <file> as an attachment to <document>
# example: upload.sh Main.WebHome /home/user/file.txt
#
fileName="`echo $2 | sed 's/^.*\([^\/]*\)/\1/'`";
path="`echo $1 | sed 's/\(.*\)\.\(.\)\(.*\)$/\1\/_\2_\/\2\3/'`";
curl -v --user Admin:admin -T $2
http://127.0.0.1:8080/xwiki/webdav/attachments/${path}/${fileName}
Caleb
On 08/24/2011 11:51 AM, Cadin Françoise wrote:
Thank you very much, I didn't want to start
developpement before being sure I can't avoid it.
Françoise
-----Message d'origine-----
De : users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] De la part de Thomas
Mortagne
Envoyé : mercredi 24 août 2011 16:14
À : XWiki Users
Objet : Re: [xwiki-users] Importing attached files in Xwiki
Ha I tough you wanted to change the database used for XWiki.
First thing is to decide where you want to put theses files in XWiki and to define a
conversion rule you can then implements in a script.
You have several solution:
* use groovy inside a XWiki page since that's the easiest way to use XWiki API to
import and store the attachments in your wiki
* if you are not very confident with groovy (or java since groovy is very close to java)
you can also use the REST
(platform.xwiki.org/xwiki/bin/view/Features/XWikiRESTfulAPI) or XMLRPC
(http://platform.xwiki.org/xwiki/bin/view/Features/XMLRPC) or WebDAV
(http://platform.xwiki.org/xwiki/bin/view/Features/WebDAV) interfaces provided by XWiki
to upload the attachments in a whatever script/program you know better
On Wed, Aug 24, 2011 at 4:04 PM, Guillaume Lerouge <guillaume(a)xwiki.com> wrote:
Hi Françoise,
in order to do this, you would need to export all attachments from you
Oracle DB and store them into a ZIP file for instance. Then you would
need to write a script that reads the contents of the ZIP file,
creates a XWiki document for each of them and attaches the file to the document.
I've seen such scripts in action, but unfortunately I cannot find it
on http://extensions.xwiki.org . If you're not a developer, they might
be a bit tough to create from scratch.
Guillaume
On Wed, Aug 24, 2011 at 3:40 PM, Thomas Mortagne
<thomas.mortagne(a)xwiki.com>wrote;wrote:
--
Thomas Mortagne
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Whatever the way you store the attachment they
are supposed to be
part of the exported xar.
On Wed, Aug 24, 2011 at 3:33 PM, Cadin Françoise
<francoise.cadin(a)insee.fr> wrote:
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Hello,
My company wants to migrate the content of an Oracle database into XWiki.
This
database contains files (xls, doc, rtf etc...) stored in BLOB
which are linked with text documents. In order to migrate the text
documents, I use the import in Xar format and it's OK, the problem is
the migration of the files. In my Wiki I chose the option to store
the attached files outside the database. I expected to put "metadatas
attachment" in the xml files and simply copy my files in the right
directory but it doesn't work. Is it a wrong idea ? What's the best way to do it
?
Thank you for help.
Françoise Cadin
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Thomas Mortagne
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
5064
days inactive
5065
days old
5 comments
4 participants
participants (4)
-
Cadin Françoise -
Caleb James DeLisle -
Guillaume Lerouge -
Thomas Mortagne