Jump to content


Photo

Worldship Automatic Importing


  • Please log in to reply
15 replies to this topic

#1 steveweissmusic

steveweissmusic

    Member

  • Members
  • PipPip
  • 19 posts

Posted 17 February 2006 - 07:18 AM

I would like to improve the process of importing of shipment data into Worldship. The problem is that each time the shipment data is exported from MOM, the DBF file that is created gets overwritten. I do not want to have to export from MOM, and then immediately go to my UPS Worldship terminal and import the new information. I would like to use the keyed import function in Worldship to pull up shipment information.

I'm looking for suggestions on what route to take. Does a program exist that will append information from a DBF table onto another DBF? If this exists, I will write a script that polls the import / export directory every minute, and if a new DBF exists, it will append to the DBF that I am using to import from.

If this type of program does not exist, I will write a script that will import the DBF data into a Access database, and then rename the dbf file. I would then use the Access database as the source for the import.

Does anyone do anything similar to this? Can you offer any different suggestions?

#2 steveweissmusic

steveweissmusic

    Member

  • Members
  • PipPip
  • 19 posts

Posted 17 February 2006 - 09:25 AM

I think I am going to attempt to run MySQL on the machine with UPS Worldship, and run the attached script every minute. I will then setup Worldship to pull from the MySQL ODBC source instead of the DBF.

Please let me know if anyone sees potential problems.

Attached Files



#3 Journeyman1

Journeyman1

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 17 February 2006 - 09:39 AM

The latest version of WorldShip--8.0 if I recall correctly--includes a new feature for doing an automatic import at specified intervals, which could be every few minutes if you want. I haven't had time to set this up yet, but it seems like the simplest way to get the results you described.

If you decide to go this route, I would be interested to hear how it works for you.

Good luck!

Evan Frink
Journeyworks Publishing

#4 steveweissmusic

steveweissmusic

    Member

  • Members
  • PipPip
  • 19 posts

Posted 17 February 2006 - 09:51 AM

The latest version of WorldShip--8.0 if I recall correctly--includes a new feature for doing an automatic import at specified intervals, which could be every few minutes if you want. I haven't had time to set this up yet, but it seems like the simplest way to get the results you described.

If you decide to go this route, I would be interested to hear how it works for you.

Good luck!

Evan Frink
Journeyworks Publishing

View Post


We have Worldship 8, but haven't seen this functionality. Because we want to do a keyed import, I believe we need a ODBC source that contains all of the information we need. If you know a way to do the automatic import, and then pull that info up by keyed import, let me know.

#5 steveweissmusic

steveweissmusic

    Member

  • Members
  • PipPip
  • 19 posts

Posted 17 February 2006 - 01:00 PM

I realized that I needed to include an update query, incase a package was updated in MOM, and the shipping record was created again.

Attached is the new version.

Attached Files



#6 steveweissmusic

steveweissmusic

    Member

  • Members
  • PipPip
  • 19 posts

Posted 20 February 2006 - 01:17 PM

This seems to be working well for me. I am still only testing things, but it is working as expected. I created a batch file with the following contents:

@ECHO OFF
path=c:\php
php convert.php >> convert.log

I then scheduled this batch file using the Windows Scheduler (Programs->Accessories->System Tools->Scheduled Tasks). Create a local account on the machine to run the process. This way, the batch process will run in the background, instead of in the active window (I am running this on the Worldship machine). I am running the process every minute.

You'll need the following programs installed to make this work:
http://www.php.net/downloads.php
http://dev.mysql.com.../mysql/5.0.html

These tools will help in the process (MySQL Administrator & MySQL Query Browser):
http://www.mysql.com/products/tools/

#7 Journeyman1

Journeyman1

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 21 February 2006 - 10:33 AM

I'm glad to hear you got it working. If others want to explore an alternative solution, here is more specific info on the feature included in Worldship 8.0, which I should have included in my earlier post. Laziness got the better of me--sorry.

In the Worldship 8.0 help files, look for "Hands-off shipping". It gives a good description of how the feature works, along with detailed instructions for setting it up.

Again, I haven't yet set it up myself, but, judging by the description, it will automatically import at your specified interval whatever records are in the upsworld.dbf table. The interval can be as brief as one second, apparently.

You would want turn on the option to have Worldship check the key field to make sure it doesn't import the same record twice. I believe the key field should be the Pkg_ref5 field in Upsworld.dbf which corresponds to the segment ID number (or is it the box ID number?) in MOM, if memory serves.

Best of luck to all.

Evan Frink
Journeyworks Publishing

#8 steveweissmusic

steveweissmusic

    Member

  • Members
  • PipPip
  • 19 posts

Posted 22 February 2006 - 07:56 AM

In the Worldship 8.0 help files, look for "Hands-off shipping". It gives a good description of how the feature works, along with detailed instructions for setting it up.


Evan,
I guess my desired results are a bit different. Let me explain our process....

We do not have MOM stations in our shipping department, and we print our invoices on plain paper. We print 2 copies of the packing slip/invoice. When the order is packed, one copy goes into the box, the other gets attached to the outside. That copy is then scanned at the Worldship machine, the box is placed on the scale, and we press F10 to print the shipping label.

It would be great if Worldship Hands-Off shipping was able to import data as a background process, to then be pulled up by a keyed import. I cannot figure out how to design this type of process solely in Worldship using Hands-Off shipping.

#9 Guest_Guest_*

Guest_Guest_*
  • Guests

Posted 16 March 2006 - 08:44 AM

Awesome information everyone! I was more than a little irritated when I discovered that MOM's integration with UPS included so many manual steps. The whole process didn't seem very integrated to me at all.

Currently I have UPS setup to do a keyed import from a UPS.dbf file, but we're having to manually import the upsworld.dbf file into the UPS.dbf file each time we run a batch in MOM. This thread is exactly what I was looking for, can't wait to get started on automating this whole process better than it is right now.

Anyone figured out how to automate the addition of tracking numbers back into MOM?

Anyhow, just wanted to thank you all for the great information.

#10 arkylady

arkylady

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 16 March 2006 - 08:45 AM

Oops that last post was me, didn't realize I wasn't logged in :)

#11 steveweissmusic

steveweissmusic

    Member

  • Members
  • PipPip
  • 19 posts

Posted 07 April 2006 - 05:58 AM

I just discovered that MOM does not support 3rd party billing with Worldship. It doesn't seem like it would be hard for them to do, since they do support it with UPS Link. However, according to support (and from my testing), it cannot be done with Worldship.

Has anyone else had this problem with Worldship? How do you deal with it?

#12 Guest_Guest_jszostek_*_*

Guest_Guest_jszostek_*_*
  • Guests

Posted 20 April 2006 - 08:27 AM

OK, so I've read over all the posts on the rewriting of trtasnfer files by MOM for UPS Worldship use. What I want to know is if any one has, or konws of someone who has, had a macro or snippet written in FoxPro to append the MOM output file to another temp DBF file, then copied that file back to the original MOM DBF file for UPS Worldship use?

I'm looking for programming help on this.

Thanks

#13 mark@majorsorplus

mark@majorsorplus

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 19 April 2007 - 07:23 AM

when i first read this thread, i could have sworn on my mothers grave that i had written this in my sleep...you are having the exact same problem we are. this is: when we batch orders through MOM the info gets sent to our UPS terminal but if we batch another time without shipping the entire first batch our barcode scanner becomes obsolete becasue the first batch does not 'exist' anymore. can you please tell me exactly what you did (im not yet at the programming level here) so we may replicate your process. we have tried everything we (and the UPS techies) can think of. any help would be greatly appreciated!!!
-Mark
Major Surplus & Survival Inc.
www.MajorSurplus.com

#14 MOM Sucks

MOM Sucks

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 24 April 2008 - 12:01 PM

We had the same challenge and I solved it with a simple macro in Access.

When the order puller finishes the order pulling process, they simply click an icon (the macro shortcut).

The macro imports the data from the momimport.dbf and adds it to the running table (upsexport) and then converts it to a CVS file on the network that ups worldship keyed import points at.

The person shipping then just scans the pick ticket and the information is imported into the ups screen.

The caveat is that is the order puller misses the macro run before the next pull, the information is gone.

#15 ranlin

ranlin

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 02 July 2009 - 11:39 PM

Bidding for and hosting the Olympics successfully is, perhaps, the ultimate glory for a city. However, before transforming the dream into reality, the benefits and drawbacks of bidding for the Olympics should be weighed carefully.

