homepage Welcome to WebmasterWorld Guest from 107.20.37.62
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
CSV XLS question
berrywoods




msg:4074000
 1:31 am on Feb 4, 2010 (gmt 0)

Hi guys, sorry i seem to always come to here when im at wits ends, not really sql indepth but still a problem i have not been able to work out..

basicly im opening a shop, and im developing an epos system, i also have an online shop. i want to be able to share data between the two easily. both the website and epos software use csv's to import and export data but in different formatting, ideally id like a nice spread sheet, with all my product data and for there to be two copies of csv files generated from the data of the spreadsheet that updates automaticly, so i can change prices and add products on the master spread sheet and use a marco to update these to the website and till at end of day. is this possible? if they used sql databases i can imagine it would be easyier but if anyone has any ideas it would be greatly appreciated. obviously linking two spreadsheets is easy but csv's dont save the formulas that allow it. unless theres a program that can do this and generate them?

 

whoisgregg




msg:4103373
 10:24 pm on Mar 23, 2010 (gmt 0)

You can definitely have this kind of system, but it's incredibly frail and will be prone to problems. Any time you plan on manually passing around files to keep systems in sync you will have headaches.

At the very least, have a script that does the passing on a regular schedule and does some kind of validation on the data contained within.

claus




msg:4103421
 12:35 am on Mar 24, 2010 (gmt 0)

Unlike what whoisgregg suggests, doing this is a piece of cake for any experienced Excel VBA developer.

Basically you would have your product data in your "Master" Excel spreadsheet, and in that spreadsheet you would have a button to press which would either create two different CSV files for manual upload, or update the two backend systems directly (by logging in and doing a SQL request).

The last type of solution will be a little more difficult to program, and hence it will be more expensive. None of them are hard, they're quite ordinary tasks for an Excel VBA programmer.

As long as the import formats are constant, such a system would be stable as a rock.

However, it still neeeds a person to update the master Excel spread sheet with product data, and to press the button.

I suggest you look at the different freelance sites for a VBA programmer. This should not be an expensive job.

whoisgregg




msg:4103719
 1:55 pm on Mar 24, 2010 (gmt 0)

Thanks for the correction, claus. I have little experience with Excel (or VBA) and was not aware that it could automate so much of the process.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved