Software Development:
Individual Programming

Real world example: Fully automatic completion of the FDA Prior Notice forms.

Find out more about typical software development tasks & prices by checking into project descriptions of programs that were developed by Bitpalace.

Question: 

Searching …

 

Unfortunately nothing found on "".

Premium support for Bitpalace web hosting customers only!

 from Fiji: +49 30 32 70 18 92, Fax (in Germany) +49 30 32 70 18 91

service@bitpalast.net 

Skype: bitpalast

One moment please … your browser is loading the page.

 

Goal

GermanCandy4You exports sweets from Germany to the US. Any food import into the US is subject to an extensive "Prior Notice" process required by the FDA (Food and Drug Administration). The sender must log the weight, FDA item code, manufacturer, purchasing source, sender and receiver and many other characteristics of each individual package and its content, even down to an individually wrapped cookie bar, in several online forms. Each item position must be logged individually, while all of the items make up one shipment.

The prior notice process is very time-consuming for the sender. Therefore, was commissioned with developing a software that would automate the login process and complete several nested FDA online forms with data supplied by GermanCandy4You's online store. Since the FDA system doesn't offer a programming interface (API) or an XML upload possibility, the software must simulate the manual data input of a human operator.

As an added challenge, the software must react to the responses generated by the FDA server. It must recognize the content displayed by the FDA server. At the end of the process it has to save two transaction numbers from a webpage and download a PDF file containing an individual prior notice customs form and save it in the online store. The program must function without error, since false information will lead to the destruction of arriving packages in customs and could entail legal action as well.

 

Screenshot: Source code excerpt from the application for automatic completion of FDA prior notice online forms.

 

Implementation

developed a PHP-script that can be executed from a web browser or as a console script under Linux. Using PHP cURL, it simulates a web browser including its operator, that logs into an SSL-protected connection in the FDA system and fills out the necessary forms for each shipment and each item contained in that shipment. The script saves all web pages the FDA server shows to the browser, while logging exactly which information was entered at a specific time as well as the FDA server's response. This makes it possible to keep a complete log of what happened at any time during a session. If the script fails to recognize that the data was processed by the FDA as expected, it will cancel processing the order with the respective error protocol entry.

The solution reads the transaction numbers for each shipment provided by the FDA from the FDA website and automatically downloads a PDF customs clearance document from the FDA website. This document, which is completed with the individual information for each package is saved for each respective order in GermanCandy4You's online store and can be attached to the package upon shipment with a simple mouse click, exactly as required by the US customs authority.

Processing time for filling out the FDA's prior notice has shrunk from approximately 20 minutes per package to a single script request, which processes all new packages fully automatically and therefore offers incredible cost savings.

 

Screenshot: Excerpt from the protocol. For legal reasons all of the script's work steps are logged in minute detail.

 

Work Hours & Price

The ready-to-run solution has been developed in only approximately 32 hours. The total cost was approximately 1,400.00 US$ without VAT.

 

Client1

GermanCandy4You
M. Bartsch
Degnerstrasse 70
D-13053 Berlin

www.germancandy4you.com 

 

 

 

 


 

Additional Services

Cheap web space for less than 1 US$/month 

Starter Server: Affordable web server from  2.18 US$ () /month with PHP, database and many more 

Online Reservation System: Occupancy & vacancy schedule for any ressources (vehicles, sports facilities …) & guest houses, holiday apartments …  1.02 US$ () /month 

 

FAQ – frequently asked questions 

 

Software development (programming, programmers) in selected countries

Cuba

Austria

Kenya

Guyana

Panama

Lesotho

Liberia

Antigua and Barbuda

Paraguay

Peru

Cameroon

Argentina

Costa Rica

Australia

Germany

Bahamas

Madagascar

Barbados

Belize

Uganda

India

Philippines

Malta

Bolivia

Botswana

Marshall Islands

Chile

Puerto Rico

Ireland

Mauritius

Rwanda

Saint Kitts and Nevis

Saint Vincent and the Grenadines

Saint Lucia

Mexico

Zambia

Samoa

Jordan

Micronesia, Federated States of

Switzerland

Dominican Republic

Malawi

Seychelles

Namibia

Kiribati

Dominican Republic

Nauru

Sierra Leone

New Zealand

Ecuador

Singapore

El Salvador

Gambia

Solomon Islands

Ghana

Spain

Nicaragua

Sudan

Nigeria

Swaziland

South Africa

Pakistan

Palau

Tanzania, United Republic of

Colombia

Grenada

Tonga

Trinidad and Tobago

Honduras

Tuvalu

Uruguay

Papua New Guinea

Venezuela

United States

Jamaica

Canada

Guatemala

Guinea

United Kingdom

Zimbabwe

 

"software development": programmer, programming, database design, interface, software developers, outsourcing, insourcing, off shore, program development, documentation, software manual, optimization, optimizing, scripting, script, revise program, revision, document software, prices for programming, Windows, Unix (z.B. Solaris, Linux, FreeBSD), Assembler, C, C++, JAVA, PHP, JavaScript & AJAX, VisualBasic, Cobol, Informix 4GL, SQL/MySQL, ADABAS, MS Access, Oracle, ARIS, Prozess 2000, Visio, MS Office (Word, Excel PowerPoint, MS Project), Automation mit VisualBasic, MS Windows Server und Clients, SAP R/3, Macromedia MX Studio, MS Frontpage, MS Expression Web, Smarty Template Engine, Joomla, Redaxo, osCommerce, OXID eSales Community Edition, OrgaMAX Web Export.

  from Fiji: +49 30 32 70 18 92 •  GmbH, Sensburger Allee 27, D-14055 Berlin (Germany)
Your purchase is tax-free, because you order from a non-EU country. 1) The project, names and addresses shown on this page are displayed courtesy of the client. © 2024  GmbH. All rights reserved. and the logo are registered trademarks of GmbH. For photo credits see imprint.

Imprint Privacy policy Sitemap