Results 21 to 30 of 30
-
12-05-2010, 12:22 AM #21New Project Manager
Just currious to know the feilds you use. I kow that in our card table we have 36 feilds to store the card information. I have sport, manufacturer,brand, cardset,card, players,teams and much more tables. In all with the SCF storefront/Inventory/OPG project, we use 53 tables and keep adding more as need be.
We maintain the card checklist up to date and member just need to query. you can report card or set errror like we do on the report a post on this forum. Everyday we get a few errors reported and they get corrected as soon as we can attend it. Ususaly done in 48 hrs. We maintain all card Print run and attributes. All person on internet can query your own public Inventory and do not need to be a member to view any of your cards. Image can be posted on other site. The edit page has the link to copy for each card you uploaded a image. A database on your hard disk is great for you but how do you share the result.
For instence here is my Carey Price PC in images:
https://www.sportscardforum.com/scf/i...1/view/2/zo/1/
Any query done on the your public inventory page can be tweek to the link you want to create.
Like this is all my trader with this time the detailed list and thumbnail images
https://www.sportscardforum.com/scf/i...1/view/1/pc/0/
All my PC with the detailed list and thumbnail images
https://www.sportscardforum.com/scf/i...1/view/1/pc/1/
You can filter 1/1 or just Auto or just Memorabilia or both, same with RC and print run. Any one with internet can view your cards 24/24 7/7. Access does not share your data with other like SCF carad manager does and it far from over. I have many thing I keep coding to improove it all.Last edited by CoolHandLuke; 12-05-2010 at 12:35 AM.
-
-
12-05-2010, 11:57 PM #22
CoolHandLuke) thanks for the reply...best of luck with your Inventory Manager. It looks cool n all, but at this point I'm interested in working with the database I set up cause I've already manually inputted thousands of cards into it. I need some help with making my data more user friendly, like with forms and all that. I got some ideas I hope to incorporate from the 2011 software just from looking at the images. If you want, I can just send you my database that way u can take a look at it and see what fields I use.
Pm if ur interested...I could use some help in tyring to send an Access database by Email if you have any tips.
I'll check more into your SCF manager...I do agree that it would be nice to have my database online for all to view like ur SCF Inventory manager does.
Brady
-
12-06-2010, 12:00 AM #23
Btw...if I wanted to input all my cards from my Access database into ur SCF Inventory manager, would there be an easy way to do that without manually inputting all my cards again?
-
-
12-06-2010, 01:51 PM #24New Project Manager
Not only SCF Inventory is Online and allow images upload for each card, so you can show your collection to all. But you do not have to type the card information to enter it, in your database.
SCF staff enter the checklist for you. So let's say you buy a 2010-11 Certified Hockey. The in My Inventory Tab, You can select the card set search, select hockey and then search for 2010-11 Certified and it list all the sets from that release. select the set to enter the card and add then l just by clicking on them. No typing other then the set search. You can enrter thoushands of cards daily, if you enter base set for instence.
This is much faster and efficient then trying to do your own database not shared with no one. Here you and all other can query you Inventory, view images etc...
Any given time, you can make a backup and download your complete inventory into one big .CSV file. A SCV file format and the basic database import export format. For instence you could create a card table in Access, empty and based on my field from my backup feature and then import the SCV file into the table by mapping the feild. Access support this. You can also open the file directly with Excell and see all the text, quantity and even a html link to a mage online if you have images uploaded.
So let say you have all you card here, you can make and dowlaod and achive Back up any day you want to make one. We will always keep the last backup you made oinline for you to download again. Been ban from the site, no problem, we will stilll let you have access to back up your inventory.
Then one can create a table in Access and import the SCF inventory directly in you access table. So if you keep back up and store them yourself, you can still create a access file on the fly. I could even provide the SQL text to create a table to receive the inventory format we have.
Back up is already coded and tested. I still need to code a importer. The problem with a importer is that it's almost impossible to macth all cards. the main reason is often set name are not always written the same way by all.
So
2010-11 UD Artifacts
2010-11 Upper Deck Artifacts
Is a example os set name that would not match. If you have UD and we have Upper Deck then it will fail.
Also often when person write the text themselves many error may get in and these text error will also fail. Still, if you have the most commonly used name then it should would well. I hope to have a basic one coded in the next months, where we will be able to import a CSV file folrmat and will let you match the column with our feilds.
So in a way, you are never tied to the card manager as anytime, you can take a backup and imoprt it in access or simply open it directly in excel. I eben tought about possible member being ban will be able to access the back up page an get a back up of all cards along with the link to all their image. Nothing get's deleted unless you delete the images.
Once I have the importer ready to try, maybe you can try it. Access can let you export in CSV format so it will be worth trying it.
-
12-06-2010, 01:59 PM #25
What is this, 1995?
-
-
12-06-2010, 04:38 PM #26
i could not use SCF inventory manager if i have no internet right?
i need to be in a location where i have internet to use this right? so if i was on a plane, or a boat or my basement for that matter where there is no wifi or internet connection i could not use the SCF manager... is this correct?
thanks again.
-
12-06-2010, 04:43 PM #27
I just started trying the inventory manager out, it works great, nice and streamlined.
-
-
12-06-2010, 05:42 PM #28New Project Manager
-
01-31-2011, 03:51 PM #29
Hi,
is there a way to SCF Inventory Manager to do bulk loads into my inventory.
I collect specific players and I want to have a checklist of all their cards. At the moment, it seems I have to click on "add" button for each card. Is there a way to "add all" to my search results?
Also, it would be convient to add a bunch of players from a set--create inventories quickly. For example, if I have cards #1, 3, 5, 7, 21, 24 from a set, I just want to check boxes for each of those cards and add to my inventory.
It also would be helpful to have various folders in my inventory.
Fields to consider adding:
Player's college
Finally, I downloaded my inventory and that works GREAT! Very fast, very easy. However, you misspelled "quantity" as "qantity"
Thanks and keep up the good work!
--chris
-
01-31-2011, 04:04 PM #30New Project Manager
I do not reply to members questions anymore. We now have 10 moderator to answer all members questions so please post them here:
Inventory/Storefront Feedback
Post any bugs, suggestions or comments here.
Someone will reply to all your questions. I am going in coding hibernation for a good month and want the new staff we just trained to get use to respond to members. I will only reply to bug and really tech stuff only.
Quantity will be fixe when I make a upgrade as it's fixe on my coding testing area. So it will go in version 0.9.1.8.
-
Originally Posted by twinsfan48 
