ExData Module v2.8.0 - Tables, Lists and more…
fixed sorting by date?
hallo zusammen..
zuallererst tausend dank für diesen umfangreichen und ausgefuchsten mod.
heute habe ich mich mal herangetraut, ihn für ein aktuelles projekt in einsatz zu bringen und bin just auf ein problem gestossen, für dessen lösung ich diesen thread bemühen möchte..
in diesem speziellen falle würde ich meine listings gerne ohne sort-dropdown, stattdessen mit vordefiniertem sorting nach erstellungsdatum (ASC oder DESC) darstellen.
ein bisschen trial&error mit den mod-quellen brachte keinen effekt - deswegen hier ein hilferuf in der hoffnung auf lösung..
--short summary in eng--
right now i'm trying to deal with it's features and was in need of private templates, but not of sorting-dropdown.
for this actual project i'd prefer to predefine a sorting of creation-date by ASC or DESC for my listings ('exd_entries'/'date' !?).
is there a possibility!?
ups, vergessen: phpwcms 1.2.6, ex-data 2.5.1
zuallererst tausend dank für diesen umfangreichen und ausgefuchsten mod.
heute habe ich mich mal herangetraut, ihn für ein aktuelles projekt in einsatz zu bringen und bin just auf ein problem gestossen, für dessen lösung ich diesen thread bemühen möchte..
in diesem speziellen falle würde ich meine listings gerne ohne sort-dropdown, stattdessen mit vordefiniertem sorting nach erstellungsdatum (ASC oder DESC) darstellen.
ein bisschen trial&error mit den mod-quellen brachte keinen effekt - deswegen hier ein hilferuf in der hoffnung auf lösung..
--short summary in eng--
right now i'm trying to deal with it's features and was in need of private templates, but not of sorting-dropdown.
for this actual project i'd prefer to predefine a sorting of creation-date by ASC or DESC for my listings ('exd_entries'/'date' !?).
is there a possibility!?
ups, vergessen: phpwcms 1.2.6, ex-data 2.5.1
sorry but I don't know ? and also I don't know where to look.DeXXus wrote:What file settings do you have for your .CSV file?
I have arange the csv file a litle and now I get this error:
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 'Ambrosio', 'Plaza Romania', 'Bucuresti', '021/200.00.00', '021/200.00.00', 'info' at line 1
Packging design,labels, catalogs,postcards,
Ok the problem is that I have a excel file that is big around 800 entries and is made like this:
Name | City | Phone | e-mail | web |
Nino |**** | 11111 |a@x.com |www.w.com
But some of the filds like the phone number have 2 or 3 phone numbers with deviders lik ; or . - is possible that this is the reason whi is not working?
Is importing a few entrys the first 3 but not the rest.
Packging design,labels, catalogs,postcards,
yeps, that's the problem, you'll have to replace all the ; and then the | with ;culda_a wrote:Ok the problem is that I have a excel file that is big around 800 entries and is made like this:
Name | City | Phone | e-mail | web |
Nino |**** | 11111 |a@x.com |www.w.com
But some of the filds like the phone number have 2 or 3 phone numbers with deviders lik ; or . - is possible that this is the reason whi is not working?
Is importing a few entrys the first 3 but not the rest.
Cheers
1.3 out, testing, testing...
Sponsoring 4 phpwcms Blog and Usermanagement
Sponsoring 4 phpwcms Blog and Usermanagement
Ok the exemple that I give you with this sign | - that sign I try to simulate the colomns in excel sorry if i misslead you .... so the data is in coloms and rows and the first row in the colomn is the title and the second row in the colomn tha entry ... so I have insert the same titles in the Exdata module but I get that error :yeps, that's the problem, you'll have to replace all the ; and then the | with ;
Cheers
andFatal error: Unable to open csv file in /include/inc_module/mod_exdata/inc_lib/exdata.class.csv.php on line 160
any sugestions? how can I save the excel fil in CSV file in order to be imported right?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 'Ambrosio', 'Plaza Romania', 'Bucuresti', '021/200.00.00', '021/200.00.00', 'info' at line 1
Packging design,labels, catalogs,postcards,
You'll really have to 'clean' you excel data first.
Some ways of doing (testing it):
1) Test with a little .CSV file (exmaple: 4 entries) well formatted and see if it works. (if ok--> proceed else... well... ???
2) in excel look for the funny signs ( ; . / ) and replace them with something you can identify (example: rororo ) then export as .CSV choosing the ; as separator.
that is a start, dunno if it's the final solution...
also check that all the fields correspond (no '' empty fields or such...) sometimes mysql doesn't like /. or such, interprets those like commands
Cheers
Some ways of doing (testing it):
1) Test with a little .CSV file (exmaple: 4 entries) well formatted and see if it works. (if ok--> proceed else... well... ???
2) in excel look for the funny signs ( ; . / ) and replace them with something you can identify (example: rororo ) then export as .CSV choosing the ; as separator.
that is a start, dunno if it's the final solution...
also check that all the fields correspond (no '' empty fields or such...) sometimes mysql doesn't like /. or such, interprets those like commands
Cheers
1.3 out, testing, testing...
Sponsoring 4 phpwcms Blog and Usermanagement
Sponsoring 4 phpwcms Blog and Usermanagement
I try this to but ... hmm I don't know maybe I will post a screenshot to see how is look like the excel file
here is how the data is inserted in excel... this is only exemple coz the file is biger ...
so any Ideea how to import a file like this .. I have save as from excel in CSV (Comma delimited) and is not working.. I ghet the errors above or this error
CSV-File is not semi-colon divided! Please check the file.
Rows should look like: value1;value2;value3;value4
here is how the data is inserted in excel... this is only exemple coz the file is biger ...
so any Ideea how to import a file like this .. I have save as from excel in CSV (Comma delimited) and is not working.. I ghet the errors above or this error
CSV-File is not semi-colon divided! Please check the file.
Rows should look like: value1;value2;value3;value4
Packging design,labels, catalogs,postcards,
To change the default List Separator on your PC:culda_a wrote:CSV-File is not semi-colon divided! Please check the file.
Rows should look like: value1;value2;value3;value4
-Bring up your default options window by clicking Start -> Settings -> Control Panel -> Regional Settings.
-Click the "Number" tab and in the "List Separator" field, replace the current default separator with the one you want to use. (semi-colon ?)
Thanks it works... and also I had to take out all the signs like this:
' or " or; and then was ok..but I still donn't know how to this:
Is there a way to sort the entry after content? I mean in the drop down menu to have a way to view the content from one fild
for exemple in one fild I want to add citys : Berlin, Vien, Amsterdam so on...
is there a way to make this city to apear automaticly in drop down menu in ordere to select the city that I want but not to be seen by the people only in the drop down menu .... and when I select for exemple city **** to show me all the entrys that has city ****.
I don't know if I was quite clear! in a few words I want to have a select criteria with more options not only drop down.
I try to use search from phpwcms but is not reading the content of the exdata module.
any sugestions?
Thanks
' or " or; and then was ok..but I still donn't know how to this:
Is there a way to sort the entry after content? I mean in the drop down menu to have a way to view the content from one fild
for exemple in one fild I want to add citys : Berlin, Vien, Amsterdam so on...
is there a way to make this city to apear automaticly in drop down menu in ordere to select the city that I want but not to be seen by the people only in the drop down menu .... and when I select for exemple city **** to show me all the entrys that has city ****.
I don't know if I was quite clear! in a few words I want to have a select criteria with more options not only drop down.
I try to use search from phpwcms but is not reading the content of the exdata module.
any sugestions?
Thanks
Packging design,labels, catalogs,postcards,
Please have a look at the auto-template-example:
http://web.casa-loca.com/index.php?exam ... o-template
AND a highlighter-effect for the rows on mouseover
all the above functions and some more enhancements will be in V2.55 release available in some days.
http://web.casa-loca.com/index.php?exam ... o-template
Will be doable with css, 2 classes for two background colorsDF6IH wrote: Would like to suggest to have rows with two different colors.
AND a highlighter-effect for the rows on mouseover
Almoust finished. Comes for auto-templates with options (show/hide, sortfiled=filter or defined field=filter, ignore visibility) and a none-option-version for private-templatesculda_a wrote: Is there a way to sort the entry after content?
Done. It's in beta-testing.yoshi01 wrote: for this actual project i'd prefer to predefine a sorting of creation-date by ASC or DESC for my listings
all the above functions and some more enhancements will be in V2.55 release available in some days.
- marcus@localhorst
- Posts: 815
- Joined: Fri 28. May 2004, 11:31
- Location: localhorst
- Contact: