Re: [Dspace-tech] Batch data change
Hi guys, Thank you all for helpful articles, I will try them all for a best practice. Have a nice day. Hakan On Fri, Mar 6, 2015 at 11:05 AM, Nason Bimbe nasonbi...@gmail.com wrote: Hi Hakim, You can also use Dspace batch metadata editing facility, see the instructions at https://wiki.duraspace.org/display/DSDOC4x/Batch+Metadata+Editing Nason On 6 March 2015 at 08:47, Hilton Gibson hilton.gib...@gmail.com wrote: Hi Hakan Perahsp this will help: http://wiki.lib.sun.ac.za/index.php/SUNScholar/SQL_Tips Cheers hg *Hilton Gibson* Ubuntu Linux Systems Administrator JS Gericke Library Room 1025C Stellenbosch University Private Bag X5036 Stellenbosch 7599 South Africa Tel: +27 21 808 4100 | Cell: +27 84 646 4758 On 4 March 2015 at 16:36, Hakan Yanaz hakan.ya...@ozyegin.edu.tr wrote: Hi, I want to change document type of all items inserted as Article to article. I do some research about that and the result is : in Postgresql, pgAdmin interface: The metadata_field_id of type field is 66 in metadatafieldregistry table. I can listed all Articles from metadatavalue table where metadata_field_id = 66 and text_value = Article If I change all text_value fields to article which I can listed like above, all things is that? Thanks for any advice. Best Regards Hakan Yanaz -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Saygılarımla *Hakan Yanaz* Kütüphane Teknolojileri Uzmanı [image: Kütüphane] *T * *:* 0216 564 91 58 *M :* hakan.ya...@ozyegin.edu.tr *www.ozyegin.edu.tr http://www.ozyegin.edu.tr/* -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] Batch data change
Hi Hakim, You can also use Dspace batch metadata editing facility, see the instructions at https://wiki.duraspace.org/display/DSDOC4x/Batch+Metadata+Editing Nason On 6 March 2015 at 08:47, Hilton Gibson hilton.gib...@gmail.com wrote: Hi Hakan Perahsp this will help: http://wiki.lib.sun.ac.za/index.php/SUNScholar/SQL_Tips Cheers hg *Hilton Gibson* Ubuntu Linux Systems Administrator JS Gericke Library Room 1025C Stellenbosch University Private Bag X5036 Stellenbosch 7599 South Africa Tel: +27 21 808 4100 | Cell: +27 84 646 4758 On 4 March 2015 at 16:36, Hakan Yanaz hakan.ya...@ozyegin.edu.tr wrote: Hi, I want to change document type of all items inserted as Article to article. I do some research about that and the result is : in Postgresql, pgAdmin interface: The metadata_field_id of type field is 66 in metadatafieldregistry table. I can listed all Articles from metadatavalue table where metadata_field_id = 66 and text_value = Article If I change all text_value fields to article which I can listed like above, all things is that? Thanks for any advice. Best Regards Hakan Yanaz -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] Batch data change
Hi Hakan Perahsp this will help: http://wiki.lib.sun.ac.za/index.php/SUNScholar/SQL_Tips Cheers hg *Hilton Gibson* Ubuntu Linux Systems Administrator JS Gericke Library Room 1025C Stellenbosch University Private Bag X5036 Stellenbosch 7599 South Africa Tel: +27 21 808 4100 | Cell: +27 84 646 4758 On 4 March 2015 at 16:36, Hakan Yanaz hakan.ya...@ozyegin.edu.tr wrote: Hi, I want to change document type of all items inserted as Article to article. I do some research about that and the result is : in Postgresql, pgAdmin interface: The metadata_field_id of type field is 66 in metadatafieldregistry table. I can listed all Articles from metadatavalue table where metadata_field_id = 66 and text_value = Article If I change all text_value fields to article which I can listed like above, all things is that? Thanks for any advice. Best Regards Hakan Yanaz -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
[Dspace-tech] Batch data change
Hi, I want to change document type of all items inserted as Article to article. I do some research about that and the result is : in Postgresql, pgAdmin interface: The metadata_field_id of type field is 66 in metadatafieldregistry table. I can listed all Articles from metadatavalue table where metadata_field_id = 66 and text_value = Article If I change all text_value fields to article which I can listed like above, all things is that? Thanks for any advice. Best Regards Hakan Yanaz -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette