[Module] fast_content_csv_v09

718 Posts

Paprikas Reply #21, 17 years, 8 months ago

Thanks man laugh

718 Posts

Paprikas Reply #22, 17 years, 5 months ago

Hi. I have a problem.
I’m trying to export all childs. Do all things like in tutorial. After "Run" button. (When using plugin - same effect)

« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY id ' at line 8 »
      SQL:  SELECT DISTINCT sc.* FROM (`database`.`modx_site_content` AS sc) WHERE 1 and CAST(sc.`id`AS CHAR) IN () ORDER BY id ASC

Even if I create new action and just put [#t#id:childIds=`:1`#t#] to id doc-field I will receive same bug.
Help sad

0.9.1 works ok. But it doesn’t containt export-all function.

83 Posts

rajfantastic Reply #23, 17 years, 5 months ago

I have successfully installed the fast_content_csv_v09 module and plugin, however i am having trouble creating a proper csv file with document fields and TVs included.

when exporting via plugin from a parent document, all fields are empty and the csv is "empty".

when exporting via plugin from a child document the fields are filled however the csv is still "empty"

"empty" csv:

id;type;contentType;pagetitle;longtitle;description;alias;link_attributes;published;pub_date;unpub_date;etc...

when exporting from module i receive this error:

MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and CAST(sc.`pagetitle`AS CHAR) = "" and CAST(sc.`alias`AS CHAR) = "" and CAST' at line 32 »

also this error in modx event log:

Undefined index: chooseworkspace

which tag should i enter in order to export all tv values?

i am willing to write english documentation if i can figure this out wink

stevesunderland.com
GRAPHICS | INTERACTIVE | MARKETING
xhtml + ajax + seo websites powered by modx

9 Posts

luckymarina Reply #24, 17 years, 4 months ago

Hi! Are there some tutorials/documentation in English (how to install and use "fast_content_csv_v09") for those, who are short time with Modx CMS???

26 Posts

ilyt Reply #25, 17 years, 3 months ago

How to make the documents were imported with the same ID as the csv file?
I first export the documents.
And when imports go astray relations parent-children sad

5,888 Posts

Bruno17 Reply #26, 17 years, 3 months ago

the IDs of inserted Documents are autoincrement. You can and should not overwrite them. If you have Documents in Place with teh same IDs as in your CSV-file you can update them with your new datas.
you can export/import the old IDs to another (new) field, name it ’oldID’, create a TV for that or use another empty field and reference to this field as parent on importing.

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

26 Posts

ilyt Reply #27, 17 years, 3 months ago

Is there a way through the module to import documents while preserving the structure of an enclosure?

9 Posts

luckymarina Reply #28, 17 years, 3 months ago

Can somebody type how to use fast_content_csv step by step in English because Tutorial is in Deutch (but I don’t know it). Thanks

5,888 Posts

Bruno17 Reply #29, 17 years, 3 months ago

what have you done so far and what are you about to do?

I can try to help (If I find the time for it), when you give me more infos about what you want to do with fast_content_csv
Bruno

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

26 Posts

ilyt Reply #30, 17 years, 3 months ago

How to import a file of this type by using your module?
Simple content of my csv file:
===================================================
id;pagetitle;parent;content;price
8;Computer;2;;
9;Laptope;2;;
10;Mobile;2;;
11;CPU;2;;
12;Motherboard;2;;
13;Memory;2;;
14;HDD;2;;
18;Product 1;8;;1000
19;Product 2;9;;10000
20;Product 3;10;;541
21;Product 4;11;;260
22;Product 5;12;;74
23;Product 6;13;;46
24;Product 7;14;;51
28;Product 8;8;;150
29;Product 9;8;<p>Lorem ipsum</p>;240
30;Product 10;12;;84
31;Product 11;12;;94
===================================================