Import product data from xl spreadsheet / customisation of administration interface

Next topic

Author	Message
steve walker	Tuesday 01 June 2004 6:18:44 am Hi there, I'm currently spec'ing up a big design project, and trying to see if Ez is able to deliver these pretty high level functionality specs - I think the answer will be yes... I am setting up a site that sells diamonds and associated products. First question is: is it possible for the product data to be updated via an import of data from a xl spreadsheet. I have seen some references to an EzTrade module that sounds as though it would do the job, but cant find the module...has it turned into the 'shop' tag in Ez version 3?... also, there is the 'plugin' to ERP systems, but I dont think this will interface with something as basic as Excel. Second question: is it possible to customise the admin interface - if I cant import external data, I'd like to give some customised views of products... for instance, a page that lists all the diamonds with their prices and discount rates etc, similar to a spreadsheet, so that the client could go through the list, make changes to any prices etc as required, and then submit price changes in one fail swoop... instead of having to go through each product one by one?? Any ideas, thoughts and feedback of any sort greatly appreciated. Regards, Steve. http://www.oneworldmarket.co.uk
steve walker	Tuesday 01 June 2004 6:29:22 am Hi, I have found some useful stuff via: http://www.ez.no/ez_publish/documentation/development/importing_attribute_data and the thread found at: http://ez.no/community/forum/developer/content_import_questions Its still all pretty experimental stuff - does anyone know of any developments since then? Steve http://www.oneworldmarket.co.uk
Mark Marsiglio	Tuesday 01 June 2004 8:05:22 am Did you look at the content import function descriptions for eZ 3.4? This is supposed to be one of the new features... Also, there may be a chance at the ERP plug in working, only because Excel does support ODBC, and you would just have to be able to map the data structure correctly for your spreadsheets. I have not used this plugin, though, so that is speculation. In regards to the admin interface, it can be customized just as the user site can - using overrides and custom .tpl files. Beware, though, there are a lot of templates in the admin/standard design folders (base folder in 3.4). Designing an entirely new inteface is possible, but would be time consuming. In my project, we created a few custom templates for displaying our own classes in the admin, and we removed the store tab from the interface because it was not used. These changes were both very easy. Adding a new template would also be quite easy. http://www.thinkcreative.com Turning Ideas Into Strategic Solutions
steve walker	Thursday 03 June 2004 12:20:31 am Mark, Thanks for your input. I cant locate the 'content import function descriptions' - I find the links as I pasted in above, but nothing succinct. It would be great to develope an admin extension that allows the input/output of data, something similar say to when you syncronise a PDA with outlook contact database... The ODBC aspect of XL is interesting... In terms of admin customisation, if I can get the data inport to work well, I dont need to worry about creating new product listing views... we shall see. Alex and others have made some inroads into data importing, but it looks pretty high level stuff - I'll post any success I have here. Steve. http://www.oneworldmarket.co.uk

eZ debug

Timing:	Jan 18 2025 19:34:31
Script start
Timing:	Jan 18 2025 19:34:31
Module start 'layout'
Timing:	Jan 18 2025 19:34:31
Module start 'content'
Timing:	Jan 18 2025 19:34:32
Module end 'content'
Timing:	Jan 18 2025 19:34:32
Script end

Main resources:

Total runtime	1.3057 sec
Peak memory usage	4,096.0000 KB
Database Queries	60

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0057	589.5234	152.6875
Module start 'layout'	0.0057	0.0047	742.2109	39.5547
Module start 'content'	0.0104	1.2941	781.7656	548.4688
Module end 'content'	1.3044	0.0013	1,330.2344	12.0625
Script end	1.3057		1,342.2969

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.2633	16	0.0002
Check MTime	0.0013	0.1019	16	0.0001
Mysql Total
Database connection	0.0008	0.0584	1	0.0008
Mysqli_queries	1.2540	96.0408	60	0.0209
Looping result	0.0005	0.0404	58	0.0000
Template Total	1.2701	97.3	2	0.6350
Template load	0.0018	0.1412	2	0.0009
Template processing	1.2682	97.1254	2	0.6341
Template load and register function	0.0002	0.0133	1	0.0002
states
state_id_array	0.0012	0.0893	1	0.0012
state_identifier_array	0.0019	0.1431	2	0.0009
Override
Cache load	0.0015	0.1187	30	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0509	2	0.0003
Fetch class attribute name	0.0014	0.1080	5	0.0003
XML
Image XML parsing	0.0005	0.0374	2	0.0002
class_abstraction
Instantiating content class attribute	0.0000	0.0008	5	0.0000
General
dbfile	0.0006	0.0471	15	0.0000
String conversion	0.0000	0.0008	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
4	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 11 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs