[Module] fast_content_csv

[Guest]

Welcome, Guest. Please login or register.
Did you miss your activation email?

1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[SamZ]

fast_content_csv_v03
Sample of csv file in attachment.

Module to import data from csv files
1. Save with code as a new module with name fast_content_csv
2. Copy file "data.csv" to your /assets/files/ folder
4. Change t_catalog and t_tovar to your value ( or set them to 1.)
5. Than just insert parent id and filename and push "Run"
p.s. You can use debug mode(debug=1) to run module without inserting data into Data Base
You can use delete param

[Dimmy]

Nice, in what order does de cvs needs to be? and is it also posible to export to cvs?

[SamZ]

Nice, in what order does de cvs needs to be?

cvs file in attachment
samething like this.

Code:

parent1;
;child 1
;child 2
;child 3
parent2;
;child 1
;child 2
;child 3
parent3;
;child 1
;child 2
;child 3

where parent1and child1 = pagetitle

and is it also posible to export to cvs?
Not now. But it is not difficult to realise. May be layter.

[SamZ]

New version is available.
bug fix
+ add "content" fild

Code:

parent1;
;child 1;content1
;child 2;content2
;child 3;content3
parent2;
;child 1;content1
;child 2;content2
;child 3;content3
parent3;
;child 1;content1
;child 2;content2
;child 3;content3

where
parent - pagetitle of parent page
child - pagetitle of child page
content - content of child page

[SamZ]

If samebody had test my module, I an waiting for bug report.
And wish list

[lukwe]

Hi, very interesting module, congrats!

I did not have a chance to test it, but I think the natural evolution of this would be to include in the CSV the whole set of controls found in the editing page for a document, i.e. published/cacheable, DocGroups, TVs, keywords..

[SamZ]

Hi, very interesting module, congrats!

I did not have a chance to test it, but I think the natural evolution of this would be to include in the CSV the whole set of controls found in the editing page for a document, i.e. published/cacheable, DocGroups, TVs, keywords..

New version of module fast_content_csv.zip is avalabel. It supports TV.

[rthrash]

Excellent news SamZ ... this is a very handy module indeed. I hope to test soon. Thanks!

[AndreasT]

This is very interesting.

The sample file seems very limited and the text is unreadable, is it possible for you to provide a more complete sample file with examples of all the fields supported, preferably in english please?

Thanks.

Cheers,

Andreas

[sottwell]

I would put each field through $modx->db->escape(), and would also use trim() instead of the ereg_replace:

Code:

 
$parent_title = $modx->db->escape(trim($parent_title));
$page_title = $modx->db->escape(trim($page_title));

[SamZ]

I would put each field through $modx->db->escape(), and would also use trim() instead of the ereg_replace:

Code:

 
$parent_title = $modx->db->escape(trim($parent_title));
$page_title = $modx->db->escape(trim($page_title));

I use this module just by my self.
Because of that I don't use esceping.
And row php function works more fast. I understood it when was working on complex import from text files (4 files about 3mb size) to MODX 5000doc and 400000tv _http://kipby.com/test/ 

[Bruno17]

Have Rewritten this usefull module for me and for everbody, who wants to use it.

module:fast_content_csv
Rewritten by Bruno b.perner@gmx.de
First Release by SamZ samz@fromru.com
v.05
Module to import data from csv files
1. Upload the files in /assets/modules
1. Save this code as a new module with name fast_content_csv
2. Copy csv files to your /assets/files/folder
3. Start the module
4. Than just insert parent id and defaults in default.csv (you can do it in the module) and save it
5. Choose the source-file and the template, if not in default.csv or your csv-file from dropdown
6. Push the Button Get Fields
7. In the next form choose the fields you want to insert or update, if not autodetected or choose ----empty if you not want to update this field
8. Make sure to choose update or insert and you are not in Testmode (checkbox) and pusch RUN
TIP: You can generate CSV-files from documents and its TVs easy with Ditto
##################################
changelog:
#
Release v05 Bruno b.perner@gmx.de
New:
fast_content_csv.class.inc.php
autodetect fieldnames for docs and TVs from first line
drop-downs to set fields manually
drop-down for csv-files and templates
use defaults from default.csv
change and save values of defaults.csv directly in the module
update docs and TVs from csv with given docid
and some little features more.
#
Release v035 by SamZ samz@fromru.com
###################################

*/

You can download my version here: http://modxcms.com/forums/index.php/topic,29616.msg180038.html#msg180038

[a.tuzhilkin]

bad archive! reload plz.

[Bruno17]

did download it and opened it without problems.
anybody else?

[AndreasT]

Worked fine for me. Unzipped without issues. Haven't testet it yet tho.

Cheers,

Andreas