/    Sign up×
Community /Pin to ProfileBookmark

Inventory for website…?

Copy linkTweet thisAlerts:
Jan 07.2010

HI there,

I am new at this and needed someone to point me to right direction.

I have a client who has been updating his inventory list by updating and uploading a PDF to his server. (customer would dl this file)

His goal for his new site is to have a feature where he can upload an EXCEL file onto the server and have it update the inventory database. Can this be done? Here is his question, please let me know if this is possible. It looks to be a CMS question so any suggestion would be great.

[I][B]“Inventory Upload – This is one of the main features that we want in order to make business function a little easier. We want to be able to take the values from our excel sheet and be able to upload them onto the inventory page while at the same time there being a date that states the latest inventory update.”[/B][/I]

Also.

[I][B]“We want a search bar that does a good internal sweep of the inventory and any of the internal content on the pages. The search bar would be needed to pull from the inventory list.”[/B][/I]

I’ve been doing websites doing the basic, CSS/HTML style w/o any server-side programming.
Do I have to look into wordpress for this site?
Please any help would be awesome. I am willing to contract this part out if anyone knows how to proceed.

thanks a million guys

_threedash

to post a comment
Full-stack Developer

6 Comments(s) ↴

Copy linkTweet thisAlerts:
@CharlesJan 07.2010 — It's quite simple, and even more so if you can convince them to save the Excel file as CSV. But you will need some sort of server side scripting. What do you have available?
Copy linkTweet thisAlerts:
@FangJan 07.2010 — 
  • 1. Certainly doable, a basic Excel to Db using PHP: http://www.ibm.com/developerworks/opensource/library/os-phpexcel/index.html


  • 2. Sounds like a site search. There are a myriad of possibilities and languages to implement this. A custom Google site search is a simple solution, implemented in minutes.
    • Copy linkTweet thisAlerts:
    @threedashauthorJan 07.2010 — he has MySQL

    will that work?
    Copy linkTweet thisAlerts:
    @FangJan 07.2010 — Yes
    Copy linkTweet thisAlerts:
    @threedashauthorJan 07.2010 — what are the steps, if you dont' mind me asking, to implement something like this onto a web site. I am not a back end type guy so I am not entirely sure where to start or how to start.
    Copy linkTweet thisAlerts:
    @FangJan 07.2010 — 1. Certainly doable, a basic Excel to Db using PHP: http://www.ibm.com/developerworks/opensource/library/os-phpexcel/index.html[/QUOTE]
    The basic steps are given here
    ×

    Success!

    Help @threedash spread the word by sharing this article on Twitter...

    Tweet This
    Sign in
    Forgot password?
    Sign in with TwitchSign in with GithubCreate Account
    about: ({
    version: 0.1.9 — BETA 5.28,
    whats_new: community page,
    up_next: more Davinci•003 tasks,
    coming_soon: events calendar,
    social: @webDeveloperHQ
    });

    legal: ({
    terms: of use,
    privacy: policy
    });
    changelog: (
    version: 0.1.9,
    notes: added community page

    version: 0.1.8,
    notes: added Davinci•003

    version: 0.1.7,
    notes: upvote answers to bounties

    version: 0.1.6,
    notes: article editor refresh
    )...
    recent_tips: (
    tipper: @AriseFacilitySolutions09,
    tipped: article
    amount: 1000 SATS,

    tipper: @Yussuf4331,
    tipped: article
    amount: 1000 SATS,

    tipper: @darkwebsites540,
    tipped: article
    amount: 10 SATS,
    )...