Hosting the Olympics surely would bring about much gain to a city. Boom of the local economy, more jobs, and the possibility of generating income all sound extremely attractive to the municipal government. At the same time, better infrastructure, cleaner environment, enjoying the spectacular game with hundreds of sports elites and entertainment stars, and the opportunity of contacting people from all over the world also seem exciting to the citizens. Besides, the bidding will definitely promote the patriotic emotion and pride, as well as the moral behavior in local people. In most cases, bidding for the Olympics is well supported by both the public and the central government.

Unfortunately, this is not the entire view of the pretty picture. If looking from another angle, the Olympic bid might bring about some side-effects to a city. wow power leveling,
First of all, the environmental impacts, including the increasing exhaust fumes of cars, more pressure on water resources, huge amount of wasted leaflets and other materials used for public activities, are most probably neglected. In order to broaden the streets, some trees may have to be cut. Near the construction site, the tiny dust may linger in the air for a long time. Reduction of farmland may be caused by the need of setting up new sports centre or accommodation facilities. These environmental consequences can be especially serious in a resource-limited and densely-populated city in a third-world country.

Besides, if talking about the economic benefit, it should not be forgotten that a quick boosting may lead to bubble growth, which may easily crash. If not well managed and organized, the big event may not be so profitable, and the new facilities may be forever empty after the games. Yes, there have been cases that host cities ended up with enormous debts.

Finally, let�s think about the low-income groups in the city. What will they get from the Olympics bidding? More tax, more fees, more expensive property prices, and higher cost of living. These definitely are not good news for them.

To bid or not to, this is a question. It is up to the choice of the municipal government, and the local public. After the decision, what they can do is to make the most of the benefit, and reduce the drawbacks to the least.
world of warcraft power leveling,
The excitement of Sydney 2000 Olympic Games lasted for a long time. 28 gold medals won by Chinese athletes dwarf our Asian nelghhors, heat quite a few hlg countries of sports, and surprise the two superpowers��the United States and the Russian Federation. The great success clearly indicates that a new superpower of sports is in embryo.

  Our success in the 27th Olympic Games is far beyond sports. First, the glory greatly enhances the international prestige of China. Through TV, people all over the world know more about New China, especially the dramatic progress made in the past two decades. Next, it greatly boosts the morale of our people. Billions of Chinese witnessed how the former ugly ducklings hecame China with the force of an avalanche. The successful stories or the Olymplc Medalists fuel the ambition of millions of Chinese youth. Finally, It heightens our selfconfidence and nationalism. China, a weak nation in sports in the past, has rapidly risen up and become one of the sports giants. Why couldn't she be a modernized China soon? What is more,the success has laid a firm foundation for Beijing to host the 2008 Olympic Games.
aoc power leveling
  The 27th Olimpic Games was over, but the Olympic Spirit lives on. In the race for a better nation,there is no finish line. If we keep on working hard, the day will certainly come when China will be a powerful country with international prestige.

Olympics

#16 origkds

origkds

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 24 July 2009 - 03:27 PM

I use a program called DBF Viewer 2000 and wrote a batch file that runs the following routine via Windows Scheduler automatically every minute.

call "C:\Program Files\DBF Viewer 2000\dbview.exe" /APPEND:C:\UPS\WSTD\ImpExp\Mom_Import.dbf,C:\UPS\WSTD\ImpExp\upsworld.dbf
Call "C:\Program Files\DBF Viewer 2000\dbview.exe" C:\UPS\WSTD\ImpExp\Mom_Import.dbf /DELETEDUPS
Call "C:\Program Files\DBF Viewer 2000\dbview.exe" C:\UPS\WSTD\ImpExp\Mom_Import.dbf /PACK

It appends records from upsworld.dbf to a file I named Mom_Import.dbf. It then removes duplicates and finally packs the file. I point the ODBC connector at Mom_Import instead of upsworld. Using the keyed import function in Worldship I scan the barcode on the packing slip and ship the package. There may be a better way to accomplish this task but with my limited programming skills this was the best I could muster. It has been working perfectly.

Note: I found that converting upsworld.dbf to a CVS file caused other problems like dropping the leading zero on zip codes from the East Coast. Also any record with a comma in any field would throw the record off by one field and make it unusable.




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users