Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan : Customization :

excel mod with short/long mod - csv export - csv delimiter

Jan 5, 2000, 5:16 AM
godie
Novice (23 posts)
Jan 5, 2000, 5:16 AM
Post #1 of 8
Views: 2865
Shortcut
Quote Reply
excel mod with short/long mod - csv export - csv delimiter
Hi,
my dbman with excel mod and short/long mod is now running on the server, I'm glad on that. But with the excel mod I have two problems I couldn't solve.
1. The downloaded *.csv file contains only the records which are on the first short display. I want to export also the other which are on the following short displays.

2. The delimiter of the exported csv file will be a comma ",". I think thats normal. but I want to have a semicolon ";". With that I can direct import this file in an existing MS access database. A comma separated csv can only be imported in an empty access database.
Note: The delimiter in default.cfg is set to ";"
Question: How can I set the delimiter for the csv export file ?
Jan 6, 2000, 8:01 AM
godie
Novice (23 posts)
Jan 6, 2000, 8:01 AM
Post #2 of 8
Views: 2787
Shortcut
Quote Reply
Re: excel mod with short/long mod - csv export - csv delimiter In reply to
Hi,
Problem 1 still remains !!! but Problem 2 is solved.
I found the delimiter setting for exported csv file:

in html.pl section export subroutines
in # print field name headers for each column of data
and # writes record in CSV format:
replace the comma to delimiter you want in the following codepart:
{print CSVFILE ",";}

regards, godie
Jan 7, 2000, 2:29 AM
Chris071371
User (195 posts)
Jan 7, 2000, 2:29 AM
Post #3 of 8
Views: 2804
Shortcut
Quote Reply
Re: excel mod with short/long mod - csv export - csv delimiter In reply to
I don't know much about Access or Excel, but I will try. All I need is for you to copy your *.cfg, *.cgi, and *.pl files into another directory as txt files and either post the URL's here or email them to me and then I can look at the mod and determine what would solve the problem. The URL to the actual DB would help too.



------------------
WFMY-TV Webmaster
Jan 7, 2000, 12:49 PM
godie
Novice (23 posts)
Jan 7, 2000, 12:49 PM
Post #4 of 8
Views: 2811
Shortcut
Quote Reply
Re: excel mod with short/long mod - csv export - csv delimiter In reply to
Ok,
-you can enter the files default_cfg.txt, html_pl.txt, auth_pl.txt and db_cgi.txt per FTP on host www.eissegeln.de , anonymous .
-you can enter the working db with http://www.eissegeln.de/cgi-bin/dbman/db.cgi
The db contains 1020 example records. Go in with admin/admin. Please don't look at the layout, there must be done many things, but I first want the funktions o.k.
Do following things:
Go to "view", select whatever you want, and view the display. You will have the short display with a max of 20 matches.
Go back to view, select the same and export records. You will get only the first 20 matches in the exported csv file.
Thanks and hope you'll find the solution

godie
Jan 7, 2000, 2:53 PM
Chris071371
User (195 posts)
Jan 7, 2000, 2:53 PM
Post #5 of 8
Views: 2780
Shortcut
Quote Reply
Re: excel mod with short/long mod - csv export - csv delimiter In reply to
I ftp'd in anonymously and all I got was a list of directories. I really don't have time to go through all of those!

If you tell me where they are, I have an idea what the problem is.

