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


Recent Events
  • 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.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


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? 8 Years, 5 Months 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? 8 Years, 5 Months ago Karma: 747
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? 8 Years, 5 Months 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? 8 Years, 5 Months ago Karma: 747
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? 8 Years, 5 Months 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? 8 Years, 5 Months ago Karma: 747
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