Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

how can i build a price list?
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: how can i build a price list?
#56343
how can i build a price list? 9 Years ago Karma: 0
hello,

be so kind and check this site.
what can i do if i need a table with e.g. five splits because i see just two → ID and title please.

what can i do with this model please:

SELECT
id,
title
FROM
#__content

can you help please?

best regards,
knut
The administrator has disabled public write access.
 
#56344
Re:how can i build a price list? 9 Years ago Karma: 760
Hello,

Specify columns which you want to retrieve from database tables in SELECT SQL query. For example:

SELECT
id,
title,
created_by
FROM
#__content

This query gets data from #__content Joomla! database table. You can retrieve data from your table.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#56345
Re:how can i build a price list? 9 Years ago Karma: 0
hello,

... okay, thanks.
but how can i get a price list with content which are not in any joomla article?
how and where can i write aricles with prices please.

now all content from joomla are listed in the table but i need a list with for e.g.

1 shoe EUR 25,00
2 shoes EUR 50,00
3 shoes EUR 75,00
...

best regards,
knut
The administrator has disabled public write access.
 
#56346
Re:how can i build a price list? 9 Years ago Karma: 760
It is possible to load data from any database tables. It is just a sample query which retrieves data from #__content table. The extension can also show data from CSV files. Where data about prices are stored?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#56347
Re:how can i build a price list? 9 Years ago Karma: 0
hello,

please have a look at the attachement. i changed from sql to csv and have build from excel a csv file.
please have patient.

best regards,
knut

"ARI Data Tables": server side pagination is not used because currently it is supported only by "ARI Data Table" widget for "SQL" source type.
Last Edit: 2015/11/23 19:12 By view2lord.
The administrator has disabled public write access.
 
#56348
Re:how can i build a price list? 9 Years ago Karma: 760
If you want to show data from a CSV file (not MS Excel file), upload it to your server, set "Choose source type" parameter to "CSV" value in module settings, enter path to the CSV file in "CSV -> Path to CSV file" parameter. For example if path to file is <joomla_directory>/reports/data.csv then populate the parameter with reports/data.csv value. Set "Server side pagination" parameter to "No", it doesn't work for data from CSV files.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 1