I also have a client with a pretty complex categorisation, and the thought
of entering thousands of item using the admin, well not on, so I had to get
a grip on the relationship between the tables department, department-item,
and item (and sku).
I initially built up the departments but did not insert any items (well
just a few to see how it worked) then exported it all and shovelled the
tables into Excel where the relationships became more apparent. Then I
built the item table in Excel, linked deptartments to items in the table
department-item and imported it all back in. Works fine
At 12:37 14/08/00 -0400, you wrote:
>Leon,
>The client has decide on a fairly complex department structure. There are
>about 100 departments and they are structured something like:
>
>Department1
> SubDepartment1
> SubSubDepartment1
> Items
> SubSubDepartment2
> Items
> SubDepartment1
> SubSubDepartment1
> Items
> SubSubDepartment2
> Items
>Department2
> SubDepartment1
> SubSubDepartment1
> Items
> SubSubDepartment2
> Items
> SubDepartment1
> SubSubDepartment1
> Items
> SubSubDepartment2
> Items
>
>I am wondering if this is too many department levels for the admin gui
>screen.
>
>Kathleen
>
>
>::-----Original Message-----
>::From: [EMAIL PROTECTED]
>::[mailto:[EMAIL PROTECTED]]On Behalf Of Leon Atkinson
>::Sent: Monday, August 14, 2000 12:04 PM
>::To: FreeTrade
>::Subject: RE: [FreeTrade] admin department items screen choking
>::
>::
>::I did a test once where I inserted many, many items. I can't find where
>::I talked about it on the list, though. Anyway, I think I had 10,000
>::items divided into 10 departments, and there were no problems with the
>::admin or the department/item screens. The quickorder screen choked, of
>::course because an HTML table with 10,000 rows is a bit over the limit.
>::
>::It's possible the code for the admin screen has changed in some way.
>::I'll try to get to testing it today.
>::
>::Leon
>::
>::> -----Original Message-----
>::> From: [EMAIL PROTECTED]
>::> [mailto:[EMAIL PROTECTED]]On Behalf Of Kathleen Ballard
>::> Sent: Monday, August 14, 2000 4:50 AM
>::> To: FreeTrade
>::> Subject: [FreeTrade] admin department items screen choking
>::>
>::>
>::> Dear List,
>::> I am in the process of importing data from existing .txt files to the ft
>::> tables.
>::>
>::> I have approx. 2100 items and 100 departments. After inserting
>::about 2500
>::> records into the department_item table, the departments and items admin
>::> screen stopped displaying. Testing showed that I can have about
>::> 500 of any
>::> of those records. More than 500 will cause a 2013 mysql error
>::> with the page
>::> displaying incompletely and all 2500 causes the page to not
>::> display at all.
>::>
>::> Has anyone else experienced this?
>::>
>::> I did check the list archives and found a reference to problems
>::> with the gui
>::> display and corrupted image files. I have reuploaded all the ft images.
>::>
>::> Kathleen
>
>
>
>------------------------------------------------------------
>To subscribe: [EMAIL PROTECTED]
>To unsubscribe: [EMAIL PROTECTED]
>Site: http://www.working-dogs.com/freetrade/
>Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
