Query about Memento database

[quintas...@gmail.com]

HI All

Been using Memento for a number of years now in a warehouse application. I have a library for all of my arrivals which includes customer details, weight and dimensions etc.

I wanted to create another library for when goods go out we key oin our unique refernece and all the details are pulled over which is fine and i have operational. However if the driver is collecting more than one item i wanted a way to key in the two unique references and Memento combines the weight and dimensions together along with other details automatically.

Would this be possible in anyway?

[Bill Crews]

So, you have a library for Drivers and another for Items, and one is linked to the other with what kind of link-to-entry field? One-to-many or many-to-many? Which is linked to which? How do identify an item? Do you key in an ID or pick from the list of links or pick from a radio-buttons field or what? How do you identify a driver (same choices)?

Weights can be combined by summing them, averaging them, or otherwise. How do you want them combined? How would you combine dimensions? How do you store dimensions? 3 fields of length, width, & height or depth?

If things are simple, using the entries list screen can allow you to aggregate, subtotal groups, filter certain categories of entries, even chart them, etc. If things are more complicated, you can use scripting to combine things, store the combined results, etc.

Ideally, you could spell out your libraries, your fields & field types, and give whatever other info might help us to help you.

--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mementodataba...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/b93c6ce2-9f0b-4613-b2a0-6107bb552ae5n%40googlegroups.com.

[Er Mo]

Hallo

Wie Bill schon Schrieb ist das Summieren von Gewicht einfach . Die Größe dagegen nicht . Man könnte das Gesammtvolumen errechnen , doch bringt das sie weiter ? Mein Ansatz da zu Wäre . Die Daten in einen Eigene Bibliothek kopieren , diese nach Fahre Gruppiren und das Gesammtgewicht Summieren . Da kann man die einzelen Einträge anschauen und die Größe entnehmen . Man konnte die Einträge auch der Größe nach Sortiren ( Fläche oder Länge/ Breite) . Beim Verladen werden die Einträge abgehackt und bestätigt das diese vom Fahrer an Datum übernommen wurden .

Hello
As Bill wrote, summing weight is easy. But not the size. You could calculate the total volume, but does that help you? My approach to there would be . Copy the data into your own library, group them by ride and add up the total weight. There you can look at the individual entries and see the size. You could also sort the entries by size (area or length/width). When loading, the entries are chopped off and confirmed that they were accepted by the driver on the date.

Ernst

[quintas...@gmail.com]

Hi Bill

I am attaching the structure of the two libraries as it might make explaining what i am trying to achieve a bit clearer. The warehouse use the first library to fill in for each complete order that is fulfilled. The second one is where a driver arrives at my depot to arrange collection of the order. However a driver may be collecting more than one order at a time so i was looking for a way to combine two entries in one library into another 

Does this help at all?

[Bill Crews]

I see. The libraries are not linked, but they share a QR number, which acts, I guess, as an order number?

The question I have is what the driver is going to do with the packages and how she'll use the dimensions to determine how to load the truck (I presume). Does the driver need to see all the dimensions and the total of each dimension? The volume of the package doesn't need to be calculated, does it?

What the driver needs to see is by delivery site, yes? Or by QR number?

To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/1d19f348-b38b-49e9-8087-4d473cfb42cdn%40googlegroups.com.

[quintas...@gmail.com]

Hi Bill

Yes the libraries aer not linked but the release note will autofill all the details based on the QR Number. Yes the QR Number is the Unique identifier and acts as an order number

The point of the release note is a driver arrives to collect a number of pieces of cargo and they sign to say they have collected it and it is in good condition that is the point of the second library. 

[Bill Crews]

OK, I'm very close to getting it now. I'm still hung up on just one set of things, and it's the same set that Ernst was asking about.

Given the length, width, and depth and now that I know how the release note is populated, please tell me exactly what you want calculated. What with lengths? Total of all? The same for the widths and the depths. Any combining of length, width, & depth, as in calculating volumes?

And what to do with the calculations. Put them in entries as fields? Add them to the end of any existing text fields? If grouping on QR numbers, will sums at the bottom of each group give the driver what she needs?

To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/6c1e650b-d499-4827-a148-0095ba91f963n%40googlegroups.com.

[Er Mo]

Hallo

Ich würde die Daten für den Fahrer in eine Bibliothek kopieren , so das er die Abmessunge jedes Paket hat . Die Summer der Gewichte kann man Summiren . Wenn der Fahre ein Paket übernommen hat , Quitirt er es in der Bibliothek und der Eintrag verschwindet von der Registerkart für die noch zu Holenten Pakete. Das kann man auch mit Mehrern Fahrer machen . Entweder Eigene Bibliotheken oder Eintrag nach Fahrer Filtern

Hello
I would copy the data for the driver into a library so that it has the dimensions of each package. The sum of the weights can be summed up. When the driver has picked up a package, he acknowledges it in the library and the entry disappears from the pending packages tab. This can also be done with multiple drivers. Either Own Libraries or Filter Entry by Driver

Ernst

[quintas...@gmail.com]

Hi Bill and Ernst,

I dont want anything actually calculated as such i will give an example. lets say in the First library i have QR 123456 which weighs 1kgs and dimensions of 10 x 10 x 10 cms. And in the same library i have QR 654321 for the same client with dims on 11 x 11 x 11 cms

When a driver arrives to collect both orders at the same time i would like to type QR 123456 and it pulls the data over which is fine but then i want to add the details from QR 654321 at the same time so it produces both sets of weight and dimensions. So when i produce a report the driver is signing for both cartons at the same time.

[Bill Crews]

If you have hundreds of QR codes in use, what ties 2 of them together, like 123456 & 654321 as opposed to all the others? Are they assigned to the same truck at some point in the process? Is the driver trying to load the truck based on weight or volume or dimensions or based on the route to be taken in delivery or how? Are we trying to support the driver's work, the work of warehouse people assigning loads to trucks or whom?

What will make it work well will mostly be the database design & how things are linked together. Maybe we should see your current take on that.

To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/53bf8e59-a4a8-4941-908e-5e57dd90c99dn%40googlegroups.com.

[Er Mo]

Hallo

Ich sehe das So : Ein Fahrer holt Pakete ab. Wenn es mehrerere sind , sollten diese in einer Liste zusamengefast werden . Der Fahrer bestätigt diese Liste und nicht jedes einzelne Paket . Es geht hier nicht um die Art der Zusammenstellung sonder wie man zu eine Liste kommt . Habe ich das so Richtig verstanden ?

Hello
I see it like this: A driver picks up packages. If there are several , they should be summarized in a list . The driver confirms this list and not each individual package. It is not about the type of compilation but how to get a list. Did I understand that correctly ?

Ernst

[quintas...@gmail.com]

HI Bill, 

The field that ties them together is the client so 123456 and 654321 could be for the same client just two seperate orders. What Ernst suggests is basically correct consider the library a manifest of cargo leaving a depot at a specific time. and the driver signs to confirm that they have collected all of the cargo mentioned on the list.