Go to view and click Export results. Then in the address bar and somewhere in the query string type mh=100. you will notice that you will get 100 lines in your file. Here is an example of the results I got. Count the lines.
Code:
Code,Recherche,Nation,DN,RegFleet,Title,Prename,Name,Address,ZIP,City,Tel,Fax,Tel2,Fax2,Mobil,Email,EmailToFax,FeePayed,Date
"848","0","G","1","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.d bman","0","0"
"949","0","G","2","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.d bman","0","0"
"950","0","G","2","Nord","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"779","0","G","3","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.d bman","0","0"
"522","1","G","4","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.d bman","0","0"
"567","no","G","5","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax. dbman","no","0"
"931","0","G","6","Nordwest","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fa x.dbman","0","0"
"730","0","G","7","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.d bman","0","0"
"639","0","G","8","Süd","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.dbm an","0","14.12.99"
"749","0","G","9","Nord","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"793","0","G","10","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax. dbman","0","0"
"992","0","G","11","Nord","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.d bman","0","0"
"1","0","G","12","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.dbm an","0","0"
"2","0","G","13","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.dbm an","0","0"
"523","1","G","14","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax. dbman","0","0"
"3","0","G","15","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.dbm an","0","0"
"532","0","G","16","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax. dbman","0","0"
"4","0","G","17","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.dbm an","0","0"
"5","0","G","18","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.dbm an","0","0"
"6","0","G","19","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.dbm an","0","0"
"809","0","G","20","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax. dbman","0","0"
"7","0","G","21","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.dbm an","0","0"
"8","0","G","22","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.dbm an","0","0"
"9","0","G","23","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.dbm an","0","0"
"521","0","G","24","Nordwest","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@f ax.dbman","0","0"
"1001","0","G","25","alt","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.d bman","0","0"
"10","0","G","26","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"11","0","G","27","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"12","0","G","28","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"13","0","G","29","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"14","0","G","30","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"897","0","G","31","Nordost","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fa x.dbman","0","0"
"648","0","G","32","Nordost","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fa x.dbman","0","0"
"15","0","G","33","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"1000","0","G","34","Nordost","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@f ax.dbman","0","0"
"16","0","G","35","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"17","0","G","36","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"18","0","G","37","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"19","0","G","38","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"20","0","G","39","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"21","0","G","40","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"22","0","G","41","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"772","0","G","42","Süd","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"23","0","G","43","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"684","0","G","44","alt","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"756","0","G","45","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax. dbman","0","0"
"24","0","G","46","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"25","0","G","47","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"566","0","G","48","Süd","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"930","0","G","49","Mitte","Herr Dr.","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.dbman","0","0"
"26","0","G","50","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"27","0","G","51","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"28","0","G","52","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"542","0","G","53","Süd","Herr Dr.","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.dbman","0","0"
"695","1","G","54","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax. dbman","0","0"
"918","0","G","55","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax. dbman","0","0"
"29","0","G","56","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"30","0","G","57","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"31","0","G","58","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"32","0","G","59","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"817","0","G","60","Süd","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"33","0","G","61","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"573","0","G","62","Süd","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"34","0","G","63","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"35","0","G","64","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"738","0","G","65","Süd","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"998","0","G","66","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax. dbman","0","0"
"36","0","G","67","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"599","0","G","68","Mitte","Frau","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax. dbman","0","0"
"37","0","G","69","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"507","0","G","70","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax. dbman","0","0"
"508","0","G","71","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax. dbman","0","0"
"38","0","G","72","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"577","0","G","73","Süd","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"980","0","G","74","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax. dbman","0","0"
"996","0","G","75","Mitte","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax. dbman","0","0"
"39","0","G","76","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"893","0","G","77","Nordwest","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@f ax.dbman","0","0"
"993","0","G","78","Nord","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.d bman","0","0"
"40","0","G","79","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"41","0","G","80","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"42","0","G","81","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"977","0","G","82","Nord","Frau","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.d bman","0","0"
"43","0","G","83","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"743","0","G","84","Nord","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.d bman","0","0"
"44","0","G","85","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"45","0","G","86","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"927","0","G","87","Nord","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.d bman","0","0"
"616","0","G","88","Nord","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.d bman","0","0"
"46","0","G","89","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"878","0","G","90","Süd","Frau","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"719","0","G","91","Süd","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"47","0","G","92","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"48","0","G","93","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"49","0","G","94","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.db man","0","0"
"733","0","G","95","Nord","Herr Dr.","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax.dbman","0","0"
"802","0","G","96","Berlin-Brandenburg","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email" ,"045897@fax.dbman","0","0"
" ","50","0","G","97","frei","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax. dbman","0"
"0"," ","856","0","G","98","Nord","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email","045897@fax .dbman"
"0","0"," ","896","0","G","99","Nord","Herr","abcd","efgh","ijkl","1234","dbtown","1245","3698","7852","4785","1710258","dbman@test.email"

Well the thing is, we need to set mh to ($#hits + 1) somewhere. I have never seen this mod so I couldn't tell you without seeing the scripts.

------------------
WFMY-TV Webmaster
Jan 8, 2000, 1:11 AM
godie
Novice (23 posts)
Jan 8, 2000, 1:11 AM
Post #6 of 8
Views: 2800
Shortcut
Quote Reply
Re: excel mod with short/long mod - csv export - csv delimiter In reply to
Hi Chris,thanks for efforts.
Don't know where you get lost in my ftp host, but anyway, I've send you the files with email.
regards, godie

Jan 8, 2000, 2:23 AM
godie
Novice (23 posts)
Jan 8, 2000, 2:23 AM
Post #7 of 8
Views: 2818
Shortcut
Quote Reply
Re: excel mod with short/long mod - csv export - csv delimiter In reply to
Hi Chris,
I thought about your "mh=100" and "mh to ($#hits + 1)".
I found a workaround.
in default.cfg set
# Default maximum number of hits returned in a search.
$db_max_hits =max number of database records;

that will funx.
Maybe you found another solution, but for the first time I have something which will be practible.

Thanx and best regards, godie

Jan 8, 2000, 6:56 AM
Chris071371
User (195 posts)
Jan 8, 2000, 6:56 AM
Post #8 of 8
Views: 2807
Shortcut
Quote Reply
Re: excel mod with short/long mod - csv export - csv delimiter In reply to
Very good Godie! I'm glad you got it worked out!



------------------
WFMY-TV Webmaster