1
August 2012
Magaya Corporation has been working on a
major project that many customers have asked
for – integrating Magaya software with UPS
and FedEx.
For many Magaya customers, shipping pack-
ages using UPS and FedEx requires entering
data into a separate system, despite having
all the package and customer details in your
Magaya system already.
With the new integration, there will be no need
to enter duplicate data, which is time consum-
ing and potentially error prone.
How it will Work
The integration will solve this issue by adding
an option in the Magaya Explorer for creating
domestic Pickup Orders, Cargo Releases, and
Shipments. You can select how you want to
ship items, via FedEx or UPS. Other vendors
may be added in the future.
The customer name, delivery address, and all
the item dimensions and description will be
automatically transferred from your Magaya
system and included in the transaction. Then
you receive the label from FedEx or UPS elec-
tronically. The labels are saved in your system,
and you can print them as needed and place
them on the boxes so they are already identi-
fied when FedEx or UPS arrives.
Your Magaya system retrieves the latest status
information from FedEx or UPS and saves it
in the Events section of the transaction. Your
customers can see the updates in Magaya
LiveTrack or with a Transaction Tracking link.
Functionality of the integration is being fine-
tuned by the Magaya Development Team to
ensure the software integration is easy to use
and meets our customers’ needs. Tests will be
conducted in September 2012, and the release
is planned after quality assurance testing is
completed.
Click here to Continue
FedEx and UPS Integration
New Magaya YouTube Channel!Check it out. Now access our training videos and more
on YouTube from anywhere at any time.
MagayaInsiderthe
Welcome to the August 2012 edition of the Magaya Insider.
This edition of the Magaya Insider newsletter shows you how to make your database run
faster using the new optimization features in the latest software version, 8.5. We’ll show you
how to reduce the size of the database, and see how version 8.5 will save even more space
by backing up all photos outside your Magaya database.
This month’s case study features Prime Air & Ocean Cargo, a freight forwarder based in Mi-
ami, Florida, that started in Ecuador shipping flowers and now ships all kinds of freight world-
wide. Their Miami office uses the Magaya Cargo System to receive, store, and ship everything
from small packages in the warehouse to offering quotes to customers shipping to and from
many other locations.
Note from the Editor
In the Works
TopicsHow to Improve Your Database
Speed
Read More +
Prime Air & Ocean Cargo
Magaya software version 8.5 brings you new features that will help optimize your Magaya database. When you update to version 8.5, these optimiza-tions are not required to use the new version but they are recommended, especially for companies with large data-bases.
Prime Air & Ocean Cargo is a freight forwarder, bonded com-mon carrier, OTI and NVOCC located in Miami, FL. They are a CNS endorsed cargo agent and have a global network of offices, including New York, Amsterdam, Quito, and work with agents in many other locations.
Read More +
2
MagayaInsiderthe
How To
Magaya software version 8.5 brings you new features that will help optimize your Magaya database. When you update to ver-sion 8.5, these optimizations are not required to use the new version but they are recommended, especially for companies with large databases.
Please note: Make a backup of your data and update to version
8.5.
1. RecyclingThe first step toward having an optimized database in version
8.5 is recycling some records to reduce the amount of records
the database holds. The smaller the database, the faster it runs.
If you have a lot of transactions in the Transaction Log, clean it
before starting the recycling. To clean the Transaction Log, click
Options > Transaction Log. In the list, click the Actions button
and select Clean up Transaction Log.
Follow these steps in this order:
In Magaya software version 8.5, go to the new Configuration
option, “Maintenance & Performance”:
1. Check the box to “Allow the system to recycle the following
records.”
2. Click the “Configure” button. A dialog box opens. It displays a
list of records your database keeps.
3. To keep your database smaller, reduce the number of days
the records are kept by changing the default to as few days
as possible. For the Transaction Log, Received Messages,
Sent Messages, we recommend selecting 30 days or 60 days.
The others can maintain the default setting or change them
according to your needs.
4. Click OK to save and close the dialog box.
5. Click “Save” in the Maintenance & Performance Configuration
screen.
You can continue working while this recycling is in process. This
setting can be adjusted at any time. The system will continue to
recycle the records to free up space according to the settings
you make here.
2. Extract Heavyweight Data
Magaya software version 8.5 has changed the way it saves im-
ages and attachments. It now extracts photos and saves them
outside the database to improve database performance. These
extracted files are called “Blob” files (or unstructured data).
If you have a large number of photos or files attached to transac-
tions, you will see a difference in the speed of your system after
this process.
Go to the “Maintenance & Performance” Configuration screen:
1. Check the box: “Allow the system to extract heavyweight
data… .” Click “Save”.
You can continue working while this is in process, but your
system may be slow. The amount of time this takes depends on
Click here to Continue
Click here to go to Page 1
Improve Your Database Speed
2
How To
3
MagayaInsiderthe
How Tohow much data you have in your system.
2. When this is complete, the system creates a Task to notify
you that the system is done extracting photographs and large
files currently in your database. Click “Set Completed” in the
Task Reminder dialog box.
Now your system will continue to extract all photographs that
you add to transactions such as Warehouse Receipts in the
future.
The 8.5 version of Magaya software saves these extracted files
in a folder called “Blobs” (inside the “Data” folder). Here is an ex-
ample of where to find the Blobs folder. Your location may differ.
You will need to copy these files separately; they are not copied
during the backup process. When you backup your system, just
copy this folder to another location. Additional details are avail-
able in the Magaya Software Customization Manual, Chapter 8
“Magaya Database Administration”.
3. Shrink Historical DataAnother way to improve your database performance is to shrink
all historical, legacy data in the database. Follow these steps:
1. In the “Maintenance & Performance” configuration menu,
check the box “Allow the system to shrink the size of histori-
cal data.”
2. Save.
3. When this is complete, the system creates a Task to notify
you that the system is done.
4. Shrink the Database
The last step we recommend is to shrink the database itself:
1. Make sure all users are logged off.
2. Stop the Magaya Communication Server.
3. Make a backup of your Magaya database.
4. Stop the Magaya Database.
5. Open the Magaya Database Server Agent dialog box from the
taskbar.
6. Click “Tools” and select “Shrink Database”.
7. Make sure the two checkboxes are checked:
Find and clean all the records that are no longer in use. •(Garbage Collector)
Run a process to reduce the size of the database files. •(Shrink Database)
8. Type “Yes” in the box to proceed.
9. When the process is completed, a dialog box tells you the
size of the database.
10. Start the Magaya Database.
11. Start the Magaya Communication server.
The system is now optimized to process and save data more
efficiently in the future. You will not need to perform this task
again. Your Magaya software is ready to use, with all the new
features in version 8.5. See Magaya.com for features and
tutorials.
Click here to Continue
Click here to go to Page 2
4
MagayaInsiderthe
New CustomersNew Customers in July 2012 Magaya Corporation welcomes the following 33 new companies that joined the Magaya Network Community
• Emjay Global, Randallstown, Maryland• Azap Motors, Jacksonville, FL
• Biotech Corp., Medley, FL
• Blue Cargo Group, LLC, Miami, FL
• J. A. Global Trading Corp.,
Pompano Beach, FL
• JL Cargo, Miami, FL
• Lemon Log, Miami, FL
• Merxtrod, Inc., Miami, FL
• Coltrans (USA) Miami, FL
• Overseas Forwarding Corp., Miami, FL
• Alterri Distribution Ctr. Laredo,
Texas
• Panandina Logistics, Dallas, Texas
• Trans World Logistics, Great Neck,
NY
• Metropolitan Warehouse, Linden,
NJ
• Sava Group, Los Angeles, CA
• Trico Maritime International,
Harbor City, CA
• Gamas Global Logistics, Nogales,
Arizona
In Maryland:
Click here to Continue
Click here to go to Page 3
In Florida:
In Texas:
In New York & New Jersey:
In California:
In Arizona:
• Pine Logistics, Billerica,
Massachusetts
• ATDS, Dubai, United Arab Emirates
• United World Line (EUR) Zevenbergen,
The Netherlands
• C.E.O. International Cargo, S.A., Santo
Domingo, Dominican Republic
In Massachusetts:
In UAE:
In Europe:
In the Caribbean:
More on the next page ...
4
New Customers
5
MagayaInsiderthe
New CustomersNew Customers in July 2012 Continued
• Air Sea Worldwide Panama, S.A.
Panama City, Panama
• Cargoways Mexico, Mexico City,
Mexico
• Cargo Xpress Logistic S.A., Panama
City, Panama
• Fletes Consolidados, S.A. Panama
City, Panama
• Ground Cargo Transportation (Costa
Rica) in San Jose
• Panama Consolidation Services,
Inc. (PCS PANAMA WHSE), Colon,
Panama
• South Cargo LLC, Colon Free Zone,
Panama
• Ground Cargo Transportation (Bolivia)
in La Paz
• SCL Cargo, Santiago, Chile
• TKARGA Limitada, Bogota, Colombia
• United World Line (BRL) Jundiai-SP,
Brazil
In Mexico and Central America: In South America:
Click here to Continue
Click here to go to Page 4
Be sure to join us on our LinkedIn
Group: The Magaya Network Community!
We welcome our new members and look forward to working with each company. See the profiles of the new customers in the Magaya Network Communication Center in your Magaya Explorer interface to find and connect with new partners in our unique network.
Magaya Corporation will be at the Houston BreakBulk Americas conference
Join us from October 9-11 at George R. BrownConvention Center
Houston, Texas
Logistics Software Solutions
Visit Us: Booth #853 Register at breakbulkevents.com
Following the Flowers to Success
Service, Quality, Details Form the Basis of Prime Air & Ocean Cargo
Prime Air & Ocean Cargo started shipping flowers from Ecuador and now incorporates their experience into shipping all kinds of cargo worldwide.
,,,,
Our carrier background helps us understand all the details in the supply chain.
Roger Paredes, President, Prime Air & Ocean Cargo
CASE STUDY:
Prime Air & Ocean Cargo Freight Forwarder
ChallengesShipping perishables requires attention to detail and relationships with
quality vendors in every step of the supply chain. Prime Air & Ocean
Cargo (PA&OC) got its start shipping flowers from Ecuador to Miami
and Amsterdam. Today the company has grown to offer complete
logistics services worldwide for all types of cargo.
President of Prime Air & Ocean Cargo, Roger Paredes explained the
steps involved when shipping a perishable such as flowers. When
flowers are harvested from the fields and greenhouses, they are
packaged in specially designed boxes that allow air flow inside the
boxes and protection of the flowers. Flowers are pre-cooled to remove
warm air inside the boxes because flowers that get too warm have a
shorter vase life. Airports that receive a large volume of flowers have
facilities to perform the pre-cooling step. Miami handles over 80% of all
cut flowers imported into the U.S.
Many of the flowers that arrive in Miami are from Ecuador and
Colombia. Approximately 40% of the flowers exported from Ecuador
are shipped to the U.S. Ecuador sends about a third of its yearly
production just for Valentine’s Day.
Prime Air & Ocean Cargo has the experience from years of working
with air carriers to understand the requirements that ensure the
cargo is handled and shipped to preserve quality. In addition to their
experience, they use the Magaya Cargo System logistics software to
process the shipments.
“Our carrier background helps us understand all the details in the
supply chain. It makes it easier to work with air carriers because
we know how they operate, how to prepare the cargo, and what
happens if a plane is delayed. We emphasize that experience with our
customers. We also want them to know we are here 24/7 if something
is urgent. We don’t wait until 9 am the next day to answer something
important.”
They use the software in the Miami office to prepare shipments and to
receive cargo at their warehouse.
“We prepare the paperwork such as the air waybills in our Magaya
system. Then our employees go to the airport to put stickers on the
flowers that are in the coolers between flights.”
Some flower shipments are destined for the U.S. and others go to
Europe, especially Amsterdam. PA&OC has a company in Amsterdam
called Prime Fresh Handling which manages the arrival of Ecuadorean
flowers in Schiphol Airport and distributes them to Russia and other
countries.
Expanding from Ecuador to Miami and BeyondPrime Air & Ocean Cargo learned its trade in the demanding conditions
of shipping perishables and still applies that methodology today to all
the cargo they ship and every customer they serve. When Mr. Paredes
and his partner, Omar Zambrano, started their company in 2001 in
At a GlancePrime Air & Ocean Cargo www.primeaircargo.com
IndustryFreight Forwarder
SolutionMagaya Cargo System , ISF, Transaction Tracking
Prime Air & Ocean Cargo is a freight forwarder, bonded common carrier, OTI and NVOCC
located in Miami, FL. They are a CNS endorsed cargo agent and have a global network
of offices, including New York, Amsterdam, Quito, and work with agents in many other
locations.
Prime Air & Ocean Cargo
All rights reserved. Magaya, the Magaya logo and all products are all trademarked unless specifically specified as of a third party.© Copyright 2012, Magaya Corporation. 786. 845. 9150 [email protected] magaya.com
Importer Security Filing (ISF), also called the 10+2 initiative, requires
that importers and carriers submit certain details about cargo destined
for the United States. Magaya Corporation has been certified by US
Customs and Border Protection (CBP) to offer ISF and has incorporated
it into the software.
When items arrive in PA&OC’s Miami warehouse, they create barcoded
labels to track each item and its location in their software. They keep
their customers updated about the status of cargo by sending out
Transaction Tracking links via email. For customers who want to check
their cargo online, there is a web-based tracking tool called Magaya
LiveTrack that PA&OC uses for their global customers.
For their exports, PA&OC uses the Magaya AES feature, the Automated
Export System, to send shipment information to the US Customs office.
All the data entered in their software for the export is transferred
automatically into the AES.
To meet Ecuadorean Customs requirements, PA&OC was able to
implement customized labels in their Magaya system that create
tracking numbers according to Customs standards. This is just another
example of how their experience in their market helps them ensure
quality customer service.
“We are very picky about the details,” Mr. Zambrano said. “It makes us
different from our competitors.”
In Conclusion“The customers that we started with are still with us. We don’t have a
high turnover of customers,” Mr. Paredes said. “With our background
and experience, we cover all the details to prevent errors. We always
know what alternatives to pursue if a problem occurs.”
“We advise customers of the best path to take. For example, when
someone called wanting to ship luggage, I said it would be more
expensive than taking it with them on their flight. It lost me money, but
that kind of customer comes back when they need shipping because
they know they will get the best advice from us,” Mr. Zambrano said.
“All our customers are important to us. Maybe a small package from
a customer today can become a large shipment from them in the
future.”
Ecuador, they were a General Sales Agent for airlines, representing
airlines such as Atlas and Centurion Cargo.
In 2004, Mr. Zambrano came from Ecuador to Miami to expand the
business into freight forwarding. They changed their name from Prime
Air to Prime Air & Ocean Cargo. “Our main market is Brazil now,” Mr.
Paredes said. Commodities they ship include electronics, perishables,
machinery, and other types of cargo.
When Mr. Zambrano arrived in Miami, he worked with another
warehouse that was using Magaya software. When he opened PA&OC,
he continued to use Magaya software.
The Miami warehouse is 10,000 square-foot warehouse and additional
leased space with an affiliated company, BlueEx Logistics that stores
items for PA&OC and other freight forwarders. There are 18 employees
in the Miami location. They have a bonded warehouse nearby in
Medley.
They have a small package courier business, bagging up the items from
USPS or Amazon and send them to Costa Rica, Ecuador, the Dominican
Republic and other countries in the Caribbean and Latin America. They
also offer repacking services.
SolutionsSince their company handles many imports, they use the Magaya
ISF plug-in to file import documents required by US Customs. The
Prime Air & Ocean Cargo